- users-list - monetdb.org

Re: [MonetDB-users] PROBLEM WITH MONETDB 5.0
by Martin Kersten 03 Jun '08

03 Jun '08

tqtrung(a)comp.nus.edu.sg wrote: > Hi, > Thank you very much. I also guess the reason due to the size of the > operands. Currently, I am running on Linux Fedora Core 8, 32 bit. The > cardinality of the opearand s in the range 100,000 to 1,500,000 records. > the sizes themselves are not a problem, but the expected size of the join result could be. you could take a sample to see how it explodes (algebra.sample()) > Are there any other solutions if my machine could not play with those > queries. > Please help me to check it again. > > Thanks, > Trung > > > >> tqtrung(a)comp.nus.edu.sg wrote: >> >>> Dear all, >>> I am a PhD student at School of Computing, NUS, Singapore. Currently, I >>> used MonetDB as the DBMS to do some experiments. I issue a query with >>> about 10 joins, but the system responds with the following errors: >>> >>> >> Please inform us about the platform and distribution you are useing. >> >>> !MALException:algebra.join:GDKerror >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> >>> >> this typically is an error when the join algorithm can not allocated >> enough memory >> to hold the intermediate result. For example, on a 32-bit system this >> might cause >> a problem quickly. >> If the join result should fit in memory, then there might be a problem >> in the >> estimation of the intermediate size needed. For this we need more >> information, >> such as the cardinality of the operands and properties obtained by >> bat.info() >> >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=tail.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=tail.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=45/4542, ext=head.priv >>> !ERROR: GDKload: cannot mmap(): name=44/4401, ext=tail.priv >>> !OS: Cannot allocate memory >>> !ERROR: GDKload failed: name=44/4401, ext=tail.priv >>> >>> I also try to change the parameter in monetdb5.conf about the memory: >>> gdk_maxsize and gdk_vm_minsize but it still does NOT work. >>> >>> >> please don't play with these settings. They only control a thread for >> flushing dirty pages to disk. >> >>> Could you please help me to figure out which parameters I could change >>> to >>> make it work. >>> >>> Thank you very much >>> Trung >>> >>> >>> >> > >

1 0

Re: [MonetDB-users] PROBLEM WITH MONETDB 5.0
by Martin Kersten 03 Jun '08

03 Jun '08

tqtrung(a)comp.nus.edu.sg wrote: > Dear all, > I am a PhD student at School of Computing, NUS, Singapore. Currently, I > used MonetDB as the DBMS to do some experiments. I issue a query with > about 10 joins, but the system responds with the following errors: > Please inform us about the platform and distribution you are useing. > !MALException:algebra.join:GDKerror > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv > !OS: Cannot allocate memory > this typically is an error when the join algorithm can not allocated enough memory to hold the intermediate result. For example, on a 32-bit system this might cause a problem quickly. If the join result should fit in memory, then there might be a problem in the estimation of the intermediate size needed. For this we need more information, such as the cardinality of the operands and properties obtained by bat.info() > !ERROR: GDKload failed: name=45/4542, ext=head.priv > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=tail.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=45/4542, ext=tail.priv > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=45/4542, ext=head.priv > !ERROR: GDKload: cannot mmap(): name=45/4542, ext=head.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=45/4542, ext=head.priv > !ERROR: GDKload: cannot mmap(): name=44/4401, ext=tail.priv > !OS: Cannot allocate memory > !ERROR: GDKload failed: name=44/4401, ext=tail.priv > > I also try to change the parameter in monetdb5.conf about the memory: > gdk_maxsize and gdk_vm_minsize but it still does NOT work. > please don't play with these settings. They only control a thread for flushing dirty pages to disk. > Could you please help me to figure out which parameters I could change to > make it work. > > Thank you very much > Trung > >

1 0

[MonetDB-users] Is it possible getting types IN params or result set?
by Marc Weber 29 May '08

29 May '08

Hi, I'd like to work on embedding query statements into the haskell language by using template haskell to automatically derive insert and select functions having proper types automatically. sqli for Java already does it. resulting in something as: (rows :: [ (Int, String) ]) = $( select "SELECT intV, stringV FROM table") $( ) means a function is automatically created returning a list of tules of type (Int, String). Because haskell is strongly typed the function select creating the the type safe function must get to know which type the query will return. When using INSERT statements it would be nice to also now which type of parameters have to be passed. Does MonetDB provide kind of query function WhichInOutTypesDoesQueryHave("SELECT ..") or WhichInOutTypesDoesQueryHave("INSERT INTO FOO (abc,def) VALUES (?,?)") This way syntax and semantics could be checked at compile time. Sincerly Marc Weber

3 5

[MonetDB-users] /bin/bash: ../Mx/Mx: No such file or directory
by Ying Zhang 28 May '08

28 May '08

Dear all, I'm trying to compile monet on my laptop But I already get a problem when I 'make' in buildtools: ../Mx/Mx -x C /home/jennie/monet/current/buildtools/mel/any_arg.mx /bin/bash: ../Mx/Mx: No such file or directory The directory Mx indeed contains too few files, but 'make' in Mx seems doing nothing: $ cd ../Mx $ ls config.log config.status Makefile mx_config.h stamp-h1 $ make make all-am make[1]: Entering directory `/home/jennie/scratch/monet-build/current/buildtools/build-debug/Mx' make[1]: Nothing to be done for `all-am'. make[1]: Leaving directory `/home/jennie/scratch/monet-build/current/buildtools/build-debug/Mx' $ ls config.log config.status Makefile mx_config.h stamp-h1 Sys. info: $ uname -a Linux 2.6.22-14-generic #1 SMP Tue Feb 12 07:42:25 UTC 2008 i686 GNU/Linux I did: bootstrap && configure && make && make install with the configure options: --prefix=$INSTALL_DIR --enable-strict --enable-assert --enable-debug --disable-optimize Does anyone have an idea why Mx is not generated by 'make'? Thanks! Jennie

2 1

Re: [MonetDB-users] (no subject)
by Martin Kersten 27 May '08

27 May '08

Yeo Yvonne wrote: > Dear Sir, > > I would like to find out more about MONETDB and the diffenerces > betwwen ORacle and MONETBD? Dear Yeo This is a question of comparing apples and oranges ;) There is no document available to compare the systems. Please have a look at the introductionary sections of the MonetDB manual. The rest is a study by itself. regards, Martin > > Thanks. > > With Regards, > Yvonne Yeo. >

3 2

[MonetDB-users] fedora core 9 repo or rpms?
by mobiledreamers＠gmail.com 23 May '08

23 May '08

Please share fc9 repos or how do we install monetdb in fc9 sudo yum -c /tmp/MonetDB-Stable-Fedora.repo resolvedep http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./0_lates…: [Errno 14] HTTP Error 404: Not Found Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: MonetDB-Stable. Please verify its path and try again *Forcing to use the 8 repo in 9 gives these errors* sudo yum -c /tmp/MonetDB-Release-Fedora.repo install MonetDB5-server MonetDB MonetDB-SQL-server5 Setting up Install Process Parsing package install arguments Resolving Dependencies --> Running transaction check ---> Package MonetDB.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB --> Processing Dependency: libcrypto.so.6 for package: MonetDB ---> Package MonetDB5-server.i386 0:5.4.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB5-server --> Processing Dependency: MonetDB-client >= 1.22 for package: MonetDB5-server --> Processing Dependency: libcrypto.so.6 for package: MonetDB5-server --> Processing Dependency: libMapi.so.0 for package: MonetDB5-server ---> Package MonetDB-SQL-server5.i386 0:2.22.0-1.fc8.oid32 set to be updated --> Running transaction check ---> Package MonetDB-client.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB-client --> Processing Dependency: libcrypto.so.6 for package: MonetDB-client ---> Package MonetDB.i386 0:1.22.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB --> Processing Dependency: libcrypto.so.6 for package: MonetDB ---> Package MonetDB5-server.i386 0:5.4.0-1.fc8.oid32 set to be updated --> Processing Dependency: libssl.so.6 for package: MonetDB5-server --> Processing Dependency: libcrypto.so.6 for package: MonetDB5-server --> Finished Dependency Resolution MonetDB-client-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-client-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB5-server-5.4.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) MonetDB-1.22.0-1.fc8.oid32.i386 from MonetDB-Release has depsolving problems --> Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB5-server-5.4.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB-client-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libcrypto.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release) Error: Missing Dependency: libssl.so.6 is needed by package MonetDB-1.22.0-1.fc8.oid32.i386 (MonetDB-Release)

2 1

[MonetDB-users] MonetDB users
by Seth Grimes 23 May '08

23 May '08

Hello all, I've just joined the list to learn more about use of MonetDB. The DBMS looks quite interesting. Who's using it outside the research community at CWI? For what type and size of applications? Thanks, Seth -- Seth Grimes Alta Plana Corp, analytical computing & data management Intelligent Enterprise magazine (CMP), Contributing Editor grimes(a)altaplana.com http://altaplana.com 301-270-0795

1 0

[MonetDB-users] deep-equals function
by luc touraille 21 May '08

21 May '08

Hi everyone, I was wondering if the deep-equals function, described in the http://www.w3.org/TR/xpath-functions/#func-deep-equal W3C XQuery functions spec , was planned to be supported soon in MonetDB/XQuery. I saw on the CVS repository that the latest files of pathfinder included its signature, but I can't find its implementation. Can anyone enlighten me ? Thanks, Luc -- View this message in context: http://www.nabble.com/deep-equals-function-tp17364244p17364244.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Data Compression Algorithms
by Veneta Dobreva 20 May '08

20 May '08

Hello, I have the following question about MonetDB: does MonetDB implement some data compression algorithms? I would like to use an RLE (run-length encoding) algorithm for compression of my data. Is this already implemented in MonetDB? Thank you in advace for your help! Regards, Veneta Dobreva -- Dipl.-Inf. Veneta Dobreva Lehrstuhl Informatik III Tel.: ++49 (0)89 289-17288 Fakultät für Informatik Fax: ++49 (0)89 289-17263 TU München, Raum 02.11.041 MI veneta.dobreva(a)in.tum.de http://www-db.in.tum.de/~dobreva/

2 1

[MonetDB-users] MonetDB V 4.22 installation on Mac OS X 10.5.2 and Mac OS X 10.4.0.
by Irini Fundulaki 18 May '08

18 May '08

Hi, I have the following problems with MonetDB XQuery Release Feb 2008, V. 4.22 on Mac OS X 10.5.2 and Mac OS X 10.4.0. 1) Mac OS X 10.5.2: a) I was not able to install MonetDB from sources. I downloaded MonetDB-Feb2008-SuperBall.bz2 and followed the instructions in http://monetdb.cwi.nl/projects/monetdb//MonetDB/Documentation/Linux-Install…. I successfully installed MonetDB, clients and MonetDB4-server, but when installing MonetDB4-XQuery I had the following error: Undefined symbols: "_embedded_mil", referenced from: _main in prog.o ld: symbol(s) not found collect2: ld returned 1 exit status make[5]: *** [Mbeddedxq] Error 1 make[4]: *** [all] Error 2 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 b) by calling monetdb-install.sh. MonetDB was installed with no problems. Nevertheless, mclient with a simple query (e.g., <example>hello</example) stalled. Mserver stalled when executing xmldb_print(); 2) Mac OS X 10.4.0 a) I was able to install MonetDB XQuery Release Feb 2008, V. 4.22 using monetdb-install.sh. Mserver did not stall with xmldb_print(). mclient for the same query exhibited different behaviors: that is, sometimes it stalled, and others not (again, the same simple query as before). I had downloaded MonetDB on September 2007, and installed it on Mac OS X 10.4.0. I had no problem with that version. Thanks for looking into it, Irini

2 1