- users-list - monetdb.org

[MonetDB-users] Restore db on different platform / OID size
by Sander Kruseman 15 Apr '11

15 Apr '11

When attempting to restore a db dump, made on Windows 7 with 32 bits sized object ID's, on OSX with 64 bits sized object ID's, I run into errors. Like: CREATE FUNCTION: name 'env' already in use If I tweak the dump script by first dropping the functions that appear to exist, I get stuff like: ' from line 1 field 5 not inserted, expecting type real failed to import table Should what I try to do be possible anyway? Am I doing anything wrong? Thanks for your feedback. Sander Kruseman

2 1

[MonetDB-users] bulk upload data
by Nic Chidu 14 Apr '11

14 Apr '11

What way do you suggest for bulk uploading data? Thanks. Nic

3 2

[MonetDB-users] documentation on metadata statement
by Nic Chidu 13 Apr '11

13 Apr '11

Where can I find doc about metadata statements. Stuff like showing database, table, running environment. Thanks, Nic

2 1

[MonetDB-users] Series UPDATE statements will significantly decrease server performance
by Vladimir Vlach 13 Apr '11

13 Apr '11

Hi, We are experiencing performance issue with MonetDB when running UPDATE. We have a table with 1M rows and 3.000 columns. All columns except primary_id are FLOAT type. When I execute series of these statements the performance on first 30-35 statements is quite acceptable (less then 1s) but then suddenly it gets really slow. One UPDATE takes 30 seconds or more. After next 5-10 statements the performance decreases and one UPDATE takes 1 minute or longer. We run this with AutoCommit. The behavior is very persistent. UPDATE table SET column=column+1 WHERE primary_id='e1a7d7c7204c292e56e942dbdad118d3' ; Would you say MonetDB is not suitable for bulk UPDATE operations? Thanks, Vlad

1 0

[MonetDB-users] UPDATE INNER JOIN syntax
by Osmin Castillo 12 Apr '11

12 Apr '11

Hi guys: How can I to update a table field based on a inner join update? What's the syntax for MonetDB? thanks in advance Osmin Castillo

2 1

[MonetDB-users] How to recover Database after crash
by Vladimir Vlach 11 Apr '11

11 Apr '11

Hi, is there guide on how to recover DB after server crash? I get following error: root@monetdb:/var/monetdb5/dbfarm# monetdb release vlad_a-f taken database out of maintenance mode: vlad_a-f root@monetdb:/var/monetdb5/dbfarm# monetdb start vlad_a-f starting database 'vlad_a-f'... FAILED start: starting 'vlad_a-f' failed: database 'vlad_a-f' appears to shut itself down after starting, check merovingian's logfile for possible hints root@monetdb:/var/monetdb5/dbfarm# tail /var/log/monetdb/merovingian.log 2011-04-11 11:40:53 MSG merovingian[2477]: starting database 'vlad_a-f', up min/avg/max: 2s/1h/15h, crash average: 0.00 0.30 0.20 (18-12=6) 2011-04-11 11:40:53 MSG vlad_a-f[2783]: arguments: /usr/bin/mserver5 --config=/etc/monetdb5.conf --dbname=vlad_a-f --set merovingian_uri=mapi:monetdb://monetdb:50000/vlad_a-f --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/monetdb5/dbfarm/vlad_a-f/.mapi.sock --set monet_vault_key=/var/monetdb5/dbfarm/vlad_a-f/.vaultkey --set monet_daemon=yes 2011-04-11 11:40:53 ERR vlad_a-f[2783]: !FATAL: BBPinit: could not write bat/BBP.dir 2011-04-11 11:40:53 MSG merovingian[2477]: database 'vlad_a-f' (2783) has exited with exit status 1 2011-04-11 11:41:02 ERR control[2477]: (local): failed to fork mserver: database 'vlad_a-f' appears to shut itself down after starting, check merovingian's logfile for possible hints Is there a procedure how to recover this? Thanks, Vlad

3 3

[MonetDB-users] Temporary tables
by Charalampos Nikolaou 10 Apr '11

10 Apr '11

Hi, this page (http://monetdb.cwi.nl/SQL/Documentation/Table-Definition.html) states that only the LOCAL TEMPORARY scope of SQL is implemented. Considering the following interaction with in mclient, it does not seem that is implemented at all. Am I missing something here or it is a bug? sql>CREATE LOCAL TEMPORARY TABLE transaction_statements ( ctx INTEGER NOT NULL, subj INTEGER NOT NULL, pred INTEGER NOT NULL, obj INTEGER NOT NULL, expl BOOL NOT NULL ); operation successful sql>INSERT INTO transaction_statements (ctx, subj, pred, obj, expl) VALUES (0, 1, 2, 805306369, 1); 1 affected row (10.450ms) sql>SELECT * FROM transaction_statements; +-----+------+------+-----+------+ | ctx | subj | pred | obj | expl | +=====+======+======+ +-----+------+------+-----+------+ 0 tuples (1.490ms) sql>SELECT * FROM tmp.transaction_statements; +-----+------+------+-----+------+ | ctx | subj | pred | obj | expl | +=====+======+======+ +-----+------+------+-----+------+ 0 tuples (1.443ms) sql>SELECT * FROM tmp._tables; +------+------------------------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-------+------+-------+ | id | name | sche | query | type | syste | comm | reado | : : : ma_i : : : m : it_a : nly : : : : d : : : : ctio : : : : : : : : : n : : +======+========================+======================================================================+======+=======+======+=======+ | 5678 | transaction_statements | 2103 | null | 0 | false | 1 | false | +------+------------------------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+-------+------+-------+ 1 tuple (2.013ms) Thanks, Babis

2 1

[MonetDB-users] build failed on undefined crypt references
by Sander Kruseman 10 Apr '11

10 Apr '11

Hi, Building from recent tar.bz2 (11.1.1) on Linux/x86_64 I get: libtool: link: gcc -g -O2 -Wno-declaration-after-statement -D_REENTRANT -o .libs/mclient mclient.o ReadlineTools.o -pthread -Wl,--export-dynamic ./.libs/libmcutil.a ../mapilib/.libs/libmapi.so /var/scratch/sander/MonetDB-11.1.1/common/stream/.libs/libstream.so ../../common/stream/.libs/libstream.so -lbz2 -lreadline -ltermcap -lcrypt -pthread -Wl,-rpath -Wl,/usr/local/lib ../mapilib/.libs/libmapi.so: undefined reference to `MD5' ../mapilib/.libs/libmapi.so: undefined reference to `SHA224' ../mapilib/.libs/libmapi.so: undefined reference to `RIPEMD160' ../mapilib/.libs/libmapi.so: undefined reference to `SHA512' ../mapilib/.libs/libmapi.so: undefined reference to `SHA384' ../mapilib/.libs/libmapi.so: undefined reference to `SHA256' ../mapilib/.libs/libmapi.so: undefined reference to `SHA1' What could be causing this? Any help is much appreciated. Sander Kruseman

2 1

[MonetDB-users] How to access MonetDB in Javascript without XRPC/XQuery?
by dsuh 09 Apr '11

09 Apr '11

Now that XRPC/XQuery is being removed from the MonetDB source, are there any options for client-side browser Javascript access to SQL queries? Would it end up looking like using the PHP interface in the web server side and passing the results to the client-side Javascript? Exactly how would this look like? I am interested in using HTML5/Javascript on the client-side to create a mashup of different data including GIS information from MonetDB. Can anyone suggest possible solutions? David Suh

2 1

[MonetDB-users] history support in mclient across sessions
by Charalampos Nikolaou 07 Apr '11

07 Apr '11

Hi, does mclient support saving of commands in a history file and accessing them again in a future mclient session? Currently, there is a -H option, but it doesn't seem to work (Mar2011 release). Thanks, Babis

2 1