April 2010 - users-list

[MonetDB-users] error when connecting with iSQL-Viewer
by Dave Howorth 13 Apr '10

13 Apr '10

I've just installed iSQL-Viewer and used its wizard to set up a connection to the VOC database that I loaded into MonetDB. But the connection doesn't work; instead I see an error apparently from MonetDB: java.sql.SQLException: ResultSet is closed! at nl.cwi.monetdb.jdbc.MonetResultSet.absolute(MonetResultSet.java:181) at nl.cwi.monetdb.jdbc.MonetResultSet.relative(MonetResultSet.java:2014) at nl.cwi.monetdb.jdbc.MonetResultSet.next(MonetResultSet.java:1981) at org.isqlviewer.sql.ResultSetWrapper.next(ResultSetWrapper.java:1194) at org.isqlviewer.ui.JdbcWorkbench.buildSchemaMenu(JdbcWorkbench.java:1145) at org.isqlviewer.ui.JdbcWorkbench.changeConnection(JdbcWorkbench.java:695) at org.isqlviewer.ui.JdbcWorkbench.actionPerformed(JdbcWorkbench.java:290) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.isqlviewer.swing.action.SwingEventManager$EventLoop.delegateEvent(SwingEventManager.java:340) at org.isqlviewer.swing.action.SwingEventManager$EventLoop.run(SwingEventManager.java:319) at java.lang.Thread.run(Thread.java:636) I've googled the error message without finding anything relevant. I know the VOC database itself works because I managed to connect to it via both the command-line and using SQuirreL. The merovingian.log just says: 2010-04-13 14:06:14 MSG merovingian[7379]: proxying client pcx36.lmb.internal:52677 for database 'test' to mapi:monetdb://127.0.0.1:50002/test Can anybody give me a clue what might cause that error message? Thanks, Dave

2 4

[MonetDB-users] "Copy into ... from STDIN" end of file
by Matthieu Guamis 09 Apr '10

09 Apr '10

Hi, I'm trying to load data using copy command and STDIN source in command line but the process ends without waiting for records. I think this is first step to load data from a second process without using file source. Here is the command: mclient -l sql -d database -u user -P pwd -s "COPY INTO table FROM STDIN" It returns immediately with exit code 0. With postgresql, the "same" command (psql -U user -h host database -c "\copy table from STDIN") prompt for datas and wait until antislash-dot ("\.") input ends records so it allows a process to load datas using STDIN. Do you think this is possible with mclient sql copy command? Regards, Matthieu

2 3

[MonetDB-users] monetdb permission denied
by Dave Howorth 09 Apr '10

09 Apr '10

Hi, noob question ... I've just installed MonetDB on an Ubuntu Karmic machine. I've got merovingian running: monetdb 7379 1 0 Apr06 ? 00:00:01 /usr/bin/merovingian but I see permission denied when I try to use monetdb on the same machine: $ monetdb status permission denied As an experiment, I have added my user to the monetdb group and I have changed the permissions so that the monetdb group can access the socket: root:/var/MonetDB5/dbfarm# ls -la total 12 drwxrwx--- 2 monetdb monetdb 4096 Apr 6 17:13 . drwxrwx--- 3 monetdb monetdb 4096 Apr 6 17:13 .. srwxrwx--- 1 monetdb monetdb 0 Apr 6 17:13 .merovingian_control -rw------- 1 monetdb nogroup 0 Apr 6 17:13 .merovingian_lock -rw------- 1 monetdb nogroup 48 Apr 6 17:13 .merovingian_pass But I still see permission denied. What's the correct way to set the system up? A pointer to whichever piece of the docs that I've missed would be ideal :) Thanks, Dave

4 8

[MonetDB-users] Announcement: New Feb2010-SP1 bugfix release of MonetDB suite
by Sjoerd Mullender 08 Apr '10

08 Apr '10

The MonetDB team at CWI/MonetDB BV is pleased to announce the Feb2010-SP1 bug fix release of the MonetDB suite of programs. More information on this release is available at <http://monetdb.cwi.nl/Development/Releases/Feb2010/>. -- Sjoerd Mullender

2 1

[MonetDB-users] Issue with large number of databases
by Steve Benz 05 Apr '10

05 Apr '10

Hi, We've been pilot testing monet with a small number of db's (~10) for a few months now with great success. We're getting ready to roll out databases for a larger number of databases, but we're experience some issues. We're hoping to run about 130 databases concurrently, however when we get above 55 the command `monetdb status` appears to experience issues: WARNING: failed to parse response from merovingian: IllegalArgumentException:sabaoth.deserialise:string does not contain path: /usr/local/MonetDB/var/Monet (it then successfully lists 54 of the databases) (we have our monetdb installed in /usr/local) The merovingian.log doesn't show any errors, just: 2010-04-05 09:55:58 MSG control[2260]: (local): served status list There also doesn't appear to be any odd characters in any of the db names. Has anyone successfully tested this number of db's running on the same server? Thanks for any help you can provide! Steve

2 1

[MonetDB-users] Superball build failure
by Matthew Jones 02 Apr '10

02 Apr '10

I recently downloaded the MonetDB-Feb2010-SuperBall-SP1.tar.bz2 file from the site in order to build MonetDB and I get this build failure: (...) config.status: creating mal_config.h config.status: executing depfiles commands config.status: executing libtool commands make all-recursive make[1]: Entering directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5' Making all in src make[2]: Entering directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5/src' make all-recursive make[3]: Entering directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5/src' Making all in mal make[4]: Entering directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5/src/mal' make[4]: Leaving directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5/src/mal' make[4]: *** No rule to make target `mal.c', needed by `all'. Stop. make[3]: *** [all-recursive] Error 1 make[3]: Leaving directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5/src' make[2]: Leaving directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5/src' make[1]: Leaving directory `/var/tmp/MonetDB-1270235519/MonetDB5-server/MonetDB5' Please refer to the full log at /var/tmp/MonetDB-1270235519/log If you believe this is an error in the script or the software, file a bug and attach the logfile. make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 making MonetDB5-server failed I actually also see this error if I build the server package standalone after building and installing the pre-reqs 73, Matthew W. Jones (KI4ZIB) http://matburt.net

2 4

Re: [MonetDB-users] [Monetdb-developers] dealing with 1G XML file in MonetDB/XQuery
by Martin Kersten 02 Apr '10

02 Apr '10

Mo Zhou wrote: > Hello, > > Could you please reply as soon as possible? From your email it is unclear what platform you are using. I guess it is a Windows 32bit version. The document you use may easily consume more memory when processed, exceeding the 32-bit addressing scheme. A 64-bit version is advised. (See earlier threads on this topic) regards, Martin > > > Thanks, > Mo > On Thu, Apr 1, 2010 at 4:49 PM, Mo Zhou <mozhou(a)umail.iu.edu> wrote: >> Hi, >> >> When I load a 1G XML file to MonetDB/XQuery, it throws exceptions as >> follows. I did not find related parameters in the monetDB config file >> to enlarge the heap size. I wonder how I can solve this problem? Thank >> you. >> >> #GDKmmap(1073741824) fails, try to free up space [memory in >> use=156511940,virtual memory in use=1309212672] >> #GDKmmap(1073741824) result [mem=156511940,vm=1309212672] >> MAPI = mozhou@localhost:40000 >> QUERY = pf:add-doc("/.../new1GL1Comp/xmldoc3.xml","1GL1doc3") >> ERROR = !ERROR: [shred_url]: 1 times inserted nil due to errors at tuples 0@0. >> !ERROR: [shred_url]: first error was: >> !ERROR: HEAPextend: failed to extend to 1073741824 for 03/02/30243theap >> !ERROR: shredBAT_append_str: >> APPEND-STR[_prop_text](http://www4.wiwiss.fu-berlin.de/bizer/bsbm/v01/instances/dataFromVendor20/Offer31281/), >> BUNappend fails >> !ERROR: CMDshred_url: operation failed. >> >> -- >> Thanks, >> Mo >> > > >

2 1

Re: [MonetDB-users] [Monetdb-developers] the database and index size
by Stefan de Konink 01 Apr '10

01 Apr '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Op 01-04-10 17:33, Mo Zhou schreef: > Does monetdb compress data in the database? I load plain text file > (12M) into a database with only one table. I shut down the database > right after that and check the size of the database. The database size > is only 8M. Obviously the amount of storage required for storing integers larger than 4 digits in plain text is higher than the amount of data that is required to represent a 4byte integer. Regarding to strings best effort deduplication is choosen. Like with any fileformat there is some metadata overhead. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAku0xBsACgkQYH1+F2Rqwn2vWwCdFts9Z8wYtLEsrqslimq/I3Vi OWEAnjIArIUtzI8yf4mhdlHF/Fy1pS5x =aXYs -----END PGP SIGNATURE-----

1 0