- developers-list - monetdb.org

[Monetdb-developers] Bug fix release of MonetDB suite
by Sjoerd Mullender 26 Feb '07

26 Feb '07

The MonetDB team at CWI, The Netherlands, is happy to announce the availability of a new bug-fix release for the major "Venus" release. New versions of all components of the MonetDB suite are released. MonetDB/XQuery The handling of updates was incomplete. Several memory mapping and concurrency problems have been fixed. Moreover, empty pages that resulted from deletion of nodes are now properly handed back to the system for reuse. MonetDB/XRPC Security and concurrency handling has been improved. MonetDB/SQL Foreign key constraint checking fixed; View in view dependencies bug fixed; Resolved crashes caused by large views; Prepared statements with more than 30 arguments now work. MonetDB/API Haskell and TCL libraries were broken and have been removed; Perl and Python libraries were broken and have been fixed. The current version of the protocol is not compatible with the previous version. Bugs fixed: [ 1579510 ] XQ: update error for "(1,2)/." [ 1590523 ] XQ: substring-after [ 1636828 ] fork() behaves strangely [ 1637867 ] XQ: seqcast int? to numeric unsupported [ 1639108 ] mserver crashes on delete query [ 1640248 ] PF: ~500 tests randomly fail on Solaris x86 [ 1644245 ] M5 & SQL5: various tests hang/timeout on Darwin [ 1648303 ] database dump does not save/restore auto-increment sequences [ 1650469 ] SQL: Armada sinks MonetDB ships [ 1651567 ] yet another delete bug, foreign key related [ 1651599 ] caching of inserts causes extreme memory consumption [ 1655818 ] SQL:Error inserting float in numeric column using JDBC [ 1655857 ] XQ: call to builtin function crashes XRPC client [ 1659889 ] SQL: sequence not restored properly [ 1644610 ] Conflict between normal query and XRPC query (and many more that hadn't been reported) -- Sjoerd Mullender

1 0

[Monetdb-developers] Clients compilaiton in windows...
by Romulo Goncalves 26 Feb '07

26 Feb '07

Compiling the clients in windows gave the error: copy ".\..\..\..\..\..\src\php\Cimpl\examples\monetdb_query_demo.php" "monetdb_query_demo.php" 1 file(s) copied. cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Zi -Ox -I. -I.\..\..\.. "-IC:\Pthreads\include" -I.\..\..\..\..\src\php\Cimpl "-I..\..\mapilib" -I.\..\..\..\..\src\php\Cimpl\..\..\mapilib -I.\..\..\..\..\..\MonetDB\NT\include -I.\..\..\..\..\..\MonetD \NT\include\common -I.\..\..\..\..\..\MonetDB\NT\include\gdk -I.\..\..\..\..\..\php-5.1.4 -I.\..\..\..\..\..\php-5.1.4\main - .\..\..\..\..\..\php-5.1.4\TSRM -I.\..\..\..\..\..\php-5.1.4\Zend -DPHP_WIN32 -DZEND_WIN32 -DZEND_DEBUG=0 -DZTS=1 -DLIBMONE DB -DCOMPILE_DL_MONETDB -Fo"php_monetdb.obj" -c ".\..\..\..\..\src\php\Cimpl\php_monetdb.c" php_monetdb.c E:\Visual Studio .NET 2003\Vc7\PlatformSDK\Include\WS2tcpip.h(647) : warning C4142: benign redefinition of type ..\..\..\..\src\php\Cimpl\php_monetdb.c(1721) : error C2198: 'zend_exception_get_default' : too few arguments for call throug pointer-to-function ..\..\..\..\src\php\Cimpl\php_monetdb.c(1736) : error C2198: 'zend_exception_get_default' : too few arguments for call throug pointer-to-function ..\..\..\..\src\php\Cimpl\php_monetdb.c(1746) : error C2198: 'zend_exception_get_default' : too few arguments for call throug pointer-to-function NMAKE : fatal error U1077: 'cl' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop. NMAKE : fatal error U1077: '"E:\Visual Studio .NET 2003\VC7\BIN\nmake.exe"' : return code '0x2' Stop. I check my zend_exceptions and the function is defined as: ZEND_API zend_class_entry *zend_exception_get_default(TSRMLS_D); My php is php-5.1.4 What values should I use? I used 0 and it compiles, but for sure it is not the best option. Regards, Romulo

3 4

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/modules/pftijah pftijah.mx, 1.92.2.17, 1.92.2.18
by Henning Rode 26 Feb '07

26 Feb '07

roel, wat was hier eigenlijk aan de hand? eigenlijk hoef je "left" toch niet nog een keer te sorteren? "left" is toch altijd gesorteerd, of niet? -henning Roel van Os wrote: > Update of /cvsroot/monetdb/pathfinder/modules/pftijah > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv12912 > > Modified Files: > Tag: XQuery_0-16 > pftijah.mx > Log Message: > PF/Tijah: fix some sortedness issues. These only seem to occur on large-scale > querying, not on the current Tests. > > > Index: pftijah.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/modules/pftijah/pftijah.mx,v > retrieving revision 1.92.2.17 > retrieving revision 1.92.2.18 > diff -u -d -r1.92.2.17 -r1.92.2.18 > --- pftijah.mx 23 Feb 2007 09:10:04 -0000 1.92.2.17 > +++ pftijah.mx 23 Feb 2007 12:12:57 -0000 1.92.2.18 > @@ -1371,7 +1371,7 @@ > } > > > - var ctx := region; > + var ctx := region.sort(); > var pre_size := load( "tj_" + collName + "_size1"); > var desc := scj_desc( pre_size, ctx, count(pre_size) ); > var result := nodes( desc ).project( dbl(scoreBase) ); > @@ -1589,7 +1589,7 @@ > var pre_size := bat("tj_" + collName + "_size" + ind); > > # evaluate doc/term (anc/desc) relationship > - var elem_tid := _containing_desc3(left.mark(0@0), pre_tid, pre_size); > + var elem_tid := _containing_desc3(left.sort().mark(0@0), pre_tid, pre_size); > pre_tid := nil; > if (elem_tid.count() = 0) {return new(oid,dbl);} > > @@ -1632,7 +1632,7 @@ > > # evaluate doc/term (anc/desc) relationship > var t2 := time(); > - var elem_tid := _containing_desc3(left.mark(0@0), pre_tid, pre_size); > + var elem_tid := _containing_desc3(left.sort().mark(0@0), pre_tid, pre_size); > var t3 := time(); > pre_tid := nil; > if (elem_tid.count() = 0) {return new(oid,dbl);} > @@ -1679,7 +1679,7 @@ > > # evaluate doc/term (anc/desc) relationship > var t2 := time(); > - var elem_tid := _containing_desc(left.mark(0@0), pre_tid, pre_size); > + var elem_tid := _containing_desc(left.sort().mark(0@0), pre_tid, pre_size); > var t3 := time(); > pre_tid := nil; > if (elem_tid.count() = 0) {return new(oid,dbl);} > @@ -1870,7 +1870,7 @@ > var pre_size := bat("tj_" + collName + "_size1"); > > # See which document contain the query terms we create a bat of [doc, term-id]: > - var doc_tid := _containing_desc(ctx.mark(0(a)0).sort(), tid_pre.reverse(), pre_size); > + var doc_tid := _containing_desc(ctx.sort().mark(0@0), tid_pre.reverse(), pre_size); > > # len(doc): [doc, size] > var doc_len := [dbl](bat("tj_" + collName + "_size1").semijoin(doc_tid)); > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins

1 0

[Monetdb-developers] windows compilaton...
by Romulo Goncalves 26 Feb '07

26 Feb '07

During the compilation of clients (cvs head) I got the following errors: cd "MonetSQLdb" && nmake /nologo "prefix=C:\cygwin\home\goncalve\MonetDB\MonetDB_SQL\clients\NT" all cl -GF -W3 -wd4273 -wd4102 -MD -nologo -Zi -Ox -I. -I.\..\..\.. "-IC:\Pthreads\include" -I.\..\..\..\..\src\python\Cim pl "-I..\..\mapilib" -I.\..\..\..\..\..\MonetDB\NT\include -I.\..\..\..\..\..\MonetDB\NT\include\common -I.\..\..\..\..\..\Mon etDB\NT\include\gdk -IC:\Python25\include -LD -Fe_MapiLib.pyd MapiLib.py.obj /link ..\..\mapilib\libMapi.lib C:\Python25\libs \python25.lib Creating library _MapiLib.lib and object _MapiLib.exp MapiLib.py.obj : error LNK2019: unresolved external symbol __imp__mapi_setBlocking referenced in function __wrap_mapi_setBlock ing MapiLib.py.obj : error LNK2019: unresolved external symbol __imp__mapi_is_blocked referenced in function __wrap_mapi_is_blocke d _MapiLib.pyd : fatal error LNK1120: 2 unresolved externals NMAKE : fatal error U1077: 'cl' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop. NMAKE : fatal error U1077: '"E:\Visual Studio .NET 2003\VC7\BIN\nmake.exe"' : return code '0x2' Stop. I already updated and compiled buildtools and MonetDB. Maybe Niels or Fabian know the reason of this error. Regards, Romulo

3 8

[Monetdb-developers] check-ins
by Henning Rode 26 Feb '07

26 Feb '07

hej amsterdam, what's the status of the release? or more important, when are we allowed to do check-ins again? and second question: which machine on the test web is actually running icc? i remember we checked the test-web on friday and besides the rare sun-os all systems looked pretty green on our test-cases. so, where exactly should we have spotted the icc compilation problems? best -henning

2 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime/xrpc/export export.xq, 1.1.2.1, 1.1.2.2
by Sjoerd Mullender 25 Feb '07

25 Feb '07

On 02/25/2007 11:02 PM, Ying Zhang wrote: > Update of /cvsroot/monetdb/pathfinder/runtime/xrpc/export > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv16912 > > Modified Files: > Tag: XQuery_0-16 > export.xq > Log Message: > A copy-paste error in the NS identifier. > > Since this change won't affect compilation, I check it in without > explicit permission from Sjoerd. :P It does, however, affect the binary and source distributions that we make, and so you should have asked permission. But you're in luck: I'm going to use tonight's build. > > > Index: export.xq > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/runtime/xrpc/export/export.xq,v > retrieving revision 1.1.2.1 > retrieving revision 1.1.2.2 > diff -u -d -r1.1.2.1 -r1.1.2.2 > --- export.xq 21 Feb 2007 16:25:48 -0000 1.1.2.1 > +++ export.xq 25 Feb 2007 22:02:54 -0000 1.1.2.2 > @@ -11,5 +11,5 @@ > > (: =================== HTTP =================== :) > > -declare function admin:GET($uri as xs:string) > +declare function export:GET($uri as xs:string) > { doc($uri) }; > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > 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-checkins] buildtools/autogen/autogen am.py, 1.30.2.1, 1.30.2.2
by Sjoerd Mullender 25 Feb '07

25 Feb '07

On 02/25/2007 01:51 PM, Niels Nes wrote: > Update of /cvsroot/monetdb/buildtools/autogen/autogen > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv2017/autogen/autogen > > Modified Files: > Tag: MonetDB_1-16 > am.py > Log Message: > we need to distribute *.def files as the rules to build them are part of > the rules.mk file (which isn't distributed) Did you really mean to check in those print statements? > > Index: am.py > =================================================================== > RCS file: /cvsroot/monetdb/buildtools/autogen/autogen/am.py,v > retrieving revision 1.30.2.1 > retrieving revision 1.30.2.2 > diff -u -d -r1.30.2.1 -r1.30.2.2 > --- am.py 13 Feb 2007 10:13:23 -0000 1.30.2.1 > +++ am.py 25 Feb 2007 12:51:11 -0000 1.30.2.2 > @@ -19,7 +19,7 @@ > from codegen import find_org > > #automake_ext = ['c', 'h', 'y', 'l', 'glue.c'] > -automake_ext = ['o', 'lo', 'c', 'h', 'tab.c', 'tab.h', 'yy.c', 'glue.c', 'proto.h', 'py.c', 'pm.c', ''] > +automake_ext = ['o', 'lo', 'c', 'h', 'tab.c', 'tab.h', 'yy.c', 'glue.c', 'proto.h', 'py.c', 'pm.c', 'def', ''] > buildtools_ext = ['mx', 'm', 'y', 'l', 'brg'] > > am_assign = "+=" > @@ -153,9 +153,11 @@ > pf = f > > # built source if has dep and ext != cur ext > + print(pf) > if not(cond) and deps.has_key(pf) and pf not in am['BUILT_SOURCES']: > pfb, pfext = split_filename(pf) > sfb, sfext = split_filename(deps[pf][0]) > + print('test %s' % pf) > if sfext != pfext: > if pfext in automake_ext: > dist = None > @@ -622,6 +624,7 @@ > def am_library(fd, var, libmap, am): > name = var[4:] > > + print("am_library\n"); > sep = "" > pref = 'lib' > if libmap.has_key("NAME"): > @@ -702,6 +705,7 @@ > deps = [] > for target in libmap['TARGETS']: > t, ext = split_filename(target) > + print(t,ext) > if ext in scripts_ext: > if target not in SCRIPTS: > SCRIPTS.append(target) > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-checkins mailing list > Monetdb-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-checkins -- Sjoerd Mullender

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/runtime Makefile.ag, 1.70, 1.71 levelsteps.mx, 1.12, 1.13 ll_staircasejoin.mx, 1.52, 1.53 ll_upwards.mx, 1.19, 1.20 pathfinder.mx, 1.297, 1.298 shredder.mx, 1.116, 1.117
by Jens Teubner 23 Feb '07

23 Feb '07

On Fri, Feb 23, 2007 at 12:51:45PM +0000, Niels Nes wrote: > [...] > > +@h > +#ifndef _LEVELSTEPS_H_ > +#define _LEVELSTEPS_H_ > + > +#define XML_DEPTH_MAX 128 > + > +#endif /* _LEVELSTEPS_H_ */ > > [...] It is a bad habit to use macro names that start with an underscore. Such names are reserved for the C library only. For a reference, see, e.g., http://www.gnu.org/software/libc/manual/html_node/Reserved-Names.html Jens -- Jens Teubner Technische Universitaet Muenchen, Department of Informatics D-85748 Garching, Germany Tel: +49 89 289-17259 Fax: +49 89 289-17263 Emacs is a nice OS - but it lacks a good text editor. That's why I am using Vim.

1 0

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/modules/pftijah pftijah.mx, 1.92.2.17, 1.92.2.18
by Henning Rode 23 Feb '07

23 Feb '07

hej roel, zijn die niet sowieso al gesorteerd? tenminste moeten ze dat eigenlijk altijd zijn. groet -henning Roel van Os wrote: > Update of /cvsroot/monetdb/pathfinder/modules/pftijah > In directory sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv12912 > > Modified Files: > Tag: XQuery_0-16 > pftijah.mx > Log Message: > PF/Tijah: fix some sortedness issues. These only seem to occur on large-scale > querying, not on the current Tests. > > > Index: pftijah.mx > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/modules/pftijah/pftijah.mx,v > retrieving revision 1.92.2.17 > retrieving revision 1.92.2.18 > diff -u -d -r1.92.2.17 -r1.92.2.18 > --- pftijah.mx 23 Feb 2007 09:10:04 -0000 1.92.2.17 > +++ pftijah.mx 23 Feb 2007 12:12:57 -0000 1.92.2.18 > @@ -1371,7 +1371,7 @@ > } > > > - var ctx := region; > + var ctx := region.sort(); > var pre_size := load( "tj_" + collName + "_size1"); > var desc := scj_desc( pre_size, ctx, count(pre_size) ); > var result := nodes( desc ).project( dbl(scoreBase) ); > @@ -1589,7 +1589,7 @@ > var pre_size := bat("tj_" + collName + "_size" + ind); > > # evaluate doc/term (anc/desc) relationship > - var elem_tid := _containing_desc3(left.mark(0@0), pre_tid, pre_size); > + var elem_tid := _containing_desc3(left.sort().mark(0@0), pre_tid, pre_size); > pre_tid := nil; > if (elem_tid.count() = 0) {return new(oid,dbl);} > > @@ -1632,7 +1632,7 @@ > > # evaluate doc/term (anc/desc) relationship > var t2 := time(); > - var elem_tid := _containing_desc3(left.mark(0@0), pre_tid, pre_size); > + var elem_tid := _containing_desc3(left.sort().mark(0@0), pre_tid, pre_size); > var t3 := time(); > pre_tid := nil; > if (elem_tid.count() = 0) {return new(oid,dbl);} > @@ -1679,7 +1679,7 @@ > > # evaluate doc/term (anc/desc) relationship > var t2 := time(); > - var elem_tid := _containing_desc(left.mark(0@0), pre_tid, pre_size); > + var elem_tid := _containing_desc(left.sort().mark(0@0), pre_tid, pre_size); > var t3 := time(); > pre_tid := nil; > if (elem_tid.count() = 0) {return new(oid,dbl);} > @@ -1870,7 +1870,7 @@ > var pre_size := bat("tj_" + collName + "_size1"); > > # See which document contain the query terms we create a bat of [doc, term-id]: > - var doc_tid := _containing_desc(ctx.mark(0(a)0).sort(), tid_pre.reverse(), pre_size); > + var doc_tid := _containing_desc(ctx.sort().mark(0@0), tid_pre.reverse(), pre_size); > > # len(doc): [doc, size] > var doc_len := [dbl](bat("tj_" + collName + "_size1").semijoin(doc_tid)); > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Monetdb-pf-checkins mailing list > Monetdb-pf-checkins(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins

1 0

[Monetdb-developers] SQL5 compilation error
by Ying Zhang 22 Feb '07

22 Feb '07

Hi, (Current branch) checkout and compile SQL results in the following error: cc1: warnings being treated as errors ../../../../src/backends/monet5/sql_scenario.mx: In function 'monet5_freestack': ../../../../src/backends/monet5/sql_scenario.mx:94: warning: passing argument 1 of 'GDKfree' makes pointer from integer without a cast make[7]: *** [lib_sql_la-sql_scenario.lo] Error 1 Regards, Jennie

2 1