- users-list - monetdb.org

Re: [MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Fabian Groffen 30 May '07

30 May '07

On 30-05-2007 12:07:26 +0200, Ingmar Weber wrote: > > This looks very much like a problem with perl on your machine. > > Quite possibly. Any detailed suggestions? I'm just not quite sure, what > exactly is wrong and how I could fix it. (e.g. by somehow telling MonetDB > to look for Perl related things there rather than there etc.) I'm not familiar with Debian and Perl, but I think something is just looking at a wrong architecture or in another place than it reports. > The output is this: > /amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so: ELF 64-bit LSB shared > object, AMD x86-64, version 1 (SYSV), stripped Looks normal to me. > > Apart from this issue, it appears strange to me that autoconf/automake > are being used. > > Well, strictly speaking the error is caused by this line in the (generated) > Makefile: > cd . && /bin/sh > /local/var/tmp/MonetDB-1180453562/MonetDB4-XQuery/pathfinder/conf/missing > --run autoconf It shouldn't do this, IMO. Running autoconf should only be done if configure has to be regenerated, which it does not have to. > But this script (.../conf/missing --run autoconf) behaves exactly like > autoconf. The error message is the same, independent of whether I run the > Makefile or type autconf by hand. What filesystem are you running stuff on? Do you build in your sources? Is your clock set correctly? Do you use NFS by chance?

1 0

[MonetDB-users] Autoconf error for /MonetDB4-XQuery/pathfinder module
by Ingmar Weber 30 May '07

30 May '07

Hey, When I try to install monetdb (either using the monetdb-install.sh script or the configure/make/make install mechanism in each directory) I get the following error for the MonetDB4-XQuery module: ----- this error occurs at the beginning of the 'make', caused by automake ---- Can't load '/amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so' for module Data::Dumper: /amd64/usr/lib/perl/5.8/auto/Data/Dumper/Dumper.so: cannot open shared object file: No such file or directory at /amd64/usr/lib/perl/5.8/XSLoader.pm line 68. at /amd64/usr/lib/perl/5.8/Data/Dumper.pm line 27 Compilation failed in require at /usr/share/autoconf/Autom4te/C4che.pm line 35. BEGIN failed--compilation aborted at /usr/share/autoconf/Autom4te/C4che.pm line 35. Compilation failed in require at /usr/bin/autom4te line 39. BEGIN failed--compilation aborted at /usr/bin/autom4te line 39. ---------------- Note that the /amd64/usr/lib/perl/5.8/* files all exist in the places named above! Still, it generates the "No such file or directory". --------------------------------- Line 68 (and surroundings) of XSLoader.pm reads as: # Many dynamic extension loading problems will appear to come from # this section of code: XYZ failed at line 123 of DynaLoader.pm. # Often these errors are actually occurring in the initialisation # C code of the extension XS file. Perl reports the error as being # in this perl code simply because this was the last perl code # it executed. my $libref = dl_load_file($file, 0) or do { require Carp; Carp::croak("Can't load '$file' for module $module: " . dl_error()); }; push(@dl_librefs,$libref); # record loaded object --------------------------------- --------------------------------- Line 27 of Dumper.pm reads as: XSLoader::load 'Data::Dumper'; --------------------------------- The error above I also get when I simply type "automake". I currently suspect some 32 bit vs. 64 bit problem, as the machine I'm compiling things on (2x Dual-Core AMD Opteron Processor 2220 SE) can run in either 32 or 64 bit mode. uname outputs: "2.6.16.29.2.amd64-smp" Any (other) ideas? Should I post some other debug information? The output of "configure" is posted below. The other packages of (Monet DB Common etc.) run through smoothly. THANKS! Ingmar ------------- output of "configure" for MonetDB4-XQuery/pathfinder ----- iweber@dork:/scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/MonetDB-Venus-SuperBall-SR1/MonetDB4-XQuery/pathfinder [10083] ./configure --prefix='/scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/' --enable-optimize --disable-debug --with-libxml2=/amd64/usr checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking target system type... x86_64-unknown-linux-gnu checking for a BSD-compatible install... /amd64/usr/bin//install -c checking whether build environment is sane... yes checking for gawk... /usr/bin/gawk checking whether make sets $(MAKE)... yes checking for monetdb-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb-config checking whether MonetDB Common version 1.16.2 or newer is installed... yes: found version 1.16.2 checking for style of include used by make... GNU checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking dependency style of gcc... none checking for egrep... grep -E checking for ANSI C header files... no checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking how to run the C preprocessor... gcc -E checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ANSI C... (cached) none needed checking dependency style of gcc... (cached) none checking for long... yes checking size of long... 8 checking whether byte ordering is bigendian... no checking which Linux distribution we're using... Debian3.1 checking if your compiler is C99 compliant... yes checking for ant... no checking for java... no checking for javac... no checking for jar... no checking for javadoc... no checking for monetdb4-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb4-config checking whether MonetDB4 version 4.16.2 or newer is installed... yes: found version 4.16.2 checking for monetdb-clients-config... /scratch/KM/ir-scratch/ingmar/MonetDB-SuperBall/installation/bin/monetdb-clients-config checking whether MonetDB Clients version 1.16.2 or newer is installed... yes: found version 1.16.2 checking for a sed that does not truncate output... /amd64/bin//sed checking for option to reload object files... -r checking for BSD-compatible nm... /amd64/usr/bin//nm -B checking whether ln -s works... yes checking how to recognise dependent libraries... pass_all checking dlfcn.h usability... yes checking dlfcn.h presence... yes checking for dlfcn.h... yes checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... none checking how to run the C++ preprocessor... g++ -E checking for g77... no checking for f77... no checking for xlf... no checking for frt... no checking for pgf77... no checking for fort77... no checking for fl32... no checking for af77... no checking for f90... no checking for xlf90... no checking for pgf90... no checking for epcf90... no checking for f95... no checking for fort... no checking for xlf95... no checking for ifc... no checking for efc... no checking for pgf95... no checking for lf95... no checking for gfortran... no checking whether we are using the GNU Fortran 77 compiler... no checking whether accepts -g... no checking for flex... no checking for lex... no checking for yywrap in -lfl... no checking for yywrap in -ll... no checking for a BSD-compatible install... /amd64/usr/bin//install -c checking for ld used by gcc... ld -IPA -m elf_x86_64 checking if the linker (ld -IPA -m elf_x86_64) is GNU ld... yes checking the maximum length of command line arguments... 32768 checking command to parse /amd64/usr/bin//nm -B output from gcc object... ok checking for objdir... .libs checking for ar... ar checking for ranlib... ranlib checking for strip... strip checking if gcc static flag works... yes checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking whether the gcc linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: creating libtool appending configuration tag "CXX" to libtool checking for ld used by g++... ld -IPA -m elf_x86_64 checking if the linker (ld -IPA -m elf_x86_64) is GNU ld... yes checking whether the g++ linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking for g++ option to produce PIC... -fPIC checking if g++ PIC flag -fPIC works... yes checking if g++ supports -c -o file.o... yes checking whether the g++ linker (ld -IPA -m elf_x86_64) supports shared libraries... yes checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes appending configuration tag "F77" to libtool checking for ANSI C header files... (cached) no checking whether time.h and sys/time.h may both be included... yes checking for dirent.h that defines DIR... yes checking for library containing opendir... none required checking alloca.h usability... yes checking alloca.h presence... yes checking for alloca.h... yes checking getopt.h usability... yes checking getopt.h presence... yes checking for getopt.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking for sys/types.h... (cached) yes checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for _LARGE_FILES value needed for large files... no checking for an ANSI C-conforming const... yes checking for size_t... yes checking return type of signal handlers... void checking for ptrdiff_t... yes checking for ssize_t... yes checking for __int64... no checking for long long... yes checking for char... yes checking size of char... 1 checking for short... yes checking size of short... 2 checking for int... yes checking size of int... 4 checking for long... (cached) yes checking size of long... (cached) 8 checking for void *... yes checking size of void *... 8 checking for size_t... (cached) yes checking size of size_t... 8 checking for ssize_t... (cached) yes checking size of ssize_t... 8 checking for ptrdiff_t... (cached) yes checking size of ptrdiff_t... 8 checking for long long... (cached) yes checking size of long long... 8 checking for __int64... (cached) no checking size of __int64... 0 checking for ftruncate... yes checking for gettimeofday... yes checking for opendir... yes checking whether ln -s works... yes checking for rm... rm -f checking for mv... mv -f checking for lockfile... echo checking for bash... /bin/sh checking for rpmbuild... no checking for rpm... no checking for an ANSI C-conforming const... (cached) yes checking for inline... inline checking for python... no checking for perl... /amd64/usr/bin//perl checking for objc... no checking pthread.h usability... yes checking pthread.h presence... yes checking for pthread.h... yes checking semaphore.h usability... yes checking semaphore.h presence... yes checking for semaphore.h... yes checking sched.h usability... yes checking sched.h presence... yes checking for sched.h... yes checking for sem_init in -lpthreadGC2... no checking for sem_init in -lpthreadGC1... no checking for sem_init in -lpthreadGC... no checking for sem_init in -lpthread... yes checking for pthread_sigmask in -lpthread... yes checking for pthread_kill_other_threads_np in -lpthread... no checking readline/readline.h usability... yes checking readline/readline.h presence... yes checking for readline/readline.h... yes checking for readline in -lreadline... yes checking for rl_completion_matches in -lreadline... yes checking for SSL_read in -lssl... no checking for ERR_get_error in -lcrypto... no checking for dlopen in -ldl... yes checking for malloc in -lmalloc... no checking for mallopt... yes checking for mallinfo... yes checking for gethostbyname_r... yes checking for setsockopt... yes checking for SOCKET... no checking for socklen_t... yes checking for libz... auto checking for libbz2... auto checking for getopt_long... yes checking libperfctr.h usability... no checking libperfctr.h presence... no checking for libperfctr.h... no checking libpperf.h usability... no checking libpperf.h presence... no checking for libpperf.h... no checking pcl.h usability... no checking pcl.h presence... no checking for pcl.h... no checking for pcre-config... no pcre-config not found; please use --with-pcre=<path> checking for pcre >= 4.5... no (without pcre-config to query the pcre version, we assume it's < 4.5) checking regex.h usability... yes checking regex.h presence... yes checking for regex.h... yes checking locale.h usability... yes checking locale.h presence... yes checking for locale.h... yes checking langinfo.h usability... yes checking langinfo.h presence... yes checking for langinfo.h... yes checking for nl_langinfo... yes checking for setlocale... yes checking iconv.h usability... yes checking iconv.h presence... yes checking for iconv.h... yes checking for iconv_t... yes checking for iconv in -liconv... no checking for libiconv in -liconv... no checking for iconv... yes checking for texi2html... no checking for latex2html... no checking for latex... no checking for pdflatex... no checking for dvips... no checking for fig2dev... no checking postscript option... eps checking /amd64/usr/bin//install -c --backup option... --backup=nil checking for php-config... no Cannot find php-config. Please use --with-php-config=PATH no checking for monetdb5-config... no checking whether gcc and cc understand -c and -o together... yes checking for unistd.h... (cached) yes checking for getopt.h... (cached) yes checking for getopt_long... (cached) yes checking stdbool.h usability... yes checking stdbool.h presence... yes checking for stdbool.h... yes checking for bool... no checking for stdint.h... (cached) yes checking for socklen_t... (cached) yes checking libgen.h usability... yes checking libgen.h presence... yes checking for libgen.h... yes checking for basename... yes checking for int... (cached) yes checking size of int... (cached) 4 checking for void *... (cached) yes checking size of void *... (cached) 8 checking if your compiler understands `__attribute__'... yes checking signal.h usability... yes checking signal.h presence... yes checking for signal.h... yes checking return type of signal handlers... (cached) void checking for strings.h... (cached) yes checking for strcasecmp... yes checking for xml2-config.64... no checking for xml2-64-config... no checking for xml2-config... /amd64/usr/bin/xml2-config checking for libxml/parser.h... yes checking for xmlParseDocument in -lxml2... yes checking libxml/SAX2.h usability... yes checking libxml/SAX2.h presence... yes checking for libxml/SAX2.h... yes configure: The following compiler options will be used to integrate the libxml2 XML parsing library: To find the libxml2 include files: -I/usr/include/libxml2 To find the libxml2 library: -L/amd64/usr/lib64 -L/usr/lib -lxml2 -lz -lpthread -lm SAX2 support: HAVE_SAX2=1 checking for string.h... (cached) yes checking for strdup... yes checking for strtok_r... yes checking time.h usability... yes checking time.h presence... yes checking for time.h... yes checking sys/time.h usability... yes checking sys/time.h presence... yes checking for sys/time.h... yes checking utime.h usability... yes checking utime.h presence... yes checking for utime.h... yes checking sys/utime.h usability... no checking sys/utime.h presence... no checking for sys/utime.h... no checking sys/times.h usability... yes checking sys/times.h presence... yes checking for sys/times.h... yes checking whether time.h and sys/time.h may both be included... (cached) yes checking whether struct tm is in sys/time.h or time.h... time.h checking for struct tm.tm_zone... no checking for tzname... yes checking whether utime accepts a null argument... yes checking for ftime... yes checking for times... yes checking for ctime_r... yes checking for localtime_r... yes checking ctime_r3... no configure: creating ./config.status config.status: creating Makefile config.status: creating MonetDB-XQuery.spec config.status: creating RunMapprove config.status: creating RunMapprove.bat config.status: creating RunMtest config.status: creating RunMtest.bat config.status: creating extra.mk config.status: creating rpm.mk config.status: creating compiler/Makefile config.status: creating conf/Makefile config.status: creating modules/Makefile config.status: creating runtime/Makefile config.status: creating runtime5/Makefile config.status: creating src/Makefile config.status: creating compiler/algebra/Makefile config.status: creating compiler/core/Makefile config.status: creating compiler/debug/Makefile config.status: creating compiler/include/Makefile config.status: creating compiler/mem/Makefile config.status: creating compiler/mil/Makefile config.status: creating compiler/parser/Makefile config.status: creating compiler/schema/Makefile config.status: creating compiler/semantics/Makefile config.status: creating compiler/sql/Makefile config.status: creating modules/pftijah/Makefile config.status: creating runtime/xrpc/Makefile config.status: creating src/tools/Makefile config.status: creating compiler/algebra/map/Makefile config.status: creating compiler/algebra/opt/Makefile config.status: creating compiler/algebra/prop/Makefile config.status: creating runtime/xrpc/admin/Makefile config.status: creating runtime/xrpc/export/Makefile config.status: creating pf_config.h config.status: pf_config.h is unchanged config.status: executing depfiles commands

2 1

[MonetDB-users] MonetDB Release Preparation
by Martin Kersten 29 May '07

29 May '07

Dear fellow MonetDB developers/users, we plan to have a new release of the MonetDB software family within the next two weeks, i.e., Feature Freeze: Friday Jun 01 2007 Release: Monday Jun 11 2007 This release cycle is used to reduce the component dependencies, such that we are better prepared to release individual components more frequently. A synopsis of what to expect: MonetDB 5 beta status is dropped and it becomes the sole back-end for the SQL front-end. SQL now supports Persistent Stored Modules. XQuery Update Facility has undergone a large series of stress tests to improve correctness, performance and robustness against concurrent updates. Many bug-fixes based on highly appreciated feedback from our user community. The priorities set for post-release actions as agreed upon by the development team are: shortterm:(summer) SQL GIS geometry model testing and release SQL/XML support development and release PF/SQL exploration (research focus) Skyserver demo website (target 2.7TB online demo) midterm: (fall) Remote SQL execution in a cluster setting SQL adaptive partitioning of large databases XQuery Algebra -> MIL compiler Date/time support in XQuery MonetDB Private BATs policy (kernel modification) lngterm: (fall/spring) XQuery Algebra -> MAL compiler public release of StreetTivo for collaborative media analysis Of course, as always, progress in each of these areas depend on availability of resources and their contribution to our research agenda. We are looking forward to messages from projects based on/exploitation of the MonetDB platform. We plan to add a section in the website to make this work more broadly visible. regards, Martin

1 0

Re: [MonetDB-users] Compile problems (CVS, Ubuntu 7.04) (Java Client JDBC Version)
by Ramon Nogueira 27 May '07

27 May '07

OK, actually going to use CVS, since that's probably easier. Just a point about compiling the Java client (which as far as I can tell, is required for install MonetDB4-server): it doesn't compile with the version of JDBC shipped in Sun JDK 6. Basically, the JDBC interfaces have been extended and so we get errors about 'class is not abstract and does not override method ...'. I fixed this the first time by adding stubs that just threw OperationNotSupportedException. Then it compiled. R. On 5/27/07, Ramon Nogueira <ramon.nogueira(a)gmail.com> wrote: > Hehe, ok I can't resist. Gonna try again with the install script and > the tricks to prevent downloading again and again. I have clean all > traces of MonetDB from my machine. If you can't provide a .deb, what > about a precompiled set of binaries for generic Linux, statically > linked with all dependencies. Its not pretty, but it would be easy for > the users. The problem with the rpms on my Ubuntu system is basically > that Debian uses a different versioning scheme for the shared > libraries (the ones I had problems with were libssl and libcrypto). > Couldn't you just statically link these in and then provide a simple > install script? Many, many people use Debian-based systems and it > would greatly improve coverage for MonetDB. I will do what I can to > help if this compile goes well. > > R. > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > Ramon, > > > > once you have time and bandwidth, could you please first remove any remains > > of MonetDB (sources, builddirs, anything installed in you chosen prefix of > > buildtools, MonetDB, clinerts, MonetDB4, pathfinder, etc.), > > and then try from scratch, again, the way you prefer to install MonetDB. > > Stop as soon as the first problem occurs (if any ;-)) and report it here. > > > > Unfortunaltely, we do not have (access to) any Debian and/or Ubuntu > > (anymore), hence, we cannot provide any .deb packages. > > > > Kind regards, > > > > Stefan > > > > > > On Sat, May 26, 2007 at 10:24:55AM +0200, Ramon Nogueira wrote: > > > Yup, first I tried installing from the "Super Source Tarball"; then > > > from `alien'ed rpm; then individual tarballs; the install script; then > > > CVS! The problem with the install script is that it downloads things > > > afresh each time and I really can't afford that (I am in South Africa > > > where unfortunately, we still need to think about bandwidth). Here is > > > the (different) error I get when I try to compile the pathfinder > > > source tarball from sourceforge (against CVS components): > > > > > > gcc -DHAVE_CONFIG_H -I. -I. -I.. -I. -I/usr/local/include/MonetDB > > > -I/usr/local/include/MonetDB/common -I/usr/local/include/MonetDB/gdk > > > -I/usr/local/include/MonetDB4 -I/usr/local/include/MonetDB4/monet > > > -I/usr/local/include/MonetDB4/plain > > > -I/usr/local/include/MonetDB4/contrib > > > -I/usr/local/include/MonetDB4/mapi > > > -I/usr/local/include/MonetDB4/calibrator -I/usr/include/libxml2 > > > -I../compiler/include -I./../compiler/include -DLIBPATHFINDER -O2 > > > -std=c99 -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 > > > -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations > > > -funroll-loops -frerun-cse-after-loop -frerun-loop-opt > > > -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH > > > -DIO_MAX=10240 -c pathfinder.c -fPIC -DPIC -o > > > .libs/lib_pathfinder_la-pathfinder.o > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx: > > > In function 'xquery_function_call': > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:3980: > > > error: expected ')' before 'LLFMT' > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417:34: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx: > > > In function 'xquery_prelude': > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: 'MT_init_lock' undeclared (first use in this function) > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: (Each undeclared identifier is reported only once > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5417: > > > error: for each function it appears in.) > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5418:32: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > /export/scratch0/monet/monet.GNU.64.64.d.14791/pathfinder/runtime/pathfinder.mx:5419:31: > > > error: macro "MT_init_lock" requires 2 arguments, but only 1 given > > > make[4]: *** [lib_pathfinder_la-pathfinder.lo] Error 1 > > > make[4]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[3]: *** [all-recursive] Error 1 > > > make[3]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[2]: *** [all] Error 2 > > > make[2]: Leaving directory > > > `/home/ramon/software/monetdb/pathfinder-0.16.2/runtime' > > > make[1]: *** [all-recursive] Error 1 > > > make[1]: Leaving directory `/home/ramon/software/monetdb/pathfinder-0.16.2' > > > make: *** [all] Error 2 > > > > > > > > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > Hi Ramon, > > > > > > > > On Sat, May 26, 2007 at 08:37:26AM +0200, Ramon Nogueira wrote: > > > > > Thanks for such a rapid response! > > > > > > > > welcome --- you were just "lucky" ;-) > > > > > > > > > I checked out the source from CVS (including buildtools, I forgot to > > > > > mention that) with the following command: > > > > > cvs -d:pserver:anonymous@monetdb.cvs.sourceforge.net:/cvsroot/monetdb > > > > > checkout (buildtools|MonetDB|MonetDB4|pathfinder}. > > > > > > > > looks good (well, I'm sure you also included clients, as you mentioned in > > > > your first email). > > > > > > > > > I'm not too savvy wrt CVS, so not sure if this represents the latest code. > > > > > > > > It is --- well, provided SourceForge does not run the anonymous pserver > > > > access on backup server that run behind (again), but even then the > > > > conpilation should work fine ... > > > > > > > > > For calling configure, I did not specify any other command line > > > > > parameters (just ./configure). I created separate build directories > > > > > build/MonetDB, build/pathfinder... and issued the ./configure and make > > > > > commands in those directories after doing ./bootstrap in the source > > > > > directories. I also tries following the instructions in the file > > > > > pathfinder/INSTALL which instructed me to do the configure/make in the > > > > > same directory as the source with the same error. > > > > > > > > sounds just right --- hence, I'm puzzled; I have no idea, yet(?), what > > > > causes this problem (i.e., where the bogus path > > > > /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/ > > > > come from... > > > > > > > > Do you by any chance have a previous source (CVS or tarball) or binary (RPM) > > > > installation of MonetDB on your machine? Possibly even the remains of an > > > > uncomplete/aborted/failed RPM installation? > > > > > > > > Stefan > > > > > > > > > > > > > On 5/26/07, Stefan Manegold <Stefan.Manegold(a)cwi.nl> wrote: > > > > > > Hi Ramon, > > > > > > > > > > > > thank you very much for using MonetDB, and sorry for the inconvenience with > > > > > > compiling pathfinder. > > > > > > > > > > > > The error looks indeed strange. Actually it make me wonder whether you > > > > > > indeed (try to) compile the CVS code base (and if so which one, the latest > > > > > > HEAD or some release branch?) or whether you are using the source tarballs? > > > > > > Of course, `bootstrap` is only required for the CVS version, but you do not > > > > > > mention buildtools, which is also required (only) for the CVS version. > > > > > > The requested but not found path > > > > > > (/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la) > > > > > > is (as far as I can see) not contained in our CVS source base (except from > > > > > > some testing stable output), but *might* be in the source tarballs (though > > > > > > it should be ignored there. > > > > > > > > > > > > To analyse the problem further could you please send us the complete > > > > > > commandlines of you `configure` call for buildtools, MonetDB, clients, > > > > > > MonetDB4 & pathfinder? > > > > > > > > > > > > Kind regards > > > > > > > > > > > > Stefan > > > > > > > > > > > > > > > > > > On Sat, May 26, 2007 at 07:58:05AM +0200, Ramon Nogueira wrote: > > > > > > > Hi, > > > > > > > > > > > > > > Trying to install MonetDB4 and pathfinder from CVS. I succeeded in > > > > > > > compiling and installing (into /usr/local) MonetDB, client and > > > > > > > MonetDB4 modules. `bootstrap' and `configure' both succeed from > > > > > > > pathfinder, but `make' produces the following error. Also, on another > > > > > > > note, I think it should be made clearer that installation of `client' > > > > > > > is a prerequisite for MonetDB4 server since this is quite a > > > > > > > counterintuitive order of dependency (server on client). I am on Linux > > > > > > > 2.6.20-15-generic i686 GNU/Linux. > > > > > > > > > > > > > > Output from `make': > > > > > > > --------------------------------------------------------------------------- > > > > > > > (cd .libs && rm -f libpf.la && ln -s ../libpf.la libpf.la) > > > > > > > /bin/bash ../libtool --tag=CC --mode=link gcc -DLIBPF_SUPPORT -g > > > > > > > -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration > > > > > > > -Werror -Wpointer-arith -Wdeclaration-after-statement > > > > > > > -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH > > > > > > > -DIO_MAX=10240 -o lib_pf_support.la -rpath > > > > > > > /usr/local/lib/MonetDB4/lib lib_pf_support_la-pf_support.glue.lo > > > > > > > lib_pf_support_la-pf_support.lo lib_pf_support_la-staircasejoin.lo > > > > > > > lib_pf_support_la-prec_foll.lo lib_pf_support_la-shredder.lo > > > > > > > libserialize.la libpf.la -lxml2 -L/usr/lib -lxml2 -ldl > > > > > > > -L/usr/local/lib -lbat -lstream -L/usr/local/lib -lmonet -lpthread > > > > > > > -L/usr/local/lib/MonetDB4/lib -l_lock -l_monettime -l_streams > > > > > > > -l_builtin -l_ascii_io -l_algebra -l_constant > > > > > > > gcc -shared .libs/lib_pf_support_la-pf_support.glue.o > > > > > > > .libs/lib_pf_support_la-pf_support.o > > > > > > > .libs/lib_pf_support_la-staircasejoin.o > > > > > > > .libs/lib_pf_support_la-prec_foll.o .libs/lib_pf_support_la-shredder.o > > > > > > > -Wl,--whole-archive ./.libs/libserialize.a ./.libs/libpf.a > > > > > > > -Wl,--no-whole-archive -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib > > > > > > > -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -L/usr/lib > > > > > > > /usr/lib/libxml2.so -ldl -L/usr/local/lib /usr/lib/libbat.so > > > > > > > /usr/lib/libstream.so /usr/lib/libmonet.so -lpthread > > > > > > > -L/usr/local/lib/MonetDB4/lib /usr/local/lib/MonetDB4/lib/lib_lock.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_monettime.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_streams.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_builtin.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_ascii_io.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_algebra.so > > > > > > > /usr/local/lib/MonetDB4/lib/lib_constant.so -Wl,-soname > > > > > > > -Wl,lib_pf_support.so.0 -o .libs/lib_pf_support.so.0.0.0 > > > > > > > (cd .libs && rm -f lib_pf_support.so.0 && ln -s > > > > > > > lib_pf_support.so.0.0.0 lib_pf_support.so.0) > > > > > > > (cd .libs && rm -f lib_pf_support.so && ln -s lib_pf_support.so.0.0.0 > > > > > > > lib_pf_support.so) > > > > > > > creating lib_pf_support.la > > > > > > > /bin/sed: can't read > > > > > > > /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la: > > > > > > > No such file or directory > > > > > > > libtool: link: `/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la' > > > > > > > is not a valid libtool archive > > > > > > > make[2]: *** [lib_pf_support.la] Error 1 > > > > > > > make[2]: *** Deleting file `lib_pf_support.la' > > > > > > > make[2]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder/runtime' > > > > > > > make[1]: *** [all-recursive] Error 1 > > > > > > > make[1]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder' > > > > > > > make: *** [all] Error 2 > > > > > > > > > > > > > > ----------------------------------------------------------------------------- > > > > > > > > > > > > > > Your help is greatly appreciated. > > > > > > > > > > > > > > Ramon Nogueira > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > > > This SF.net email is sponsored by DB2 Express > > > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > > > http://sourceforge.net/powerbar/db2/ > > > > > > > _______________________________________________ > > > > > > > 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 | > > > > > > > > > > > > > > > > ------------------------------------------------------------------------- > > > > > This SF.net email is sponsored by DB2 Express > > > > > Download DB2 Express C - the FREE version of DB2 express and take > > > > > control of your XML. No limits. Just data. Click to get it now. > > > > > http://sourceforge.net/powerbar/db2/ > > > > > _______________________________________________ > > > > > 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 | > > > > > > > > > > ------------------------------------------------------------------------- > > > This SF.net email is sponsored by DB2 Express > > > Download DB2 Express C - the FREE version of DB2 express and take > > > control of your XML. No limits. Just data. Click to get it now. > > > http://sourceforge.net/powerbar/db2/ > > > _______________________________________________ > > > 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 3

[MonetDB-users] Compile problems (CVS, Ubuntu 7.04)
by Ramon Nogueira 27 May '07

27 May '07

Hi, Trying to install MonetDB4 and pathfinder from CVS. I succeeded in compiling and installing (into /usr/local) MonetDB, client and MonetDB4 modules. `bootstrap' and `configure' both succeed from pathfinder, but `make' produces the following error. Also, on another note, I think it should be made clearer that installation of `client' is a prerequisite for MonetDB4 server since this is quite a counterintuitive order of dependency (server on client). I am on Linux 2.6.20-15-generic i686 GNU/Linux. Output from `make': --------------------------------------------------------------------------- (cd .libs && rm -f libpf.la && ln -s ../libpf.la libpf.la) /bin/bash ../libtool --tag=CC --mode=link gcc -DLIBPF_SUPPORT -g -O2 -Wall -Wextra -std=c99 -Werror-implicit-function-declaration -Werror -Wpointer-arith -Wdeclaration-after-statement -Wno-declaration-after-statement -DEMBEDDED -DMT -DNO_CGI -DNO_AUTH -DIO_MAX=10240 -o lib_pf_support.la -rpath /usr/local/lib/MonetDB4/lib lib_pf_support_la-pf_support.glue.lo lib_pf_support_la-pf_support.lo lib_pf_support_la-staircasejoin.lo lib_pf_support_la-prec_foll.lo lib_pf_support_la-shredder.lo libserialize.la libpf.la -lxml2 -L/usr/lib -lxml2 -ldl -L/usr/local/lib -lbat -lstream -L/usr/local/lib -lmonet -lpthread -L/usr/local/lib/MonetDB4/lib -l_lock -l_monettime -l_streams -l_builtin -l_ascii_io -l_algebra -l_constant gcc -shared .libs/lib_pf_support_la-pf_support.glue.o .libs/lib_pf_support_la-pf_support.o .libs/lib_pf_support_la-staircasejoin.o .libs/lib_pf_support_la-prec_foll.o .libs/lib_pf_support_la-shredder.o -Wl,--whole-archive ./.libs/libserialize.a ./.libs/libpf.a -Wl,--no-whole-archive -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -Wl,--rpath -Wl,/usr/local/lib/MonetDB4/lib -L/usr/lib /usr/lib/libxml2.so -ldl -L/usr/local/lib /usr/lib/libbat.so /usr/lib/libstream.so /usr/lib/libmonet.so -lpthread -L/usr/local/lib/MonetDB4/lib /usr/local/lib/MonetDB4/lib/lib_lock.so /usr/local/lib/MonetDB4/lib/lib_monettime.so /usr/local/lib/MonetDB4/lib/lib_streams.so /usr/local/lib/MonetDB4/lib/lib_builtin.so /usr/local/lib/MonetDB4/lib/lib_ascii_io.so /usr/local/lib/MonetDB4/lib/lib_algebra.so /usr/local/lib/MonetDB4/lib/lib_constant.so -Wl,-soname -Wl,lib_pf_support.so.0 -o .libs/lib_pf_support.so.0.0.0 (cd .libs && rm -f lib_pf_support.so.0 && ln -s lib_pf_support.so.0.0.0 lib_pf_support.so.0) (cd .libs && rm -f lib_pf_support.so && ln -s lib_pf_support.so.0.0.0 lib_pf_support.so) creating lib_pf_support.la /bin/sed: can't read /export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la: No such file or directory libtool: link: `/export/scratch1/monet/monet.GNU.32.32.d.14791/MonetDB/.GNU.32.32.d-Fedora6/lib/libbat.la' is not a valid libtool archive make[2]: *** [lib_pf_support.la] Error 1 make[2]: *** Deleting file `lib_pf_support.la' make[2]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder/runtime' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/ramon/software/monetdb/cvs/pathfinder' make: *** [all] Error 2 ----------------------------------------------------------------------------- Your help is greatly appreciated. Ramon Nogueira

4 11

[MonetDB-users] MonetDB shows error after graceful stop
by Venks 25 May '07

25 May '07

Hi, I am using the following commands to START and STOP the MonetDB database. monetdb --start --dbname=test --dbinit='include sql;' monetbd --stop After I STOP the monetdb server I am getting the following messages in my console. Sometimes these messages repeat few times. ========================================================= /root/MonetDB070524/bin/mguardian: line 131: [: /dev/mapper/VolGroup00-LogVol00 43: integer expression expected /root/MonetDB070524/bin/mguardian: line 195: mserver5: command not found ========================================================== What are these messages? Do they represent an error in my set up? Or is this a some bug in MonetDB? Please look into it. Thanks, - Venks

3 2

[MonetDB-users] monetdb-install.sh not working
by Venks 25 May '07

25 May '07

Folks, I tried to executed the all-in-one script "monetdb-install.sh" and it's not working. I installed it last week few times without any error. Please look into this issue. Thanks, PS: Below is the excerpt from the log file. ======================================================= Connecting to www.ins.cwi.nl[192.16.196.21]:80... connected. HTTP request sent, awaiting response... Please refer to the full log at /var/tmp/MonetDB-1179870979/log If you believe this is an error in the script or the software, Tue May 22 17:56:20 EDT 2007 The following tools might be relevant to debug your problem: : 1.12 $ 403 Forbidden 17:56:20 ERROR 403: Forbidden. fetching http://www.ins.cwi.nl/~fabian/monetdb/tars/latest/current/MonetDB.tar.gz failed! file a bug and attach the logfile. autoconf (GNU Autoconf) 2.59 Written by David J. MacKenzie and Akim Demaille. =======================================================

6 10

Re: [MonetDB-users] Unable to connect to MonetDB
by Colin Foss 25 May '07

25 May '07

Venks, That is a good question and I didn't send the resolution to the general list. The strange behavior was that local connections were ok and remote connections would block all subsequent connections (local or remote) until I killed the remote MapiClient. I think there is something wrong with the "release" version when compiled from the script. After I used --nightly=stable or --nightly=current I was able to connect. I had mapi_open=true with all three versions. I was going to recompile with --nightly=current today, now that all is well again with www.ins.cwi.nl and I'll let you know my results. ~~>Colin --- Venks <venkatesh.mantha(a)gmail.com> wrote: > Colin, > > Was your issue regarding connecting from other > clients > (mapi_open=true) resolved? > > I installed the latest build this morning and now I > am unable to > connect from other clients. > > Thanks, > > - Venks >

1 0

[MonetDB-users] MonetDb-XQuery problem
by Maarten Clements 25 May '07

25 May '07

Using the following XQuery in MonetDb (WinXP) crashes on large documents (when C1 and C2 are small it works ok): > <col> { > for $b in doc("C1.xml")/collection/doc > for $top in doc("C2.xml")/collection/doc > where ($b/year > 1950) and ($b/title = $top/title) > return > <movie> > {$b/year} > </movie> > } </col> If I remove one of the two conditions it works perfectly, e.g.: > <col> { > for $b in doc("C1.xml")/collection/doc > for $top in doc("C2.xml")/collection/doc > where ($b/title = $top/title) > return > <movie> > {$b/year} > </movie> > } </col> Can anyone explain this problem? ______________________________ Maarten Clements

3 5

[MonetDB-users] copy into with primary key errors
by Colin Foss 24 May '07

24 May '07

I've been trying to bulk load a large set of data into a table with a compound primary key. Every time the copy into fails on the second file with an error about an "invalid input type". Even if I comment out the suspect file, the third file with have the same error. If I repeat the load and comment out the first file, then the third file will have the "invalid input type" error. Has anyone been able to use COPY INTO with a compound primary key and multiple files?

1 1

[MonetDB-users] Cannot connect to MonetDB via ODBC from PowerBuilder
by Franco Guidoli 24 May '07

24 May '07

Hi all: I'm trying to connect to MonetDB via ODBC from PowerBuilder, but during connection it gets into a "loop" (that's what I think after viewing the ODBC driver log which I'm sending now). Thanks in advance. Franco http://www.nabble.com/file/p10774553/odbcdebug.log odbcdebug.log -- View this message in context: http://www.nabble.com/Cannot-connect-to-MonetDB-via-ODBC-from-PowerBuilder-… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] latest build startup error
by Colin Foss 23 May '07

23 May '07

After building with "monetdb-install.sh --enable-sql", The default .mserver5.dbinit contains: include sql;sql.start(); the "sql.start();" command triggers an error found in mserver5.log in the dbfarm. == mserver5.log: START 2007-05-17 08:13:02 #include sql; sql.start(); # function user.main():void; # 0 (main:void) #command startQuery(s:str):void # 1 (_1:str) #address SQLstartQuery # 2 (_2:str) #comment "Initialize tracing query performance"; # 3 (_3:str) #command exitQuery(s:str):void # 4 (_4:str) #address SQLexitQuery # 5 (_5:str) #comment "Finalize tracing query performance"; # 6 (_6:str) #command dec_round( v:sht, r:dbl ) :sht # 7 (_7:str) #address sht_dbl_dec_round_wrap # 8 (_8:str) #comment "round off the value v to nearests multiple of r"; # 9 (_9:str) #command dec_round( v:sht, r:int ) :sht # 10 (_10:str) #address sht_int_dec_round_wrap # 11 (_11:str) #comment "round off the value v to nearests multiple of r"; # 12 (_9:str) #command dec_round( v:int, r:dbl ) :int # 13 (_12:str) #address int_dbl_dec_round_wrap # 14 (_13:str) #comment "round off the value v to nearests multiple of r"; # 15 (_9:str) #command dec_round( v:int, r:int ) :int # 16 (_14:str) #address int_int_dec_round_wrap # 17 (_15:str) #comment "round off the value v to nearests multiple of r"; # 18 (_9:str) #command dec_round( v:lng, r:dbl ) :lng # 19 (_16:str) #address lng_dbl_dec_round_wrap # 20 (_17:str) #comment "round off the value v to nearests multiple of r"; # 21 (_9:str) #command dec_round( v:lng, r:int ) :lng # 22 (_18:str) #address lng_int_dec_round_wrap # 23 (_19:str) #comment "round off the value v to nearests multiple of r"; # 24 (_9:str) #command dec_round( v:flt, r:int ) :flt # 25 (_20:str) #address flt_int_dec_round_wrap # 26 (_21:str) #comment "round off the value v to nearests multiple of r"; # 27 (_9:str) #command dec_round( v:dbl, r:int ) :dbl # 28 (_22:str) #address dbl_int_dec_round_wrap # 29 (_23:str) #comment "round off the value v to nearests multiple of r"; # 30 (_9:str) #address CALCstr2sht # 31 (_24:str) #command calc.str( v:sht ) :str # 32 (_25:str) #address CALCsht2str # 33 (_26:str) #comment "Cast sht to str"; # 34 (_27:str) #address CALCstr2int # 35 (_28:str) #command calc.str( v:int ) :str # 36 (_29:str) #address CALCint2str # 37 (_30:str) #comment "Cast int to str"; # 38 (_31:str) #address CALCstr2lng # 39 (_32:str) #command calc.str( v:lng ) :str # 40 (_33:str) #address CALClng2str # 41 (_34:str) #comment "Cast lng to str"; # 42 (_35:str) #command calc.str( v:any_1, digits:int ) :str # 43 (_36:str) #address CALCflt2sht # 44 (_37:str) #address CALCflt2int # 45 (_38:str) #address CALCflt2lng # 46 (_39:str) #address CALCdbl2sht # 47 (_40:str) #address CALCdbl2int # 48 (_41:str) #address CALCdbl2lng # 49 (_42:str) #address CALCsht2sht # 50 (_43:str) #address CALCint2sht # 51 (_44:str) #address CALClng2sht # 52 (_45:str) #address CALCsht2int # 53 (_46:str) #address CALCint2int # 54 (_47:str) #address CALClng2int # 55 (_48:str) #address CALCsht2lng # 56 (_49:str) #address CALCint2lng # 57 (_50:str) #address CALClng2lng # 58 (_51:str) #address CALCsht2flt # 59 (_52:str) #address CALCint2flt # 60 (_53:str) #address CALClng2flt # 61 (_54:str) #address CALCsht2dbl # 62 (_55:str) #address CALCint2dbl # 63 (_56:str) #address CALClng2dbl # 64 (_57:str) sql.prelude(); # 65 SQLprelude (_58:void) sql.start(); # 66 SQLsession (_59:void) end main; # 67 !syntax error, unexpected IDENT in: "include" I'm not sure if this is a bug in the monetdb script or mserver5 itself.

2 2

[MonetDB-users] website community links
by Colin Foss 22 May '07

22 May '07

I'd like to make a suggestion for the community webpage of http://monetdb.cwi.nl, please add a link to the sourceforge tracker (http://sourceforge.net/tracker/?group_id=56967)

2 1

[MonetDB-users] Creative Suite 3 Design ready to download
by Colby Sizemore 22 May '07

22 May '07

By treesor might see as the masonrySeems reflected in the infinite of the lamps.I might have happily lived some other childhood.and the numbed yards will go back undercover.From point to point of meaningopen? closed?Wind, sleet. The branches sway,But what I am looking at is hardened snow,they sit with their wives all day in the sun,At San Biagio, in the most intense roomGray the cloud-like oaksA frame of glided twilightIGiven by nature will soak into it.Again awaken from your being gone to findAs if your human shape were what the stormShe stretches a hand toward the toothy sleeperDim, and die tonight?Your gloved hands covering your lips' good-byeCoextensive with everything? How could they know?The flakes which have stolen onto the flagstones

1 0

[MonetDB-users] monetdb roadmap
by Colin Foss 21 May '07

21 May '07

Anyone have insight into when 2.18 will be released? http://monetdb.cwi.nl/projects/monetdb/Development/Roadmap/index.html

1 0

[MonetDB-users] other than to quit smoking.
by Odette Spears 21 May '07

21 May '07

GPSI Announces Market Attack Into $1 Trillion Market! Global Payment Solutions Symbol: GPSI Price: $0.03 GPSI announced its plans to address the huge influx of immigrant workers into the US that need banking solutions that they otherwise would not qualify for. This market is expected to represent over $1 Trillion dollars to be managed by 2008. GPSI provides viable solutions to this market. This is hot, read the news and watch for more Monday! Get on GPSI first thing Monday! The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking. The obvious step forward is to attempt to greatly extend healthy life spans in mice by preventing mitochondrial damage, repairing it as it occurs, or making it irrelevant. " Projects like this demonstrate that real progress has been made in stem cell basics. other than to quit smoking.

1 0

[MonetDB-users] Syntax in Query causes a Server Crash - Critical
by Venks 21 May '07

21 May '07

Hi, The following query has a syntax issue. But instead of reporting the syntax error, the server crashes. select count(*) from (select col2, count(*) as row_count from data_1to10 group by col2 order by row_count desc, col1) sq I have attached a PERL script which can be used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> You will need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

2 1

[MonetDB-users] M5 SQL load data with "copy into" behaviour and 32 bits limitation
by Franco Guidoli 20 May '07

20 May '07

Hi all: I'm testing MonetDB5 to know if it's suitable for an OLAP project. I have to load a bit more than 11.5 million rows into one table, and I get the following results (I'm working on a Windows 2000 Professional 32 bits box with 1GB RAM and Monet v5.0.0_beta1_2): - when I try to load all the data in a single "copy into", mserver crashes at a certain point. - when I try to load the data in 100K chunks with several "copy into" into the same sql session, the server crashes at 7.8 million rows, and when I try to load the rest of the data it gets loaded, but the first 7.8 million rows get corrupt and the rest get ok. - when I load the data in 100K chunks in 5 different times (2.6 million rows each time) everything gets ok; after every 2.6 million I disconnect from sql client and shutdown the server, so when I restart the server and connect from sql client all the logs get persistent (thanks to Niels Nes to explain simply that logs get persistent after a server restart and when a sql session starts). So, initially I thought that MonetDB couldn't load that amount of data in a 32 bits box, but after all it can, because at last the data was successfully loaded. Is there a limitation with the "copy into"? Is there a way to achieve this process without restarting the server and sql sessions? I've read some threads about 32 bits limitation, but I don't know for sure how to calculate the maximum rows I can have into a single table. In my case, the table has a 147 bytes length using the following sizes in data types: smallint --> 2 bytes int --> 4 bytes char(2) --> 2 bytes the limitation would be 2GB / 147 bytes --> 14.608.732 rows ? I've assumed this after what I've read, but please let me know if I'm doing a wrong calculation. Thanks in advance, Franco -- View this message in context: http://www.nabble.com/M5-SQL-load-data-with-%22copy-into%22-behaviour-and-3… Sent from the monetdb-users mailing list archive at Nabble.com.

3 2

[MonetDB-users] latest build cannot connect from remote client
by Colin Foss 17 May '07

17 May '07

I installed MonetDB5 using monetdb-install.sh. I d/l'ed the script today. The binaries compiled fine but I am unable to connect from a different computer besides the host. i.e. mserver5 running on serverA, client running on desktopB. desktopB> MapiClient -l sql -h serverA -umonetdb MapiClient never returns. In another window I ran netstat and can see the connection from desktopB to serverA on the correct port (50000). Using 'telnet serverA 50000' I can see mserver5 responding with: 46:avuaOb0v:mserver:7:SHA1,MD5,crypt,plain:3412 Any ideas?

3 4

[MonetDB-users] Query Bug
by Venks 16 May '07

16 May '07

Hi, The following query works for the first time: WITH t AS ( SELECT * FROM tables ) SELECT * FROM t If I execute the query again, it gives the following error: Variable 't' allready declared If I change the alias from "t" to "t2" it works for the first time and then gives the error on second execution. Please look into this and correct this bug. Thanks, - Venkatesh

1 0

[MonetDB-users] GDK Error on a query joining non-key columns
by Venks 16 May '07

16 May '07

Hi, I get the following error: MALException:algebra.join:GDKerror ERROR: GDKload failed: name=02/45/24557, ext=buns.priv while executing the following query: select count(*) from ( select 1 from data_1to10 a, data_10to20 b where a.col2 = b.col2 ) sq I have attached a PERL script which is used to generate the required data for testing. I have also attached a table definition script and the load script. Please use the attached PERL script to generate the data as follows: ./massrecs.pl > <filename> After generating the first file, you will need to update the PERL script to change the numbers in the for loop, so that the next 20 million rows from 10,000,001 to 20,000,000 are generated. You will also need to edit the "test_load_tables.sql" script to update the filename according to the name given. Please let me know if you are unable to execute the test for any reason. Thanks, - Venkatesh

1 0

[MonetDB-users] XRPC problem: too many parameters
by Makoto YUI 16 May '07

16 May '07

Hi, I caught an error (see attached file) at the remote method invocation of XRPC. While I'm not sure whether my query is correct or not, is there imitation of parameters in XRPC? The query and dataset used in the evaluation are put on here. http://db-www.naist.jp/~makoto-y/tmp/xrpc.tgz Thanks, Makoto YUI MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. MAPI = monetdb@localhost:50000 QUERY = import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit ERROR = !ERROR: doLoopLiftedRPC: execution failed at all destinations mapi_query_part:1705:import module namespace test = "xrpc-test-function" at "/usr/share/MonetDB/xrpc/export/xrpc-mod.xq"; (: local database :) declare variable $blast-gb := fn:doc("blast-gb.xml")/result; declare variable $blast-uniprot := fn:doc("blast-uniprot.xml")/result; (: remote basebase :) declare variable $remote-endpoint := "xanadu.naist.jp"; let $gb_entry := (for $e in $blast-gb/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e), $uniprot_entry := (for $e in $blast-uniprot/BlastOutput let $hit := $e/BlastOutput_iterations/Iteration/Iteration_hits/Hit where $hit/Hit_num = 1 and $hit/Hit_hsps/Hsp/Hsp_evalue/text() <= 1.0e-8 return $e) where $gb_entry/BlastOutput_query-def/text() = $uniprot_entry/BlastOutput_query-def/text() return <result> { let $gb-hit := $gb_entry/BlastOutput_iterations/Iteration/Iteration_hits/Hit, $gb-key := $gb-hit/Hit_gb/text() return let $genbank-remote-entries := execute at {$remote-endpoint} { test:q1($gb-key) } for $remote_entry at $pos in $genbank-remote-entries let $gb_definition := $remote_entry/INSDSeq_definition, $gb_feature := $remote_entry/INSDSeq_feature-table/INSDFeature, $blast_evalue := $gb-hit[Hit_gb/text() = $remote_entry/INSDSeq_accession-version/text()]/Hit_hsps/Hsp/Hsp_evalue return <genbank num="{ $pos }">{ $blast_evalue, $gb_definition, $gb_feature } </genbank> } </result> fetch next block: start at:2 got next block: length:269 text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations got complete block: text:XRPC_Client_Serialisation: 626 microsec !WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:XRPC_Client_Serialisation: 626 microsec allocating new result set XRPC_Client_Serialisation: 626 microsec got complete block: text:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" !ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!WARNING: doLoopLiftedRPC: error occurred during RPC call to "xanadu.naist.jp" allocating new result set got complete block: text:!ERROR: CMDhttp_post: too many parameters. !ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: too many parameters. got complete block: text:!ERROR: CMDhttp_post: operation failed. !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: CMDhttp_post: operation failed. got complete block: text: !ERROR: doLoopLiftedRPC: execution failed at all destinations read_line: closing result set got complete block: text:!ERROR: doLoopLiftedRPC: execution failed at all destinations read_line:!ERROR: doLoopLiftedRPC: execution failed at all destinations allocating new result set fetch next block: start at:271 got next block: length:0 text: got complete block: text: read_line: closing result set closing result set Timer 1014.527 msec

1 0

[MonetDB-users] Persistent Stored Modules in MonetDB
by Venks 15 May '07

15 May '07

Is there any other documentation that I can get my hands on for understanding all the supported syntax for Persistent Stored Modules? The reference manual has nothing much and the examples as part of the MonetDB install are few. I am trying to find all the 4GL syntax that can be used while creating a persistent stored module. Thanks, - Venks

2 2

Re: [MonetDB-users] Cubulus OLAP tuning advice & first Monet benchmarks
by Martin Kersten 14 May '07

14 May '07

Would you be so kind to provide a "superball" ? MonetDB5-server in http://monetdb.cwi.nl/testing/projects/monetdb/Current/.DailyBuilds./ 0_latest/SourceTarBalls/ cannot be built on it's own.. In addition, on the Mac there is builtin readline (NetBSD: readline.h,v 1.11 2004/01/17) , and mclient does not use it. Headers: #include <readline/readline.h>, #include <readline/history.h> Libs: /usr/lib/libreadline.dylib Darwinports installed as dependency readline 5.0 : Headers: /opt/local/include/readline : chardefs.h history.h keymaps.h readline.h rlconf.h rlstdc.h rltypedefs.h tilde.h Libs: /opt/local/lib/libreadline.5.0.dylib /opt/local/lib/ libreadline.a /opt/local/lib/libreadline.5.dylib /opt/local/ lib/libreadline.dylib BR, Alex On May 13, 2007, at 9:21 PM, Martin Kersten wrote: > Hello, thanks to your report I was able to construct > a test case that uncovered an error in the decimal > conversion. I am not sure if this solves your > problem, but at least it avoids a series of errors. > > The problem occurred if you did not provide 4 decimal > digits. > > Added test decimal.SF-1718253 to BugTracker directory > > The updated version is in the head branch. > > Alexandru Toth wrote: >> Hello, >> Please advice on the rounding errors 73897488.0537 vs >> 74523898.6957. CREATE TABLE fact_cub ( >> figure decimal(10,4) DEFAULT NULL, >> dim_0 int DEFAULT NULL, >> dim_1 int DEFAULT NULL, >> dim_2 int DEFAULT NULL, >> dim_3 int DEFAULT NULL, >> dim_4 int DEFAULT NULL, >> dim_5 int DEFAULT NULL >> ) >> INSERT INTO fact_cub VALUES ('190.9420',4,49,39,17,3,2); >> INSERT INTO fact_cub VALUES ('998.9138',4,49,39,17,3,3); ...... >> As sanity check, the count(*) returns same number. >> sql>select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % sys.fact_cub # table_name >> % count_no_nil_figure # name >> % int # type >> % 6 # length >> [ 149406 ] >> Timer 1611.294 msec >> sql>select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> % ., sys.fact_cub # table_name >> % single_value, sum_figure # name >> % smallint, decimal # type >> % 1, 12 # length >> [ 0, *73897488.0537 * ] >> Timer 1842.599 msec >> mysql> select count( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +-----------------+ >> | count( figure ) | >> +-----------------+ >> | 149406 | >> +-----------------+ >> 1 row in set (13.59 sec) >> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 and >> dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and dim_1 >> <= 64; >> +---+---------------+ >> | 0 | sum( figure ) | >> +---+---------------+ >> | 0 | *74523898.6957* | >> +---+---------------+ >> 1 row in set (7.45 sec) >> BR, Alexandru >> On May 13, 2007, at 4:26 PM, Martin Kersten wrote: >>> Alexandru Toth wrote: >>>> Hello, >>>> Replacing 2 comparisons with between is not necessarily faster >>>> in databases other than Monet. Proof (same 7 million rows table): >>> >>> We looked at the plans and noticed that indeed the optimizer missed >>> a point. It has been checked in the current trend. >>>> mysql> select 0, sum( figure ) from fact_cub where dim_0 between >>>> 4 and 15 and dim_4 = 2 and dim_5 = 2 and dim_1 between 57 and 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (13.14 sec) >>>> mysql> select 0, sum( figure ) from fact_cub where 4 <= dim_0 >>>> and dim_0 <= 15 and dim_4 = 2 and dim_5 = 2 and 57 <= dim_1 and >>>> dim_1 <= 64; >>>> +---+---------------+ >>>> | 0 | sum( figure ) | >>>> +---+---------------+ >>>> | 0 | 74523898.6957 | >>>> +---+---------------+ >>>> 1 row in set (7.51 sec) >>>> Replacing 2 comparisons with one logic AND might be faster, but >>>> SQL is not as readable >>>> Cheers, Alexandru >

2 1

[MonetDB-users] you are the man
by Wilbur Hammer 13 May '07

13 May '07

students of all ages. I can see in the next generation how implies that companies will have greater flexibility in regards soldier in a white cravat turns a key to launch the counter is a process of creativity and satisfaction of discovering new exemplified in the global economic system: European Economic photography, has too much basis in reality. It is about the way avant-garde will continually rear its unusual head where it's reacting to feedback from their surroundings. The premise behind my language. We are always partaking in our society to one In theory, our voice boxes would become non functional in a few artificial life. Computer generated living beings live and their industry, replication is rampant, to a certain degree, and hallucinogenic narcotics available in the market. People will substitute for the drugs I've never done though overloads do Without this communication network we may be thrown back into the can still be accessed in the traditional way, it can hang on your And frighten myself with the thought of my little ones burning vital information on disk. Even in this class, so many people a fascist government will experience greater control and order by place in the world at a cost comparable to a postage stamp. any artificial intelligence is our resilience, damage caused to a drawing by hand.These quickly redrawn views however, only remain As an Interior Design student I have noted what computer programs effects is astounding. New methods and techniques arise daily as an attempt, no matter how noble or heroic, to secure our freedom. is the idea of general purpose simulation, and went on to explain maker and memory storer. The one great advantage we have over

1 0