February 2009 - users-list

[MonetDB-users] Corrupt DB - missing bat files
by David Svenson 19 Feb '09

19 Feb '09

Hi, When importing date with 'COPY INTO' I reached a database corruption state. When I open the server, it comes up fine, but immediately when I start a client the server crashes with this message: # Listening for connection requests on mapi:abacusdb://127.0.0.1:50000/ # AbacusDB/SQL module v2.27.0 loaded >!ERROR: GDKload: cannot open: name=01\106, ext=head !OS: The system cannot find the path specified. !ERROR: GDKload: failed name=01\106, ext=head The bat files for 01\106 that are mentioned in the error message are missing from the dbfarm. Does the fact that they are supposed to be in folder 01 mean that these are system tables? Can I recover from this state, or has my current database become unrecoverably corrupt? -- View this message in context: http://www.nabble.com/Corrupt-DB---missing-bat-files-tp22096097p22096097.ht… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Please, HELP me!
by Xiaofang Tao 18 Feb '09

18 Feb '09

Hello, my friends： I have just installed the latest version of MonetDB5 (SQL) on windows, 32bit system. When I start the client (start-programs-MonetDB5-MonetDB SQL Client), after I start the server (start-programs-MonetDB5-MonetDB SQL Server), the client window prompted start with sql, and I can not use the command like -d. -f, -H, -u and so on, moreover, I can not specify the user or the schema. If I want to use these commands and to specify the user and the schema, what I should do. Hoping for your reply! Best regards. Tao Xiaofang

1 0

[MonetDB-users] Please, HELP me!
by taoxiaofang 18 Feb '09

18 Feb '09

Hello, my friends： I have just installed the latest version of MonetDB5 (SQL) on windows, 32bit system. When I start the client (start-programs-MonetDB5-MonetDB SQL Client), after I start the server (start-programs-MonetDB5-MonetDB SQL Server), the client window prompted start with sql, and I can not use the command like -d. -f, -H, -u and so on, moreover, I can not specify the user or the schema. If I want to use these commands and to specify the user and the schema, what I should do. Hoping for your reply! Best regards. 2009-02-18 taoxiaofang

1 0

[MonetDB-users] Java 1.6 and MonetDB JDBC driver
by Fabian Groffen 17 Feb '09

17 Feb '09

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6795561 The MonetDB JDBC driver is affected by above bug, which manifests itself as an IndexOutOfBoundsException thrown somewhere deep from the heart of the driver in the mcl StartOfHeaderParser. The only workaround is to use JDK 1.4 or 1.5 if you hit this problem.

2 1

[MonetDB-users] sql - division
by dariuszs 13 Feb '09

13 Feb '09

Hello, How do I modify this sql to get correct answer? sql> select 10/100; I got 0 instead of 0.10 Thanks. Dariusz.

2 2

[MonetDB-users] Challenge string is not valid
by David Svenson 12 Feb '09

12 Feb '09

Hi, While working with MonetDB, I suddenly reached some sort of state in which I constantly get: "Challenge string is not valid" Whenever I try to connect to MonetDB. I am using the Mapi libraries, and get the same error if I use mclient.exe. I can't figure out how I reached this state and how I'm supposed to get out of it. Please help. Thanks, David. -- View this message in context: http://www.nabble.com/Challenge-string-is-not-valid-tp21976173p21976173.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] copy/select * from /into - very slow
by dariuszs 09 Feb '09

09 Feb '09

Hi, Could you please help me here. I've got 300 fields, 100 million records, 800 bytes per row in a table. Exporting 60 fields into a table takes about 1 minute and selecting * from table takes very long time, and I don't see lots of cpu usage when exporting all records. Thanks. Dariusz.

2 9

[MonetDB-users] Algebra Mode vs sql debug 16384
by Ross Bates 06 Feb '09

06 Feb '09

Hi All - can someone help me clarify the difference between Algebra "-G" mode and setting SQL debug equal to 16384 in the monetdb config file? With an older version of MonetDb I set the sql_debug=16384 in the config file so I could take advantage of Algebra mode when starting the server via mero. Today I compiled the Nov08-SP2 release and ran some tests using sql_debug=0 vs sql_debug=16384. I assumed they would do the exact same since Algebra mode is now the default. They returned very different results however. For SQL statements with a large number of predicates (100+), performance is about the same. But for anything smaller the query speed is much worse (10x avg) when I don't have sql_debug=16384 turned on. The query trace files are also different when I run the exact same query with and without the 16384 flag. I made sure to restart the server process in between. Also, below is the latest output from mserver --version: Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008- MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /home/ross/monetNov08sp2 Libraries: openssl: OpenSSL 0.9.8g 19 Oct 2007 (compiled with OpenSSL 0.9.8g 19 Oct 2007) Compiled by: ross@home Compilation: gcc -O2 -std=c99 -fgnu89-inline -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations -funroll-loops -frerun-cse-after-loop -frerun-loop-opt -ftree-vectorize Linking : /usr/bin/ld Any thoughts? Best Regards, Ross

5 4

[MonetDB-users] sql - string functions
by dariuszs 06 Feb '09

06 Feb '09

Hi, Just wondering why - strings functions seem to be very slow eg. 'select substring(field1,1,10) || substring(field2,1,20) as field3 from table1'. Thanks for help. Dariusz.

1 0

[MonetDB-users] Fedora 9 RPMs in Stable DailyBuild directory
by Hans van Rijswijk (DT) 06 Feb '09

06 Feb '09

Dear MonetDB users, In the release directories (http://monetdb.cwi.nl/downloads/Fedora/9/x86_64/) I can find RPMs for Fedora 9. Why can't I find Fedora 9 RPMs in the Stable DailyBuild directory (http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./200 90206/RPMs/) ? I needs to make a distribution including the latest Stable MonetDB and including Fedora 9 RPMs. Regards, Hans van Rijswijk

2 1