- users-list - monetdb.org

[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/… [View More]

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 … [View More]

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 … [View More]

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: ====================… [View More]

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 … [View More]

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 … [View More]

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 … [View More]

3 3