- users-list - monetdb.org

[MonetDB-users] query time
by anagnostes 20 Sep '11

20 Sep '11

Hi. I would like to know if it's possible to get the query time using the input "\<file" and redirecting the output to "\>file" in Windows. When i use the input file it nevers throws the query time. So i can't know it. Thank you. -- View this message in context: http://old.nabble.com/query-time-tp32232809p32232809.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Memory leaks in the latest trunk?
by Stefan de Konink 20 Sep '11

20 Sep '11

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hello, Recently I decided it was again a good idea(tm) to 'test' the latest MonetDB trunk on an updated dataset. Sadly over the last 6 days I observed a growing memory usage, today resulting in a segmentation fault. For now nothing more than mserver5[26142]: segfault at 8 ip 00007f1e1e592a31 sp 00007f1e00ca63b8 error 4 in libc-2.13.so[7f1e1e515000+17d000] is known to me, which is development wise totally useless. But an other question did arise: is testing currently taking memory into a count? Especially longer tests might show greater usage of memory. It is obviously no problem replay all the queries that ran against the database and valgrind it... but there might have been work done from development respective that can shed light over the problems. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.17 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAk5OiAAACgkQYH1+F2Rqwn3d+ACdH5ySymgx46EON89qdnlYof39 ZHsAn1LjL9eOHncOjM99+wAupwMC6OR3 =BsVB -----END PGP SIGNATURE-----

2 1

[MonetDB-users] count slower than expected?
by Joris Slob 20 Sep '11

20 Sep '11

Hello mailing list! This is my first attempt to ask a question here, so please excuse my ignorance. For large tables (>1M rows), I encounter strange behavior when using the COUNT function in SQL in the mclient. When I do the following query: SELECT DISTINCT(predicate) FROM facts; I get a nice resultset of 31 tuples in 20ms. When I try the following query: SELECT COUNT(DISTINCT(predicate)) FROM facts; I get my answer in 565ms. It seems weird that the database doesn't 'optimize' this count to: SELECT COUNT(*) FROM (SELECT DISTINCT(predicate) FROM facts) AS b; I get my answer in 20ms. The facts table is defined as follows: CREATE TABLE "sys"."facts" ( "subject" CHAR(2048), "predicate" CHAR(2048), "object" CHAR(2048) ); This is my first attempt to make a knowledge store and I am aware there is lots I can do to optimize how I store the data. I was just surprised that the count took significantly longer than getting all the results out and counting them. Here is the version information of MonetDB I am using: MonetDB 5 server v11.3.7 "Apr2011-SP2" (32-bit, 32-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Found 1.0GiB available memory, 2 available cpu cores Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 0.9.8k 25 Mar 2009 (compiled with OpenSSL 0.9.8k 25 Mar 2009) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: root(a)ottar.ins.cwi.nl (i486-pc-linux-gnu) Compilation: gcc -Wall -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 -ftree-vectorize Linking : /usr/bin/ld -Wl,-Bsymbolic-functions Greetings, Joris

2 1

[MonetDB-users] omission in documentation?
by Sander Kruseman 20 Sep '11

20 Sep '11

Hi, I'm unable to find documentation on 'mapi_open' on the new website. I read the 5 available man pages, but found no mention of it. The man page for monetdb does however, mention monetdb.conf(5) but I cannot find that one either. Am I overlooking something? regards, Sander Kruseman

2 1

[MonetDB-users] Announcement: New Apr2011-SP2 bugfix release of MonetDB suite
by Sjoerd Mullender 16 Sep '11

16 Sep '11

The MonetDB team at CWI/MonetDB BV is pleased to announce the Aug2011 feature release of the MonetDB suite of programs. The default width for OID columns in the database is now 64 bits for all 64-bit architecture. In releases up to this release, the default width on 64-bit Windows was still 32 bits. This means that with the current release it is possible to have tables with more than about 2 million rows even on Windows (as long as you use a 64-bit build). More information (including release notes) on this release is available at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>. -- Sjoerd Mullender

1 0

[MonetDB-users] Calling a stored procedure from java
by elarios 13 Sep '11

13 Sep '11

Hi, Please, I would like to know the correct sintaxis for calling a stored procedures in MonetDB from a Java application. I was using some code that works fine in MySQL but this doesn't work in MonetDB. The code inside a method is: ------------------------------------------------------------------- Connection con = null; ResultSet rs = null; CallableStatement cs = null; cs = con.prepareCall("{call hts.spInsertFile(?)}"); File fl = new File("/home//Test/example.pdf"); imgfile = new FileInputStream(fl); cs.setBinaryStream(1,imgfile); rs = cs.executeQuery(); ------------------------------------------------------------------- When I execute the stored procedure from Netbeans IDE the stored procedure works fine. I've made a trace in the application and the statement: con.prepareCall("{call hts.spInsertFile(?)}"); returns null and finally throws an exception: Exception in thread "main" java.lang.NullPointerException at testmonetdb.DBase.set_file(DBase.java:86) at testmonetdb.MonetDBTest.main(MonetDBTest.java:34) The MonetDB version I'm using is: MonetDB 5 server v11.3.7 "Apr2011-SP2" (64-bit, 64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2011 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Found 3.9GiB available memory, 4 available cpu cores Libraries: libpcre: 8.12 2011-01-15 (compiled with 8.10) openssl: OpenSSL 1.0.0d 8 Feb 2011 (compiled with OpenSSL 1.0.0d-fips 8 Feb 2011) libxml2: 2.7.7 (compiled with 2.7.7) Compiled by: mockbuild@ (x86_64-unknown-linux-gnu) Compilation: gcc -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -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 -ftree-vectorize Linking : /usr/bin/ld -m elf_x86_64 I'm also using Netbeans IDE 7.1 with the jdbcclient.jar (http://dev.monetdb.org/downloads/Java/Oct2010-SP1/) Thanks in advance for your help, Enrique. -- View this message in context: http://old.nabble.com/Calling-a-stored-procedure-from-java-tp32431606p32431… Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Does MonetDB support materialized view or not?
by Ken Cheng 03 Sep '11

03 Sep '11

Hi All, Does MonetDB support materialized view or not? Yours sincerely, Ken Cheng

3 3

[MonetDB-users] stack protector error
by Michael Sioutis 27 Aug '11

27 Aug '11

Hello, I get an error when trying to compile latest MonetDB default branch on my Ubuntu 10.04 64bit machine. bootstrap: OK configure (../configure --prefix=/opt/MonetDB/ --enable-monetdb5 --enable-sql --enable-rdf --enable-geom --enable-bits=64 --enable-debug --enable-datacell): OK make -j2: ERROR The error is: ../../gdk/gdk_batop.mx: In function ‘BATsetprop’: ../../gdk/gdk_batop.mx:2890: error: not protecting function: no buffer at least 8 bytes long I think flags -fstack-protector-all and -Wstack-protector are to blame, they default to 8 bytes. I can skip the problem if I set 8 byte long dummy buffers to EVERY function that doesn't have such a buffer, e.g., char mybuf[8]; memset(buf, 0, sizeof(buf)); I also thought of setting the buffer size to 1, by passing --param spp-buffer-size=1 as a compiler option, but then I get various other errors. gcc version: gcc (Ubuntu 4.4.3-4ubuntu5) 4.4.3 Copyright (C) 2009 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. Mike

2 8

[MonetDB-users] Current Pathfinder list/team
by Anton Kolev 21 Aug '11

21 Aug '11

Gentlemen, Which is the proper current list (or personal contact) for the Pathfinder related questions? Are there recent work after Mar2011 branch [1]? Thank you in advance, Anton [1] http://dev.monetdb.org/hg/MonetDB/file/932a58fecbde/pathfinder

2 1

[MonetDB-users] Does MonetDB support regular expression predicates?
by Viktor Rosenfeld 21 Aug '11

21 Aug '11

Hi, does MonetDB support regular expression matching on strings? It's supposedly part of SQL:99, but I couldn't find anything about this on the homepage or the mailing list. I only found the Data Manipulation reference, which lists LIKE predicates. Cheers, Viktor

2 1