- users-list - monetdb.org

[MonetDB-users] Killing long running queries
by Ramkumarlak 06 Apr '11

06 Apr '11

Is there any way to know the current running queries (like mysql's "show full processlist"). Also is there any way of killing long running queries. -- View this message in context: http://old.nabble.com/Killing-long-running-queries-tp31276295p31276295.html Sent from the monetdb-users mailing list archive at Nabble.com.

3 5

Re: [MonetDB-users] [expath] Kudos on CXAN
by Christian Grün 05 Apr '11

05 Apr '11

…time for MonetDB to join up ;) ___________________________ On Tue, Apr 5, 2011 at 12:04 AM, Florent Georges <fgeorges(a)gmail.com> wrote: > On 3 April 2011 14:31, Chris Maloney wrote: > >> Florent, I suddenly realized this morning why you have the >> image that you do on the CXAN site -- it's a pronunciation >> hint! > > Good catch! > > For the others, the picture on the home page of CXAN > <http://cxan.org/beta/> is a painting of Paul Cezanne > <http://en.wikipedia.org/wiki/Paul_C%C3%A9zanne>, a French > painter. > > I hesitated with a self-portrait (this one is a portrait of > Victor Chocquet, dont ask me who he is), but I liked this one. > The hint is that the X is actually pronounced like a Z, to make > the name fluent (either a la French, with a C like in sailer, or > English style, with a C like in sea). > > Very good catch :-) > > -- > Florent Georges > http://fgeorges.org/ > > -- > You received this message because you are subscribed to the Google Groups "EXPath" group. > To post to this group, send email to expath(a)googlegroups.com. > To unsubscribe from this group, send email to expath+unsubscribe(a)googlegroups.com. > For more options, visit this group at http://groups.google.com/group/expath?hl=en.

1 0

[MonetDB-users] query dit not produce result set
by Bas Kaptijn 04 Apr '11

04 Apr '11

Hi, with the MAR2010 release (x64 windows through installer) (and also the release Feb2010-SP2) I get an exception running a particular query, whilst a slightly modified one with the expected result (except for the naming of a result column) does not. I narrowed the problem down to this: sql>CREATE TABLE dbg (a INT, b INT); operation successful sql>INSERT INTO dbg (a,b) VALUES (10,10); 1 affected row (32.410ms) sql>SELECT a as d, SUM(b), (2 * (SUM(b) / (SELECT 2))) as f FROM dbg GROUP BY d; +------+------+------+ | d | L451 | f | +======+======+======+ | 10 | 10 | 10 | +------+------+------+ 1 tuple (8.841ms) sql>SELECT a as d, SUM(b) as e, (2 * (SUM(b) / (SELECT 2))) as f FROM dbg GROUP BY d; sql> The second select query does not produce a result set (as stated in the SQLException I get when doing this through JDBC). The monetdb client just shows a new prompt without stating any warning/error. The query works when I remove the "as e" ... or the "select 2" but in the real case I get this problem this select does much more than just selecting the number 2. I think this is a bug. Or am I doing something that is not (yet) supported in MonetDB? Thanks Bas Kaptijn

2 1

[MonetDB-users] for help(software information is added)
by Xianmin Liu 31 Mar '11

31 Mar '11

Hi, Sorry for missing the software information in last letter. I used MonetDB4-XQuery-Installer-x86_64-20110324 version, it seems to be the latest. If you have read my last letter, pls ignore followings. I am testing the performance of MonetDB/XQuery over large data. I use a HP xw8600 workstation, with Intel(R) Xeon(R) CPU X5482 3.20GHz, and 32GB RAM. I generate XMark data as large as 50GB, using standard XMark generator with 500 factor. When I tried to load it into database using "pf:add-doc", error message returned as following. ERROR = !ERROR: [shred_url]: 1 times inserted nil due to errors at tuples 0@0. !ERROR: [shred_url]: first error was: !ERROR: strPut: string heaps gets larger than 15GB. !ERROR: shredBAT_append_str: APPEND-STR[_prop_text]( !ERROR: catch fain deserves liking knee katharine easy hand helms daughter corn hire amaz plainness curtains staying excuse since tom walls thirty goodman twice corrections flesh behold woundl ess cargo royally zwagger nuncle season repair govern piercing sighs ounce arrest ganymede balthasar perjury !ERROR: ), BUNappend fails !ERROR: CMDshred_url: operation failed. Timer 2633290.282 msec Can you help me? How can I fix it? Thanks a lot. -- Xianmin Liu

2 2

[MonetDB-users] DROP TABLE IF EXISTS <table>;
by Michael Sioutis 31 Mar '11

31 Mar '11

Hello, I want to prevent an SQLException from occurring for tables that do not exist in my database. For example: sql>DROP TABLE "locked"; SQLException:sql.catalog:DROP TABLE: no such table 'locked' It seems (and is documented) that there is no such thing like "IF EXISTS" in MonetDB. Is there a way to circumvent the SQLException? Mike

5 8

Re: [MonetDB-users] for help(software information is added)
by Peter Boncz 31 Mar '11

31 Mar '11

Xianmin, On Windows we only build with 32bits oids (even with 64bits pointers). When working with 32-bits offsets string heaps are restricted to 16GB. For large data, we recommend 64-bits linux. Then grab a oid64 rpm. Peter From: Xianmin Liu [mailto:xianmliu@gmail.com] Sent: donderdag 31 maart 2011 11:09 To: monetdb-users(a)lists.sourceforge.net; Peter Boncz Cc: Wenfei Fan; Gao Cong; Nan Tang; Anastasios (Tasos) Kementsietsidis Subject: for help(software information is added) Hi, Sorry for missing the software information in last letter. I used MonetDB4-XQuery-Installer-x86_64-20110324 version, it seems to be the latest. If you have read my last letter, pls ignore followings. I am testing the performance of MonetDB/XQuery over large data. I use a HP xw8600 workstation, with Intel(R) Xeon(R) CPU X5482 3.20GHz, and 32GB RAM. I generate XMark data as large as 50GB, using standard XMark generator with 500 factor. When I tried to load it into database using "pf:add-doc", error message returned as following. ERROR = !ERROR: [shred_url]: 1 times inserted nil due to errors at tuples 0@0. !ERROR: [shred_url]: first error was: !ERROR: strPut: string heaps gets larger than 15GB. !ERROR: shredBAT_append_str: APPEND-STR[_prop_text]( !ERROR: catch fain deserves liking knee katharine easy hand helms daughter corn hire amaz plainness curtains staying excuse since tom walls thirty goodman twice corrections flesh behold woundl ess cargo royally zwagger nuncle season repair govern piercing sighs ounce arrest ganymede balthasar perjury !ERROR: ), BUNappend fails !ERROR: CMDshred_url: operation failed. Timer 2633290.282 msec Can you help me? How can I fix it? Thanks a lot. -- Xianmin Liu

1 0

[MonetDB-users] for help
by Xianmin Liu 31 Mar '11

31 Mar '11

Hi, I am testing the performance of MonetDB/XQuery over large data. I use a HP xw8600 workstation, with Intel(R) Xeon(R) CPU X5482 3.20GHz, and 32GB RAM. I generate XMark data as large as 50GB, using standard XMark generator with 500 factor. When I tried to load it into database using "pf:add-doc", error message returned as following. ERROR = !ERROR: [shred_url]: 1 times inserted nil due to errors at tuples 0@0. !ERROR: [shred_url]: first error was: !ERROR: strPut: string heaps gets larger than 15GB. !ERROR: shredBAT_append_str: APPEND-STR[_prop_text]( !ERROR: catch fain deserves liking knee katharine easy hand helms daughter corn hire amaz plainness curtains staying excuse since tom walls thirty goodman twice corrections flesh behold woundl ess cargo royally zwagger nuncle season repair govern piercing sighs ounce arrest ganymede balthasar perjury !ERROR: ), BUNappend fails !ERROR: CMDshred_url: operation failed. Timer 2633290.282 msec Can you help me? How can I fix it? Thanks a lot. -- Xianmin Liu

2 1

[MonetDB-users] DROP TABLE IF EXISTS <table>;
by Michael Sioutis 30 Mar '11

30 Mar '11

Hello, I want to prevent an SQLException from occurring for tables that do not exist in my database. For example: sql>DROP TABLE "locked"; SQLException:sql.catalog:DROP TABLE: no such table 'locked' It seems (and is documented) that there is no such thing like "IF EXISTS" in MonetDB. Is there a way to circumvent the SQLException? Mike

1 0

[MonetDB-users] How to determine size of a table and its indexes
by Nekas 30 Mar '11

30 Mar '11

In Oracle and MySQL for example, we can obtain the space occupied in the DB by tables and indexes in the user space. Is this possible in MonetDB? If so, how can I do it? I often need it, so it would be quite helpful to me. Thanks you in advance, Ana T.

1 2

[MonetDB-users] Announcement: New Mar2011 feature release of MonetDB suite
by Sjoerd Mullender 28 Mar '11

28 Mar '11

The MonetDB team at CWI/MonetDB BV is pleased to announce the Mar2011 feature release of the MonetDB suite of programs. This release marks the last planned release of MonetDB4 and Pathfinder, and hence the last planned release of MonetDB/XQuery. Development of the Pathfinder compiler continues at the University of Tübingen. The next release, currently planned for April 2011, should be a smooth upgrade from this release, even if MonetDB/XQuery is installed (which will of course then not be upgraded). This release also marks the first release of the new way of building the MonetDB suite. For details on both these issues, and on the other features and bug fixes of this release, please see the release notes at <http://monetdb.cwi.nl/Development/Releases/Mar2011/>. As usual, the download location is <http://dev.monetdb.org/downloads/>. -- Sjoerd Mullender

1 0