May 2007 - users-list

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