- developers-list - monetdb.org

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker-2008/Tests is_distinct_broken.SF-2430201.stable.err, , NONE, 1.1 is_distinct_broken.SF-2430201.stable.out, , NONE, 1.1
by Romulo Goncalves 16 Dec '08

16 Dec '08

Niels Nes wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8183/src/test/BugTracker-2008/Tests > > Added Files: > is_distinct_broken.SF-2430201.stable.err > is_distinct_broken.SF-2430201.stable.out > Log Message: > approved output You need to do the same for the stable ;) If not I can't close the bug... Romulo > > > --- NEW FILE: is_distinct_broken.SF-2430201.stable.out --- > stdout of test 'is_distinct_broken.SF-2430201` in directory 'src/test/BugTracker-2008` itself: > > > # 12:32:45 > > # 12:32:45 > mserver5 "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=4 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=35778 --set xrpc_port=45446 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker-2008" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. > # 12:32:45 > > > # MonetDB server v5.9.0, based on kernel v1.27.0 > # Serving database 'mTests_src_test_BugTracker-2008', using 4 threads > # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked > # Copyright (c) 1993-July 2008 CWI. > # Copyright (c) August 2008- MonetDB B.V., all rights reserved > # Visit http://monetdb.cwi.nl/ for further information > # Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:35778/ > # MonetDB/SQL module v2.27.0 loaded > > Ready. > # falling back to direct mode > # falling back to direct mode > # falling back to direct mode > #function user.main():void; > # clients.quit(); > #end main; > > Over.. > > # 12:32:45 > > # 12:32:45 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35778 > # 12:32:45 > > > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > [ 1 ] > % sys.way_tags # table_name > % way # name > % int # type > % 8 # length > [ 23950375 ] > [ 24644162 ] > % . # table_name > % single_value # name > % tinyint # type > % 2 # length > [ 10 ] > % .b # table_name > % a # name > % tinyint # type > % 2 # length > [ 10 ] > > # 12:32:45 > > # 12:32:45 > Done. > # 12:32:45 > > > > --- NEW FILE: is_distinct_broken.SF-2430201.stable.err --- > stderr of test 'is_distinct_broken.SF-2430201` in directory 'src/test/BugTracker-2008` itself: > > > # 12:32:45 > > # 12:32:45 > mserver5 "--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10 --set gdk_nr_threads=4 --set "monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=35778 --set xrpc_port=45446 --set monet_prompt= --trace "--dbname=mTests_src_test_BugTracker-2008" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. > # 12:32:45 > > > # builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu > # builtin opt gdk_version = 1.27.0 > # builtin opt monet_pid = 8562 > # builtin opt prefix = /ufs/niels/scratch/monetdb/Linux-x86_64 > # builtin opt exec_prefix = ${prefix} > # builtin opt gdk_dbname = tst > # builtin opt gdk_dbfarm = ${prefix}/var/MonetDB > # builtin opt gdk_debug = 8 > # builtin opt gdk_mem_bigsize = 262144 > # builtin opt gdk_alloc_map = yes > # builtin opt gdk_mem_pagebits = 14 > # builtin opt gdk_vmtrim = yes > # builtin opt monet_admin = adm > # builtin opt monet_prompt = > > # builtin opt monet_welcome = yes > # builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin > # builtin opt monet_daemon = yes > # builtin opt host = localhost > # builtin opt mapi_port = 50000 > # builtin opt mapi_noheaders = no > # builtin opt mapi_debug = 0 > # builtin opt mapi_clients = 2 > # builtin opt sql_debug = 0 > # builtin opt sql_logdir = ${prefix}/var/MonetDB > # builtin opt xquery_logdir = ${prefix}/var/MonetDB > # builtin opt standoff_ns = http://monetdb.cwi.nl/standoff > # builtin opt standoff_start = start > # builtin opt standoff_end = end > # config opt prefix = /ufs/niels/scratch/monetdb/Linux-x86_64 > # config opt config = ${prefix}/etc/monetdb5.conf > # config opt prefix = /ufs/niels/scratch/monetdb/Linux-x86_64 > # config opt exec_prefix = ${prefix} > # config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm > # config opt gdk_dbname = demo > # config opt gdk_alloc_map = no > # config opt gdk_embedded = no > # config opt gdk_debug = 0 > # config opt monet_mod_path = ${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin > # config opt monet_daemon = no > # config opt monet_welcome = yes > # config opt mero_msglog = ${prefix}/var/log/merovingian.log > # config opt mero_errlog = ${prefix}/var/log/merovingian.log > # config opt mero_timeinterval = 600 > # config opt mero_pidfile = ${prefix}/var/run/merovingian.pid > # config opt mero_exittimeout = 7 > # config opt mero_doproxy = yes > # config opt mero_discoveryttl = 600 > # config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal > # config opt mal_listing = 2 > # config opt checkpoint_dir = ${prefix}/var/MonetDB5/chkpnt > # config opt mapi_port = 50000 > # config opt mapi_open = false > # config opt sql_logdir = ${prefix}/var/MonetDB5/sql_logs > # config opt sql_init = ${exec_prefix}/lib/MonetDB5/sql_init.sql > # cmdline opt config = /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf > # cmdline opt gdk_nr_threads = 4 > # cmdline opt monet_mod_path = /ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin > # cmdline opt gdk_dbfarm = /ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm > # cmdline opt sql_logdir = /ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs > # cmdline opt mapi_open = true > # cmdline opt xrpc_open = true > # cmdline opt mapi_port = 35778 > # cmdline opt xrpc_port = 45446 > # cmdline opt monet_prompt = > # cmdline opt gdk_dbname = mTests_src_test_BugTracker-2008 > # cmdline opt mal_listing = 0 > # cmdline opt gdk_debug = 10 > #warning: please don't forget to set your vault key! > #(see /ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf) > > # 12:32:45 > > # 12:32:45 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=35778 > # 12:32:45 > > > > # 12:32:45 > > # 12:32:45 > Done. > # 12:32:45 > > > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > Monetdb-sql-checkins mailing list > Monetdb-sql-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

1 0

Re: [Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker-2008/Tests is_distinct_broken.SF-2430201.sql, Nov2008, NONE, 1.1.2.2 All, Nov2008, 1.6.2.8, 1.6.2.9
by Sjoerd Mullender 15 Dec '08

15 Dec '08

Where is the stable output? There is no sense running a test if there is no stable output. Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15432 > > Modified Files: > Tag: Nov2008 > All > Added Files: > Tag: Nov2008 > is_distinct_broken.SF-2430201.sql > Log Message: > Add test to cover bug: > is_distinct_broken.SF-2430201 > > Note: Please do not propagate this check in. It was already checked in current cvs branch ;) > > > U All > Index: All > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2008/Tests/All,v > retrieving revision 1.6.2.8 > retrieving revision 1.6.2.9 > diff -u -d -r1.6.2.8 -r1.6.2.9 > --- All 19 Nov 2008 10:39:51 -0000 1.6.2.8 > +++ All 15 Dec 2008 10:04:26 -0000 1.6.2.9 > @@ -30,3 +30,4 @@ > count_with_order_by_and_limit_crashes.SF-2229936 > sql_command_kills_db.SF-2233677 > between_no_columns.SF2102101 > +is_distinct_broken.SF-2430201 > > --- NEW FILE: is_distinct_broken.SF-2430201.sql --- > create table way_tags (way int, k int); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(23950375,1); > insert into way_tags values(24644162,1); > insert into way_tags values(24644162,1); > insert into way_tags values(24644162,1); > > select distinct way from way_tags group by way, k having count(*) > 1; > > drop table way_tags; > > select distinct (select 10 union all select 10); > > select distinct a from (select 10 as a union all select 10 as a) as b; > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > 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-pf-checkins] pathfinder/runtime shredder.mx, , 1.149, 1.150
by Sjoerd Mullender 15 Dec '08

15 Dec '08

Shouldn't this also be done on the stable branch? Jan Flokstra wrote: > Update of /cvsroot/monetdb/pathfinder/runtime > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15280 > > Modified Files: > shredder.mx > Log Message: > - Try to fix [ monetdb-Bugs-2141012 ] XQ: unclear error > > > > U shredder.mx > Index: shredder.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/shredder.mx,v > retrieving revision 1.149 > retrieving revision 1.150 > diff -u -d -r1.149 -r1.150 > --- shredder.mx 11 Dec 2008 13:46:47 -0000 1.149 > +++ shredder.mx 15 Dec 2008 13:27:08 -0000 1.150 > @@ -601,6 +601,8 @@ > return GDK_SUCCEED; > } > > +#define INHOLE(P) (P->pageFree && (P->nnode_pre&REMAP_PAGE_MASK) == ((oid)P->pageFree)) > + > #define _NEXT_PRE_IMP(P) if ((P->nnode_pre++ == GDK_oid_max || P->nnode_nid++ == GDK_oid_max) ||\ > (P->pageFree && (P->nnode_pre&REMAP_PAGE_MASK) == ((oid)P->pageFree) && !createHole(P)))\ > { GDKerror("shredder: failed inserting RID tuple " OIDFMT " \n", (P->nnode_pre-1)); > @@ -1795,6 +1797,17 @@ > break; > } > } > + /* Now check if by coincedence the shredder starts in a not yet > + * created hole. If soo a proper hole has to be created after > + * which the document can start. > + */ > + if ( INHOLE(shredCtx) ) { > + if ( !createHole(shredCtx) ) { > + GDKerror("shredder_create: recover from starting in a hole fails!\n"); > + return shredder_free(shredCtx,-shredCtx->updatable); > + > + } > + } > } > if (shredCtx->nnode_pre <= pre_min) { > shredCtx->nnode_pre = pre_min; > @@ -1822,6 +1835,7 @@ > if (shredCtx->val == NULL || shredCtx->content_buf == NULL || shredCtx->lifo == NULL) { > return shredder_free(shredCtx,-shredCtx->incremental); > } > + > return shredCtx; > } > > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > 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

[Monetdb-developers] bug fix release preparation
by Sjoerd Mullender 15 Dec '08

15 Dec '08

Tomorrow I want to build the December bug fix release. So please no more checkins on the Stable branch, unless you have my express permission. -- Sjoerd Mullender

1 0

[Monetdb-developers] !MALException:mkey.bulk_rotate_xor_hash:command failed
by Stefan de Konink 15 Dec '08

15 Dec '08

sql>ALTER table way_tags add primary key(way, k); !MALException:mkey.bulk_rotate_xor_hash:command failed What should I read from that one? Stefan

1 0

[Monetdb-developers] # falling back to direct mode
by Stefan de Konink 14 Dec '08

14 Dec '08

As $subj; What does it mean? I'm about to run my final result test on the new algebra version; but I just wondered what it means. Stefan

1 0

Re: [Monetdb-developers] [Monetdb-checkins] clients/src/mapiclient MapiClient.mx, , 1.130, 1.131
by Stefan Manegold 14 Dec '08

14 Dec '08

On Sat, Dec 13, 2008 at 03:50:22PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/clients/src/mapiclient > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv11819/mapiclient > > Modified Files: > MapiClient.mx > Log Message: > Start removing the default choice. It should not be an option > any longer. > Preferrably, we should remove the -g altogether. > > > U MapiClient.mx > Index: MapiClient.mx > =================================================================== > RCS file: /cvsroot/monetdb/clients/src/mapiclient/MapiClient.mx,v > retrieving revision 1.130 > retrieving revision 1.131 > diff -u -d -r1.130 -r1.131 > --- MapiClient.mx 5 Dec 2008 14:57:32 -0000 1.130 > +++ MapiClient.mx 13 Dec 2008 15:50:20 -0000 1.131 > @@ -1287,7 +1287,6 @@ > stream_printf(toConsole, "\\a - disable auto commit\n"); > } > if (mode == SQL || mode == XQUERY) { > - stream_printf(toConsole, "\\G - switch to algebra frontend\n"); > stream_printf(toConsole, "\\g - switch to old frontend\n"); hm, this means that you tell users only how to switch to the old frontend, but once they have done so, they (now) won't get told (anymore) how to switch back, again ... ... maybe not that handy --- and for XQuery, the "old" backend is both still available and still required for some functionality ... Hence, IMHO (1) "-G" / "-g" and "\G" / "\g" make only sense as pairs, i.e., to switch back and forth, i.e., removing one does not make (much) sense; and (2) XQuery still requires both for the time being. Thus, if we don't need either for SQL any more, we should remove the documentation (and functionality) of both switches only for SQL, but not for XQuery --- and if we do so, we should do this everywhere, i.e., not only with mclient, but also with Mserver/mserver5, MonetDB.conf/monetdb5.conf, Mtest.py and the wbe site --- well, lacking branches, the latter can only be done once we have a new feature release in about 3 month from now ... Stefan > } > if (mode == XQUERY) { > @@ -1709,7 +1708,6 @@ > fprintf(stderr, " -r nr | --rows=nr for pagination\n"); > fprintf(stderr, " -w nr | --width=nr for pagination\n"); > fprintf(stderr, " -D | --dump create an SQL dump\n"); > - fprintf(stderr, " -G | --algebra use algebra frontend\n"); > fprintf(stderr, " -g | --no-algebra use old frontend\n"); > > fprintf(stderr, "\nXQuery specific options\n"); > > > ------------------------------------------------------------------------------ > SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. > The future of the web can't happen without you. Join us at MIX09 to help > pave the way to the Next Web now. Learn more and register at > http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ > _______________________________________________ > 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 |

3 4

[Monetdb-developers] New "testing" CVS module
by Stefan Manegold 12 Dec '08

12 Dec '08

Dear fellow MonetDB developers, I just separated the MonetDB testing tools (Mtest.py & friends) from MonetDB/src/testing/ into their own "testing" CVS module / MonetDB component. IMPORTANT NOTE: =============== In case you plan to upgrade your exiting CVS-based "MonetDB" installation, please run `make uninstall` in your "MonetDB" build directory, first, i.e., before running `cvs update` in your "MonetDB" source directory. Once you update your "MonetDB" to the latest CVS development trunk version, and plan to continue (or start) using Mtest.py, you also need to check out the new "testing" CVS module (from SF) and compile and install it any time after you compiled and installed "MonetDB", and before you plan to use Mtest.py. The new "testing" CVS module depends only on "MonetDB" (and hence requires that to be installed), but on no other MonetDB component (except from the "buildtools", in case your are compiling from CVS sources). No other MonetDB component depends on the new "testing" CVS module other than that you obviously need to have "testing" installed once you want/need to run tests using Mtest.py. Details: -------- The MonetDB testing tools (Mtest.py & friends) are not part of the actual MonetDB functionality, but mainly for MonetDB development purpose (and hence only distributed only in the source tarballs, but not in any (official) binary packages). To make them less dependent on release cycles (and vice versa), and well as to prepare making them usable without MonetDB --- for now, they actually still depend on MonetDB; see below) --- we decided to separate the MonetDB testing tools from the "MonetDB" CVS module into their own "testing" CVS module. For the time being (i.e., until further notice), "testing" depends on "MonetDB" --- more precisely only on some utils from MonetDB/src/common/, but not on the GDK kernel from MonetDB/src/gdk/, as (1) Mtest.py (mainly for "convenience") still uses monet_options.py; and (2) (on Windows only), Mdiff.c uses "our" getopt code. Python modules "subprocess26.py" & "trace.py" have been moved from <PYTHON_LIBDIR>/MonetDB to <PYTHON_LIBDIR>/MonetDBtesting . Changes are wrapped in CVS tags "before_testing_separation" & "after_testing_separation". Regards, Stefan -- | 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

[Monetdb-developers] gridsql
by Martin.Kersten＠cwi.nl 09 Dec '08

09 Dec '08

Can you have a 1-2 hour look at gridsql if it is feasible at all. If so, let's push Venks.... ;) otherwise avoid the frustration for him.

3 2

[Monetdb-developers] Announcement: New feature release of MonetDB suite
by Sjoerd Mullender 08 Dec '08

08 Dec '08

The MonetDB team at CWI is pleased to announce the new "Nov2008" release of the MonetDB suite of programs. This is a feature release, involving, among other things, a change in the database format, so be sure to dump your databases before attempting an upgrade. More information on the new release is available at <https://sourceforge.net/forum/forum.php?forum_id=892621>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0