- users-list - monetdb.org

Re: [MonetDB-users] Could not bootstrap buildtools on SunOS 5.10
by Ying Zhang 29 Aug '06

29 Aug '06

Thanks, your tip helps to get rid of a strange problem in another MonetDB installation of mine. I was also installing monet on a Fedora4, 32bits machine (norma at cwi). I could not install all buildtools in one go while I can install each buildtool separately. After having clean out the buildtools and start all over again, the problem disappeared. But it doesn't help to solve this problem. I will have to find other solutions:) On Mon, Aug 28, 2006 at 10:17:19PM +0200, Martin Kersten wrote: > Hello, > I am not the right person, but I spent 2.5 hours yesterday (and friday > too) to re-install my version :-(. > One of the lessons learned, with each step use a fresh window, so that > existing shell variables and aliases are out of the way. > > i.e. > step 1, clean out the builtools (or better save them elsewhere ;-)) > followed by cvs upd > step 2, open a new SUN session window and start the bootstrap sequence. > > good luck ! > > Ying Zhang wrote: > >Hello, > > > >I'm trying to install MonetDB (CVS HEAD) on a SunOS 5.10 32 bits machine > >(electra at CWI), but I'm already stuck by bootstrapping the buildtools. > >I've attached the whole output of the bootstrap. Please note the > >message at the end of the output. I have no idea what is going wrong > >here, so any help will be appreciated! > > > >Kind regards, > > > >Jennie > > > > > >========================================== > >$ ./bootstrap > >+ rm -f configure > >+ cp configure.ac configure > >+ chmod +x configure > >+ cd Mx > >+ ./bootstrap > >/opt/sfw/share/aclocal/xmms.m4:17: warning: underquoted definition of > >XMMS_TEST_ VERSION > > run info '(automake)Extending aclocal' > > or see > > http://sources.redhat.com/automake/automake.html#Extending%20aclocal > >/opt/sfw/share/aclocal/xmms.m4:62: warning: underquoted definition of > >AM_PATH_XM MS > >/opt/sfw/share/aclocal/xdelta.m4:7: warning: underquoted definition of > >AM_PATH_X DELTA > >/opt/sfw/share/aclocal/vorbis.m4:9: warning: underquoted definition of > >XIPH_PATH _VORBIS > >/opt/sfw/share/aclocal/sdl.m4:11: warning: underquoted definition of > >AM_PATH_SDL > >/opt/sfw/share/aclocal/progtest.m4:13: warning: underquoted definition of > >AM_PAT H_PROG_WITH_TEST > >/opt/sfw/share/aclocal/ogg.m4:8: warning: underquoted definition of > >XIPH_PATH_OG G > >/opt/sfw/share/aclocal/lcmessage.m4:11: warning: underquoted definition of > >AM_LC _MESSAGES > >/opt/sfw/share/aclocal/imlib.m4:9: warning: underquoted definition of > >AM_PATH_IM LIB > >/opt/sfw/share/aclocal/imlib.m4:167: warning: underquoted definition of > >AM_PATH_ GDK_IMLIB > >/opt/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of > >AM_PAT H_GIMPPRINT > >/opt/sfw/share/aclocal/gimp.m4:8: warning: underquoted definition of > >AM_PATH_GIM P > >/opt/sfw/share/aclocal/gettext.m4:11: warning: underquoted definition of > >AM_WITH _NLS > >/opt/sfw/share/aclocal/gettext.m4:196: warning: underquoted definition of > >AM_GNU _GETTEXT > >/opt/sfw/share/aclocal/ao.m4:9: warning: underquoted definition of > >XIPH_PATH_AO > >/usr/share/aclocal/vorbis.m4:9: warning: underquoted definition of > >XIPH_PATH_VOR BIS > >/usr/share/aclocal/vorbis-old.m4:9: warning: underquoted definition of > >AM_PATH_V ORBIS > >/usr/share/aclocal/pkg.m4:5: warning: underquoted definition of > >PKG_CHECK_MODULE S > >/usr/share/aclocal/ogg.m4:8: warning: underquoted definition of > >XIPH_PATH_OGG > >/usr/share/aclocal/ogg-old.m4:8: warning: underquoted definition of > >AM_PATH_OGG > >/usr/share/aclocal/esd.m4:10: warning: underquoted definition of > >AM_PATH_ESD > >/usr/share/aclocal/esd.m4:175: warning: underquoted definition of > >AM_ESD_SUPPORT S_MULTIPLE_RECORD > >/usr/share/aclocal/audiofile.m4:12: warning: underquoted definition of > >AM_PATH_A UDIOFILE > >/usr/sfw/share/aclocal/gtk.m4:7: warning: underquoted definition of > >AM_PATH_GTK > >/usr/sfw/share/aclocal/glib.m4:8: warning: underquoted definition of > >AM_PATH_GLI B > >/usr/sfw/share/aclocal/gimpprint.m4:8: warning: underquoted definition of > >AM_PAT H_GIMPPRINT > >./bootstrap: test: argument expected > > + exit 1 > > > > > > > >------------------------------------------------------------------------- > >Using Tomcat but need to do more? Need to support web services, security? > >Get stuff done quickly with pre-integrated technology to make your job > >easier > >Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >_______________________________________________ > >MonetDB-users mailing list > >MonetDB-users(a)lists.sourceforge.net > >https://lists.sourceforge.net/lists/listinfo/monetdb-users

3 2

Re: [MonetDB-users] help please
by Stefan Manegold 25 Aug '06

25 Aug '06

George, if everything works well, there should be daily-built MonetDB/SQL RPMs available also for 64-bit SuSE as of tomorrow (european) morning from http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… I found and (hopefully) fixed the bug that prevented them from being built. Stefan On Wed, Aug 23, 2006 at 05:46:44AM -0700, George H wrote: > Stefan: > > Thanks so much for everything. > > You've been the greatest. > > George > > > > Stefan Manegold wrote: > > >Hi George, > > > >On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > > > > > >>Hey Stephan: > >> > >>On SuSE 10.1 (AMD64) using download from SourceForge (developed on > >>Fedora Core as you said) I got: > >> > >># rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >>libtermcap.so.2 () (64bit) is needed > >> > >> > > > >libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, > >though that FC4 comes with > > libcrypto.so.5, libssl.so.5, libtermcap.so.2, > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 > >respectively), while SuSE 9.3 (and apparently also 10.1) comes with > > libcrypto.so.0, /usr/lib64/libssl.so.0 > >(which are actually symlinks to > > libcrypto.so.0.9.7f, libssl.so.0.9.7f > >respectively). > >Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > > > > > > > >>I downloaded the sever and client for SuSE 9.3 as you recommended from > >>http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>Both seemed to install fine and the Mserver command brough me to the > >> > >> > > > >good. > > > > > > > >>MonetDB> prompt, however with the following warnings. > >> > >>!Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > >>!Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > >>!Warning: BBPdir: initializng BBP > >> > >>Are these a problem? > >> > >> > > > >nope, that normal when you start Mserver for the firt time. > >It just creates and initializes the location for its databases. > > > > > > > >>Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > >>result > >> > >>error: Failed dependencies: > >> > >>libcrypto.so.5 () (64bit) is needed > >>libssl.so.5 () (64bit) is needed > >> > >> > > > >that's the FC4 RPM, right? > >Hence, same problem as mentioned above. > > > > > > > >>Is there an SQL-server frontend for SuSe 9.3 or some other solution that > >>would allow meto have an SQL frontend to use with the install success I > >>had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > >>need the SQL? I sure hope not. > >> > >> > > > >There is supposed to be an SQL frontend RPM also for SuSE 9.3 at > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >However, the compilation of that seem to have failed recently (at least > >last > >night) --- I cannot yet see/understand why (in fact, compilation worked, > >but > >creating the RPMs failed) --- We'll (try to) look into this ... > >... sorry for the inconvenience... > > > >Hence, you'll either have to wait until we manage to fix the RPM build for > >MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: > >http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >), or you could get the source code (source-RPM or tar ball) for > >MonetDB/SQL, i.e., > > MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… > > or > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… > > > >and compile them yourself (next to the MonetDB-server & MonetDB-client > >RPMs, > >also the MonetDB-devel RPM needs to be installed). > > > >Let us know, in case you have more problems/questions. > > > >Stefan > > > > > >ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net > >mailing > > list in your replies? > > Other might be interested in this topic as well... > > Thanks in advance! > > > > > > > > > >>Thanks Stephen. > >> > >>Best to you....George > >> > >> > >> > >>Stefan Manegold wrote: > >> > >> > >> > >>>Dear George, > >>> > >>>to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install > >>>the respective > >>>MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > >>> http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >>>"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >>>MonetDB-client-4.12.0-1.*.rpm to be installed as well." > >>> > >>>You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page > >>>as > >>>MonetDB-server-4.12.0-1.*.rpm: > >>> http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > >>> > >>> > >>>What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >>>Could you please send/post the list? > >>>(Most probably, they are indeed required....) > >>> > >>> > >>>Note though, that the RPM available from SF have been built on (and for) > >>>a > >>>Fedora Core 4 system, hence, there *might* be problem with installing > >>>them > >>>on a SuSE 10.1 system. > >>> > >>>We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >>>cannot > >>>provide any SuSE 10.1 specific RPMs, yet. > >>> > >>>All we can currently offer (in case you don't manage to install the > >>>Fedora > >>>Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > >>> http://monetdb.cwi.nl/GetGoing/Download/index.html > >>>(scroll down to 'Daily Builds') and click on 'CVS release branch > >>>("Stable")', or directly go to > >>> http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > >>> > >>>(There have been only minor bug fixes on the release branch, hence there > >>>should be no major differences between the 4.12.0 release from SF and the > >>>4.12.1 daily builds...) > >>> > >>> > >>>Kind Regards, > >>> > >>>Stefan > >>> > >>> > >>>On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > >>> > >>> > >>> > >>> > >>>>Hello: > >>>> > >>>>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>>>but can you help. > >>>> > >>>>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>>>(amd64) using the rpm -ivh command and I have "error: Failed > >>>>dependencies." > >>>> > >>>>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>>>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>>>(64bit) are needed. > >>>> > >>>>Where do I get these? I've been searching, but all I can find is their > >>>>presence in other rpm packages. For example, I see that some of these > >>>>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>>>lengthy list of missing dependencies for installation. > >>>> > >>>>Can you give me a hint. I feel like I'm in dependency hell, but I > >>>>realizie I'm more likely in naive dumblandia. > >>>> > >>>>Help please........Thanks, George > >>>> > >>>>------------------------------------------------------------------------- > >>>>Using Tomcat but need to do more? Need to support web services, > >>>>security? > >>>>Get stuff done quickly with pre-integrated technology to make your job > >>>>easier > >>>>Download IBM WebSphere Application Server v.1.0.1 based on Apache > >>>>Geronimo > >>>>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >>>>_______________________________________________ > >>>>MonetDB-users mailing list > >>>>MonetDB-users(a)lists.sourceforge.net > >>>>https://lists.sourceforge.net/lists/listinfo/monetdb-users > >>>> > >>>> > >>>> > >>>> > >>>> > >>> > >>> > >>> > > > > > > > -- | 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 2

Re: [MonetDB-users] help please
by Stefan Manegold 23 Aug '06

23 Aug '06

Hi George, On Tue, Aug 22, 2006 at 05:23:52PM -0700, George H wrote: > Hey Stephan: > > On SuSE 10.1 (AMD64) using download from SourceForge (developed on > Fedora Core as you said) I got: > > # rpm -ivh MonetDB-client-4.12.0-1.x86_64.rpm > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed > libtermcap.so.2 () (64bit) is needed libcrypto.so, libssl.so libtermcap.so are indeed required --- it appears, though that FC4 comes with libcrypto.so.5, libssl.so.5, libtermcap.so.2, (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f, libtermcap.so.2.0.8 respectively), while SuSE 9.3 (and apparently also 10.1) comes with libcrypto.so.0, /usr/lib64/libssl.so.0 (which are actually symlinks to libcrypto.so.0.9.7f, libssl.so.0.9.7f respectively). Hence, the FC4 RPMs do not fit SuSE 9.3 and 10.1 > I downloaded the sever and client for SuSE 9.3 as you recommended from > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > Both seemed to install fine and the Mserver command brough me to the good. > MonetDB> prompt, however with the following warnings. > > !Warning: GDKlockHome: created directory /var/lib/MonetDB/defarm/demo/ > !Warning: GDKlockhome:ignoring empty or invalid .gdk_lock > !Warning: BBPdir: initializng BBP > > Are these a problem? nope, that normal when you start Mserver for the firt time. It just creates and initializes the location for its databases. > Finally, I tryed rpm -ivh MonetDB-SQL-server-2.12.0-1.x86_64.rpm. The > result > > error: Failed dependencies: > > libcrypto.so.5 () (64bit) is needed > libssl.so.5 () (64bit) is needed that's the FC4 RPM, right? Hence, same problem as mentioned above. > Is there an SQL-server frontend for SuSe 9.3 or some other solution that > would allow meto have an SQL frontend to use with the install success I > had with the MonetDB for SuSe9.3? Or am I forced to use FedoraCore if I > need the SQL? I sure hope not. There is supposed to be an SQL frontend RPM also for SuSE 9.3 at http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… However, the compilation of that seem to have failed recently (at least last night) --- I cannot yet see/understand why (in fact, compilation worked, but creating the RPMs failed) --- We'll (try to) look into this ... ... sorry for the inconvenience... Hence, you'll either have to wait until we manage to fix the RPM build for MonetDB/SQL on SuSE 9.3 (64-bit; it works on/for 32-bit: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… ), or you could get the source code (source-RPM or tar ball) for MonetDB/SQL, i.e., MonetDB-SQL-2.12.0-1.src.rpm or MonetDB-SQL-2.12.0.tar.gz from http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=1141… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceR… or http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./SourceT… and compile them yourself (next to the MonetDB-server & MonetDB-client RPMs, also the MonetDB-devel RPM needs to be installed). Let us know, in case you have more problems/questions. Stefan ps: Could you please also cc the Monetdb-users(a)lists.sourceforge.net mailing list in your replies? Other might be interested in this topic as well... Thanks in advance! > Thanks Stephen. > > Best to you....George > > > > Stefan Manegold wrote: > > >Dear George, > > > >to install the MonetDB-server-4.12.0-1.*.rpm, you also need to install the > >respective > >MonetDB-client-4.12.0-1.*.rpm, as mentioned in the release notes at > > http://sourceforge.net/project/shownotes.php?release_id=427002&group_id=569…: > >"[...] the MonetDB-server-4.12.0-1.*.rpm requires the corresponding > >MonetDB-client-4.12.0-1.*.rpm to be installed as well." > > > >You get the MonetDB-client-4.12.0-1.*.rpm from the same SF download page as > >MonetDB-server-4.12.0-1.*.rpm: > > http://sourceforge.net/project/showfiles.php?group_id=56967&package_id=5234… > > > > > >What are the missing dependencies for MonetDB-client-4.12.0-1.x86_64.rpm? > >Could you please send/post the list? > >(Most probably, they are indeed required....) > > > > > >Note though, that the RPM available from SF have been built on (and for) a > >Fedora Core 4 system, hence, there *might* be problem with installing them > >on a SuSE 10.1 system. > > > >We don't have (access to) a (64-bit) SuSE 10.1 system, yet, hence, we > >cannot > >provide any SuSE 10.1 specific RPMs, yet. > > > >All we can currently offer (in case you don't manage to install the Fedora > >Core 4 RPMs), are SuSE 9.3 RPMs form our MonetDB web site at > > http://monetdb.cwi.nl/GetGoing/Download/index.html > >(scroll down to 'Daily Builds') and click on 'CVS release branch > >("Stable")', or directly go to > > http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./RPMs/Su… > > > >(There have been only minor bug fixes on the release branch, hence there > >should be no major differences between the 4.12.0 release from SF and the > >4.12.1 daily builds...) > > > > > >Kind Regards, > > > >Stefan > > > > > >On Tue, Aug 22, 2006 at 12:11:52PM -0700, George H wrote: > > > > > >>Hello: > >> > >>I am new to MonetDB and I'm no linux wizard either, so please excuse, > >>but can you help. > >> > >>I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 > >>(amd64) using the rpm -ivh command and I have "error: Failed > >>dependencies." > >> > >>It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), > >>libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () > >>(64bit) are needed. > >> > >>Where do I get these? I've been searching, but all I can find is their > >>presence in other rpm packages. For example, I see that some of these > >>are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own > >>lengthy list of missing dependencies for installation. > >> > >>Can you give me a hint. I feel like I'm in dependency hell, but I > >>realizie I'm more likely in naive dumblandia. > >> > >>Help please........Thanks, George > >> > >>------------------------------------------------------------------------- > >>Using Tomcat but need to do more? Need to support web services, security? > >>Get stuff done quickly with pre-integrated technology to make your job > >>easier > >>Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > >>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > >>_______________________________________________ > >>MonetDB-users mailing list > >>MonetDB-users(a)lists.sourceforge.net > >>https://lists.sourceforge.net/lists/listinfo/monetdb-users > >> > >> > >> > > > > > > -- | 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

[MonetDB-users] help please
by George H 22 Aug '06

22 Aug '06

Hello: I am new to MonetDB and I'm no linux wizard either, so please excuse, but can you help. I'm trying to install MonetDB-server-4.12.0-x86_64.rpm on SuSE 10.1 (amd64) using the rpm -ivh command and I have "error: Failed dependencies." It says libMapi.so.0 () (64bit), libcrypto.so.5 () (64bit), libmutils.so.0 () (64bit), libssl.so.5 () (64bit), libstream.so.0 () (64bit) are needed. Where do I get these? I've been searching, but all I can find is their presence in other rpm packages. For example, I see that some of these are in the MonetDB-client-4.12.0-1.x86_64.rpm, but it has it's own lengthy list of missing dependencies for installation. Can you give me a hint. I feel like I'm in dependency hell, but I realizie I'm more likely in naive dumblandia. Help please........Thanks, George

2 1

Re: [MonetDB-users] return type of 'count' in mil
by Stefan Manegold 14 Aug '06

14 Aug '06

Jenny, the return type of count is "legacy". You're right, in case of BATs with more than 2^31 BUNs (possible only on 64-bit systems), the default count(BAT[any,any]):int will fail (or at least return a wrong result. We hanven't changed it to count(BAT[any,any]):lng, yet, maily due to backward-compatibility and due to the fact that a grouped-count ({count}(BAT[any::1,any::2]):BAT[any::1,int/lng]) would than in all cases return a BAT[any,lng], possibly "wasting" space compared to a BAT[any,int]. Eventually, count should return a vraiable integer type that is 32-bit on 32-bit systems and 64-bit on 64-bit systems --- I've been planning to add this "word" type (together with a "proper" 1-byte integer "byte") for quite some time, but it never made it to the very top op my priority-ordered todo list... for now, in case you indeed need th count of >2^31 BUN BATs, you can use count(int):lng, where you provide the BAT's id (i.e., int(BAT)) iso. the BAT itself as argument: ======== MonetDB>help("count"); COMMAND: count(BAT[any,any], bit) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT; ignores BUNs with nil-tail iff ignore_nils==TRUE. COMMAND: count(BAT[any,any]) : int MODULE: algebra COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the number of elements currently in a BAT. COMMAND: count(BAT[void,void], lng) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Sets the size (in number of elements) of a BAT. COMMAND: count(int) : lng MODULE: bat COMPILED: by adm on Mon Aug 7 18:07:14 2006 Returns the current size (in number of elements) of a BAT. MonetDB> ======== Stefan On Wed, Aug 09, 2006 at 04:29:33PM +0200, Ying Zhang wrote: > hi stefan, > > I'm wondering if the return type 'int' of the mil command 'count' is > correct. According to help("count"): > > ... > COMMAND: count(BAT[any,any]) : int > MODULE: algebra > COMPILED: by adm on Mon Aug 7 15:11:12 2006 > Returns the number of elements currently in a BAT. > ... > > what if I want to count a BAT[oid,oid] which contains a max. nr. of BUNs > that a BAT with 64bits oid can have. would this be a problem, since > 'oid' is of 64bits on 64bits machines, while 'int' is of 32bits? or is > a mil 'int' different than a C 'int', namely the size of a mil 'int' > also varias in different machines? > > Thanks > > Jennie -- | 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

[MonetDB-users] MonetDB-XQuery and C#
by Arthur van Bunningen 11 Aug '06

11 Aug '06

Dear all, As we are writing a windows application which will store and query structured documents in a database and we want to use MonetDB/XQuery as database backend, we wondered what the easiest method is to access MonetDB/XQuery from C#. For what it's worth: parsing the XML results is of course no problem, and ODBC is supported. Hopefully some of you can point us to a workable solution. Thanks in advance, Arthur

4 3

[MonetDB-users] xquery over large amount of small documents
by Martijn Faassen 02 Aug '06

02 Aug '06

Hi there, I asked something like this question last year and I'm basically checking up on the progress since then. I hope this mail is not interpreted as demanding anything; I can see you guys are doing impressive work, I'm just trying to give feedback from the perspective of an application developer drooling over the potential of XML databases.. I can see on your website that collections() support is not there yet (marked as "will", though). I also looked at this page: http://monetdb.cwi.nl/XQuery/Overview/Roadmap/index.html 'many small documents' is not listed on this roadmap. On another roadmap page however: http://monetdb.cwi.nl/Development/Roadmap/index.html I do see the following entry (for the september release this year): XQuery: support for large numbers of small documents This gives me hope. :) Is that still the plan? If so, it might be useful to update the XQuery roadmap with that tidbit from the main MonetDB roadmap, as I might not be the only one who is looking for such features. My use case is that of a CMS - large amounts of smaller XML documents that it would be nice to do efficient queries over. Updating small parts of documents (XUpdate) would be nice, but whole-document updates would be okay already, though that might actually mean something like XUpdate to you guys, as you might deal with collections internally as something close to one giant document. Monet is tantalizing because it promises supreme xquery performance but the applications I can imagine do need support for large quantities of smaller documents. If there's a version under development somewhere that supports this feature I'd be happy to try playing with it and give some feedback. Thanks for the attention! Regards, Martijn

2 2

[MonetDB-users] Question about MonetDB ODBC driver configuration
by china-davy 27 Jul '06

27 Jul '06

Hi: I have installed MonetDB (Operationg system is windows xp) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work,for example the "databasename,username,and so on".But the configuration work is forbidded(When I click the "MonetDB" in the windows ODBC Manager,nothing happned to let me do configure work,and,not error message )?could you tell me why,and,how to confiigure the ODBC? -- View this message in context: http://www.nabble.com/Question-about-MonetDB-ODBC-driver-configuration-tf19… Sent from the monetdb-users forum at Nabble.com.

2 1

[MonetDB-users] 回复: help! where i get manual
by Fabian 17 Jul '06

17 Jul '06

Hi Peter Chen, I'm not very familiar with ODBC. I'm sending your question to the monetdb-users mailing list. I expect someone there to be able to better answer your question. Regards On 12-07-2006 09:08:59 +0800, liudawei wrote: > Hi Groffen: > > I have install the MonetDB to my computer (Operationg system is windows) and the ODBC driver.I want to connet the MonetDB server through ODBC driver,so I must do some configuration work.But the configuration work is forbidded，could you tell me why,and,how to confiigure the ODBC? > > Fabian <Fabian.Groffen(a)cwi.nl> 写道： Hi, > > Thanks for your interest in MonetDB. The technical documentation of the > MonetDB kernel can be found on our webpage, http://monetdb.cwi.nl/ for > MIL: http://monetdb.cwi.nl/TechDocs/FrontEnds/mil/index.html > > The SQL documentation is limited to how to get yourself going > http://monetdb.cwi.nl/TechDocs/FrontEnds/SQL/index.html > Our SQL syntax is conforming to the SQL/99 standard. We currently have > not made a manual for the SQL/99 standard. A little help I can give you > is that PostgreSQL is fairly SQL/99 conformant as well, and as such > PostgreSQL queries are a good starting point for MonetDB/SQL. > > Regards, > Fabian > > > > liudawei wrote: > > Hi: > > I am a starter on MonetDB,I am interesting in this excllent Database.My > > questions are is: > > 1) where I can get the manual of Monet Server and SQL Front End. > > > > > > best regards > > Peter Chen

3 3

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 12 Jul '06

12 Jul '06

Hi all, > I read the discussion, and I might have experienced the same kind of problem > before. I think there is some problem with the naming (when a document is > previously shredded with the same name as a 'cached' document). At the time > I experienced the problem I couldn't figure out what the exact problem was, > but removing the dbfarm worked for me: > > So perhaps you could try to: > - stop Mserver > - completely remove the dbfarm-folder (defaultpath is > "$PREFIX/var/MonetDB/dbfarm") (hopefully you don't have important XML > documents stored in the database ;) > - start Mserver > - and then run the large query (without running any other queries first)? Thank you very much, everything works fine now! Just removed all dbfarm subdirectories and the error message disappeared. And no, there were no important XML documents stored in the database, only some XMark generated streams ;-)! Nevertheless: I never shredded any document before encountering the problem the first time. Before I /only/ used direct loading from the query. I just tried shredding to solve the problem... Hope this helps to locate the bug! Cheers Michael _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

3 2

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Michael Schmidt 11 Jul '06

11 Jul '06

Hello Stefan, thank you very much for your engagement! > In the meantime, I have some more questions for you: > > Which version of SuSE Linux and which version of gcc do you use? I am running SuSe Linux 10.0 and gcc (GCC) 4.0.2 20050901 (prerelease) (SUSE Linux). > Which exact version of the MonetDB source do you use? > - The released tar-balls from SourceForge > (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? Yes, I used the tar balls. During installation I encountered some problems with the bzip library file, but after manual reinstallation of this package from sources everything worked fine. If I can help you debugging, e.g. by running any tests, please let me know. Kind Regards Michael _____________________________________________________________________ Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! http://smartsurfer.web.de/?mc=100071&distributionid=000000000071

2 1

Re: [MonetDB-users] MonetDB XQuery Module Crash
by Stefan Manegold 11 Jul '06

11 Jul '06

On Sun, Jul 09, 2006 at 05:27:17PM +0200, Michael Schmidt wrote: > Hi Stefan, > > 2 more things: > > - I suppose you already posted my mail at MonetDB-users. I can't see them in the archives but I guess they are updated each night, am I right? I honestly don't know, when SF updates the mailinglist archives, but my mail (quoting your original mail) is (now) in there: http://sourceforge.net/mailarchive/forum.php?thread_id=21306336&forum_id=42… > - I just tried loading the XML-document using "shred_doc". It's the same error message, so the crash is independent from the query. hm, strange --- as I just said, it works fine for me on my Athlon 64 x2 running FC4... I'll check another Athlon 64 with SuSE 9.3 later this week... Stefan > Thanks again for your help! > Michael > ______________________________________________________________________________ > Mit WEB.DE iNews werden Sie über die Ergebnisse der wichtigsten WM-Begegnungen > per SMS informiert: http://freemail.web.de/features/inews.htm/?mc=021202 -- | 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-users] MonetDB XQuery Module Crash
by Stefan Manegold 11 Jul '06

11 Jul '06

Hi Michael, I just double-checked your problem on my AMD Athlon 64 X2 running 64-bit Fedora Core 4, and everything works fine. I can shred and query XMarks documents up to 1.1 GB without problems (didn't try larger ones ;-)). We also have an Athlon 64 running 64-bit SuSE Linux 9.3 --- but I haven't had time to check that one, yet; I'll try to check it the coming days (a 500kB document works fine on that machine in our nightly testing...). In the meantime, I have some more questions for you: Which version of SuSE Linux and which version of gcc do you use? Which exact version of the MonetDB source do you use? - The released tar-balls from SourceForge (MonetDB-4.12.0.tar.gz & MonetDB-XQuery-0.12.0.tar.gz)? - The release source RPMs from SourceForge (MonetDB-4.12.0-1.src.rpm & MonetDB-XQuery-0.12.0-1.src.rpm)? - Source tar-balls or source RPMs from our daily-builds site (http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./)? - A CVS checkout? (Which branch/tag?) Cheers, Stefan ps: I felt free to get let the Monetdb-users mailing list participate in the discussion, again... On Sun, Jul 09, 2006 at 05:14:23PM +0200, Michael Schmidt wrote: > Hi Stefan, > > > Sorry for the inconvenience! > > We'll update the info on the web site. > > And I feel free to propagate this discussion to the Monetdb-users list. > > Thank you very much, I will also register there... > > > Wrt. your actual problem, I have a couple of questions, maily requesting > > more information to analyse the problem: > > > > What kind of system are you running MonetDB/XQuery on? > > CPU (type, 32- or 64-bit)? > > amount of memory? > > free disk space? > > operating system (type, 32- or 64-bit)? > > I'm running SuSe Linux 64-bit, here my /proc/cpuinfo... If there are any more details you need to know feel free to ask me again. > > processor : 0 > vendor_id : GenuineIntel > cpu family : 15 > model : 4 > model name : Intel(R) Pentium(R) 4 CPU 3.00GHz > stepping : 3 > cpu MHz : 2992.716 > cache size : 2048 KB > physical id : 0 > siblings : 2 > core id : 0 > cpu cores : 1 > fpu : yes > fpu_exception : yes > cpuid level : 5 > wp : yes > flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm constant_tsc pni monitor ds_cpl est cid cx16 xtpr > bogomips : 5994.87 > clflush size : 64 > cache_alignment : 128 > address sizes : 36 bits physical, 48 bits virtual > power management: > > > > How did you install MonetDB/XQuery? Using binary (.rpm or .msi) packages or > > compiling from source (tarball or from CVS)? > > I compiled them from source. > > > Which queries are you running? Which of them are working with up to 50MB but > > fail with 100MB or more? > > It's the same for all queries. I'm running the XMark test Queries #1, #6, #8, #13 and #20. Here one example Query: (XMark #1): > > query1> > { for $b in doc("/home/.../xmark.xml")/site/people/person > where $b/person_id = 'person0' > return > <result> {$b/name} </result> } > </query1> > > > Did you load/shred your document explicitely via the "shred_doc" MIL command > > on the Mserver console, or did you have them loaded/shreded implicitely on > > the fly via the fn:doc() XQuery function? > > As running benchmarks where loading time should be included, explicit console loading is unsuitable. As seen above I load them from the query. > > > In the latter case, you could try whether the failing queries do work in > > larger documents once you increase the XML document cache limit by staring > > Mserver with "--set xquery_cacheMB=<size>" where size is large than the > > default 100, e.g., just larger than your largest document. > > (Admittedly, there is only very little "well hidden" documentation about the > > "--set" option(s) of Mserver; we're working on that...) > > I tested "--set xquery_cacheMB=500" without success. > > Kind regards > Michael > _____________________________________________________________________ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071&distributionid=000000000071 > > -- | 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-users] MonetDB XQuery Module Crash
by Stefan Manegold 09 Jul '06

09 Jul '06

Hi Michael, thank you very much for being interested in and using MonetDB/XQuery, as well as for reporting your problem! Apparently, the mailinglist information on the FAQ page of the MonetDB/XQUery web site is indeed a bit misleading. There are actually no specific MonetDB/*XQuery* mailing lists, but "only" general mailing lists for MonetDB that are supposed to be used for all communication about/around MonetDB and all of it's companions and front-ends, o.a., MonetDB/SQL & MonetDB/XQuery; see http://monetdb.cwi.nl/News/MailChannels/ for details. Sorry for the inconvenience! We'll update the info on the web site. And I feel free to propagate this discussion to the Monetdb-users list. Wrt. your actual problem, I have a couple of questions, maily requesting more information to analyse the problem: What kind of system are you running MonetDB/XQuery on? CPU (type, 32- or 64-bit)? amount of memory? free disk space? operating system (type, 32- or 64-bit)? How did you install MonetDB/XQuery? Using binary (.rpm or .msi) packages or compiling from source (tarball or from CVS)? Which queries are you running? Which of them are working with up to 50MB but fail with 100MB or more? Did you load/shred your document explicitely via the "shred_doc" MIL command on the Mserver console, or did you have them loaded/shreded implicitely on the fly via the fn:doc() XQuery function? In the latter case, you could try whether the failing queries do work in larger documents once you increase the XML document cache limit by staring Mserver with "--set xquery_cacheMB=<size>" where size is large than the default 100, e.g., just larger than your largest document. (Admittedly, there is only very little "well hidden" documentation about the "--set" option(s) of Mserver; we're working on that...) If this helps, then there might be a bug somewhere in our document caching code... Kind regards, Stefan On Sun, Jul 09, 2006 at 03:54:30PM +0200, Michael Schmidt wrote: > Hi all, > > I'm confused as I expected a MonetDB XQuery users mailing list instead of > a developer list. However, this list was linked in the MonetDB/XQuery FAQ > section so I thought it would be worth trying... > > Here is my problem: I'm just running some XQuery benchmarks using MonetDB > together with the XQuery module. Installation was ok and I have chosen a > set of queries to be evaluated against data generated with the xmlgen > tool. Query processing works fine for 10MB and 50MB documents, but when > processing large documents (100MB and 200MB) the client reports an error > message. I even tried to figure out the source of the problem using trace > option -t but do not understand the listed error messages. Here is the > final error message reported by the client: > > ERROR: [rename]: 29 times inserted nil due to errors at tuples "pre_size", "pre_level", "pre_prop", "pre_kind", "qn_uri", "qn_prefix". > ERROR: [rename]: first error was: > ERROR: rename(<tmp_351>,pre_size2): operation failed > ERROR: interpret_unpin: [rename] bat=171,stamp=-1285 OVERWRITTEN > ERROR: BBPdecref: tmp_253 does not have pointer fixes. > ERROR: interpret_params: +(param 2): evaluation error. > > Once again: evaluation of the same queries works fine on small streams but > fails on large streams. By the way, I've installed the latest offcial > release of both the server and the XQuery module. > > Is this a bug or are there any default memory limits causing the crash? I > tried to figure out what the --set option is good for but was not able to > detect any documentation on supported options. > > Kind regards > Michael > _____________________________________________________________________ > Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! > http://smartsurfer.web.de/?mc=100071&distributionid=000000000071 > > > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > _______________________________________________ > Monetdb-developers mailing list > Monetdb-developers(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-developers > -- | 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

[MonetDB-users] MonetDB as a transaction processing XML database?
by Sander Kruseman 06 Jul '06

06 Jul '06

Hello, Is my conclusion correct that I should not use MonetDB (yet) as a transaction processing XML database? (inserts and deletes of lots of XML snippets, xqueries on the complete database content, by multiple processes) Could you perhaps suggest an alternative solution? Any familiarity with Berkely DB XML by Sleepycat for example? Btw. we need a C++ API for this. Thanks in advance. Sander

2 1

[MonetDB-users] MonetDB 4.12.0 Release Announcement
by Fabian Groffen 23 Jun '06

23 Jun '06

It is my great pleasure to announce the availability of MonetDB 4.12.0 and its accompanying SQL 2.12.0 and XQuery 0.12.0. This release is the next step in delivering the high performance database system that has been under development for several years now. Some of the many changes since the 4.10.2 release include: MonetDB/XQuery 0.12.0 (nick-named "Ceres") Various improvments of functionality and performance. Addition of XPath extensions for XML standoff annotations. "Ceres" is a small detour on our trip to "Mars" [1], as update functionality is unfortunately still not robust enough for consumption by the majority. MonetDB/SQL 2.12.0 Many bugfixes. Support for local and global temporary tables. Preliminary support for triggers. For a complete list of new features and known problems, please see the release notes and errata list, available at: http://monetdb.cwi.nl/Development/Roadmap/Version4.12/index.html MonetDB/Five Alpha Release 1 ============================ The efforts on the next generation of MonetDB, version Five, are released now. This snapshot of version Five of MonetDB is the very first alpha release of this ongoing development. Beware: alpha is alpha! This software is only suitable as sneak-preview into the MonetDB developers team's kitchen! Come and taste some of the many delicious spices we prepare. Unlike the previous generation, Five comes with the MAL language, instead of MIL, which makes it completely incompatible with old MIL scripts. However, the SQL sources work fine with this alpha release. Comparing the performance of both backends via SQL should give you an indication of what our cooks will serve for dinner. This first alpha "appetiser" release of MonetDB/Five is nick-named "Tomato Soup". Interested users are invited to visit our MonetDB/Five page for more details: http://monetdb.cwi.nl/Development/Five/index.html Availability ============ The MonetDB family products are supported on i686, x86_64 and ia64 Linux, i686 Solaris 10, ppc and ppc64 Mac OS X 10.4 and i686 Windows XP. Binary distributions are available for Linux and Windows. The new release is available for download from our SourceForge page: http://sourceforge.net/project/showfiles.php?group_id=56967 Acknowledgements ================ Many man-hours were donated by various people to make this release happening. I want to thank al MonetDB developers for their efforts spent into this piece of software. All of our contributors and bug reporters also deserve the credits for the time they put into their contribution. Further Information =================== Further information about MonetDB, MonetDB/SQL and MonetDB/XQuery is available on our web site at: http://monetdb.cwi.nl/ http://monetdb.cwi.nl/SQL/ http://monetdb.cwi.nl/XQuery/ For details about recent changes, migration from earlier versions, and future plans, please visit our roadmap page: http://monetdb.cwi.nl/Development/Roadmap/ User CVS Information ==================== If you use a CVS checkout, you might have to change some things in order to keep on working with the latest sources. With every release some new tags are set and numbers changed. Please check your source trees that you use the right sticky tags on them. The sources that are put in this release are tagged as follows: MonetDB MonetDB_4-12-0 sql SQL_2-12-0 pathfinder XQuery_0-12-0 The new stable branches are now available through the following tags: MonetDB MonetDB_4-12 sql SQL_2-12 pathfinder XQuery_0-12 To update to the new stable branches use ``cvs update -r <branch tag>`` for the repositories you work with. Feedback or Questions ===================== If you have any questions or feedback regarding this release, feel free to contact us through this list: monetdb-users(a)lists.sourceforge.net We hope you will enjoy this new release of MonetDB as much as we do. [1] See http://en.wikipedia.org/wiki/1_Ceres and http://www.nasa.gov/multimedia/imagegallery/image_feature_404.html

1 0

Re: [MonetDB-users] Reminder: MonetDB Bug-Etiquette
by Stefan Manegold 19 Jun '06

19 Jun '06

Dear all, two more small pleas that will make bug reporting and fixing much simpler and smoother: - When submitting a bug, please *always* set both the "Category:" and the "Group:"! This helps the developer(s) to identify which version/part of the system your bug occured with. - When changing the "Status:", "Resolution:", and/or "Priority:", please *always* provide a comment that explans the motivation and/or reason for your action. E.g., when closing a bug report, please mention whether, how and where you fixed it. Thanks again! Stefan On Sun, Jun 18, 2006 at 10:09:13PM +0200, Stefan Manegold wrote: > Dear all, > > since the last MonetDB "BugDay" on Dec 19 2005, many bugs have been reported > and fixed. > > Unfortunately, not all bug reports that have been closed since then have > been backed-up by a test script in CVS to verify and monitor to validity of > the respective bug fix, as described in the "MonetDB Bug-Etiquette" > (cf. one of > http://sourceforge.net/mailarchive/forum.php?thread_id=9021727&forum_id=398… > http://sourceforge.net/mailarchive/forum.php?thread_id=9021726&forum_id=425… > ) > > According to the "MonetDB Bug-Etiquette", a bug report should (may/must) not > be closed without adding a respective test to our test system in CVS. > > While both the user/submitter that reports the bug and the > developer/assignee that fixes it should share the task of "designing" the > test and adding it to the test system in CVS, we agreed that the > developer/assignee is finally "responsible" that the test is indeed added > *before* the bug report is closed. > > > To ensure the stability and correctness of MonetDB and its companions and to > avoid that supposedly fixed bug sneak in again unnoticed, I'd like to ask > all of you that reported and/or fix any bug(s) since Dec 19 2005 > the following favour: > > Please check all "your" bugs (see * below) since Dec 19 2005, whether a test > has been added or not. > + If the comments in the bug report are not clear, please check the CVS > repository. > + If you're a user/submitter and don't know where to look or what to do, > please remind the respective developer/assignee of your bug by added a > respective comment and re-opening the bug report. > + If there is a test, or no test is necessary or feasible, but the > bug-report does not mention this clearly, please add a new comment that > explains the situation. > + If there is no test although there should be one, please re-open the bug > report with a respective comment to indicate that a test must be added. > As said before, "users/submitters" are welcome to help adding tests, but > developers/assignees are finally responsible that the tests are indeed > added. > > Please recall, we plan to release MonetDB 4.12, MonetDB/SQL 2.12 and > MonetDB/XQuery 0.12 soon (i.e., before the end of this month), > and we all want them to be as stable and "bug-free" as possible...! > > > Feel free to use these channels to comment and/or ask questions. > > > Thank you all very much for your contributions to make MonetDB even better > than it already is! > > > Kind regards, > > Stefan > > > *) To find "your" bugs, just > - go to http://sourceforge.net/tracker/?group_id=56967&atid=482468 , > - select your username from the list "Assignee:", > - or enter your username as "Submitter username (show mine):" > (and set "Assignee:" to "Any"), > - set "Status:", "Category:" & "Group:" to "Any", > - set "Sort By:" to "Open Date" and "Descending", > - and click on "Browse". > > -- > | 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 | -- | 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

[MonetDB-users] Reminder: MonetDB Bug-Etiquette
by Stefan Manegold 18 Jun '06

18 Jun '06

Dear all, since the last MonetDB "BugDay" on Dec 19 2005, many bugs have been reported and fixed. Unfortunately, not all bug reports that have been closed since then have been backed-up by a test script in CVS to verify and monitor to validity of the respective bug fix, as described in the "MonetDB Bug-Etiquette" (cf. one of http://sourceforge.net/mailarchive/forum.php?thread_id=9021727&forum_id=398… http://sourceforge.net/mailarchive/forum.php?thread_id=9021726&forum_id=425… ) According to the "MonetDB Bug-Etiquette", a bug report should (may/must) not be closed without adding a respective test to our test system in CVS. While both the user/submitter that reports the bug and the developer/assignee that fixes it should share the task of "designing" the test and adding it to the test system in CVS, we agreed that the developer/assignee is finally "responsible" that the test is indeed added *before* the bug report is closed. To ensure the stability and correctness of MonetDB and its companions and to avoid that supposedly fixed bug sneak in again unnoticed, I'd like to ask all of you that reported and/or fix any bug(s) since Dec 19 2005 the following favour: Please check all "your" bugs (see * below) since Dec 19 2005, whether a test has been added or not. + If the comments in the bug report are not clear, please check the CVS repository. + If you're a user/submitter and don't know where to look or what to do, please remind the respective developer/assignee of your bug by added a respective comment and re-opening the bug report. + If there is a test, or no test is necessary or feasible, but the bug-report does not mention this clearly, please add a new comment that explains the situation. + If there is no test although there should be one, please re-open the bug report with a respective comment to indicate that a test must be added. As said before, "users/submitters" are welcome to help adding tests, but developers/assignees are finally responsible that the tests are indeed added. Please recall, we plan to release MonetDB 4.12, MonetDB/SQL 2.12 and MonetDB/XQuery 0.12 soon (i.e., before the end of this month), and we all want them to be as stable and "bug-free" as possible...! Feel free to use these channels to comment and/or ask questions. Thank you all very much for your contributions to make MonetDB even better than it already is! Kind regards, Stefan *) To find "your" bugs, just - go to http://sourceforge.net/tracker/?group_id=56967&atid=482468 , - select your username from the list "Assignee:", - or enter your username as "Submitter username (show mine):" (and set "Assignee:" to "Any"), - set "Status:", "Category:" & "Group:" to "Any", - set "Sort By:" to "Open Date" and "Descending", - and click on "Browse". -- | 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

[MonetDB-users] join on 2 attributes
by Henning Rode 07 Jun '06

07 Jun '06

hej monet-db-useres, i maybe forgot a very basic thing here, but how do you perform in monet an equi-join on two attributes. it seems such a normal task that there must be something easier than what i did now (see attachment: generating first example instances, then do the join with 'intersect') you should have the same problem when you select on a qname (namespace and tagname), but i could not find that example. if i underspecified my problem, just let me know in advance ;-) best -henning var x_a := new(void,int).seqbase(0@0); x_a.append(1); x_a.append(1); x_a.append(1); x_a.append(2); x_a.append(2); x_a.append(2); x_a := [oid](x_a); var x_b := new(void,int).seqbase(0@0); x_b.append(1); x_b.append(2); x_b.append(4); x_b.append(1); x_b.append(2); x_b.append(4); x_b := [oid](x_b); var y_c := new(void,int).seqbase(0@0); y_c.append(1); y_c.append(2); y_c := [oid](y_c); var y_d := new(void,int).seqbase(0@0); y_d.append(2); y_d.append(1); y_d := [oid](y_d); print(x_a,x_b); print(y_c,y_d); var x_y := join(x_a,y_c.reverse()); var x_d := join(x_y,y_d); intersect(x_b,x_d).print();

1 0

[MonetDB-users] MEL Question: Creating a New Search Accelerator
by John Cieslewicz 05 Jun '06

05 Jun '06

I am trying to build a new search accelerator as described in Section 2.5 of the Monet Extension Language (MEL) User Guide (http://monetdb.cwi.nl/TechDocs/Core/mel/index.html) When I execute mel on my module definition it does not seem to recognize the ".ACCELERATOR" key word. In Section 3.5, "Implementing Accelerators" the 'mean' accelerator implementation is described. Is there an example of the module definition of 'mean' in MEL? I also looked at the mel source code and found that in buildtools/_MEL/mel.yy it appears that 'accelerator' is not part of the grammar for a module: ---- definition: atomdef | command | iterator | builtin | operator | object | MEL_PRELUDE '=' ident ';' { $$.sym = new Prelude(MEL_PRELUDE, $3.s); } | MEL_EPILOGUE '=' ident ';' { $$.sym = new Epilogue(MEL_EPILOGUE, $3.s); } ; --- Questions: (1) Are user defined search accelerator modules actually supported in MonetDB? (2) If so, is there an example of such an accelerator module? (3) If not, what would be the best way to integrate a new index technique into the system? Thanks! -John

1 0

[MonetDB-users] python client library for Windows
by Max 10 May '06

10 May '06

Hello! I'm just installed Python 2.4 and MonetDB-Installer-4.10.2.msi, but can't find precompiled python Mapi modules. Generally, I want to try SQL interface to MonetDB from Python. After some dig around tar.gz sources i've found Mapi.py, MapiClient.py, CMapi.py, MapiLib.py and monet_options.py. Still need binary _MapiLib... Also please clarify meaning of monet_options.py file.

2 1

[MonetDB-users] RHEL 4 x86_64 RPMs
by Henk van Lingen 03 May '06

03 May '06

On Fri, Apr 28, 2006 at 06:44:42PM +0200, Stefan Manegold wrote: > > > RPM build errors: > > > File not found by glob: /var/tmp/MonetDB-root/usr/share/MonetDB/lib/*jar > > Can it be that you don't have Java installed on your system? > > Nevertheless I think this is a bug. > > yes, yes, yes: > > - it should also work with REHL4 on x86_64 --- ate least I don't see any > reason why it should not work, provided the systems installed properly; we > actually build RPMs every night on an Itanium running > "Red Hat Enterprise Linux WS release 4 (Nahant Update 3)". NB: Itanium <> x86_64, right? > - your problem looks indeed as if (a proper) java (>=1.4) is not installed or > at least not found by configure (check the configure output and/or the > config.log) Right, I didn't install java on the build host (didn't know it was a dep for MonetDB) However, now I installed java-1.4.2-gcj-compat-devel and java-1.4.2-gcj-compat. But the problems persist. After ./configure --enable-bits=64 make make dist make rpm I have: asclepius:src/MonetDB-4.10.2 144% grep java config.log Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --with-system-zlib --enable-__cxa_atexit --disable-libunwind-exceptions --enable-java-awt=gtk --host=x86_64-redhat-linux configure:4068: checking for java configure:4086: found /usr/bin/java configure:4098: result: /usr/bin/java configure:4120: checking for javac configure:4138: found /usr/bin/javac configure:4150: result: /usr/bin/javac configure:4198: checking for javadoc configure:4216: found /usr/bin/javadoc configure:4228: result: /usr/bin/javadoc config.status:955: creating src/mapi/clients/java/Makefile config.status:955: creating src/mapi/examples/java/Makefile ac_cv_path_JAVA=/usr/bin/java ac_cv_path_JAVAC=/usr/bin/javac ac_cv_path_JAVADOC=/usr/bin/javadoc JAVA='/usr/bin/java' JAVAC='/usr/bin/javac' JAVADOC='/usr/bin/javadoc' Do I really need the Sun Java? Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

3 3

[MonetDB-users] RHEL 3 RPMs
by Henk van Lingen 28 Apr '06

28 Apr '06

Hi, Is there a special reason there are no i686 RPM's anymore like there were until 4.6.0_rc2? I think it's a bit weird there are RPM's for the hobby OS 'FedoraCore' but not for the much used server OS 'RedHat Enterprise 3 (and 4)'? The FedoraCore (which Core?) needs libstdc++.so.6 whereas RHEL 3 only has libstdc++.so.5 ... There also seems to be no SRPM's. Cheers, -- Henk van Lingen, Systems & Network Administrator (o- -+ Dept. of Computer Science, Utrecht University. /\ | phone: +31-30-2535278 v_/_ http://henk.vanlingen.net/ http://www.tuxtown.net/netiquette/

6 14

[MonetDB-users] Issues with concurrent connections using JDBC
by Anderson Supriano 09 Apr '06

09 Apr '06

Hi! I'm working on a research about database performance and I'm running a TPC-W implementation (based on http://www.ece.wisc.edu/~pharm/tpcw.shtml) on some databases (Monet, MySQL, Postgresql). Basically, what is being done is having some emulated browsers generating load on the servlet container (tomcat in my case) that access the database through JDBC. -------------- -------------- ---------------- | Emulated | | Tomcat | | DB | | Browser | -----> | | ------> | | -------------- -------------- ---------------- When running this benchmark with concurrent accesses I'm getting problems. If I try 5 concurrent Emulated Browsers running (and 5 concurrent database connections) everything goes well. The problem starts when I increase the concurrency. With 30 concurrent connections everything goes well for a few minutes and then it stops working. The servlet container stops responding and monet uses low percentage of CPU on this state. When I try to kill tomcat and start again (without killing Monet) it starts working again and stops after a while. Based on this experiment it seems that Monet is still responsive, but the instance of servlet container that was accessing Monet just freezes. I'm trying to investigate it a little more, but since I'm not an expert on MonetDB internals, I'd like to know if there is some known issue like this one or if anyone can have a tip on how to solve this. Since Monet is responsive and the servlet container is freezing, it looks like JDBC driver is doing something that is freezing the container (I used to suspect on application, but since it is working very well with MySQL and Postgresql, it seems to not be the problem). I'll appreciate any help on this subject. Thanks very much for your attention. Best regards, Anderson Supriano

2 2

[MonetDB-users] Commit failure on concurrent transactions
by Anderson Supriano 02 Apr '06

02 Apr '06

Hi! I am running several concurrent transactions on Monet DB using JDBC and I'm getting an error when commiting a transaction: java.sql.SQLException: COMMIT: failed ERROR: COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2185) at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1937) at nl.cwi.monetdb.jdbc.MonetConnection.commit(MonetConnection.java:443) Is there a way that this exception can be handled in order to have all transactions working (even if waiting the last one to be finished)? I am using MonetDB-4.10.0 and SQL-2.10.0. Thanks for your cooperation. Best regards, Anderson Supriano

2 2