- users-list - monetdb.org

[MonetDB-users] Problem with colums named "begin" and "end"
by Markus Gritsch 25 Nov '07

25 Nov '07

Hi, I have a table with columns named "begin" and "end". With SQLite and MySQL the SELECT works all right, but MonetDB cannot parse the SQL: sql>CREATE TABLE "test" ("id" INT, "begin" TIMESTAMP, "end" TIMESTAMP); sql>INSERT INTO test ("id", "begin", "end") VALUES (0, '2003-02-07 12:00:00', '2003-02-07 12:00:00'); sql>SELECT id, begin end FROM test; !syntax error, unexpected BEGIN in: "select id, begin" Kind regards, Markus

3 4

[MonetDB-users] Memory Leak in mserver5.exe
by Markus Gritsch 24 Nov '07

24 Nov '07

Hi, I have a medium sized dataset of about 50 MB text data. When I repeatedly call SELECT * FROM entry WHERE LOWER(note) LIKE '%hui%' I get at some time not my result, but the following error in DbVisualizer: protocol violation, unexpected line: VirtualAlloc(1a0a0000,29806592,MEM_COMMIT,PAGE_READWRITE): failed Repeatedly calling the query from the command line like this mclient.exe -lsql -s"SELECT * FROM entry WHERE LOWER(note) LIKE '%hui%'" > result.txt produces the attached memory usage graph. After 11 times calling the query the memory is full, and some kind of garbage collection seems to happen. However, after only 6 additional times the memory is again full and the garbage collection is quite less effective than before. Subsequent calls reach the memory limit every time. Markus P.S.: I have disabled the virtual memory on my Windows XP because when the OS starts paging, it becomes unbearably slow.

2 5

[MonetDB-users] New MonetDB Bug Fix Release
by Sjoerd Mullender 24 Nov '07

24 Nov '07

The MonetDB team at CWI is pleased to announce a new bug fix release of the MonetDB suite of programs. The following packages have been released: MonetDB Clients 1.20.2 MonetDB5 Server 5.2.2 MonetDB SQL 2.20.2 There is of course also a new "Super Source Ball", a tarball containing the combined sources. All this is available on our SourceForge project page. See https://sourceforge.net/project/showfiles.php?group_id=56967 for the downloadable files. See http://monetdb.cwi.nl/projects/monetdb/Development/Releases/Version4.20/ind… for a list of fixes. -- Sjoerd Mullender

1 0

[MonetDB-users] MonetSQLdb and Unicode
by Markus Gritsch 23 Nov '07

23 Nov '07

Hi, is the Python module MonetSQLdb expected to handle unicode? Currently when INSERTing I must make sure that Python unicode types get converted to strings using UTF-8 encoding. Likewise when SELECTing I get UTF-8 encoded strings back. BTW, is it possible to use another encoding than UTF-8 with MonetDB? The Python DB API for SQLite allows inserting Python unicode types and yields unicode when selecting. MySQLdb allows specifying a 'charset' parameter in the connection constructor and uses this charset to automatically encode unicode objects when inserting. It also returns unicode objects. The following script raises an exception when used with MonetDB: import MonetSQLdb x = MonetSQLdb.connect() c = x.cursor() c.execute('DROP TABLE test') c.execute('CREATE TABLE test(id int, name varchar(20))') c.execute('INSERT INTO test (id, name) VALUES (%s, %s)', (0, u'm')) c.execute("SELECT * FROM test") value = c.fetchone()[-1] print type(value) c.close() x.close() --- Traceback (most recent call last): File "test.py", line 8, in <module> c.execute('INSERT INTO test (id, name) VALUES (%s, %s)', (0, u'm')) File "C:\Python25\lib\site-packages\mdb\MonetSQLdb\cursors.py", line 95, in execute self.errorhandler(self, exc, value) File "C:\Python25\lib\site-packages\mdb\MonetSQLdb\__init__.py", line 77, in defaulterrorhandler raise errorclass, errorvalue RuntimeError: !SELECT: identifier 'm' unknown

2 1

[MonetDB-users] No useful error message on SQL syntax error
by Markus Gritsch 23 Nov '07

23 Nov '07

Hi, when using MonetSQLdb from Python and the executed SQL contains a syntax error, there is no useful information displayed in the traceback. The following script for example import MonetSQLdb x = MonetSQLdb.connect() c = x.cursor() c.execute('DROP TABLE test') c.execute('DROP TABLE test') yield this traceback: Traceback (most recent call last): File "testMonetDB.py", line 9, in <module> c.execute('DROP TABLE test') File "C:\Python25\lib\site-packages\mdb\MonetSQLdb\cursors.py", line 95, in execute self.errorhandler(self, exc, value) File "C:\Python25\lib\site-packages\mdb\MonetSQLdb\__init__.py", line 72, in defaulterrorhandler raise errorclass, errorvalue RuntimeError: None The Message is None whereas it should be DROP TABLE: no such table 'test' Kind regards, Markus

2 2

[MonetDB-users] bug 1834820 AUTO_INCREMENT failures...
by m h 22 Nov '07

22 Nov '07

Hello again - I've filed another bug here.... http://sourceforge.net/tracker/index.php?func=detail&aid=1834820&group_id=5… Similar to the NUMERIC not allowing initial NULLs, AUTO_INCREMENT won't allow skipping of Primary Keys (the first time after, the second time it works) after you've inserted with a Primary Key... -matt

2 3

[MonetDB-users] Merovingian
by Venks 21 Nov '07

21 Nov '07

Hi, I have been using some old scripts to START and STOP MonetDB instances. One of our requirements is to not to use default database and default directories for data/logs. So, I specify the data/log/checkpoint and the mapi_port explicitly when I bring up the instance using "mserver5". Please find enclosed the actual command from the START script below. #...Launch the database /root/countdb/bin/mserver5 --dbfarm=/mnt/countdb1/dbfarm --dbname=csdb --dbinit='include sql;' --set sql_logdir=/mnt/countdb1/sql_logs --set checkpoint_dir=/mnt/countdb1/chkpnt --set mapi_port=50001 --set daemon=yes --set monet_welcom=no --set MONETDB5_PREFIX=$MDIR >> $LOG 2>&1 & I understand the "merovingian" is the new and updated program to handle instance administration issues. Can you please provide more information on how I can use "merovingian" to START/STOP MonetDB instances? Is there online help for "merovingian" apart from what mentioned in the configuration file? Like "mserver5 --help" I was expecting "merovingian --help" but that doesn't work. Thanks, -Venks

4 5

[MonetDB-users] Running multiple instances on same machine
by Venks 21 Nov '07

21 Nov '07

Hi, Can you please tell me how to run three different MonetDB instances on one machine? I created three different binaries from the install and I tried to change the port from 50000 to 50001, 50002 and 50003. But for some reason I can only connect using 50000. Thanks, -Venks

3 3

[MonetDB-users] Bug 1833800 - python client not getting actual errors, only None
by m h 19 Nov '07

19 Nov '07

I've filed bug 1833800. It was reported in passing in a previous thread that the python client isn't getting the acutal errors. A fix for this wonderful! thanks much, matt

2 3

[MonetDB-users] python issues
by m h 17 Nov '07

17 Nov '07

Hello- The simple python example from the website is crashing [0]. I get the following output when I try to run it: matt@r52 ~/work/II/svn/trunk/2MonetDB $ python testmdb.py (981, 'schemas', 980, None, '0', True, '0', '0') *** glibc detected *** python: free(): invalid pointer: 0x080cf8d8 *** ======= Backtrace: ========= /lib/libc.so.6[0xb7cdea00] /lib/libc.so.6(cfree+0x89)[0xb7ce06f9] /usr/lib/libMapi.so.0(mapi_destroy+0x77)[0xb7b4a40f] /home/matt/work/vpython/lib/python2.4/site-packages/MonetDB/_MapiLib.so[0xb7fa25a5] /usr/lib/libpython2.4.so.1.0(PyCFunction_Call+0x10d)[0xb7eef420] /usr/lib/libpython2.4.so.1.0(PyEval_EvalFrame+0x3259)[0xb7f1c7b5] /usr/lib/libpython2.4.so.1.0(PyEval_EvalCodeEx+0x62e)[0xb7f1e17a] /usr/lib/libpython2.4.so.1.0[0xb7ee1d0c] /usr/lib/libpython2.4.so.1.0(PyObject_Call+0x27)[0xb7ece52e] /usr/lib/libpython2.4.so.1.0[0xb7ed378e] /usr/lib/libpython2.4.so.1.0(PyObject_Call+0x27)[0xb7ece52e] /usr/lib/libpython2.4.so.1.0(PyEval_CallObjectWithKeywords+0xcc)[0xb7f18c55] /usr/lib/libpython2.4.so.1.0[0xb7ed60b5] /usr/lib/libpython2.4.so.1.0(PyDict_DelItem+0xc8)[0xb7eee29a] /usr/lib/libpython2.4.so.1.0[0xb7ed5755] /usr/lib/libpython2.4.so.1.0(PyObject_SetAttr+0xbc)[0xb7ef098b] /usr/lib/libpython2.4.so.1.0(PyEval_EvalFrame+0x23b5)[0xb7f1b911] /usr/lib/libpython2.4.so.1.0(PyEval_EvalCodeEx+0x62e)[0xb7f1e17a] /usr/lib/libpython2.4.so.1.0[0xb7ee1d0c] /usr/lib/libpython2.4.so.1.0(PyObject_Call+0x27)[0xb7ece52e] /usr/lib/libpython2.4.so.1.0[0xb7ed378e] /usr/lib/libpython2.4.so.1.0(PyObject_Call+0x27)[0xb7ece52e] /usr/lib/libpython2.4.so.1.0(PyEval_CallObjectWithKeywords+0xcc)[0xb7f18c55] /usr/lib/libpython2.4.so.1.0[0xb7ed60b5] /usr/lib/libpython2.4.so.1.0[0xb7eec587] /usr/lib/libpython2.4.so.1.0(PyDict_SetItem+0xb0)[0xb7eee75d] /usr/lib/libpython2.4.so.1.0[0xb7ed579f] /usr/lib/libpython2.4.so.1.0(PyObject_SetAttr+0xbc)[0xb7ef098b] /usr/lib/libpython2.4.so.1.0(PyEval_EvalFrame+0x2372)[0xb7f1b8ce] /usr/lib/libpython2.4.so.1.0(PyEval_EvalFrame+0x3390)[0xb7f1c8ec] /usr/lib/libpython2.4.so.1.0(PyEval_EvalCodeEx+0x62e)[0xb7f1e17a] /usr/lib/libpython2.4.so.1.0[0xb7ee1d0c] /usr/lib/libpython2.4.so.1.0(PyObject_Call+0x27)[0xb7ece52e] /usr/lib/libpython2.4.so.1.0[0xb7ed378e] /usr/lib/libpython2.4.so.1.0(PyObject_Call+0x27)[0xb7ece52e] /usr/lib/libpython2.4.so.1.0(PyEval_CallObjectWithKeywords+0xcc)[0xb7f18c55] /usr/lib/libpython2.4.so.1.0[0xb7ed60b5] /usr/lib/libpython2.4.so.1.0[0xb7eec587] /usr/lib/libpython2.4.so.1.0(PyDict_SetItem+0xb0)[0xb7eee75d] /usr/lib/libpython2.4.so.1.0(_PyModule_Clear+0x148)[0xb7eef9c3] /usr/lib/libpython2.4.so.1.0(PyImport_Cleanup+0x1ee)[0xb7f2fc18] /usr/lib/libpython2.4.so.1.0(Py_Finalize+0xf9)[0xb7f35261] /usr/lib/libpython2.4.so.1.0(Py_Main+0x9ad)[0xb7f3b1e9] python(main+0x1a)[0x804866e] /lib/libc.so.6(__libc_start_main+0xdc)[0xb7c8efdc] python[0x80485b1] ======= Memory map: ======== 08048000-08049000 r-xp 00000000 08:03 1772622 /home/matt/work/vpython/bin/python 08049000-0804a000 rw-p 00000000 08:03 1772622 /home/matt/work/vpython/bin/python 0804a000-080f5000 rw-p 0804a000 00:00 0 [heap] b7800000-b7821000 rw-p b7800000 00:00 0 b7821000-b7900000 ---p b7821000 00:00 0 b79e1000-b79e9000 r-xp 00000000 08:03 4735072 /lib/libnss_files-2.6.1.so b79e9000-b79ea000 r--p 00007000 08:03 4735072 /lib/libnss_files-2.6.1.so b79ea000-b79eb000 rw-p 00008000 08:03 4735072 /lib/libnss_files-2.6.1.so b79eb000-b79f6000 r-xp 00000000 08:03 4669940 /lib/libbz2.so.1.0.4 b79f6000-b79f7000 r--p 0000a000 08:03 4669940 /lib/libbz2.so.1.0.4 b79f7000-b79f8000 rw-p 0000b000 08:03 4669940 /lib/libbz2.so.1.0.4 b79f8000-b7a06000 r-xp 00000000 08:03 2621464 /lib/libz.so.1.2.3 b7a06000-b7a07000 rw-p 0000d000 08:03 2621464 /lib/libz.so.1.2.3 b7a07000-b7a0d000 r-xp 00000000 08:03 541522 /usr/lib/libstream.so.0.0.0 b7a0d000-b7a0e000 r--p 00005000 08:03 541522 /usr/lib/libstream.so.0.0.0 b7a0e000-b7a0f000 rw-p 00006000 08:03 541522 /usr/lib/libstream.so.0.0.0 b7a0f000-b7af6000 r-xp 00000000 08:03 3432882 /usr/lib/libcrypto.so.0.9.8 b7af6000-b7b0b000 rw-p 000e6000 08:03 3432882 /usr/lib/libcrypto.so.0.9.8 b7b0b000-b7b0e000 rw-p b7b0b000 00:00 0 b7b0e000-b7b3d000 r-xp 00000000 08:03 3432885 /usr/lib/libssl.so.0.9.8 b7b3d000-b7b41000 rw-p 0002e000 08:03 3432885 /usr/lib/libssl.so.0.9.8 b7b41000-b7b4c000 r-xp 00000000 08:03 541530 /usr/lib/libMapi.so.0.0.0 b7b4c000-b7b4d000 r--p 0000a000 08:03 541530 /usr/lib/libMapi.so.0.0.0 b7b4d000-b7b4e000 rw-p 0000b000 08:03 541530 /usr/lib/libMapi.so.0.0.0 b7b73000-b7c79000 rw-p b7b73000 00:00 0 b7c79000-b7da3000 r-xp 00000000 08:03 4735105 /lib/libc-2.6.1.so b7da3000-b7da5000 r--p 0012a000 08:03 4735105 /lib/libc-2.6.1.so b7da5000-b7da6000 rw-p 0012c000 08:03 4735105 /lib/libc-2.6.1.so b7da6000-b7da9000 rw-p b7da6000 00:00 0 b7da9000-b7db2000 r-xp 00000000 08:03 1492902 /usr/lib/gcc/i686-pc-linux-gnu/4.1.2/libgcc_s.so.1 b7db2000-b7db3000 rw-p 00009000 08:03 1492902 /usr/lib/gcc/i686-pc-linux-gnu/4.1.2/libgcc_s.so.1 b7db3000-b7db4000 rw-p b7db3000 00:00 0 b7db4000-b7dd8000 r-xp 00000000 08:03 4735063 /lib/libm-2.6.1.so b7dd8000-b7dd9000 r--p 00023000 08:03 4735063 /lib/libm-2.6.1.so b7dd9000-b7dda000 rw-p 00024000 08:03 4735063 /lib/libm-2.6.1.so b7dda000-b7e85000 r-xp 00000000 08:03 1712627 /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.6/libstdc++.so.5.0.7 b7e85000-b7e8a000 rw-p 000aa000 08:03 1712627 /usr/lib/gcc-lib/i686-pc-linux-gnu/3.3.6/libstdc++.so.5.0.7 b7e8a000-b7e8f000 rw-p b7e8a000 00:00 0 b7e8f000-b7e91000 r-xp 00000000 08:03 4735083 /lib/libutil-2.6.1.so b7e91000-b7e92000 r--p 00001000 08:03 4735083 /lib/libutil-2.6.1.so b7e92000-b7e93000 rw-p 00002000 08:03 4735083 /lib/libutil-2.6.1.so b7e93000-b7e95000 r-xp 00000000 08:03 4735065 /lib/libdl-2.6.1.so b7e95000-b7e96000 r--p 00001000 08:03 4735065 /lib/libdl-2.6.1.so b7e96000-b7e97000 rw-p 00002000 08:03 4735065 /lib/libdl-2.6.1.so b7e97000-b7eaa000 r-xp 00000000 08:03 4735068 /lib/libpthread-2.6.1.so b7eaa000-b7eab000 r--p 00013000 08:03 4735068 /lib/libpthread-2.6.1.so b7eab000-b7eac000 rw-p 00014000 08:03 4735068 /lib/libpthread-2.6.1.so b7eac000-b7eae000 rw-p b7eac000 00:00 0 b7eae000-b7f62000 r-xp 00000000 08:03 2050159 /usr/lib/libpython2.4.so.1.0 b7f62000-b7f63000 r--p 000b3000 08:03 2050159 /usr/lib/libpython2.4.so.1.0 b7f63000-b7f85000 rw-p 000b4000 08:03 2050159 /usr/lib/libpython2.4.so.1.0 b7f85000-b7f8b000 rw-p b7f85000 00:00 0 b7f8b000-b7f8f000 r-xp 00000000 08:03 4166255 /usr/lib/python2.4/lib-dynload/strop.so b7f8f000-b7f90000 r--p 00003000 08:03 4166255 /usr/lib/python2.4/lib-dynload/strop.so b7f90000-b7f92000 rw-p 00004000 08:03 4166255 /usr/lib/python2.4/lib-dynload/strop.so b7f92000-b7f94000 r-xp 00000000 08:03 541562 /usr/lib/libmutils.so.0.0.0 b7f94000-b7f95000 r--p 00001000 08:03 541562 /usr/lib/libmutils.so.0.0.0 b7f95000-b7f96000 rw-p 00002000 08:03 541562 /usr/lib/libmutils.so.0.0.0 b7f96000-b7fab000 r-xp 00000000 08:03 606460 /usr/lib/python2.4/site-packages/MonetDB/_MapiLib.so.0.0.0 b7fab000-b7fac000 r--p 00014000 08:03 606460 /usr/lib/python2.4/site-packages/MonetDB/_MapiLib.so.0.0.0 b7fac000-b7fad000 rw-p 00015000 08:03 606460 /usr/lib/python2.4/site-packages/MonetDB/_MapiLib.so.0.0.0 b7fad000-b7fae000 rw-p b7fad000 00:00 0 b7fb1000-b7fb2000 r-xp b7fb1000 00:00 0 [vdso] b7fb2000-b7fcc000 r-xp 00000000 08:03 4735086 /lib/ld-2.6.1.so b7fcc000-b7fcd000 r--p 00019000 08:03 4735086 /lib/ld-2.6.1.so b7fcd000-b7fce000 rw-p 0001a000 08:03 4735086 /lib/ld-2.6.1.so bff36000-bff58000 rw-p bff36000 00:00 0 [stack] Aborted matt@r52 ~/work/II/svn/trunk/2MonetDB $ I'm running the latest ebuild for gentoo. Any suggestions to remove crashing would be great. thanks much, matt 0 -http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/The-Python-Library.html#The-Python-Library

5 17

[MonetDB-users] (some) Numeric columns don't allow NULL?
by m h 16 Nov '07

16 Nov '07

Hello again, I've got a column declared as such: foo NUMERIC(9, 2), When I try and enter NULL values into it, it gives the following error: !SQLException:int:"" is no decimal value (doesn't contain a '.') Now, the message itself had me confused (still does actually), but I figured out by trial that it was complaining that I was shoving a NULL value in that column. Can someone explain why a NULL value can't go it here? (There is no "NOT NULL" on the column) Also columns defined as "NUMERIC(7,0)" allow NULL values..... Confused..... -matt

2 4

[MonetDB-users] Using DataSource class within MonetDB -- connection error -- cause? fix?
by jsolderitsch 16 Nov '07

16 Nov '07

I got lots of good help with my last query. I am trying to access a MonetDB through Sun's Glassfish app server. I am following an example that uses the Java Persistence API and Netbeans 6.0 beta 2 that has some interesting automation to generate code, in particular for configuration file generation that define the jndi context. But my example doesn't work. My code is based on a tutorial I found that uses Derby which is built into Glassfish. I see the errors: TopLink, version: Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007)) Server: unknown RAR5038:Unexpected exception while creating resource RAR5117 : Failed to obtain/create connection from connection pool [ jdbc_monetdb_localhost_demoPool ]. Reason : Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused RAR5114 : Error allocating connection : [Error in allocating a connection. Cause: Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused] Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused Error Code: 0 Local Exception Stack: Exception [TOPLINK-4002] (Oracle TopLink Essentials - 2.0 (Build b58g-fcs (09/07/2007))): oracle.toplink.essentials.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Error in allocating a connection. Cause: Connection could not be allocated because: Unable to connect (localhost:45123): Connection refused I looked at the class MonetDataSource in the JDBC jar file and I see that the constructor for MonetDataSource uses 45123 for the field portNumber. But there is no apparent way to set the portNumber to something else. How do I get MonetDB to listen on this port? It seems that the default port is 50000. Is there a conf setting I can make to get this to work? What is the difference between portNumber here and port value as checked for in the Driver class? Any help appreciated. Jim -- View this message in context: http://www.nabble.com/Using-DataSource-class-within-MonetDB----connection-e… Sent from the monetdb-users mailing list archive at Nabble.com.

3 7

[MonetDB-users] how to select a column named "column"?
by m h 15 Nov '07

15 Nov '07

Hi all, I'm trying to reflect tables (to create a sqlalchemy backend for monetdb). I need to reflect the tables to do that and need primary keys. This information is stored in keycolumns, yet I can't seem to get the column out by itself. sql>select * from keycolumns; +------+--------+------+---+ |id |column |trunc |nr | +======+========+======+===+ |4394 |vendnum | 0 | 0 | |4393 |vendnum | 0 | 0 | +------+--------+------+---+ Timer 1.750 msec 2 rows sql>select column from keycolumns; !syntax error, unexpected COLUMN in: "select column" Timer 0.163 msec 0 rows sql>select keycolumns.column from keycolumns; !syntax error, unexpected COLUMN in: "select keycolumns.column" Advice??? thanks matt

4 3

[MonetDB-users] how compile PHP interface on Linux
by Martin Minka 15 Nov '07

15 Nov '07

I am running CentOS 4.5 (RHEL4.5). I compiled PHP 5.2.2 from source. I compiled "MonetDB server v5.2.0, based on kernel v1.20.0" from source with monetdb-install.sh . MonetDB server works for me. I downloaded clients-1.20.0.tar.gz, unpacked in /tmp and runned: ./configure --prefix=/mytest/MonetDB --with-php --with-php-config=/mytest/php/bin --with-php-extensiondir=/mytest/php/lib/php/extensions I see only warning, that Buildtools are not installed and that I will not able to build from CVS, that should be fine, I am not using source code from CVS (right?). I run make and it seams to me, that the process is only building only mapiclient and mapilib. Output of make does not mention any problems but there is also no mentioning of PHP in this output. The output files are here http://www.struix.com/phpmonetdb.zip. I wonder, if somebody could help me out. Sincerely, Martin

2 4

[MonetDB-users] Using JDBC for MonetDB across the network
by jsolderitsch 13 Nov '07

13 Nov '07

I successfully installed Monet on Mac OS X (Tiger) and it works as expected. I can use JDBC from Aqua Data Studio or even Netbeans 6.0 beta 2 to access databases I create but my experiments so far are when these clients and the Monet DB are on the same Mac OS X host. Now I want to install Monet on a linux box on my network and access the DB via JDBC from my Mac. I installed Monet on the linux box (Cent OS). But access via JDBC from the Mac does not seem to be working. I seem to connect from the Mac via Aqua Data Studio, but I do not see the demo database. Instead I see a <DEFAULT> database listed with no schemas. I created a new user and and a schema for that user on Linux using the command line client and that seemed to work. But after disconnecting and re-connecting, I still don't see the database. Could I be doing something wrong? Jim -- View this message in context: http://www.nabble.com/Using-JDBC-for-MonetDB-across-the-network-tf4793137.h… Sent from the monetdb-users mailing list archive at Nabble.com.

3 24

[MonetDB-users] Compilation error in MonetDB4
by Ying Zhang 13 Nov '07

13 Nov '07

Hello, I get the following error when compiling the module MonetDB4: (dev branch, on andorea.ins.cwi.nl => fedora 6, MD Athlon(tm) 64 X2 Dual Core Processor 3800+) gcc -m64 -DHAVE_CONFIG_H -I. -I/ufs/zhang/monet/dev/MonetDB4/src/tools -I../.. -I/ufs/zhang/monet/dev/MonetDB4/src/tools -I../monet -I/ufs/zhang/monet/dev/MonetDB4/src/tools/../monet -I../modules/plain -I/ufs/zhang/monet/dev/MonetDB4/src/tools/../modules/plain -I/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB -I/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/common -I/export/scratch1/zhang/monet/dev/G.64.64.d.debug/include/MonetDB/gdk -DLIBEMBEDDEDMIL -Wall -Wextra -std=c99 -g -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wundef -Wp,-D_FORTIFY_SOURCE=2 -D_REENTRANT -c embeddedclient.c -fPIC -DPIC -o .libs/libembeddedmil_la-embeddedclient.o In file included from /ufs/zhang/monet/dev/MonetDB4/src/tools/embeddedclient.mx:69: embeddedclient.h:29:26: error: mapilib/Mapi.h: No such file or directory In file included from /ufs/zhang/monet/dev/MonetDB4/src/tools/embeddedclient.mx:69: embeddedclient.h:31: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'embedded_mil' /ufs/zhang/monet/dev/MonetDB4/src/tools/embeddedclient.mx:183: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'embedded_mil' make[5]: *** [libembeddedmil_la-embeddedclient.lo] Error 1 make[5]: Leaving directory `/export/scratch1/zhang/mbuild/dev/MonetDB4/build-debug/src/tools' I think I have seen such error earlier, in de mailing-list or bug report, but I can't recall it. I believe both my source code and build env. are up-to-date and clean, but this error still looks as if I have some out-dated stuf. Does anybody have a clue about this? Thanks! Jennie

2 2

[MonetDB-users] R: Re: mclient fails to connect to local database server: "No route to host"
by marco.antonelli82＠fastwebnet.it 12 Nov '07

12 Nov '07

>Can you check the merovingian.log file to see if it actually sees a >client connecting, or maybe give another hint why things go wrong? > These lines appear in /usr/local/var/log/merovingian.log when I try to connect with mclient: MSG merovingian[8124]: database 'demo' already running since 2007-11-12 14:24: 35, up min/avg/max: 2/769/4851, crash average: 0.00 0.00 0.00 (10-9=0) MSG merovingian[8124]: redirecting client for database 'demo' to mapi:monetdb: //hp:50001/ The fact is that my host is reffered as "hp" (my machine name) and as "localhost". On my /etc/hosts file "hp" is an alias for 192.168.1.1 and not for 127.0.0.1, and beacuse of this mclient is blocked by my firewall. I changed my /etc/hosts file and now it works, but how to make MonetDB listen on "localhost" instead of "hp"? There is no option for that in /usr/local/etc/monetdb5.conf I find this error message as well when I start the "demo" db: ERR demo[8181]: #warning: please don't forget to set your vault key! ERR demo[8181]: #(see /usr/local/etc/monetdb5.conf) What is this about? Thanks for help Fabian!

2 1

[MonetDB-users] mclient fails to connect to local database server: "No route to host"
by marco.antonelli82＠fastwebnet.it 12 Nov '07

12 Nov '07

Hello everyone, I successfully managed to install MonetDB components(MonetDB-common, MonetDB clients, MonetDB5-server, MonetDB_SQL) on Linux, but I have some problems in running it. These are the steps that I followed from the online documentation: I started merovingian with: sudo merovingian then I created the "demo" database and started it with: sudo monetdb create demo sudo monetdb start demo I checked the status: sudo monetdb status demo name state uptime crashes demo running 29m 6s 0 (if I run this command without 'sudo' i get: monetdb status demo warning: MonetDB Database Server is not running name state uptime crashes demo stopped 1 2007-11-12 12:33:41 Is that normal?) So everything seems fine, but when I run mclient (both as root and normal user) I got an error: mclient -lsql --database=demo !ERROR mapi_reconnect: connect: No route to host Setup connection failed I even tried to add a kernel route with: sudo route add -host localhost lo but it did not help. Does somebody know what is the problem and how to solve it? Best regards, Marco Antonelli

2 1

[MonetDB-users] XQuery: Schema import, Indexing
by Silvio Kohler 09 Nov '07

09 Nov '07

Hi, we're trying to benchmark different XML-DBs, one of them is MonetDB/Xquery. Two questions came up: 1) How is schema import done in MonetDB/XQuery? Does it affect execution time for queries? We imported it in the XML file and also in the query, but did not have any effect on execution time. Also, a lot of schema items such as <xs:enumeration> or <xs:dateTime> seem not to be supported. 2) Is indexing possible? Regards, Silvio

4 4

[MonetDB-users] Is there a blocking connect to server
by Pranav Vaidya 08 Nov '07

08 Nov '07

Hello, Is there a client API in Monet which implements a blocking connect to the Mserver (possibly with a time out). My understanding of mapi_connect is that it is a non-blocking connect. I would appreciate it if someone could kindly direct me in this regard. My thanks in advance. Pranav. -- View this message in context: http://www.nabble.com/Is-there-a-blocking-connect-to-server-tf4768425.html#… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] XQuery: Schema import, Indexing
by Silvio Kohler 06 Nov '07

06 Nov '07

Hi, we're trying to benchmark different XML-DBs, one of them is MonetDB/Xquery. Two questions came up: 1) How is schema import done in MonetDB/XQuery? Does it affect execution time for queries? We imported it in the XML file and also in the query, but did not have any effect on execution time. Also, a lot of schema items such as <xs:enumeration> or <xs:dateTime> seem not to be supported. 2) Is indexing possible? Regards, Silvio

1 0

[MonetDB-users] "merovingian" usage
by Venks 31 Oct '07

31 Oct '07

Recent installation of MonetDB showed the following text at the end of the installation. ==================================== You can start using MonetDB/SQL by starting /root/countdb/bin/merovingian in the background. Read the merovingian(1), monetdb(1) and mclient(1) manpages to learn how to create a database and afterwards connect to it. ==================================== Is "merovingian" ready for usage? When I type "merovingian" I am getting the following error: =============================================================================== unable to create .merovingian_lock file in /root/countdb/var/MonetDB5/dbfarm: No such file or directory =============================================================================== That's because there is no MonetDB5 directory yet. This may be of importance to us as I need to do the following: - Run MonetDB in background - Create the database directory, LOG, CheckPoint and any other files related to any database in a user specified directory. Right now I am using mserver5 executable in a script to start MonetDB in the background. This script was provided by you (Fabian) Please let me know if I need to start using "merovingian" for my needs. Thanks, -Venks

6 14

[MonetDB-users] On Java/JDBC compatibility
by Sander Kruseman 31 Oct '07

31 Oct '07

I thought this might be of interest to some of you. New Java releases are normally upwards binary-compatible with prior releases with only few minor/niche exceptions. This implies that one should normally be able to use recent JVM versions to run MonetDB's (JDBC) class/jar files, even if these were compiled with an older JDK version. See: http://java.sun.com/j2se/1.5.0/compatibility.html and: http://java.sun.com/javase/6/webnotes/compatibility.html#binary Note that the opposite does not hold: class/jar files cannot be run with a JVM older than that from the JDK used to compile them. (Every newer JDK marks its generated class files with a different class file version number, which is checked by the JVM.) I hope this helps. Sander Kruseman

1 0

[MonetDB-users] SQL DELETE bug?
by Sander Kruseman 30 Oct '07

30 Oct '07

Hi, Using server v5.0.0 on Windows with the JDBC terminal v1.18.0, SQL DELETE statements appear to fail. Working in autocommit mode, I issue the following commands: create table test (id int unique not null, name varchar(10) not null); insert into test (id, name) values (1, 'jan'); delete from test where id = 1; select * from test; I get no rows, as was to be expected. However, using DbVisualizer (also using JDBC) I can still see the one inserted table row (after Reload View). After restarting both server and JDBC terminal, I also get the row when using the JDBC terminal. Bug or ignorance? Note that I am using my own schema having been setup with its own user, similar to the VOC tutorial. kind regards, Sander Kruseman

2 2

[MonetDB-users] Large Databases
by algatt 29 Oct '07

29 Oct '07

I am trying to create a large database almost 10GB (TPC-H). When I try to bulk load a 7GB file the server does not work anymore. First, the server quits in the middle of the bulk load, then when I try to re-start the server it does not start showing a message about the OS not having enough space. Then I split the 7GB file into individuals 1GB files, after I upload around 4GB individually, the server crashes. Then when I re-start the server it does not start stating that the BACKUP folder cannot be accessed and not enough permissions! I am using MonetDB 5 on Windows XP 1GB RAM. Any ideas? Thank You. alan -- View this message in context: http://www.nabble.com/Large-Databases-tf4710020.html#a13462531 Sent from the monetdb-users mailing list archive at Nabble.com.

3 3