September 2007 - developers-list

[Monetdb-developers] Compiling on Darwin 7
by Fabian Groffen 21 Jan '08

21 Jan '08

Is there anyone that can think of a solution for this problem? cc1: warnings being treated as errors /Volumes/Scratch/monetdb/stable/monetdb/src/modules/plain/bat.mx: In function 'local_itoa': /Volumes/Scratch/monetdb/stable/monetdb/src/modules/plain/bat.mx:1253: warning: format '%zd' expects type 'signed size_t', but argument 4 has type 'ssize_t' I mean... is there a difference between "signed size_t" and "ssize_t"? Ehrm. [Orion:src/modules/plain] fabian% uname -a Darwin Orion.local 7.9.0 Darwin Kernel Version 7.9.0: Wed Mar 30 20:11:17 PST 2005; root:xnu/xnu-517.12.7.obj~1/RELEASE_PPC Power Macintosh powerpc PowerBook4,3 Darwin [Orion:src/modules/plain] fabian% gcc --version gcc (GCC) 4.0.1 (Apple Computer, Inc. build 5341) Copyright (C) 2005 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Probably just need to compile without -Werror.

4 5

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.198, 1.199
by Stefan Manegold 28 Sep '07

28 Sep '07

On Fri, Sep 28, 2007 at 08:10:06PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv18777 > > Modified Files: > mal_interpreter.mx > Log Message: > Avoid complaints by compilers by switching to the preprocessor. Martin, before you wonder why the SLOW ans FAST cases don't show any differences any more --- neither performance nor in speed ---: Since your code defines both macros SLOW (as 1) and FAST (as 0), directives #ifdef @1 with @1 being substituted with either SLOW or FAST by Mx, always evaluate to true, regardsless of whether @1 is SLOW (== 1) or FAST (== 0). As initially suggested by both Sjoerd and me, you might want to use #if @1 directives, instead, to re-establish your (supposely) intended behaviour. Stefan > Index: mal_interpreter.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_interpreter.mx,v > retrieving revision 1.198 > retrieving revision 1.199 > diff -u -d -r1.198 -r1.199 > --- mal_interpreter.mx 28 Sep 2007 16:00:57 -0000 1.198 > +++ mal_interpreter.mx 28 Sep 2007 20:10:04 -0000 1.199 > @@ -743,13 +743,15 @@ > case ENDsymbol: > if( getInstrPtr(mb,0)->token == FACTORYsymbol) > ret= shutdownFactory(mb); > - if( @1 && oldtimer) > +#ifdef @1 > + if( oldtimer) > cntxt->timer= oldtimer; > +#endif > if( pcicaller && garbageControl(getInstrPtr(mb,0)) ) > garbageCollector(mb, stk, TRUE); > - if(@1){ > - @:endProfile@ > - } > +#ifdef @1 > + @:endProfile@ > +#endif > stkpc= mb->stop; > continue; > default: > @@ -759,9 +761,9 @@ > } > ret = createScriptException(mb, stkpc,MAL, > NULL, "unkown operation"); > - if( @1){ > - @:endProfile@ > - } > +#ifdef @1 > + @:endProfile@ > +#endif > stkpc= mb->stop; > continue; > } > @@ -1027,7 +1029,8 @@ > } > } > /* Provide debugging support */ > - if( @1 && (GDKdebug & 10) ){ > +#ifdef @1 > + if( GDKdebug & 10 ){ > BAT *b; > str oldmsg =0; > > @@ -1061,6 +1064,7 @@ > } > } > } > +#endif > @- > @= commandcall > { > @@ -1599,7 +1603,8 @@ > #endif > > @= timingHndlr > -if( @1 && cntxt->flags && stk->cmd != 't' && stk->cmd != 'C'){ > +#ifdef @1 > +if( cntxt->flags && stk->cmd != 't' && stk->cmd != 'C'){ > if( cntxt->flags & timerFlag) > stream_printf(cntxt->fdout,"[%6d usec ",GDKusec()-cntxt->timer); > #ifdef HAVE_SYS_RESOURCE_H > @@ -1641,6 +1646,7 @@ > if( cntxt->flags & timerFlag) > cntxt->timer = GDKusec(); > } > +#endif > @- > The bigfoot memory tracker keeps track on the space > occupancy of BATs. It ignores for the time being the heaps. > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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 |

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.197, 1.198
by Sjoerd Mullender 28 Sep '07

28 Sep '07

On 2007-09-28 18:01, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5547 > > Modified Files: > mal_interpreter.mx > Log Message: > Split the interpreter in two versions. A FAST and SLOW version. > If there is no request for debugging or performance measurement > outstanding, we can go the fast path. However, given the fact > that at any time we may enter the debugger, a jump to the slow > line is always possible. > The code relies on compiler optimization to get rid of blocks > with constant arguments. Unclear if all compilers are that smart. This may fail for some compilers. Some compilers warn about constant expressions in conditionals, and we turn warnings into errors. Be prepared to fix this if there are compilers that have a problem with this usage. One way to solve the problem is to use the preprocessor: #if @1 ... #endif instead of if (@1) { ... } > > Index: mal_interpreter.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_interpreter.mx,v > retrieving revision 1.197 > retrieving revision 1.198 > diff -u -d -r1.197 -r1.198 > --- mal_interpreter.mx 24 Sep 2007 08:24:22 -0000 1.197 > +++ mal_interpreter.mx 28 Sep 2007 16:00:57 -0000 1.198 > @@ -70,6 +70,9 @@ > #include "mal_debugger.h" /* for mdbStep() */ > #include "mal_type.h" > > +#define SLOW 1 > +#define FAST 0 > + > static str runMALsequence( Client cntxt, MalBlkPtr mb, int startpc, > int stoppc, MalStkPtr stk, MalStkPtr env, InstrPtr pcicaller); > static str setDynamicType(MalBlkPtr mb, VarPtr v, int tpe, int pc); > @@ -421,8 +424,27 @@ > stkpc = startpc; > exceptionVar = exceptionPC = -1; > (void)exceptionPC; /* TODO maybe we should use this variable somewhere*/ > +@- > +From this point onwards we should differentiate fast processing > +against monitored processing. Fast processing is possible if there is > +no call to the debugger statically/dynamically set. Same holds for > +performance control statements. > +The code currently does not statically checks the mode change. > +Preferrably we should introduce a itrace flag PROFILE > +We rely on optimizing compilers to remove the redundant code. > +@c > + if( malProfileMode == 0 && cntxt->itrace==0){ > + while(stkpc < mb->stop && stkpc != stoppc ){ > + pci = getInstrPtr(mb,stkpc); > + if( malProfileMode + cntxt->itrace) > + goto workslow; > + @:MALinterpret(FAST)@ > + @:MALflowofcontrol(FAST)@ > + } > + } else > while(stkpc < mb->stop && stkpc != stoppc ){ > pci = getInstrPtr(mb,stkpc); > +workslow: > if( cntxt->itrace ) { > lng t=0; > if( stk->cmd== 0) stk->cmd= cntxt->itrace; > @@ -445,8 +467,8 @@ > } > > @:beginProfile@ > - @:MALinterpret@ > - @:MALflowofcontrol@ > + @:MALinterpret(SLOW)@ > + @:MALflowofcontrol(SLOW)@ > @:endProfile@ > } > @:MALwrapup@ > @@ -639,11 +661,11 @@ > limited. > @c > switch( pci->token){ > - case ASSIGNsymbol: @:assignStmt@ break; > - case PATcall: @:patterncall@ break; > - case CMDcall: @:commandcall@ break; > - case FACcall: @:factorycall@ break; > - case FCNcall: @:functioncall@ break; > + case ASSIGNsymbol: @:assignStmt(SLOW)@ break; > + case PATcall: @:patterncall(SLOW)@ break; > + case CMDcall: @:commandcall(SLOW)@ break; > + case FACcall: @:factorycall(SLOW)@ break; > + case FCNcall: @:functioncall(SLOW)@ break; > } > /* we don't allow sequential flow control here */ > dropMALflowStep(flow,stkpc,n,pending,mb,stk); > @@ -710,22 +732,24 @@ > @= MALinterpret > ret = 0; > switch( pci->token){ > - case ASSIGNsymbol: @:assignStmt@ break; > - case PATcall: @:patterncall@ break; > - case CMDcall: @:commandcall@ break; > - case FACcall: @:factorycall@ break; > - case FCNcall: @:functioncall@ break; > + case ASSIGNsymbol: @:assignStmt(@1)@ break; > + case PATcall: @:patterncall(@1)@ break; > + case CMDcall: @:commandcall(@1)@ break; > + case FACcall: @:factorycall(@1)@ break; > + case FCNcall: @:functioncall(@1)@ break; > case NOOPsymbol: > case REMsymbol: > break; > case ENDsymbol: > if( getInstrPtr(mb,0)->token == FACTORYsymbol) > ret= shutdownFactory(mb); > - if( oldtimer) > + if( @1 && oldtimer) > cntxt->timer= oldtimer; > if( pcicaller && garbageControl(getInstrPtr(mb,0)) ) > garbageCollector(mb, stk, TRUE); > - @:endProfile@ > + if(@1){ > + @:endProfile@ > + } > stkpc= mb->stop; > continue; > default: > @@ -735,7 +759,9 @@ > } > ret = createScriptException(mb, stkpc,MAL, > NULL, "unkown operation"); > - @:endProfile@ > + if( @1){ > + @:endProfile@ > + } > stkpc= mb->stop; > continue; > } > @@ -886,9 +912,10 @@ > if( lhs->vtype == TYPE_bat) > BBPincref(lhs->val.br.id, TRUE); > } > - @:restoreTarget@ > + @:restoreTarget(@1)@ > ret = 0; > - @:exceptionHndlr@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @} > @- > @@ -1000,7 +1027,7 @@ > } > } > /* Provide debugging support */ > - if( GDKdebug & 10 ){ > + if( @1 && (GDKdebug & 10) ){ > BAT *b; > str oldmsg =0; > > @@ -1146,8 +1173,9 @@ > ret = createScriptException(mb, stkpc, MAL, NULL, > "too many arguments for command call"); > } > - @:restoreTarget@ > - @:exceptionHndlr@ > + @:restoreTarget(@1)@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @- > @= patterncall > @@ -1157,8 +1185,9 @@ > else { > @:safeTarget@ > ret = (str) (*pci->fcn)(mb,stk,pci); > - @:restoreTarget@ > - @:exceptionHndlr@ > + @:restoreTarget(@1)@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @- > MAL function calls are relatively expensive, because they have to assemble > @@ -1171,8 +1200,9 @@ > stk->pcup = stkpc; > @:safeTarget@ > ret= runMAL(cntxt,pci->blk,1,mb,stk,pci); > - @:restoreTarget@ > - @:exceptionHndlr@ > + @:restoreTarget(@1)@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @- > Factory calls are more involved. At this stage it is a synchrononous > @@ -1184,7 +1214,8 @@ > "reference to MAL function missing"); > else > ret= runFactory(cntxt,pci->blk,mb,stk,pci); > - @:exceptionHndlr@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(SLOW)@ > @- > The type dispatching table in getArgValue can be removed if we > determine at compile time the address offset within a ValRecord. > @@ -1323,7 +1354,6 @@ > @{ > > @= exceptionHndlr > - @:timingHndlr@ > if( ret != MAL_SUCCEED ) { > str msg = 0, nxt; > if( stk->cmd ) { > @@ -1569,7 +1599,7 @@ > #endif > > @= timingHndlr > -if( cntxt->flags && stk->cmd != 't' && stk->cmd != 'C'){ > +if( @1 && cntxt->flags && stk->cmd != 't' && stk->cmd != 'C'){ > if( cntxt->flags & timerFlag) > stream_printf(cntxt->fdout,"[%6d usec ",GDKusec()-cntxt->timer); > #ifdef HAVE_SYS_RESOURCE_H > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.197, 1.198
by Stefan Manegold 28 Sep '07

28 Sep '07

On Fri, Sep 28, 2007 at 04:01:00PM +0000, Martin Kersten wrote: > Update of /cvsroot/monetdb/MonetDB5/src/mal > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv5547 > > Modified Files: > mal_interpreter.mx > Log Message: > Split the interpreter in two versions. A FAST and SLOW version. > If there is no request for debugging or performance measurement > outstanding, we can go the fast path. However, given the fact > that at any time we may enter the debugger, a jump to the slow > line is always possible. > The code relies on compiler optimization to get rid of blocks > with constant arguments. Unclear if all compilers are that smart. All C-compilers (respetively their C preprocessors) are expected to respect C preprocessor directives (e.g., #if ... #endif), "even" with optimization disabled. Hence, why not use those compile-time conditionals instead "pseudo"-runtime conditionals with constant conditions? (Would also speed-up the compilation process...) Stefan > > > Index: mal_interpreter.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB5/src/mal/mal_interpreter.mx,v > retrieving revision 1.197 > retrieving revision 1.198 > diff -u -d -r1.197 -r1.198 > --- mal_interpreter.mx 24 Sep 2007 08:24:22 -0000 1.197 > +++ mal_interpreter.mx 28 Sep 2007 16:00:57 -0000 1.198 > @@ -70,6 +70,9 @@ > #include "mal_debugger.h" /* for mdbStep() */ > #include "mal_type.h" > > +#define SLOW 1 > +#define FAST 0 > + > static str runMALsequence( Client cntxt, MalBlkPtr mb, int startpc, > int stoppc, MalStkPtr stk, MalStkPtr env, InstrPtr pcicaller); > static str setDynamicType(MalBlkPtr mb, VarPtr v, int tpe, int pc); > @@ -421,8 +424,27 @@ > stkpc = startpc; > exceptionVar = exceptionPC = -1; > (void)exceptionPC; /* TODO maybe we should use this variable somewhere*/ > +@- > +From this point onwards we should differentiate fast processing > +against monitored processing. Fast processing is possible if there is > +no call to the debugger statically/dynamically set. Same holds for > +performance control statements. > +The code currently does not statically checks the mode change. > +Preferrably we should introduce a itrace flag PROFILE > +We rely on optimizing compilers to remove the redundant code. > +@c > + if( malProfileMode == 0 && cntxt->itrace==0){ > + while(stkpc < mb->stop && stkpc != stoppc ){ > + pci = getInstrPtr(mb,stkpc); > + if( malProfileMode + cntxt->itrace) > + goto workslow; > + @:MALinterpret(FAST)@ > + @:MALflowofcontrol(FAST)@ > + } > + } else > while(stkpc < mb->stop && stkpc != stoppc ){ > pci = getInstrPtr(mb,stkpc); > +workslow: > if( cntxt->itrace ) { > lng t=0; > if( stk->cmd== 0) stk->cmd= cntxt->itrace; > @@ -445,8 +467,8 @@ > } > > @:beginProfile@ > - @:MALinterpret@ > - @:MALflowofcontrol@ > + @:MALinterpret(SLOW)@ > + @:MALflowofcontrol(SLOW)@ > @:endProfile@ > } > @:MALwrapup@ > @@ -639,11 +661,11 @@ > limited. > @c > switch( pci->token){ > - case ASSIGNsymbol: @:assignStmt@ break; > - case PATcall: @:patterncall@ break; > - case CMDcall: @:commandcall@ break; > - case FACcall: @:factorycall@ break; > - case FCNcall: @:functioncall@ break; > + case ASSIGNsymbol: @:assignStmt(SLOW)@ break; > + case PATcall: @:patterncall(SLOW)@ break; > + case CMDcall: @:commandcall(SLOW)@ break; > + case FACcall: @:factorycall(SLOW)@ break; > + case FCNcall: @:functioncall(SLOW)@ break; > } > /* we don't allow sequential flow control here */ > dropMALflowStep(flow,stkpc,n,pending,mb,stk); > @@ -710,22 +732,24 @@ > @= MALinterpret > ret = 0; > switch( pci->token){ > - case ASSIGNsymbol: @:assignStmt@ break; > - case PATcall: @:patterncall@ break; > - case CMDcall: @:commandcall@ break; > - case FACcall: @:factorycall@ break; > - case FCNcall: @:functioncall@ break; > + case ASSIGNsymbol: @:assignStmt(@1)@ break; > + case PATcall: @:patterncall(@1)@ break; > + case CMDcall: @:commandcall(@1)@ break; > + case FACcall: @:factorycall(@1)@ break; > + case FCNcall: @:functioncall(@1)@ break; > case NOOPsymbol: > case REMsymbol: > break; > case ENDsymbol: > if( getInstrPtr(mb,0)->token == FACTORYsymbol) > ret= shutdownFactory(mb); > - if( oldtimer) > + if( @1 && oldtimer) > cntxt->timer= oldtimer; > if( pcicaller && garbageControl(getInstrPtr(mb,0)) ) > garbageCollector(mb, stk, TRUE); > - @:endProfile@ > + if(@1){ > + @:endProfile@ > + } > stkpc= mb->stop; > continue; > default: > @@ -735,7 +759,9 @@ > } > ret = createScriptException(mb, stkpc,MAL, > NULL, "unkown operation"); > - @:endProfile@ > + if( @1){ > + @:endProfile@ > + } > stkpc= mb->stop; > continue; > } > @@ -886,9 +912,10 @@ > if( lhs->vtype == TYPE_bat) > BBPincref(lhs->val.br.id, TRUE); > } > - @:restoreTarget@ > + @:restoreTarget(@1)@ > ret = 0; > - @:exceptionHndlr@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @} > @- > @@ -1000,7 +1027,7 @@ > } > } > /* Provide debugging support */ > - if( GDKdebug & 10 ){ > + if( @1 && (GDKdebug & 10) ){ > BAT *b; > str oldmsg =0; > > @@ -1146,8 +1173,9 @@ > ret = createScriptException(mb, stkpc, MAL, NULL, > "too many arguments for command call"); > } > - @:restoreTarget@ > - @:exceptionHndlr@ > + @:restoreTarget(@1)@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @- > @= patterncall > @@ -1157,8 +1185,9 @@ > else { > @:safeTarget@ > ret = (str) (*pci->fcn)(mb,stk,pci); > - @:restoreTarget@ > - @:exceptionHndlr@ > + @:restoreTarget(@1)@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @- > MAL function calls are relatively expensive, because they have to assemble > @@ -1171,8 +1200,9 @@ > stk->pcup = stkpc; > @:safeTarget@ > ret= runMAL(cntxt,pci->blk,1,mb,stk,pci); > - @:restoreTarget@ > - @:exceptionHndlr@ > + @:restoreTarget(@1)@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(@1)@ > } > @- > Factory calls are more involved. At this stage it is a synchrononous > @@ -1184,7 +1214,8 @@ > "reference to MAL function missing"); > else > ret= runFactory(cntxt,pci->blk,mb,stk,pci); > - @:exceptionHndlr@ > + @:exceptionHndlr(@1)@ > + @:timingHndlr(SLOW)@ > @- > The type dispatching table in getArgValue can be removed if we > determine at compile time the address offset within a ValRecord. > @@ -1323,7 +1354,6 @@ > @{ > > @= exceptionHndlr > - @:timingHndlr@ > if( ret != MAL_SUCCEED ) { > str msg = 0, nxt; > if( stk->cmd ) { > @@ -1569,7 +1599,7 @@ > #endif > > @= timingHndlr > -if( cntxt->flags && stk->cmd != 't' && stk->cmd != 'C'){ > +if( @1 && cntxt->flags && stk->cmd != 't' && stk->cmd != 'C'){ > if( cntxt->flags & timerFlag) > stream_printf(cntxt->fdout,"[%6d usec ",GDKusec()-cntxt->timer); > #ifdef HAVE_SYS_RESOURCE_H > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.197, 1.198
by Fabian Groffen 28 Sep '07

28 Sep '07

On 28-09-2007 18:07:48 +0200, Martin Kersten wrote: > Fabian Groffen wrote: >> On 28-09-2007 16:01:00 +0000, Martin Kersten wrote: >> >>> +#define SLOW 1 >>> +#define FAST 0 >>> >> >> How about an enum here? >> > He, ze zijn weer terug ;-) > Niet nodig is allemaal locaal duidelijk. The idea is that the compiler is able to help you (bail out). Local or not is irrellevant IMO.

1 0

Re: [Monetdb-developers] [Monetdb-checkins] MonetDB5/src/mal mal_interpreter.mx, , 1.197, 1.198
by Fabian Groffen 28 Sep '07

28 Sep '07

On 28-09-2007 16:01:00 +0000, Martin Kersten wrote: > +#define SLOW 1 > +#define FAST 0 How about an enum here?

1 0

[Monetdb-developers] MonetDB4 server (Mserver) crash on solaris 10
by xxiao 27 Sep '07

27 Sep '07

hi, I built MonetDB4 server on a solaris 10 SPARC machine. When I try to execute it, the server applciation crashed and posted the following error message: >Mserver # Monet Database Server V4.18.2 # Copyright (c) 1993-2007, CWI. All rights reserved. # Compiled for sparc-sun-solaris2.10/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. !ERROR: BATSIGcrash: Mserver internal error (Bus error), please restart. !ERROR: (One potential cause could be that your disk might be full...) the machine configuration is: >uname -a SunOS vlsi 5.10 Generic_118833-33 sun4u sparc SUNW,Sun-Fire-480R Solaris Is the crash really due to that the disk is full? And can someone give me a hint how I can trace my problems? Thanks a lot. -- View this message in context: http://www.nabble.com/MonetDB4-server-%28Mserver%29-crash-on-solaris-10-tf4… Sent from the monetdb-developers mailing list archive at Nabble.com.

4 5

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/src/sqlhelpers/db2tools common.inc, XQuery_0-20, NONE, 1.1.2.1 load, XQuery_0-20, NONE, 1.1.2.1 table, XQuery_0-20, NONE, 1.1.2.1
by Stefan Manegold 24 Sep '07

24 Sep '07

To ensure a smooth finalization of our combined effort to get the upcoming release out "as fast as possible" and without any self-made hurdles, I assume that adding these new "feature(s)" in the *release branch* has been coordinated with Sjoerd, right? (In particular wrt. how/where they need to be added to the source and in particular binary packages, documentation, and which platforms they are targeted for (Windows??).) Greetings from Vienna, Stefan On Mon, Sep 24, 2007 at 09:10:33AM +0000, Manuel Mayr wrote: > Update of /cvsroot/monetdb/pathfinder/src/sqlhelpers/db2tools > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv18874 > > Added Files: > Tag: XQuery_0-20 > common.inc load table > Log Message: > > > Shell scripts to create tables, and load content for SQL-backend > > > --- NEW FILE: load --- > #!/bin/sh > > THIS=${0} > THISDIR=${0%/*} > THISFILE=${0##*/} > DB2=`which db2` > > source common.inc > > ################################################ > # FUNCTIONS > > function load_table { > #check parameter list > if [ ${#} -ne 3 ]; then > error "Usage: ${0} <file> <schema> <table>" > fi > > SCHEMA=${2} > FILE=${1} > TABLE=${3} > > # set schema to ours > ${DB2} "set current schema ${SCHEMA}" > > # create the names-table > ${DB2} -t<<EOT > LOAD FROM ${FILE} OF DEL > MODIFIED BY DELPRIORITYCHAR > REPLACE INTO ${TABLE} > NONRECOVERABLE > INDEXING MODE rebuild; > EOT > > ${DB2} "SET INTEGRITY FOR ${TABLE} IMMEDIATE CHECKED" > EFLAG=${?} > return ${EFLAG} > } > > function print_help () { > out "Pathfinder XQuery" > out "(c) Database Group, Technische Universitaet Muenchen" > out "" > out "Usage: ${THISFILE} (create|drop) <db> <schema> <file>" > out "" > out -e "\t<db>:\t\tName of the Database the content should be placed/removed." > out -e "\t<schema>:\tName of the Schema the content should be placed/removed." > out -e "\t<names_file>:\tNames file" > out -e "\t<file>:\tEncoded document" > } > > ################################################ > # MAIN > > if [ $# -ne 4 ]; then > print_help; > exit 0; > fi > > DATABASE=${1} > SCHEMA=${2} > NFILE=${3} > LFILE=${4} > > ${DB2} "connect to ${DATABASE}" > > EFLAG=${?} > out -ne "Connecting to database ${DATABASE} ... "; fail $EFLAG; > > test ${EFLAG} -ne 0 && exit 1; > > load_table "${NFILE}" "${SCHEMA}" "${TAB_NAMES}"; > EFLAG=${?}; > out -ne "Loading ${SCHEMA}.${TAB_NAMES} ... "; fail ${EFLAG}; > > load_table ${LFILE} "${SCHEMA}" "${TAB_DOC}"; > EFLAG=${?}; > out -ne "Loading ${SCHEMA}.${TAB_DOC} ... "; fail ${EFLAG}; > > ${DB2} "terminate" > > --- NEW FILE: table --- > #!/bin/sh > > THIS=${0} > THISDIR=${0%/*} > THISFILE=${0##*/} > DB2=`which db2` > > source common.inc > > ################################################ > # FUNCTIONS > > function create_names { > #check parameter list > if [ ${#} -ne 2 ]; then > error "Usage: ${0} <schema> <tabname>" > fi > > SCHEMA=${1} > TABNAME=${2} > > # set schema to ours > ${DB2} "set current schema ${SCHEMA}" > > # create the names-table > ${DB2} -t<<EOT > CREATE TABLE ${TABNAME}(nameid INT NOT NULL PRIMARY KEY, > name VARCHAR(32) NOT NULL); > EOT > EFLAG=${?} > return ${EFLAG} > } > > function create_doc { > #check parameter list > if [ ${#} -ne 3 ]; then > error "Usage: ${0} <schema> <tabname> <namesname>" > fi > > SCHEMA=${1} > TABNAME=${2} > NAMESNAME=${3} > > ${DB2} "set current schema ${SCHEMA}" > > ${DB2} -t<<EOT > CREATE TABLE ${TABNAME}(pre INT NOT NULL PRIMARY KEY, > size INT NOT NULL, > level SMALLINT NOT NULL, > kind SMALLINT, > nameid INT, > value VARCHAR(100), > guide INT NOT NULL, > FOREIGN KEY (nameid) references ${NAMESNAME}(nameid)); > EOT > EFLAG=${?} > return ${EFLAG} > } > > function create_xmldoc { > #check parameter list > if [ ${#} -ne 4 ]; then > error "Usage: ${0} <schema> <tabname> <docname> <namesname>" > fi > > SCHEMA=${1} > TABNAME=${2} > DOCNAME=${3} > NAMENAME=${4} > > ${DB2} "set current schema ${SCHEMA}" > > ${DB2} -t<<EOT > CREATE VIEW ${TABNAME}(pre, size, level, kind, guide, > nameid, value, name) AS > (SELECT pre, size, level, kind, guide, > doc.nameid, value, name > FROM ${DOCNAME} AS doc > LEFT OUTER JOIN > ${NAMESNAME} AS names > ON doc.nameid = names.nameid); > EOT > EFLAG=${?} > return ${EFLAG} > } > > function drop_table { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <table>" > fi > > TABLE=${1} > > ${DB2} "drop table ${TABLE}" > } > > function drop_names { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <schema>" > fi > > SCHEMA=${1} > > ${DB2} "set current schema ${SCHEMA}" > drop_table "${TAB_NAMES}" > EFLAG=${?} > return ${EFLAG} > } > > function drop_doc { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <schema>" > fi > > SCHEMA=${1} > > ${DB2} "set current schema ${SCHEMA}" > drop_table "${TAB_DOC}" > EFLAG=${?} > return ${EFLAG} > } > > function drop_xmldoc { > #check parameter list > if [ ${#} -ne 1 ]; then > error "Usage: ${0} <schema>" > fi > > SCHEMA=${1} > > ${DB2} "set current schema ${SCHEMA}" > ${DB2} "drop view xmldoc" > EFLAG=${?} > return ${EFLAG} > } > > function print_help () { > out "Pathfinder XQuery" > out "(c) Database Group, Technische Universitaet Muenchen" > out "" > out "Usage: $THISFILE (create|drop) <db> <schema>" > out "" > out -e "\t(create|drop):\teither create or drop the tables " > out -e "\t<db>:\t\tName of the Database the tables should be placed/removed." > out -e "\t<schema>:\tName of the Schema the tables should be placed/removed." > } > > ################################################ > # MAIN > > if [ $# -ne 3 ]; then > print_help; > exit 0; > fi > > OPTION=${1} > DATABASE=${2} > SCHEMA=${3} > > ${DB2} "connect to ${DATABASE}" > EFLAG=$? > out -ne "Connecting to database ${DATABASE} ... "; fail $EFLAG; > test $EFLAG -ne 0 && exit 1; > > case ${OPTION} in > create) create_names ${SCHEMA} ${TAB_NAMES}; > EFLAG=${?}; > out -ne "Creating ${SCHEMA}.${TAB_NAMES} ... "; fail ${EFLAG}; > > create_doc ${SCHEMA} ${TAB_DOC} ${TAB_NAMES}; > EFLAG=${?}; > out -ne "Creating ${SCHEMA}.${TAB_DOC} ... "; fail ${EFLAG}; > > create_xmldoc ${SCHEMA} ${TAB_XMLDOC} ${TAB_DOC} ${TAB_NAMES}; > EFLAG=${?}; > out -ne "Creating ${SCHEMA}.${TAB_XMLDOC} ... "; fail ${EFLAG}; > ;; > > drop) drop_xmldoc ${SCHEMA} > EFLAG=${?} > out -ne "Dropping ${SCHEMA}.${TAB_XMLDOC} ... "; fail ${EFLAG}; > > drop_doc ${SCHEMA} > EFLAG=${?} > out -ne "Dropping ${SCHEMA}.${TAB_DOC} ... "; fail ${EFLAG}; > > drop_names ${SCHEMA} > EFLAG=${?} > out -ne "Dropping ${SCHEMA}.${TAB_NAMES} ... "; fail ${EFLAG}; > ;; > *) print_help; > exit 1; > ;; > esac > ${DB2} "terminate" > > --- NEW FILE: common.inc --- > DEBUG=0 > > TAB_NAMES="names" > TAB_DOC="doc" > TAB_XMLDOC="xmldoc" > > DB2=`which db2` > > function fail { > if [ ${#} -ne 1 ]; then > error "Wrong use of fail" > fi > > if [ ${1} -eq 0 ]; then > out "Success" > return 0; > else > out "Failed" > return 0; > fi > } > > function error { > if [ ${#} -ne 1 ]; then > echo "Wrong use of error" > exit 1; > fi > echo -e "Error: ${1}" > exit 1 > } > > function warning > { > if [ ${#} -ne 1 ]; then > error "Wrong use of debug" > fi > echo -e "Warning: ${1}" > } > > function out { > if [ ${#} -eq 1 ]; then > echo -e "${1}" > return 0; > fi > if [ ${#} -eq 2 ]; then > echo "${1}" "${2}" > else > error "wrong use of out" > fi > } > > function debug { > if [ ${#} -ne 1 ]; then > error "Wrong use of debug" > fi > test ${DEBUG} -eq 1 && echo -e "Debug: ${1}" > } > > function LOG1 { > prompt="\n# `date +%H:%M:%S` > "; { echo -en "$prompt$prompt" ; echo -n "$*" ; echo -en "$prompt\n\n" ; } >&2; > } > > function getAbsolutePath { > if [ -z ${1} ]; then > error "Wrong use of ${0}"; > fi > > PATH_=${1%/*} > FILE_=${1##*/} > > echo `cd ${PATH_} 2> /dev/null && pwd || echo ${PATH_}`/${FILE_} > } > > test -z $DB2 && error "DB2 not available"; > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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 |

4 3

[Monetdb-developers] hi
by Mark Polo 20 Sep '07

20 Sep '07

hi, Monet DB is in-memory database only ? is it disk-based just like timesten contains both? thnaks n regards mark polo -- View this message in context: http://www.nabble.com/hi-tf4486230.html#a12793347 Sent from the monetdb-developers mailing list archive at Nabble.com.

2 1

Re: [Monetdb-developers] [Monetdb-pf-checkins] pathfinder/compiler/sql lalg2sql.brg, , 1.73, 1.74
by Stefan Manegold 19 Sep '07

19 Sep '07

On Wed, Sep 19, 2007 at 07:19:52AM +0000, Manuel Mayr wrote: > Update of /cvsroot/monetdb/pathfinder/compiler/sql > In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17096/sql > > Modified Files: > lalg2sql.brg > Log Message: > > > Fixing failure indicated by testweb Thanks! BUT: http://sourceforge.net/mailarchive/forum.php?thread_name=20070918223806.GA2… says: " [...] IMPORTANT NOTES: 1) As usually, as of NOW, a) ALL bug fixes (and ONLY those) MUST be checked in to the above release branches (and ONLY there)! b) ALL new features (and ONLY those) MUST be checked in to the development trunk (HEAD) (and ONLY there)! (In case you need assistance please feel free to contact MonetDB-developers@li... .) [...] " Stefan > Index: lalg2sql.brg > =================================================================== > RCS file: /cvsroot/monetdb/pathfinder/compiler/sql/lalg2sql.brg,v > retrieving revision 1.73 > retrieving revision 1.74 > diff -u -d -r1.73 -r1.74 > --- lalg2sql.brg 18 Sep 2007 11:47:20 -0000 1.73 > +++ lalg2sql.brg 19 Sep 2007 07:19:48 -0000 1.74 > @@ -482,8 +482,6 @@ > #define EXT_COLUMN_NAME(alias,att,ty) (ext_column_name ( \ > (alias), new_col ((att),(ty)))) > > - > - > /* .......... Column Environment Helper Functions .......... */ > > struct sql_column_env_t > @@ -1523,14 +1521,18 @@ > * twigs */ > PFla_op_t *twig; > unsigned int i; > - for (i = 0; i < PFarray_last (frags); i++) { > - twig = *(PFla_op_t **)PFarray_at (frags, i); > - if (twig == p) > - break; > - } > - if (i < PFarray_last (frags) && twig) { > - SER_REPORT(p) = ser_tc; > - return; > + > + if (p->kind == la_twig) { > + for (i = 0; i < PFarray_last (frags); i++) { > + twig = *(PFla_op_t **)PFarray_at (frags, i); > + if (twig == p) > + break; > + } > + > + if (i < PFarray_last (frags) && twig) { > + SER_REPORT(p) = ser_tc; > + return; > + } > } > > /* if we find a leaf return yes */ > @@ -1773,10 +1775,8 @@ > alias_bind(document, alias (docalias1))), > eq (PRE(docalias1), item_pre)), > alias_bind (document, alias (docalias2))), > - and_ ( > - gteq (PRE(docalias2), PRE(docalias1)), > - gteq (add (PRE(docalias1), SIZE(docalias1)), > - PRE(docalias2))))), > + between (PRE(docalias2), PRE(docalias1), > + add (PRE(docalias1), SIZE(docalias1))))), > NULL, > (IS_LITERAL(cpos))? > stmt_list (PRE(docalias2)): > @@ -2211,12 +2211,14 @@ > case 6: > /* Rel: thetajoin (Rel, Rel) */ > case 8: > + { > assert (kids[0] && nts[0]); > assert (kids[1] && nts[1]); > /* reduce the first child */ > reduce (kids[0], nts[0]); > > PFarray_t *left_args = PFarray (sizeof(PFsql_t*)); > + /* left join predicate for the equijoin */ > if (p->kind == la_eqjoin) { > PFalg_simple_type_t l_ty; > > @@ -2229,7 +2231,7 @@ > p->sem.eqjoin.att1, > l_ty); > } > - /* join predicates for the theta-join operator */ > + /* left join predicates for the theta-join operator */ > else if (p->kind == la_thetajoin) { > PFalg_att_t left; > PFalg_simple_type_t l_ty; > @@ -2256,6 +2258,7 @@ > reduce (kids[1], nts[1]); > > PFarray_t *right_args = PFarray (sizeof(PFsql_t*)); > + /* left join predicate for the equi-join operator */ > if (p->kind == la_eqjoin) { > PFalg_simple_type_t r_ty; > > @@ -2382,7 +2385,7 @@ > where_list_add (WHERELIST(p), cond); > } > } > - break; > + } break; > > /* Rel: semijoin (Rel, Rel) */ > case 7: > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2005. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > 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