- users-list - monetdb.org

[MonetDB-users] DBD::monetdb and database name
by Dave Howorth 14 Apr '10

14 Apr '10

I just started trying to use DBD::MonetDB and ran into a couple of issues. I'm not sure where you prefer to get reports so I thought I'd send it here first. First, although both the version on CPAN and the version on my machine, presumably from the MonetDB installation, both claim to be version 0.09, they are different. IMHO, this is a Bad Idea. Having the up-to-date version on CPAN is desirable since that's what Perl programmers expect. Having two versions with the same number is essential, since otherwise CPAN's and Perl's dependency mechanisms will fail and bug reporting becomes a real problem. Second, and what caused me to investigate more carefully, when I typed in the first example program for DBD::monetdb I saw: $ ./monetdb-test-1.pl DBI connect('','',...) failed: merovingian: no such database 'demo', please create it first That doesn't surprise me, because I didn't create a demo database. But I was surprised when I couldn't find any facility to name the database in the documentation or the code. Except when I actually read the installed code as opposed to the published version on CPAN I see that there is. So please add docs. I've suggested a patch below. Cheers, Dave PS The code will compile a little faster if you use __END__ --- /usr/lib/perl5/DBD/monetdb.pm 2010-03-22 16:22:51.000000000 +0000 +++ perl/DBD/monetdb.pm 2010-04-14 15:18:13.000000000 +0100 @@ -670,6 +670,8 @@ 1; +__END__ + =head1 NAME DBD::monetdb - MonetDB Driver for DBI @@ -783,6 +785,7 @@ $dsn = 'dbi:monetdb:'; $dsn = "dbi:monetdb:host=$host"; $dsn = "dbi:monetdb:host=$host;port=$port"; + $dsn = "dbi:monetdb:host=$host;database=$database"; $dbh = DBI->connect($dsn, $user, $password); @@ -794,7 +797,11 @@ =item port -The port where MonetDB daemon listens to. Default for MonetDB is 50000. +The port where MonetDB daemon listens. Default for MonetDB is 50000. + +=item database + +The name of the database to connect to. =back

2 1

[MonetDB-users] how to set the vm_maxsize and mem_maxsize
by HotMan 14 Apr '10

14 Apr '10

If i want to restrict monetdb (ie let it use less than the available memory) i don't konw how to set the vm_maxsize and mem_maxsize.could you help me? my os is centos 5.2 thank you ! --HotMan -- View this message in context: http://old.nabble.com/how-to-set-the-vm_maxsize-and-mem_maxsize-tp28220922p… Sent from the monetdb-users mailing list archive at Nabble.com.

3 3

[MonetDB-users] monetdb is a MMDB?when this db save the data into disk?
by zhliangzh 14 Apr '10

14 Apr '10

monetdb is a MMDB?i don't konw when this db save the data into disk? -- View this message in context: http://old.nabble.com/monetdb-is-a-MMDB-when-this-db-save-the-data-into-dis… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[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