November 2008 - developers-list

[Monetdb-developers] Constraint violations with all details
by Stefan de Konink 23 Nov '08

23 Nov '08

Hi, I cannot find it back in the trackers but I think it have asked this question before. Would it be possible to output the actual failing constraint details instead of 'just an error'. sql>alter table relation_members_way add constraint relation_to_way_fkey foreign key(to_way) references ways; !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'relation_members_way.relation_to_way_fkey' violated Inserting with INSERTS will give a nice error, because the query it self contains the problem. This is not true for a copy into, or in this respect just an alter table. Stefan ps. indeed I have to think too long about a query that will show me the non existing primary keys.

2 2

Re: [Monetdb-developers] Could not create hash table for key test
by Peter Boncz 23 Nov '08

23 Nov '08

Hi Stefan, Like Martin indicated, MonetDB runs out of memory here, when trying to obtain a contiguous area of 14GB. The error messages show that MonetDB is pulling all the stops to try to get this memory from the system. That is, a so-called "trim" buffer manager thread tries to unload all unpinned other tables. To no avail here. You see the actvity of the trim thread only when a GDKmalloc has failed already, and the system tries again after unloading what it can. The fact that though it tries to GDKmalloc you see the GDKload error message indicates that it actually tries to get the 14GB by creating a file and memory mapping on it. The cause for failure can thus be: (1) your file system is full (test just after the error message appears, because a MonetDB restarts first clears out all temp files it created on the last run) (2) you try to process such large loads on a 32-bts machine (naughty naughty) For these large sizes, and the way MonetDB manages mamory, you need a 64-bits OS. Peter > Message: 4 > Date: Sun, 23 Nov 2008 02:04:09 +0100 > From: Stefan de Konink <stefan(a)konink.de> > Subject: [Monetdb-developers] Could not create hash table for key test > To: monetdb-dev <monetdb-developers(a)lists.sourceforge.net> > Message-ID: <4928AC09.7010205(a)konink.de> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > #GDKmalloc(14777222432) fail => BBPtrim(enter) > usage[mem=14840896,vm=27527806976] > #BBPTRIM_ENTER: memsize=14840896,vmsize=27527806976 > #BBPTRIM: memtarget=4611686018427387904 vmtarget=0 > #BBPTRIM_EXIT: memsize=19120128,vmsize=27527806976 > #GDKmalloc(14777222432) fail => BBPtrim(ready) > usage[mem=11538120,vm=27527806976] > #BATpropcheck: BAT tmp_1260(-688): could not allocate hash table for key > test > #GDKmalloc(14777222432) fail => BBPtrim(enter) > usage[mem=11537664,vm=27527806976] > #BBPTRIM_ENTER: memsize=11537664,vmsize=27527806976 > #BBPTRIM: memtarget=4611686018427387904 vmtarget=0 > #BBPTRIM_EXIT: memsize=19120128,vmsize=27527806976 > #GDKmalloc(14777222432) fail => BBPtrim(ready) > usage[mem=10416208,vm=27527806976] > #BATpropcheck: BAT tmp_1135(-605): could not allocate hash table for key > test > MAPI = monetdb@localhost:50000 > QUERY = COPY 773410980 RECORDS INTO node_tags from > '/mnt/data2/csv/node_tags.csv' USING DELIMITERS ',', '\n', ''''; > ERROR = !MALException: GDKmallocmax: failed for 1892320544 bytes > !ERROR: GDKload: failed name=12/1252, ext=thash > !ERROR: GDKmallocmax: failed for 1892320544 bytes > !ERROR: GDKload: failed name=12/1253, ext=thash > > What kind of voodoo is this? > > I'm trying to import a 42GB csv file using copy into, on a native > system, 2GB of memory, 4GB of swap. Latest CVS version, this time > compiled for CoreDuo, without debuging, with optimise. > > > Stefan > > > > ------------------------------ > > Message: 5 > Date: Sun, 23 Nov 2008 03:02:18 +0100 > From: Stefan de Konink <stefan(a)konink.de> > Subject: Re: [Monetdb-developers] Could not create hash table for key > test > To: monetdb-dev <monetdb-developers(a)lists.sourceforge.net> > Message-ID: <4928B9AA.5060401(a)konink.de> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > #BBPTRIM_ENTER: memsize=180224,vmsize=14397997056 > #BBPTRIM: memtarget=0 vmtarget=0 > #BBPTRIM_EXIT: memsize=20365312,vmsize=14397997056 > #BBPTRIM_ENTER: memsize=2496368440,vmsize=16874000184 > #BBPTRIM: memtarget=778092856 vmtarget=0 > #BBPTRIM_EXIT: memsize=20365312,vmsize=10150287928 > Killed > > This one also doen't make me happy. The initial table that are inserted > without a problem are of 19GB and 1GB. > > The table that fails after it is 7GB. > > > Now obviously we are talking about a system that could use some more > memory. But I don't really see why it is inserting 20GB without a > problem, and then borks on the inserting of 7GB. A non string, table. > > > > Stefan > > > > ------------------------------ > > Message: 6 > Date: Sun, 23 Nov 2008 08:32:00 +0100 > From: Martin Kersten <Martin.Kersten(a)cwi.nl> > Subject: Re: [Monetdb-developers] Could not create hash table for key > test > To: Stefan de Konink <stefan(a)konink.de>, monetdb-dev > <monetdb-developers(a)lists.sourceforge.net> > Message-ID: <492906F0.5060209(a)cwi.nl> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Dear Stefan, > Let's explain as far as possible. > > Stefan de Konink wrote: >> #GDKmalloc(14777222432) fail => BBPtrim(enter) >> usage[mem=14840896,vm=27527806976] >> #BBPTRIM_ENTER: memsize=14840896,vmsize=27527806976 >> #BBPTRIM: memtarget=4611686018427387904 vmtarget=0 >> #BBPTRIM_EXIT: memsize=19120128,vmsize=27527806976 >> > The system is trying to malloc space for (in this case) a hash table, > but that instruction fails. Then it attempts to free up memory by > swapping out tables. > Given the fact that after this sweep it still fails, indicates that > your swap memory has become fragmented, such that there is no > consecutive area of 14 GB left. > > For large table loads (relative to the swap size) it is advisable to > load in multiple steps. > First load the data into the tables without (foreign) key checks. > After this step ALTER the tables to respect the (foreign) keys. > > Better solutions are being worked on. >> #GDKmalloc(14777222432) fail => BBPtrim(ready) >> usage[mem=11538120,vm=27527806976] >> #BATpropcheck: BAT tmp_1260(-688): could not allocate hash table for key >> test >> #GDKmalloc(14777222432) fail => BBPtrim(enter) >> usage[mem=11537664,vm=27527806976] >> #BBPTRIM_ENTER: memsize=11537664,vmsize=27527806976 >> #BBPTRIM: memtarget=4611686018427387904 vmtarget=0 >> #BBPTRIM_EXIT: memsize=19120128,vmsize=27527806976 >> #GDKmalloc(14777222432) fail => BBPtrim(ready) >> usage[mem=10416208,vm=27527806976] >> #BATpropcheck: BAT tmp_1135(-605): could not allocate hash table for key >> test >> MAPI = monetdb@localhost:50000 >> QUERY = COPY 773410980 RECORDS INTO node_tags from >> '/mnt/data2/csv/node_tags.csv' USING DELIMITERS ',', '\n', ''''; >> ERROR = !MALException: GDKmallocmax: failed for 1892320544 bytes >> !ERROR: GDKload: failed name=12/1252, ext=thash >> !ERROR: GDKmallocmax: failed for 1892320544 bytes >> !ERROR: GDKload: failed name=12/1253, ext=thash >> >> What kind of voodoo is this? >> >> I'm trying to import a 42GB csv file using copy into, on a native >> system, 2GB of memory, 4GB of swap. Latest CVS version, this time >> compiled for CoreDuo, without debuging, with optimise. >> >> >> Stefan >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> Monetdb-developers mailing list >> Monetdb-developers(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-developers >> > > > > > ------------------------------ > > Message: 7 > Date: Sun, 23 Nov 2008 09:32:30 +0100 > From: Martin Kersten <Martin.Kersten(a)cwi.nl> > Subject: Re: [Monetdb-developers] Could not create hash table for key > test > To: Stefan de Konink <stefan(a)konink.de>, monetdb-dev > <monetdb-developers(a)lists.sourceforge.net> > Message-ID: <4929151E.2040909(a)cwi.nl> > Content-Type: text/plain; charset=ISO-8859-1; format=flowed > > Stefan de Konink wrote: >> #BBPTRIM_ENTER: memsize=180224,vmsize=14397997056 >> #BBPTRIM: memtarget=0 vmtarget=0 >> #BBPTRIM_EXIT: memsize=20365312,vmsize=14397997056 >> #BBPTRIM_ENTER: memsize=2496368440,vmsize=16874000184 >> #BBPTRIM: memtarget=778092856 vmtarget=0 >> #BBPTRIM_EXIT: memsize=20365312,vmsize=10150287928 >> Killed >> > ^^^^^^^^ > This means the process is victimized by the Linux kernel. >> This one also doen't make me happy. The initial table that are inserted >> without a problem are of 19GB and 1GB. >> >> The table that fails after it is 7GB. >> >> >> Now obviously we are talking about a system that could use some more >> memory. But I don't really see why it is inserting 20GB without a >> problem, and then borks on the inserting of 7GB. A non string, table. >> >> >> >> Stefan >> >> ------------------------------------------------------------------------- >> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge >> Build the coolest Linux based applications with Moblin SDK & win great >> prizes >> Grand prize is a trip for two to an Open Source event anywhere in the world >> http://moblin-contest.org/redirect.php?banner_id=100&url=/ >> _______________________________________________ >> Monetdb-developers mailing list >> Monetdb-developers(a)lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/monetdb-developers >> > > > > > ------------------------------ > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > > ------------------------------ > > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > > > End of Monetdb-developers Digest, Vol 30, Issue 9 > ************************************************* >

2 1

[Monetdb-developers] MAPI protocol suggestion
by Stefan de Konink 22 Nov '08

22 Nov '08

Hi, With light on my recent philosophical question on doubles/uints for the lossy storage on coordinates. I wonder the following; Would it be possible to implement a binary MAPI protocol that can use the native types of the data that is stored within MonetDB? So for example; I create a table: CREATE TABLE helloword (hello varchar(13), world integer); INSERT INTO helloword (hello, world) VALUES ('hoi', 1); And fetch this table: SELECT hello, world FROM helloworld; And receive the MAPI data in the following (too simplistic) way: (len) (string) --> 5 hello 5 world --> 3 hoi 4 0x0 0x0 0x0 0x1 For several reasons the above will not work; the length field is too short (only up to 255) it is also not optimal. I wonder if it can trigger any idea to allow the end user to use native types instead of char[]'s. Stefan

2 4

Re: [Monetdb-developers] [Monetdb-checkins] java Makefile.ag, , 1.11, 1.12 build.properties, , 1.5, 1.6 release.txt, , 1.5, 1.6
by Stefan Manegold 18 Nov '08

18 Nov '08

Fabian, Sjoerd, shouldn't we then also increase the "version" of the java tarball, e.g., ======== $ sed -i -e 's|20080625|20081118|' java/configure.ag java/NT/rules.msc ======== $ cvs diff java/configure.ag java/NT/rules.msc -------- Index: java/configure.ag =================================================================== RCS file: /cvsroot/monetdb/java/configure.ag,v retrieving revision 1.16 diff -u -r1.16 configure.ag --- java/configure.ag 10 Oct 2008 08:41:25 -0000 1.16 +++ java/configure.ag 18 Nov 2008 10:36:12 -0000 @@ -20,7 +20,7 @@ # Process this file with autoconf to produce a configure script. AC_PREREQ(2.59) -AC_INIT([MonetDB Java], [20080625], [monet(a)cwi.nl] [MonetDB-java]) +AC_INIT([MonetDB Java], [20081118], [monet(a)cwi.nl] [MonetDB-java]) AC_CONFIG_AUX_DIR(conf) AM_INIT_AUTOMAKE AM_CONFIG_HEADER([monetdb_java_config.h]) Index: java/NT/rules.msc =================================================================== RCS file: /cvsroot/monetdb/java/NT/rules.msc,v retrieving revision 1.9 diff -u -r1.9 rules.msc --- java/NT/rules.msc 10 Oct 2008 08:41:25 -0000 1.9 +++ java/NT/rules.msc 18 Nov 2008 10:36:12 -0000 @@ -29,6 +29,6 @@ MONETDB_LIBS=/libpath:"$(MONETDB_PREFIX)\lib" pkg = MonetDB -VERSION=20080625 +VERSION=20081118 ODBC_LIBS = odbccp32.lib user32.lib ======== The java tarball has a date as "version number", since it contains JDBC & XRPC and hence can/should not have the JDBC version number. (The xrpc wrapper .jar files do not even have a versioning schema, yet ...) Stefan On Tue, Nov 18, 2008 at 10:27:33AM +0000, Fabian wrote: > Update of /cvsroot/monetdb/java > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv13749 > > Modified Files: > Makefile.ag build.properties release.txt > Log Message: > Bump version due to changed licence. Nothing has changed between 1.8 and 1.9, tagged suffix (Excelsa) with the current release (Nov2008). We should probably make a note of this in the general release notes. > > U Makefile.ag > Index: Makefile.ag > =================================================================== > RCS file: /cvsroot/monetdb/java/Makefile.ag,v > retrieving revision 1.11 > retrieving revision 1.12 > diff -u -d -r1.11 -r1.12 > --- Makefile.ag 10 Oct 2008 08:41:25 -0000 1.11 > +++ Makefile.ag 18 Nov 2008 10:27:31 -0000 1.12 > @@ -30,7 +30,7 @@ > ant_distjdbc = { > COND = HAVE_JAVAJDBC > DIR = datadir/MonetDB/lib > - FILES = monetdb-1.3-mcl.jar monetdb-1.8-jdbc.jar jdbcclient.jar > + FILES = monetdb-1.3-mcl.jar monetdb-1.9-jdbc.jar jdbcclient.jar > } > > ant_distxrpc = { > > U release.txt > Index: release.txt > =================================================================== > RCS file: /cvsroot/monetdb/java/release.txt,v > retrieving revision 1.5 > retrieving revision 1.6 > diff -u -d -r1.5 -r1.6 > --- release.txt 16 Jun 2008 12:46:39 -0000 1.5 > +++ release.txt 18 Nov 2008 10:27:31 -0000 1.6 > @@ -1,8 +1,8 @@ > RELEASE NOTES > -MonetDB JDBC driver version 1.8 (Excelsa/MCL-1.3) > +MonetDB JDBC driver version 1.9 (Excelsa-Nov2008/MCL-1.3) > Fabian Groffen <Fabian.Groffen(a)cwi.nl> > > -Release date: 2008-06-16 > +Release date: 2008-11-18 > > > This JDBC driver is designed for use with MonetDB, a main-memory > @@ -12,6 +12,8 @@ > interface are available. It is believed, however, that this > implementation is rich enough to be suitable for a majority of > application settings. > +Most notably, JDBC4 is not implemented at the moment. This disallows > +Java 1.6 and up to compile the driver from source. > > Below a list of supported features can be found. Please read this list > if you intend to use this driver. If you feel some features are > > U build.properties > Index: build.properties > =================================================================== > RCS file: /cvsroot/monetdb/java/build.properties,v > retrieving revision 1.5 > retrieving revision 1.6 > diff -u -d -r1.5 -r1.6 > --- build.properties 16 Jun 2008 12:46:39 -0000 1.5 > +++ build.properties 18 Nov 2008 10:27:31 -0000 1.6 > @@ -19,9 +19,9 @@ > # major release number > JDBC_MAJOR=1 > # minor release number > -JDBC_MINOR=8 > +JDBC_MINOR=9 > # an additional identifying string > -JDBC_VER_SUFFIX=Excelsa > +JDBC_VER_SUFFIX=Excelsa-Nov2008 > # the default port to connect on, if no port given when using SQL > JDBC_DEF_PORT=50000 > # the default port to connect on, if no port given when using XML:DB > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime/xrpc/admin/Tests db_env.stable.out, XQuery_0-24, 1.1.2.1, 1.1.2.2
by Stefan Manegold 18 Nov '08

18 Nov '08

On Mon, Nov 17, 2008 at 05:53:14PM +0000, Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv17083/admin/Tests > > Modified Files: > Tag: XQuery_0-24 Also this one: checked in in wrong branch! Stefan > db_env.stable.out > Log Message: > new output (with one additional bun) > > > > U db_env.stable.out > Index: db_env.stable.out > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests/Attic/db_env.stable.out,v > retrieving revision 1.1.2.1 > retrieving revision 1.1.2.2 > diff -u -d -r1.1.2.1 -r1.1.2.2 > --- db_env.stable.out 17 Nov 2008 12:03:42 -0000 1.1.2.1 > +++ db_env.stable.out 17 Nov 2008 17:53:12 -0000 1.1.2.2 > @@ -125,6 +125,9 @@ > <bun head="xrpc_trusted"> > # http://monetdb.cwi.nl;http://127.0.0.1;http://localhost;/net/jarl/export/sc… > </bun> > + <bun head="xrpc_user"> > +# http://127.0.0.1;127.0.0.1;http://localhost;localhost > + </bun> > </XQueryResult> > > # 12:02:35 > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

18 Nov '08

Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder/runtime/xrpc/admin/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv22023 > > Added Files: > Tag: XQuery_0-24 Checked in in wrong branch. > All add_del_doc.prologue.src add_del_doc.stable.err > add_del_doc.stable.out add_del_doc.xq.in add_trusted.mil > backup_restore.prologue.src backup_restore.stable.err > backup_restore.stable.out backup_restore.xq.in > db_env.prologue.src db_env.stable.err db_env.stable.out > db_env.xq.in db_stats.prologue.src db_stats.stable.err > db_stats.stable.out db_stats.xq.in > Log Message: > Tests for the admin XQuery functions > > > > > --- NEW FILE: db_stats.stable.err --- > stderr of test 'db_stats` in directory 'runtime/xrpc/admin` itself: > > > # 11:06:16 > > # 11:06:16 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=36716 --set xrpc_port=46327 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" db_stats.prologue ; echo ; echo Over.. > # 11:06:16 > > > > # 11:06:16 > > # 11:06:16 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=36716 db_stats.xq > # 11:06:16 > > > > # 11:06:17 > > # 11:06:17 > Done. > # 11:06:17 > > > > --- NEW FILE: All --- > add_del_doc > backup_restore > db_stats > db_env > > --- NEW FILE: backup_restore.stable.out --- > stdout of test 'backup_restore` in directory 'runtime/xrpc/admin` itself: > > > # 11:19:35 > > # 11:19:35 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=37835 --set xrpc_port=44669 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" backup_restore.prologue ; echo ; echo Over.. > # 11:19:35 > > > > > # MonetDB Server v4.24.0 > # based on GDK v1.24.1 > # Copyright (c) 1993-2008, CWI. All rights reserved. > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # PF/Tijah module v0.5.0 loaded. http://dbappl.cs.utwente.nl/pftijah > # MonetDB/XQuery module v0.24.1 loaded (default back-end is 'milprint_summer') > # XRPC administrative console at http://127.0.0.1:44669/admin > > printf("\nReady.\n"); > > Ready. > quit(); > > Over.. > > # 11:19:36 > > # 11:19:36 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=37835 backup_restore.xq > # 11:19:36 > > > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult><db-before-backup><document updatable="true" collection="xmark">xmark1.xml</document><document updatable="true" collection="xmark">xmark2.xml</document></db-before-backup></XQueryResult> > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult></XQueryResult> > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult><db-after-del/></XQueryResult> > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult><db-after-restore><document updatable="false" collection="xmark" uri="">xmark1.xml</document><document updatable="false" collection="xmark" uri="">xmark2.xml</document></db-after-restore></XQueryResult> > > # 11:19:37 > > # 11:19:37 > Done. > # 11:19:37 > > > > --- NEW FILE: db_env.stable.out --- > stdout of test 'db_env` in directory 'runtime/xrpc/admin` itself: > > > # 12:02:34 > > # 12:02:34 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=32688 --set xrpc_port=47901 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" db_env.prologue ; echo ; echo Over.. > # 12:02:34 > > > > > # MonetDB Server v4.24.0 > # based on GDK v1.24.1 > # Copyright (c) 1993-2008, CWI. All rights reserved. > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # PF/Tijah module v0.5.0 loaded. http://dbappl.cs.utwente.nl/pftijah > # MonetDB/XQuery module v0.24.1 loaded (default back-end is 'milprint_summer') > # XRPC administrative console at http://127.0.0.1:47901/admin > > printf("\nReady.\n"); > > Ready. > quit(); > > Over.. > > # 12:02:34 > > # 12:02:34 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=32688 db_env.xq > # 12:02:34 > > > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult> > <bun head="config"> > # /net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf > </bun> > <bun head="datadir"> > # /net/jarl/export/scratch0/zhang/monet-install/stable/debug/share > </bun> > <bun head="gdk_alloc_map"> > # no > </bun> > <bun head="gdk_arch"> > # 64bitx86_64-unknown-linux-gnu > </bun> > <bun head="gdk_dbfarm"> > # /net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm > </bun> > <bun head="gdk_dbname"> > # mTests_runtime_xrpc_admin > </bun> > <bun head="gdk_mem_bigsize"> > # 262144 > </bun> > <bun head="gdk_mem_maxsize"> > # 6786091110 > </bun> > <bun head="gdk_mem_pagebits"> > # 14 > </bun> > <bun head="gdk_version"> > # 1.24.0 > </bun> > <bun head="gdk_vmtrim"> > # yes > </bun> > <bun head="host"> > # localhost > </bun> > <bun head="mapi_clients"> > # 2 > </bun> > <bun head="mapi_open"> > # true > </bun> > <bun head="mapi_port"> > # 32688 > </bun> > <bun head="monet_admin"> > # adm > </bun> > <bun head="monet_cwd"> > # /ufs/zhang/homepage/ROOT/mTests/runtime/xrpc/admin > </bun> > <bun head="monet_version"> > # 4.24.0 > </bun> > <bun head="standoff_end"> > # end > </bun> > <bun head="standoff_ns"> > # > </bun> > <bun head="standoff_start"> > # start > </bun> > <bun head="xquery_backend"> > # milprint_summer > </bun> > <bun head="xquery_cacheMB"> > # 100 > </bun> > <bun head="xquery_cacherules"> > # > </bun> > <bun head="xquery_logdir"> > # /net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs > </bun> > <bun head="xquery_output"> > # dm > </bun> > <bun head="xquery_procMB"> > # 128 > </bun> > <bun head="xrpc_admin"> > # 127.0.0.1;http://127.0.0.1;localhost;http://localhost > </bun> > <bun head="xrpc_open"> > # true > </bun> > <bun head="xrpc_options"> > # > </bun> > <bun head="xrpc_port"> > # 47901 > </bun> > <bun head="xrpc_trusted"> > # http://monetdb.cwi.nl;http://127.0.0.1;http://localhost;/net/jarl/export/sc… > </bun> > </XQueryResult> > > # 12:02:35 > > # 12:02:35 > Done. > # 12:02:35 > > > > --- NEW FILE: add_del_doc.prologue.src --- > $TSTSRCDIR/add_trusted.mil > > --- NEW FILE: add_del_doc.xq.in --- > (: > 1. add two xmark documents and show the results; > 2. delete the two added documents and show the results. > > Test the following admin functions: > - adm:collections() > - adm:documents() > - adm:documents($collections) > - adm:add-doc() > - adm:del-col() > - adm:del-doc() > :) > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > (execute at {"$HOST:$XRPCPORT"} > {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark1.xml", > "xmark1.xml", "xmark", 10)}, > execute at {"$HOST:$XRPCPORT"} > {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark2.xml", > "xmark2.xml", "xmark", 10)} > ) > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > (<collections-after-add>{ > execute at {"$HOST:$XRPCPORT"} {adm:collections()} > }</collections-after-add>, > <documents-after-add>{ > let $docs := execute at {"$HOST:$XRPCPORT"} {adm:documents()} > return > for $d in $docs > return element document { > attribute updatable {$d/@updatable}, > attribute collection {$d/@collection}, > $d/text() } > }</documents-after-add>, > <documents-of-collection-after-add>{ > let $docs := execute at {"$HOST:$XRPCPORT"} {adm:documents("xmark")} > return > for $d in $docs > return element document { > attribute updatable {$d/@updatable}, > attribute collection {$d/@collection}, > $d/text() } > }</documents-of-collection-after-add> > ) > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > execute at {"$HOST:$XRPCPORT"} {adm:del-col("xmark")} > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > (<collections-after-del>{ > execute at {"$HOST:$XRPCPORT"} {adm:collections()} > }</collections-after-del>, > <documents-after-del>{ > let $docs := execute at {"$HOST:$XRPCPORT"} {adm:documents()} > return > for $d in $docs > return element document { > attribute updatable {$d/@updatable}, > attribute collection {$d/@collection}, > $d/text() } > }</documents-after-del>, > <documents-of-collection-after-del>{ > let $docs := execute at {"$HOST:$XRPCPORT"} {adm:documents("xmark")} > return > for $d in $docs > return element document { > attribute updatable {$d/@updatable}, > attribute collection {$d/@collection}, > $d/text() } > }</documents-of-collection-after-del> > ) > > > --- NEW FILE: add_del_doc.stable.err --- > stderr of test 'add_del_doc` in directory 'runtime/xrpc/admin` itself: > > > # 16:44:49 > > # 16:44:49 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=36099 --set xrpc_port=49971 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" add_del_doc.prologue ; echo ; echo Over.. > # 16:44:49 > > > > # 16:44:49 > > # 16:44:49 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=36099 add_del_doc.xq > # 16:44:49 > > > > # 16:44:50 > > # 16:44:50 > Done. > # 16:44:50 > > > > --- NEW FILE: db_stats.prologue.src --- > $TSTSRCDIR/add_trusted.mil > > --- NEW FILE: db_env.stable.err --- > stderr of test 'db_env` in directory 'runtime/xrpc/admin` itself: > > > # 11:50:19 > > # 11:50:19 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=36039 --set xrpc_port=47247 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" db_env.prologue ; echo ; echo Over.. > # 11:50:19 > > > > # 11:50:19 > > # 11:50:19 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=36039 db_env.xq > # 11:50:19 > > > > # 11:50:20 > > # 11:50:20 > Done. > # 11:50:20 > > > > --- NEW FILE: db_stats.stable.out --- > stdout of test 'db_stats` in directory 'runtime/xrpc/admin` itself: > > > # 11:06:16 > > # 11:06:16 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=36716 --set xrpc_port=46327 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" db_stats.prologue ; echo ; echo Over.. > # 11:06:16 > > > > > # MonetDB Server v4.24.1 > # based on GDK v1.24.1 > # Copyright (c) 1993-2008, CWI. All rights reserved. > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # PF/Tijah module v0.5.0 loaded. http://dbappl.cs.utwente.nl/pftijah > # MonetDB/XQuery module v0.24.1 loaded (default back-end is 'milprint_summer') > # XRPC administrative console at http://127.0.0.1:46327/admin > > printf("\nReady.\n"); > > Ready. > quit(); > > Over.. > > # 11:06:16 > > # 11:06:16 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=36716 db_stats.xq > # 11:06:16 > > > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult> > <bun head="xquery_index_curMB"> > # 0 > </bun> > <bun head="xquery_cache_curdocs"> > # 0 > </bun> > <bun head="xquery_cache_curMB"> > # 0 > </bun> > <bun head="xquery_log_curMB"> > # 0 > </bun> > <bun head="gdk_vm_cursize"> > # 182517760 > </bun> > <bun head="gdk_mem_cursize"> > # 67584024 > </bun> > </XQueryResult> > > # 11:06:17 > > # 11:06:17 > Done. > # 11:06:17 > > > > --- NEW FILE: db_stats.xq.in --- > (: > Test the following admin functions: > - adm:db-stats() > Filter out uninteresting differences in the results > :) > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > for $stat in execute at {"$HOST:$XRPCPORT"} {adm:db-stats()} > return > (text { "
 " }, > element bun { > $stat/@head, > text { "
# " }, > string($stat/@tail), > text { "
 " } > }), > text { "
" } > > --- NEW FILE: backup_restore.stable.err --- > stderr of test 'backup_restore` in directory 'runtime/xrpc/admin` itself: > > > # 11:19:35 > > # 11:19:35 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=37835 --set xrpc_port=44669 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" backup_restore.prologue ; echo ; echo Over.. > # 11:19:35 > > > > # 11:19:36 > > # 11:19:36 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=37835 backup_restore.xq > # 11:19:36 > > > > # 11:19:37 > > # 11:19:37 > Done. > # 11:19:37 > > > > --- NEW FILE: db_env.prologue.src --- > $TSTSRCDIR/add_trusted.mil > > --- NEW FILE: add_trusted.mil --- > module("pathfinder"); > module("unix"); > > var TSTSRCDIR := getenv("TSTSRCDIR"); > var TSTTRGDIR := getenv("TSTTRGDIR"); > var HOST := getenv("HOST"); > var XRPCPORT := getenv("XRPCPORT"); > > add_xrpc_trusted(TSTSRCDIR); > add_xrpc_trusted(TSTTRGDIR); > add_xrpc_trusted("http://"+HOST+":"+XRPCPORT); > > commit(); > > > --- NEW FILE: add_del_doc.stable.out --- > stdout of test 'add_del_doc` in directory 'runtime/xrpc/admin` itself: > > > # 16:44:49 > > # 16:44:49 > Mserver "--config=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/lib:/net/jarl/export/scratch0/zhang/monet-install/stable/debug/lib/MonetDB4/bin" --set "gdk_dbfarm=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/dbfarm" --set "sql_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/sql_logs" --set "xquery_logdir=/net/jarl/export/scratch0/zhang/monet-install/stable/debug/var/MonetDB4/xquery_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=36099 --set xrpc_port=49971 --set monet_prompt= --trace "--dbname=mTests_runtime_xrpc_admin" "--dbinit= module(pathfinder);" add_del_doc.prologue ; echo ; echo Over.. > # 16:44:49 > > > > > # MonetDB Server v4.24.0 > # based on GDK v1.24.1 > # Copyright (c) 1993-2008, CWI. All rights reserved. > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # PF/Tijah module v0.5.0 loaded. http://dbappl.cs.utwente.nl/pftijah > # MonetDB/XQuery module v0.24.1 loaded (default back-end is 'milprint_summer') > # XRPC administrative console at http://127.0.0.1:49971/admin > > printf("\nReady.\n"); > > Ready. > quit(); > > Over.. > > # 16:44:49 > > # 16:44:49 > mclient -lxquery -fxml -umonetdb -Pmonetdb --host=jarl --port=36099 add_del_doc.xq > # 16:44:49 > > > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult><collections-before-add/><documents-before-add/></XQueryResult> > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult><collections-after-add><collection updatable="true" size="511 KiB" numDocs="2">xmark</collection></collections-after-add><documents-after-add><document updatable="true" collection="xmark">xmark1.xml</document><document updatable="true" collection="xmark">xmark2.xml</document></documents-after-add><documents-of-collection-after-add><document updatable="true" collection="xmark">xmark1.xml</document><document updatable="true" collection="xmark">xmark2.xml</document></documents-of-collection-after-add></XQueryResult> > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult><collections-after-del/><documents-after-del/><documents-of-collection-after-del/></XQueryResult> > > # 16:44:50 > > # 16:44:50 > Done. > # 16:44:50 > > > > --- NEW FILE: db_env.xq.in --- > (: > Test the following admin functions: > - adm:db-env() > Filter out uninteresting differences in the results > :) > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > for $env in execute at {"$HOST:$XRPCPORT"} {adm:db-env()} > return > (text { "
 " }, > element bun { > $env/@head, > text { "
# " }, > string($env/@tail), > text { "
 " } > }), > text { "
" } > > > --- NEW FILE: backup_restore.prologue.src --- > $TSTSRCDIR/add_trusted.mil > > --- NEW FILE: backup_restore.xq.in --- > (: > 1. show current documents in DB > 2. backup current DB > 3. delete all documents in DB > 4. restore backup > > Test the following admin functions: > - adm:add-doc() > - adm:documents() > - adm:backup() > - adm:backup-col() > - adm:del-col() > - adm:del-doc() > - adm:restore() > - adm:restore-col() > :) > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > (execute at {"$HOST:$XRPCPORT"} > {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark1.xml", > "xmark1.xml", "xmark", 10)}, > execute at {"$HOST:$XRPCPORT"} > {adm:add-doc("http://$HOST:$XRPCPORT/admin/xmark2.xml", > "xmark2.xml", "xmark", 10)} > ) > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > <db-before-backup>{ > let $docs := execute at {"$HOST:$XRPCPORT"} {adm:documents()} > return > for $d in $docs > return element document { > attribute updatable {$d/@updatable}, > attribute collection {$d/@collection}, > $d/text() } > }</db-before-backup> > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > execute at {"$HOST:$XRPCPORT"} {adm:backup("test")} > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > execute at {"$HOST:$XRPCPORT"} {adm:del-col("xmark")} > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > <db-after-del>{ > execute at {"$HOST:$XRPCPORT"} {adm:collections()} > }</db-after-del> > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > execute at {"$HOST:$XRPCPORT"} {adm:restore("test", 0)} > <> > import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/" > at "http://$HOST:$XRPCPORT/admin/admin.xq"; > <db-after-restore>{ > let $docs := execute at {"$HOST:$XRPCPORT"} {adm:documents()} > return > for $d in $docs > return element document { > attribute updatable {$d/@updatable}, > attribute collection {$d/@collection}, > attribute uri {$d/@uri}, > $d/text() } > }</db-after-restore> > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/server sql_parser.mx, Nov2008, 1.296.2.1, 1.296.2.2
by Sjoerd Mullender 18 Nov '08

18 Nov '08

Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/server > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv6758/src/server > > Modified Files: > Tag: Nov2008 > sql_parser.mx > Log Message: > we don't have lng sizes in types > > > U sql_parser.mx > Index: sql_parser.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/server/sql_parser.mx,v > retrieving revision 1.296.2.1 > retrieving revision 1.296.2.2 > diff -u -d -r1.296.2.1 -r1.296.2.2 > --- sql_parser.mx 17 Nov 2008 22:29:45 -0000 1.296.2.1 > +++ sql_parser.mx 18 Nov 2008 08:09:21 -0000 1.296.2.2 > @@ -4166,7 +4166,7 @@ > { > lng d = $3; ^^^ > if (d > 18) { > - char *msg = sql_message("decimal of " LLFMT " digits are not supported", d); > + char *msg = sql_message("decimal of %d digits are not supported", d); ^^ One change too many or one too few? > yyerror(msg); > _DELETE(msg); > $$.type = NULL; > @@ -4177,14 +4177,14 @@ > } > | sqlDECIMAL '(' nonzero ',' posint ')' > { > - lng d = $3; > - lng s = $5; > + int d = $3; > + int s = $5; > if (s >= d || s + d > 18) { > char *msg = NULL; > if (s >= d) > - msg = sql_message("scale (" LLFMT ") should be less than precision (" LLFMT ")", s, d); > + msg = sql_message("scale (%d) should be less than precision (%d)", s, d); > else > - msg = sql_message("decimal(" LLFMT ","LLFMT") isn't supported because P="LLFMT" + S="LLFMT" > 18", d, s, d, s); > + msg = sql_message("decimal(%d,%d) isn't supported because P=%d + S=%d > 18", d, s, d, s); > yyerror(msg); > _DELETE(msg); > $$.type = NULL; > @@ -4210,7 +4210,7 @@ > } > | sqlFLOAT '(' intval ',' intval ')' > { if ($5 >= $3) { > - char *msg = sql_message("precision(" LLFMT ") should be less than number of digits(" LLFMT ")", $5, $3); > + char *msg = sql_message("precision(%d) should be less than number of digits(%d)", $5, $3); > > yyerror(msg); > _DELETE(msg); > @@ -4241,7 +4241,7 @@ > { sql_find_subtype(&$$, $1, $3, 0); } > | type_alias '(' intval ',' intval ')' > { if ($5 >= $3) { > - char *msg = sql_message("precision(" LLFMT ") should be less than number of digits(" LLFMT ")", $5, $3); > + char *msg = sql_message("precision(%d) should be less than number of digits(%d)", $5, $3); > > yyerror(msg); > _DELETE(msg); > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

1 0

[Monetdb-developers] trace in SQL....
by Romulo Goncalves 17 Nov '08

17 Nov '08

If I use the latest stable version of M5-SQL and I trace a query I can't see the execution time for each MAL instruction. What I get now is the same output as the one output by the explain plus the mal code ends with #end s0_1; # mdb.setTrace(false); Was it a decision or a mistake done during the implementation of the new logging tool called History? Romulo

1 0

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/storage store.mx, Nov2008, 1.22.2.1, 1.22.2.2
by Sjoerd Mullender 14 Nov '08

14 Nov '08

Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/storage > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv25673 > > Modified Files: > Tag: Nov2008 > store.mx > Log Message: > I got the single thing.... > Sorry the mistake... This is exactly what I mean with being *very* conservative and being *absolutely* sure. This error makes me very unhappy. > > U store.mx > Index: store.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/storage/store.mx,v > retrieving revision 1.22.2.1 > retrieving revision 1.22.2.2 > diff -u -d -r1.22.2.1 -r1.22.2.2 > --- store.mx 14 Nov 2008 13:46:52 -0000 1.22.2.1 > +++ store.mx 14 Nov 2008 14:04:09 -0000 1.22.2.2 > @@ -110,7 +110,7 @@ > } > list_destroy(k->columns); > base_destroy(&k->base); > - if ((k->type == pkey) && (k->t->pkey = (sql_ukey *) k)) > + if ((k->type == pkey) && (k->t->pkey == (sql_ukey *) k)) > k->t->pkey = NULL; > _DELETE(k); > } > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

2 1

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/storage store.mx, Nov2008, 1.22, 1.22.2.1
by Sjoerd Mullender 14 Nov '08

14 Nov '08

Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/storage > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv24421 > > Modified Files: > Tag: Nov2008 > store.mx > Log Message: > Set the pkey from the table structure to NULL to avoid garbage when we are checking if the table > already contain a specific pkey... > > > U store.mx > Index: store.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/storage/store.mx,v > retrieving revision 1.22 > retrieving revision 1.22.2.1 > diff -u -d -r1.22 -r1.22.2.1 > --- store.mx 30 Oct 2008 08:48:54 -0000 1.22 > +++ store.mx 14 Nov 2008 13:46:52 -0000 1.22.2.1 > @@ -110,6 +110,8 @@ > } > list_destroy(k->columns); > base_destroy(&k->base); > + if ((k->type == pkey) && (k->t->pkey = (sql_ukey *) k)) Do you really mean a single = here? ^ > + k->t->pkey = NULL; > _DELETE(k); > } > > > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's challenge > Build the coolest Linux based applications with Moblin SDK & win great prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins -- Sjoerd Mullender

2 2