May 2007 - users-list

[MonetDB-users] Creative Suite 3 Design ready to download
by Colby Sizemore 22 May '07

22 May '07

By treesor might see as the masonrySeems reflected in the infinite of the lamps.I might have happily lived some other childhood.and the numbed yards will go back undercover.From point to point of meaningopen? closed?Wind, sleet. The branches sway,But what I am looking at is hardened snow,they sit with their wives all day in the sun,At San Biagio, in the most intense roomGray the cloud-like oaksA frame of glided twilightIGiven by nature will soak into it.Again awaken from your being gone to findAs if your human shape were what the stormShe stretches a hand toward the toothy sleeperDim, and die tonight?Your gloved hands covering your lips' good-byeCoextensive with everything? How could they know?The flakes which have stolen onto the flagstones

1 0

[MonetDB-users] monetdb roadmap
by Colin Foss 21 May '07

21 May '07

Anyone have insight into when 2.18 will be released? http://monetdb.cwi.nl/projects/monetdb/Development/Roadmap/index.html

1 0

[MonetDB-users] other than to quit smoking.
by Odette Spears 21 May '07

21 May '07

GPSI Announces Market Attack Into $1 Trillion Market! Global Payment Solutions Symbol: GPSI Price: $0.03 GPSI announced its plans to address the huge influx of immigrant workers into the US that need banking solutions that they otherwise would not qualify for. This market is expected to represent over $1 Trillion dollars to be managed by 2008. GPSI provides viable solutions to this market. This is hot, read the news and watch for more Monday! Get on GPSI first thing Monday! The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking. The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking.

1 0

[MonetDB-users] Syntax in Query causes a Server Crash - Critical
by Venks 21 May '07

21 May '07

Hi, The following query has a syntax issue. But instead of reporting the syntax error, the server crashes. select count(*) from (select col2, count(*) as row_count from data_1to10 group by col2 order by row_count desc, col1) sq I have attached a PERL script which can be used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> You will need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

2 1

[MonetDB-users] M5 SQL load data with "copy into" behaviour and 32 bits limitation
by Franco Guidoli 20 May '07

20 May '07

Hi all: I'm testing MonetDB5 to know if it's suitable for an OLAP project. I have to load a bit more than 11.5 million rows into one table, and I get the following results (I'm working on a Windows 2000 Professional 32 bits box with 1GB RAM and Monet v5.0.0_beta1_2): - when I try to load all the data in a single "copy into", mserver crashes at a certain point. - when I try to load the data in 100K chunks with several "copy into" into the same sql session, the server crashes at 7.8 million rows, and when I try to load the rest of the data it gets loaded, but the first 7.8 million rows get corrupt and the rest get ok. - when I load the data in 100K chunks in 5 different times (2.6 million rows each time) everything gets ok; after every 2.6 million I disconnect from sql client and shutdown the server, so when I restart the server and connect from sql client all the logs get persistent (thanks to Niels Nes to explain simply that logs get persistent after a server restart and when a sql session starts). So, initially I thought that MonetDB couldn't load that amount of data in a 32 bits box, but after all it can, because at last the data was successfully loaded. Is there a limitation with the "copy into"? Is there a way to achieve this process without restarting the server and sql sessions? I've read some threads about 32 bits limitation, but I don't know for sure how to calculate the maximum rows I can have into a single table. In my case, the table has a 147 bytes length using the following sizes in data types: smallint --> 2 bytes int --> 4 bytes char(2) --> 2 bytes the limitation would be 2GB / 147 bytes --> 14.608.732 rows ? I've assumed this after what I've read, but please let me know if I'm doing a wrong calculation. Thanks in advance, Franco -- View this message in context: http://www.nabble.com/M5-SQL-load-data-with-%22copy-into%22-behaviour-and-3… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] latest build cannot connect from remote client
by Colin Foss 17 May '07

17 May '07

I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today. The binaries compiled fine but I am unable to connect from a different computer besides the host. i.e. mserver5 running on serverA, client running on desktopB. desktopB> MapiClient -l sql -h serverA -umonetdb MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with: 46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412 Any ideas?

3 4

[MonetDB-users] Query Bug
by Venks 16 May '07

16 May '07

Hi, The following query works for the first time: WITH t AS ( SELECT * FROM tables ) SELECT * FROM t If I execute the query again, it gives the following error: Variable 't' allready declared If I change the alias from "t" to "t2" it works for the first time and then gives the error on second execution. Please look into this and correct this bug. Thanks, - Venkatesh

1 0

[MonetDB-users] GDK Error on a query joining non-key columns
by Venks 16 May '07

16 May '07

Hi, I get the following error: MALException:algebra.join:GDKerror ERROR: GDKload failed: name=02/45/24557, ext=buns.priv while executing the following query: select count(*) from ( select 1 from data_1to10 a, data_10to20 b where a.col2 = b.col2 ) sq I have attached a PERL script which is used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> After generating the first file, you will need to update the PERL script to change the numbers in the for loop, so that the next 20 million rows from 10,000,001 to 20,000,000 are generated. You will also need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

1 0

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 16 May '07

16 May '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

1 0

[MonetDB-users] Persistent Stored Modules in MonetDB
by Venks 15 May '07

15 May '07

Is there any other documentation that I can get my hands on for understanding all the supported syntax for Persistent Stored Modules? The reference manual has nothing much and the examples as part of the MonetDB install are few. I am trying to find all the 4GL syntax that can be used while creating a persistent stored module. Thanks, - Venks

2 2