December 2007 - users-list

[MonetDB-users] windows 127.0.0.1
by Miki Muzsi 04 Dec '07

04 Dec '07

Hi there, Anybody knows if the installation of Monet can be changed (on windows) to use localhost instead of 127.0.0.1. It seems that because of that I can not connect to MondetDB from a different machine; I get the error message: Could not open connection to the host, on port 50000: Connect failed. I've lokked into monetdb5.conf, registriey, docs ... nothing helpt. BTW I am using version v5.2.2 on windows. Cheers, Miki Chordiant Software International Ltd. Registered office: Chiswick Park Building 10, 566 Chiswick High Road, London W4 5XS Registered in UK no. 02155722 and VAT no. GB 479 9023 02 The information transmitted herewith is sensitive information of Chordiant Software or its customers and is intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

2 1

[MonetDB-users] offset support?
by m h 04 Dec '07

04 Dec '07

Is there support for OFFSET in queries? The syntax doesn't throw an error, but the expected behavior isn't correct... sql>select * from query_users; +---------+----------+ |user_id |user_name | +=========+==========+ | 1 |john | | 2 |jack | | 3 |ed | | 4 |wendy | | 5 |laura | | 6 |ralph | | 7 |fido | +---------+----------+ Timer 1.820 msec 7 rows sql> Timer 0.294 msec 0 rows sql>SELECT query_users.user_id, query_users.user_name more>FROM query_users ORDER BY query_users.user_id more> LIMIT 3 OFFSET 2; +---------+----------+ |user_id |user_name | +=========+==========+ | 1 |john | | 2 |jack | | 3 |ed | +---------+----------+ -matt

3 10

[MonetDB-users] Slow Data Load
by Paulo Jorge Dias 02 Dec '07

02 Dec '07

Hi, I am working on a Windows XP SP2 32bit with MonetDB v5.2.2 kernel v1.20.0 I have built a java program to upload data from an Oracle Database Table with 6milion rows. After about 4milion of rows loaded the performance decreases dramatically. I have tried to use other way, which is generating all insert statements to a file and then using mclient to execute all the insert statements. Slower that the java option because the autocommit=on and parsing of each statement, but the result is the same. After about 4milion of rows loaded the performance decreases dramatically. Can someone give an explanation for this behavior? Thanks, Paulo Jorge Dias -- View this message in context: http://www.nabble.com/Slow-Data-Load-tf4929292.html#a14108678 Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Server in a weird state....
by m h 01 Dec '07

01 Dec '07

I tried running the SQLAlchemy ORM testsuite. The first time it ran for a while and then mserver segfaulted. (It also grew to using 700+Megs of memory. Am assumming this is a monetdb issue, since after each test the tables are usually dropped). The server now has issues. It appears to start fine: # MonetDB server v5.2.3, based on kernel v1.20.1 # Serving database 'demo' # Compiled for i686-pc-linux-gnu/32bit with 32bit OIDs dynamically linked # Copyright (c) 1993-2007 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /root/MonetDB/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.20.3 loaded When I try to connect with the command line client it complains repeatedly: !ERROR: BUNdelete: access denied to tmp_537, aborting. !ERROR: BUNdelete: access denied to tmp_537, aborting. ....

3 21

[MonetDB-users] Preferred bulk load method?
by m h 01 Dec '07

01 Dec '07

Good afternoon- Just wondering if there is a preferred method to load large datasets into monetdb? Piping SQL through mclient? thanks much -matt

2 14