March 2010 - users-list

[MonetDB-users] (no subject)
by Abernethy, Simon 15 Mar '10

15 Mar '10

Dear Sir I have been testing the lastest version of mserver5 under Linux on an embedded arm platform (Marvell PXA270 XScale 600Mhz) and a PC. MonetDB server v5.16.5 kernel v1.34 I have built it for gumstix (arm based platform) and for PC I have built it using the monetdb-install.sh with the following parameters export EXTRA_ECONF="-enable-optimize -disable-debug -enable-strict -with-gcc=arm-angstrom-linux-gnueabi-gcc -host=arm-angstrom-linux-gnueabi -with-openssl=$HOME/gumstix/openssl -without-perl -without-ruby -without-python -without-php -without-java -without-swig without-libxml2 -with-pcre=$HOME/gumstix/pcre . /monetdb-install.sh -nightly=stable -prefix=$HOME/gumstix/monet -build ==$HOME/gumstix/monetBuildGum -enable-sql Unfortunately using 2 instances of my test program (test1.cpp attached) writing to the database at the same time, I see the memory being consumed and not released - it is very noticeable on a gumstix and will use all the memory within a hour. If I stop the writer applications the memory usage remains constant. No further memory is released If I halt the database server and reload the same same database I get a considerable reduction in the memory i.e. mserver5 memory footprint on a gumstix (http://www.gumstix.com/ verdex-pro 11% memory usage at Start running 2 instances of the test application (test1) 35.8% memory running for 3mins then stopping the write (test1) applications 10.3% memory after stopping and restarting database 12.8% memory after reloading database The test programs were run for only a few minutes. I also have valgrind reports of the same programs being run a the pc if helpful Simon Abernethy Software Engineer MiPlaza Philips Research Europe WB6.014 (HTC34 6.14) 5656 AE Eindhoven, The Netherlands Tel +31 40 27 49566 Fax +31 40 27 42081 Email simon.abernethy(a)philips.com<mailto:simon.abernethy@philips.com> http://www.miplaza.com ________________________________ The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.

1 0

[MonetDB-users] merovingian module loading
by Mitja Kleider 09 Mar '10

09 Mar '10

Hello, I would like to use merovingian and load the geom module as if I would be running > mserver5 --dbinit="include geom;include sql;sql.start();" Is this possible with merovingian? Regards Mitja

2 1

[MonetDB-users] sql query size
by dariuszs 06 Mar '10

06 Mar '10

Hi, Is there any limit on how big the sql query can be (in bytes)? Thanks. Dariusz.

3 3

[MonetDB-users] fetch_field errors.
by Guillaume Yziquel 04 Mar '10

04 Mar '10

Hello. I've been reading, in Mapi.mx, the following: > @item char **mapi_fetch_field_array(MapiHdl hdl) > > Return an array of string pointers to the individual fields. A zero > is returned upon encountering end of sequence or error. This can be > analyzed in using @code{mapi\_error()}. As I'm not a big fan of dynamic type checks, or dynamic error checks, I'd appreciate knowing: what kind of errors might this be? Any errors assuming anything might fail? Just to know... -- Guillaume Yziquel http://yziquel.homelinux.org/

2 3

[MonetDB-users] Cannot load libMapi with C++ after compiling and linking
by Alexander Koglin 03 Mar '10

03 Mar '10

Hi everybody, I tried to setup an Eclipse project by linking the libMapi against it and adding some entities to MonetDB SQL and always get the following error: *.../Project/Debug/Project: error while loading shared libraries: libMapi.so.1: cannot open shared object file: No such file or directory* After all linking and compiling goes alright. When Invoking the GCC C++ Compiler I call the following directive: *g++ -I/usr/local/Tarari/include -I/root/MonetDB/include/MonetDB -I/root/xerces-2.8/include -O0 -g3 -Wall -c -fmessage-length=0 `monetdb-clients-config --cflags --libs` -MMD -MP -MF"src/IndexHandler.d" -MT"src/IndexHandler.d" -o"src/IndexHandler.o" "../src/IndexHandler.cpp" g++ -I/usr/local/Tarari/include -I/root/MonetDB/include/MonetDB -I/root/xerces-2.8/include -O0 -g3 -Wall -c -fmessage-length=0 `monetdb-clients-config --cflags --libs` -MMD -MP -MF"src/MonetMapiUpdater.d" -MT"src/MonetMapiUpdater.d" -o"src/MonetMapiUpdater.o" "../src/MonetMapiUpdater.cpp" g++ -I/usr/local/Tarari/include -I/root/MonetDB/include/MonetDB -I/root/xerces-2.8/include -O0 -g3 -Wall -c -fmessage-length=0 `monetdb-clients-config --cflags --libs` -MMD -MP -MF"src/NodeFetcher.d" -MT"src/NodeFetcher.d" -o"src/NodeFetcher.o" "../src/NodeFetcher.cpp"* When invoking the GCC C++ Linker I call the following directive: *g++ -L/usr/local/Tarari/lib -L/root/MonetDB/lib -L/root/xerces-2.8/lib `monetdb-clients-config --cflags --libs` -o"NodeFetcherCPP" ./src/IndexHandler.o ./src/MonetMapiUpdater.o ./src/NodeFetcher.o -lMapi -ltararixpath -lxerces-c * What can be the reason for the error during execution? Thank you for any help, Alexander

3 2

[MonetDB-users] Cursor Alternative?
by Nafees Ur Rehman 03 Mar '10

03 Mar '10

Hi, Is there any alternative available in MonetDB to operate on records from within the function code? As cursors are not supported. Regards Nafees Ur Rehman Database & Information System Deptt of Computer Science University of Konstanz, Germany.

2 2

[MonetDB-users] Name of fields in query result?
by Guillaume Yziquel 02 Mar '10

02 Mar '10

Hello. Here are a few functions/methods from the postgresql-ocaml binding. > class type result = object > (** Main routines *) > > method nfields : int > (** [#nfields] @return the number of fields in a query result. *) > > method fname : int -> string > (** [#fname n] @return the name of the [n]th field. > > @raise Error if field out of range. > *) > > method fnumber : string -> int > (** [#fnumber field] @return the index of the field named [field]. > > @raise Not_found if no such named field. > *) I'm looking for equivalents of fname and fnumber methods in MAPI. Couldn't find an equivalent. So, is there a way, when you get the result of a query, to get the names of the fields in the result? All the best, -- Guillaume Yziquel http://yziquel.homelinux.org/

4 8

[MonetDB-users] Announcement: New Feb2010 feature release of MonetDB suite
by Sjoerd Mullender 02 Mar '10

02 Mar '10

The MonetDB team at CWI/MonetDB BV is pleased to announce the Feb2010 feature release of the MonetDB suite of programs. More information (including release notes) on this release is available at <http://monetdb.cwi.nl/Development/Releases/Feb2010/>. -- Sjoerd Mullender

2 1

[MonetDB-users] Slowdowns after Delete
by Reeves, Matthew J. 01 Mar '10

01 Mar '10

Hello, I have a MonetDB database that contains a table of rolling events. There are 200 million records with 500,000 bulk loaded each day with the oldest 500,000 deleted at midnight. I'm finding the database gets slower as time goes on. It gets to the point of being almost unusable after a week. Is there something I should be doing different? Thanks, Matt

4 4