- users-list - monetdb.org

[MonetDB-users] Parallel Processing
by Nafees Ur Rehman 04 May '10

04 May '10

Hi, Does monetdb has support for parallel processing? If some can guide me on that. Regards Nafees Ur Rehman

4 8

[MonetDB-users] trigger ambiguous issue
by Huabing 03 May '10

03 May '10

I have following trigger statement: CREATE TRIGGER delete_pos_cp AFTER DELETE ON cp referencing old row as o FOR EACH ROW WHEN o.new_id_ IS NOT NULL UPDATE cp SET old_id_ = o.old_id_ WHERE rec_id_ = o.rec_id_; Following error is issued: SELECT: identifier 'rec_id_' ambiguous The last "o.rec_id_" gives rise to this ambigious. Any suggestion on this.

2 1

Re: [MonetDB-users] sql query size
by dariuszs 27 Apr '10

27 Apr '10

Hi, This still does not work in the latest version - Feb2010+SP2 - on Windows XP 32bit, Windows Server 2003 64bit,Ubuntu 9.10 64 bit,Fedora 12 64bit. Dariusz. Martin Kersten wrote: > Thanks for the example, we will look into it. > > dariuszs wrote: >> Martin, >> 1) Table schema >> sql>\d zip_codes >> CREATE TABLE "sys"."zip_codes" ( >> "zip_code" varchar(5) >> ); >> sql> >> >> 2) From mclient >> sql>\< /tmp/test.sql >> MAPI = monetdb@localhost:50000 >> ACTION= read_line >> QUERY = select count(*) from zip_codes WHERE zip_code IN >> ('00501','00544','01001','01002','01003','01004','01005','01007','01008','01009','01010','01011','01012','01013','01014','01020','01021','01022','01026','01027','01028','01029','01030','01031','01032','01033','01034','01035','01036','01037','01038','01039','01040','01041','01050','01053','01054','01056','01057','01059','01060','01061','01062','01063','01066','01068','01069','01070','01071','01072','01073','01074','01075','01077','01079','01080','01081','01082 >> >> ERROR = Connection terminated >> sql> >> 3) From shell >> root@monetdb:/tmp# mclient -lsql < test.sql >> MAPI = monetdb@localhost:50000 >> ACTION= read_line >> QUERY = select count(*) from zip_codes WHERE zip_code IN >> ('00501','00544','01001','01002','01003','01004','01005','01007','01008','01009','01010','01011','01012','01013','01014','01020','01021','01022','01026','01027','01028','01029','01030','01031','01032','01033','01034','01035','01036','01037','01038','01039','01040','01041','01050','01053','01054','01056','01057','01059','01060','01061','01062','01063','01066','01068','01069','01070','01071','01072','01073','01074','01075','01077','01079','01080','01081','01082 >> >> ERROR = Connection terminated >> root@monetdb:/tmp# >> 4) SQL >> >> >> Dariusz >> >> Martin Kersten wrote: >>> Hi Dariusz, >>> >>> A bug or a system limitation. It should at least never crash. >>> >>> How did you submit the query? To mclient? or mserver? or through >>> a mapi libary call? >>> >>> I would have to look into the SQL parser. The underlying stream would >>> expand upon need. It is, however, an interesting query. What kind of >>> application generates it? >>> >>> regards, Martin >>> >>> ps. we should keep a profile of users to avoid asking platform >>> details. >>> >>> dariuszs wrote: >>>> Hi Martin, >>>> Then I guess it's a bug. Please try running a query over 44k, >>>> you'll get >>>> MAPI = monetdb@localhost:50000 >>>> ACTION= read_line. >>>> QUERY = select count(*) from plk100 WHERE c15 IN >>>> ('00501','00544','01001','01002','01003'.......... >>>> ERROR = Connection terminated >>>> Any query under 44k runs fine, so I'm assuming the limit is 64k >>>> (query + other packet data) >>>> >>>> Thanks. Dariusz. >>>> >>>> >>>> >>>> Martin Kersten wrote: >>>>> dariuszs wrote: >>>>> >>>>>> Hi, >>>>>> Is there any limit on how big the sql query can be (in bytes)? >>>>>> Thanks. Dariusz. >>>>>> >>>>>> >>>>> As far as i am aware no. >>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> >>>>>> Download Intel® Parallel Studio Eval >>>>>> Try the new software tools for yourself. Speed compiling, find bugs >>>>>> proactively, and fine-tune applications for parallel performance. >>>>>> See why Intel Parallel Studio got high marks during beta. >>>>>> http://p.sf.net/sfu/intel-sw-dev >>>>>> _______________________________________________ >>>>>> MonetDB-users mailing list >>>>>> MonetDB-users(a)lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> >>>>> Download Intel® Parallel Studio Eval >>>>> Try the new software tools for yourself. Speed compiling, find bugs >>>>> proactively, and fine-tune applications for parallel performance. >>>>> See why Intel Parallel Studio got high marks during beta. >>>>> http://p.sf.net/sfu/intel-sw-dev >>>>> _______________________________________________ >>>>> MonetDB-users mailing list >>>>> MonetDB-users(a)lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/monetdb-users >>>>> >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >>> >> > > > >

1 0

[MonetDB-users] ODBC connection problem.
by Nozhup 27 Apr '10

27 Apr '10

I get the following error when trying to connect a MonetDB database with 'OpenOffice.org Database' through the ODBC driver. [unixODBC][MonetDB][ODBC Driver 1.0]Client unable to establish connection .ini-files used: odbc.ini: [MonetDB_User] Description = Default MonetDB Data Source Driver = MonetDB Host = localhost Port = 50000 Database = TestDB User = monetdb Password = monetdb Debug = odbcinst.ini [MonetDB] Description = MonetDB Driver Driver = Driver64 = /home/breplu/MonetDB/lib/libMonetODBC.so Setup = Setup64 = /home/breplu/MonetDB/lib/libMonetODBCs.so UsageCount = 1 CPTimeout = CPReuse = MonetDB version: Feb2010 release A ODBC connection between MySql and OpenOffice works correctly, so I don't think the problem lies with OpenOffice. Am I doing something wrong or is this a know issue with MonetDB? Thanks in advance. -- View this message in context: http://old.nabble.com/ODBC-connection-problem.-tp28364397p28364397.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 1

[MonetDB-users] SMELLIEST data types???
by Steve Schmechel 27 Apr '10

27 Apr '10

I'm guessing that this was meant to be "SMALLINT". From: http://monetdb.cwi.nl/SQL/Documentation/SQL-Features.html Feature ID Feature name S/N B011-B017 Embedded Language support. Core SQL:1999 says that at least one of Embedded Ada, Embedded C, Embedded Cobol, Embedded Fortran, Embedded MUMPS, Embedded Pascal or Embedded PL/I 1 should be supported. N E011 Numeric data types (FULL support) S E011-01 INTEGER and SMELLIEST data types ^^^^^^^^^ I know I read that page before, funny I never noticed that. (I have to admit, I did check the standard just to make sure it wasn't in there and I had just missed it all these years.) I have seen a few database tables that had some really stinky data types, but I'm glad I never came across one that contained the smelliest. :-) Steve

2 1

Re: [MonetDB-users] SQL Case Statement
by Steve Schmechel 27 Apr '10

27 Apr '10

--- On Mon, 4/26/10, Mark Bucciarelli <mkbucc(a)gmail.com> wrote: > From: Mark Bucciarelli <mkbucc(a)gmail.com> > $ cd src/monet_2009Nov/ > $ find . -name "*sql*.y" > ./sql/src/server/sql_parser.y > $ > > Well commented YACC source. > > I use that when I have a SQL question. This file is not in any of the tarballs, including Nov2009. Do you have to generate it? If so, that would be a horrible way to document an external API: 1) Download source code. 2) Run lexical analyzer on source code. 3) Try to understand code comments. 4) Retry your query in the client application. Is there another document somewhere? If the comments are very good, maybe that could be quickly refined to become the official documentation. Thanks, Steve

3 2

[MonetDB-users] SQL Case Statement
by Hering Cheng 26 Apr '10

26 Apr '10

Hi, Is there any plan to add support for CASE in SELECT clauses to MonetDB? Thanks. Hering

4 6

[MonetDB-users] how to grant privileges to creating tables?
by Min Lu 25 Apr '10

25 Apr '10

Dear MonetDB users, Is it all possible to grant the privilege of "creating tables" to some users in MonetDB? For example, something like "grant create table to user_name" or similar? Thanks, Min

2 2

[MonetDB-users] how to grant privileges to creating tables? (more specific version)
by Min Lu 25 Apr '10

25 Apr '10

Dear all, I just want to address my question in last message in a more specific way. Actually I am wondering if I can grant privileges to creating local/global temporary tables to a normal user other than monetdb. And what is the complete list of priveleges known to MonetDB? Thanks, Min

2 2

[MonetDB-users] Fedora 12 cannot install public key
by dariuszs 23 Apr '10

23 Apr '10

Hi, Just trying to install public key on another server [root@monetdb ~]# rpm --import http://monetdb.cwi.nl/downloads/MonetDB-GPG-KEY error: http://monetdb.cwi.nl/downloads/MonetDB-GPG-KEY: import failed. [root@monetdb ~]#

1 1

[MonetDB-users] mal index
by Miguel Ángel Águila Lorente 23 Apr '10

23 Apr '10

Hello, I'm working in a research problem and we need to create a graph database. We think that MonetDB can be useful to represent this graph since the use of bats may make the graph traversal efficient. Nevertheless, SQL is limited for the type of operations that we need to do, and that is why we have decided to resort to MAL. Our database is like this: - Nodes: a) node ident b) name - Edges: a) edge ident b) head node ident c) tail node ident One of the operations is to find the node with maximum out degree and, after that, to do a BFS using this node as the source. I have stored all the information in bats: batNode1=[oid,node ident] batNode2=[oid,name] batEdge=[oid, edge ident] batEdgeHead=[oid, head node ident] batEdgeTail=[oid,tail node ident] For getting the node with the maximum out degree, I access batEdgeHead and store the number of occurrences of every node id in a batAux. batAux=[node ident, times] After that I only select the node id with the largest number of occurrences. Now, we are ready to do the BFS. In every iteration, I have to save all the tail nodes for exploring them in the next generation. This is the pseudocode explanation: Put the node id to NodesToVisit While there are NodesToVisit currentNode=NodesToVisit; edgeToVisit=get edges idents from batEdgeHead from currentNode ident While there are edgesToVisit currentEdge=edgesToVisit nodeFinal=get tail node ident from batEdgeTail from currentEdge ident If notExist nodeFinal in NodesToVisit put nodeFinal in NodesToVisit endIf endWhile endWhile The main problem happens when I perform a select from batEdgeHead from the ident node. batEdgeHead might become very large and accessing it might be very expensive in terms of time. Is there any kind of indexing? I tried with crackers and AVL index but, if I am not wrong, this is only useful if I had to do the same selection more than once. The number of the nodes is 325.000 and the number of edges 925.000. At the end of this e-mail you will find the code. May any one help in improving the performance of this code? Best regards, Miquel Àngel Àguila Bat equivalence: batEdge, batNode1 --> b1:= bat.new(:oid,:lng); batNode2 --> b2:= bat.new(:oid,:str); batEdgeHead --> rh:= bat.new(:oid,:lng); batEdgeTail --> rt:= bat.new(:oid,:lng); batType --> b4:= bat.new(:oid, int) (Type: 1. nodeType1, 2. nodeType2 , 3. edgeType1, 4. edgeType2, 5. edgeType3) Loaded the bats, here is the code: Maxium out degree:----------------------------------------------------- edart:=algebra.select(b4,3); nodOut:=algebra.semijoin(rh,edart); res:=bat.new(:lng,:int); valor:=0; barrier (mloop16:lng ,h16:oid ,tl16:lng ) := bat.newIterator(nodOut); bite1:=algebra.exist(res,tl16); barrier ifpart:= bite1; valor:=algebra.find(res, tl16); valor:=calc.+(valor,1); res:=bat.replace(res,tl16,valor); exit ifpart; barrier elsepart:= calc.!=(bite1,true); bat.insert(res,tl16,1); exit elsepart; redo (mloop16:lng ,h16:oid ,tl16:lng ) := bat.hasMoreElements(nodOut); exit mloop16:lng ; maxOutDegree:=aggr.max(res); node:=algebra.select(res,maxOutDegree); io.print(node); nodart:=algebra.select(b4,1); nodart2:=algebra.semijoin(b1,nodart); ident2:=algebra.join(nodart2,node); name2:=algebra.semijoin(b3,ident2); secondtime:=alarm.time(); #Traversals------------------------------------------------------------ node2:=algebra.semijoin(b1,name2); aux:=0:lng; idoid:=0@0; barrier (mloop17:lng ,h17:oid ,tl17:lng) := bat.newIterator(node2); aux:=tl17; idoid:=h17; exit mloop17:lng ; nod:=bat.new(:lng,:lng); dif:=bat.new(:lng,:lng); vis:=bat.new(:lng,:lng); ar:=bat.new(:oid,:oid); tr:=bat.new(:oid,:oid); bat.insert(nod,aux,aux); dif:=algebra.difference(nod,vis); outer6:= aggr.count(dif); rhtaux:=bat.new(:oid,:int); rhaux:=bat.new(:oid,:lng); rtaux:=bat.new(:oid,:lng); rhtaux:=algebra.select(b4,3); rtaux:=algebra.semijoin(rt,rhtaux); rhaux:=algebra.semijoin(rh,rhtaux); barrier outer:=true; barrier (mloop18:lng ,h18:lng ,tl18:lng ) := bat.newIterator(dif); # This is the problem, I need to do a lot of selects rhaux2:=algebra.select(rhaux,tl18); rtaux2:=algebra.semijoin(rtaux,rhaux2); barrier (mloop19:lng ,h19:oid,tl19:lng ) := bat.newIterator(rtaux2); bite1:=algebra.exist(nod,tl19); barrier ifpart:= bite1; bat.insert(tr,h19,h19); exit ifpart; barrier elsepart:= calc.!=(bite1,true); bat.insert(ar,h19,h19); bat.insert(nod,tl19,tl19); exit elsepart; redo (mloop19:lng ,h19:oid ,tl19:lng ) := bat.hasMoreElements(rtaux2); exit mloop19:lng ; bat.insert(vis,h18,tl18); redo (mloop18:lng ,h18:lng ,tl18:lng ) := bat.hasMoreElements(dif); exit mloop18:lng ; dif:=algebra.difference(nod,vis); outer6:= aggr.count(dif); outer:=calc.!=(outer6,0); redo outer:=calc.!=(outer6,0); exit outer;

4 4

Re: [MonetDB-users] Core Dump upon COPY on SPARC
by Hering Cheng 23 Apr '10

23 Apr '10

Using Feb2010 release resulted in a different error. This time, mserver5 did not crash: MAPI = chenher@rdcuxsrv220:50000 QUERY = COPY 34274958 RECORDS INTO app.t_compute_all_closeprice FROM '/home/chenher/gaal/tmp/tar/t_compute_all_closeprice.txt' DELIMITERS '|', '\n'; ERROR = !MALException:!ERROR: HEAPextend: failed to extend to 274199664 for 17/1745tail Here is the configuration from log file: 2010-04-21 13:11:51 MSG tar[537]: # MonetDB server v5.18.1, based on kernel v1.36.1 2010-04-21 13:11:51 MSG tar[537]: # Serving database 'tar', using 16 threads 2010-04-21 13:11:51 MSG tar[537]: # Compiled for sparc-sun-solaris2.10/64bit with 64bit OIDs dynamically linked 2010-04-21 13:11:51 MSG tar[537]: # Found 32.000 GiB available main-memory. 2010-04-21 13:11:51 MSG tar[537]: # Copyright (c) 1993-July 2008 CWI. 2010-04-21 13:11:51 MSG tar[537]: # Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved 2010-04-21 13:11:51 MSG tar[537]: # Visit http://monetdb.cwi.nl/ for further information 2010-04-21 13:11:51 MSG tar[537]: # Listening for connection requests on mapi:monetdb://127.0.0.1:50001/ 2010-04-21 13:11:52 MSG tar[537]: # MonetDB/SQL module v2.36.1 loaded Any suggestion? On Wed, Apr 21, 2010 at 1:16 PM, Hering Cheng <hering.cheng(a)computer.org>wrote: > The statement I gave is the only statement that I passed to mclient, using > --statement argument. > > > On Wed, Apr 21, 2010 at 11:32 AM, Niels Nes <Niels.Nes(a)cwi.nl> wrote: > >> On Wed, Apr 21, 2010 at 11:08:46AM -0700, Hering Cheng wrote: >> > Here is the single COPY statement I was using: >> > >> > COPY 34274958 RECORDS INTO app.t_compute_all_closeprice FROM '/home/ >> > chenher/gaal/tmp/tar/t_compute_all_closeprice.txt' DELIMITERS '|', '\ >> > n'; >> >> I was wondering because the crash you have seems to indicate its >> in the commit, ie your load finished but then the commit (auto or not) >> crashes. Probably because of some out of memory problem. >> >> niels >> > >> > On Wed, Apr 21, 2010 at 11:02 AM, Niels Nes <Niels.Nes(a)cwi.nl> wrote: >> > >> > On Wed, Apr 21, 2010 at 10:48:48AM -0700, Hering Cheng wrote: >> > > Hi, >> > > >> > > I am trying to load 77 GB of data (or 34,274,958 records) into >> > MonetDB, >> > > using the Feb2010 SP1 source code compiled on Solaris SPARC with >> > Sun >> > > Studio 12.1 compiler with debugging enabled, and the database >> > crashes 5 >> > > hours into the loading. Here is some information about my >> > > configuration: >> > > >> > > I start up with Merovingian like this: >> > > >> > > $ ( ulimit -d $[32*1024*1024]; export LD_PRELOAD_64=/usr/lib/64/ >> > > libumem.so:${LD_PRELOAD_64}; export LD_PRELOAD=/usr/lib/ >> > libumem.so:$ >> > > {LD_PRELOAD}; export MONETDB5CONF=/GAAL/chenher/ >> > rdcuxsrv220-local-disk/ >> > > chenher/monetdb/feb2010sp1/etc/monetdb5.conf; /GAAL/chenher/share >> > / >> > > monetdb/distro-sparc-feb2010-sp1-64bit/bin/merovingian; ) >> > > >> > > Here are the relevent log sections: >> > > >> > > 2010-04-16 13:25:28 MSG merovingian[4302]: starting database >> > 'tar', up >> > > min/avg/max: 4m/4m/4m, crash average: 0.00 0.00 0.00 (1-1=0) >> > > 2010-04-16 13:25:29 MSG tar[15594]: arguments: /GAAL/chenher/ >> > share/ >> > > monetdb/distro-sparc-feb2010-sp1-64bit/bin/mserver5 --config=/ >> > GAAL/ >> > > chenher/rdcuxsrv220-local-disk/chenher/monetdb/feb2010sp1/etc/ >> > > monetdb5.conf --dbname=tar --dbinit=include sql; --set >> > merovingian_uri= >> > > mapi:monetdb://rdcuxsrv220:50000/tar --set monet_daemon=yes --set >> > > mapi_open=false --set mapi_autosense=true --set mapi_port=50001 >> > --set >> > > monet_vault_key=/GAAL/chenher/rdcuxsrv220-local-disk/chenher/ >> > monetdb/ >> > > feb2010sp1/var/MonetDB5/dbfarm/tar/.vaultkey --set sql_optimizer= >> > > default_pipe >> > > 2010-04-16 13:25:34 MSG tar[15594]: # MonetDB server v5.18.3, >> > based on >> > > kernel v1.36.3 >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Serving database 'tar', >> > using 16 >> > > threads >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Compiled for >> > > sparc-sun-solaris2.10/64bit with 64bit OIDs dynamically linked >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Found 32.000 GiB available >> > > main-memory. >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Copyright (c) 1993-July >> > 2008 CWI. >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Copyright (c) August >> > 2008-2010 >> > > MonetDB B.V., all rights reserved >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Visit http://monetdb.cwi.nl >> > / for >> > > further information >> > > 2010-04-16 13:25:34 MSG tar[15594]: # Listening for connection >> > requests >> > > on mapi:monetdb://127.0.0.1:50001/ >> > > 2010-04-16 13:25:35 MSG tar[15594]: # MonetDB/SQL module v2.36.3 >> > loaded >> > > 2010-04-16 13:25:35 MSG control[4302]: rdcuxsrv220:58146: started >> > > database 'tar' >> > > ... >> > > 2010-04-21 10:23:37 MSG merovingian[4302]: database 'tar' (15594) >> > has >> > > crashed (dumped core) >> > > >> > > Using Sun's DBX tool to examine the crash: >> > > >> > > ... >> > > t@212 (l@212) terminated by signal SEGV (no mapping at the fault >> > > address) >> > > Current function is temp_create >> > > 87 temp_dup(b->batCacheid); >> > > (dbx) where >> > > current thread: t@212 >> > > =>[1] temp_create(b = (nil)), line 87 in "bat_utils.c" >> > > [2] ebat2real(b = 5714, ibase = 0), line 162 in "bat_utils.c" >> > > [3] delta_append_bat(bat = 0x104923c98, i = 0x10143ec98), line >> > 234 in >> > > "bat_storage.c" >> > > [4] append_col(tr = 0x104fe1e98, c = 0x1045c7af8, i = >> > 0x10143ec98, >> > > tpe = 5), line 267 in "bat_storage.c" >> > > [5] mvc_append_wrap(cntxt = 0xffffffff7f352c00, mb = >> > 0x1050d5d98, stk >> > > = 0x101816018, pci = 0x1056a7c18), line 1120 in "sql.c" >> > > [6] runMALsequence(cntxt = 0xffffffff7f352c00, mb = >> > 0x1050d5d98, >> > > startpc = 1, stoppc = 0, stk = 0x101816018, env = (nil), >> > pcicaller = >> > > (nil)), line 2908 in "mal_interpreter.c" >> > > [7] callMAL(cntxt = 0xffffffff7f352c00, mb = 0x1050d5d98, env = >> > > 0xfffffffddabff908, argv = 0xfffffffddabff968, debug = '\0'), >> > line 402 >> > > in "mal_interpreter.c" >> > > [8] SQLexecutePrepared(c = 0xffffffff7f352c00, be = >> > 0x1050f0ec8, q = >> > > 0x104fe1b18), line 1196 in "sql_scenario.c" >> > > [9] SQLengineIntern(c = 0xffffffff7f352c00, be = 0x1050f0ec8), >> > line >> > > 1249 in "sql_scenario.c" >> > > [10] SQLengine(c = 0xffffffff7f352c00), line 1349 in >> > "sql_scenario.c" >> > > [11] runPhase(c = 0xffffffff7f352c00, phase = 4), line 363 in >> > > "mal_scenario.c" >> > > [12] runScenarioBody(c = 0xffffffff7f352c00), line 412 in >> > > "mal_scenario.c" >> > > [13] runScenario(c = 0xffffffff7f352c00), line 438 in >> > > "mal_scenario.c" >> > > [14] MSserveClient(dummy = 0xffffffff7f352c00), line 368 in >> > > "mal_session.c" >> > > (dbx) threads >> > > t@1 a l@1 ?() LWP suspended in __pollsys() >> > > t@2 a l@2 SERVERlistenThread() LWP suspended in >> > __pollsys >> > > () >> > > t@3 a l@3 mvc_logmanager() LWP suspended in >> > __pollsys() >> > > t@4 b l@4 umem_update_thread() sleep on (unknown) in >> > > __lwp_park() >> > > t@13 a l@13 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@14 a l@14 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@15 a l@15 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@16 a l@16 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@17 a l@17 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@18 a l@18 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@19 a l@19 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@20 a l@20 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@21 a l@21 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@22 a l@22 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@23 a l@23 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@24 a l@24 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@25 a l@25 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@26 a l@26 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@27 a l@27 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > t@28 a l@28 runDFLOWworker() sleep on 0x101ea9a48 in >> > > __lwp_park() >> > > o> t@212 a l@212 ?() signal SIGSEGV in temp_create() >> > > >> > > With Feb2010 release, I managed to load a much larger database >> > without >> > > a crash. I will try loading this smaller data set again with the >> > > Feb2010 release and report what happens. In the meantime, can >> > you give >> > > me some suggestions? >> > > >> > > Thanks. >> > > Hering >> > > >> > >> > Are you loading with a single COPY into or with several insert >> > into? >> > >> > Niels >> > >> > > >> > >> ------------------------------------------------------------------------------ >> > >> > > _______________________________________________ >> > > MonetDB-users mailing list >> > > MonetDB-users(a)lists.sourceforge.net >> > > https://lists.sourceforge.net/lists/listinfo/monetdb-users >> > >> > >> > -- >> > Niels Nes, Centrum Wiskunde & Informatica (CWI) >> > Science Park 123, 1098 XG Amsterdam, The Netherlands >> > room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl<sip%3A4098(a)sip.cwi.nl> >> > url: http://www.cwi.nl/~niels <http://www.cwi.nl/%7Eniels> >> e-mail: Niels.Nes(a)cwi.nl >> > >> > >> >> -- >> Niels Nes, Centrum Wiskunde & Informatica (CWI) >> Science Park 123, 1098 XG Amsterdam, The Netherlands >> room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl<sip%3A4098(a)sip.cwi.nl> >> url: http://www.cwi.nl/~niels <http://www.cwi.nl/%7Eniels> e-mail: >> Niels.Nes(a)cwi.nl >> > >

2 3

[MonetDB-users] copy into file
by dariuszs 22 Apr '10

22 Apr '10

Hi, It looks like the same problem exists no matter what the OS (Fedora 12 or Ubuntu 9.10 or Windows) and this worked in Nov2009-SP1 release. When you try: sql>copy select * from table1 limit 1000 into '/tmp/output.txt'; MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = copy select * from table1 limit 1000 into '/tmp/output.txt'; ERROR = !Connection terminated Timer 1105.876 msec You have mail in /var/spool/mail/root [root@monetdb ~]# [root@monetdb /]# mserver5 --version MonetDB server v5.18.3 (64-bit), based on kernel v1.36.3 (64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Found 47.3GiB available memory, 16 available cpu cores Configured for prefix: /usr Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0-beta4 10 Nov 2009 (compiled with OpenSSL 1.0.0-fips-beta4 10 Nov 2009) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: mockbuild@ (x86_64-redhat-linux-gnu) Compilation: gcc -O2 -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 : ld -IPA -m elf_x86_64 Please help. Thanks. Dariusz.

4 27

[MonetDB-users] SQL constraints and performance
by Isidor Zeuner 22 Apr '10

22 Apr '10

Dear MonetDB developers, from my own experiences regarding database engine design, I know that SQL constraints can be used to increase performance because the query planner can use them to reason about certain regularities in the data. On the other hand, they come with a cost as the engine is supposed to enforce them. Are there any common rules on how constraints and performance correlate in MonetDB, which could be used to adapt a schema to work especially fast with MonetDB? Best regards, Isidor

1 0

[MonetDB-users] Core Dump upon COPY on SPARC
by Hering Cheng 21 Apr '10

21 Apr '10

Hi, I am trying to load 77 GB of data (or 34,274,958 records) into MonetDB, using the Feb2010 SP1 source code compiled on Solaris SPARC with Sun Studio 12.1 compiler with debugging enabled, and the database crashes 5 hours into the loading. Here is some information about my configuration: I start up with Merovingian like this: $ ( ulimit -d $[32*1024*1024]; export LD_PRELOAD_64=/usr/lib/64/libumem.so:${LD_PRELOAD_64}; export LD_PRELOAD=/usr/lib/libumem.so:${LD_PRELOAD}; export MONETDB5CONF=/GAAL/chenher/rdcuxsrv220-local-disk/chenher/monetdb/feb2010sp1/etc/monetdb5.conf; /GAAL/chenher/share/monetdb/distro-sparc-feb2010-sp1-64bit/bin/merovingian; ) Here are the relevent log sections: 2010-04-16 13:25:28 MSG merovingian[4302]: starting database 'tar', up min/avg/max: 4m/4m/4m, crash average: 0.00 0.00 0.00 (1-1=0) 2010-04-16 13:25:29 MSG tar[15594]: arguments: /GAAL/chenher/share/monetdb/distro-sparc-feb2010-sp1-64bit/bin/mserver5 --config=/GAAL/chenher/rdcuxsrv220-local-disk/chenher/monetdb/feb2010sp1/etc/monetdb5.conf --dbname=tar --dbinit=include sql; --set merovingian_uri=mapi:monetdb://rdcuxsrv220:50000/tar --set monet_daemon=yes --set mapi_open=false --set mapi_autosense=true --set mapi_port=50001 --set monet_vault_key=/GAAL/chenher/rdcuxsrv220-local-disk/chenher/monetdb/feb2010sp1/var/MonetDB5/dbfarm/tar/.vaultkey --set sql_optimizer=default_pipe 2010-04-16 13:25:34 MSG tar[15594]: # MonetDB server v5.18.3, based on kernel v1.36.3 2010-04-16 13:25:34 MSG tar[15594]: # Serving database 'tar', using 16 threads 2010-04-16 13:25:34 MSG tar[15594]: # Compiled for sparc-sun-solaris2.10/64bit with 64bit OIDs dynamically linked 2010-04-16 13:25:34 MSG tar[15594]: # Found 32.000 GiB available main-memory. 2010-04-16 13:25:34 MSG tar[15594]: # Copyright (c) 1993-July 2008 CWI. 2010-04-16 13:25:34 MSG tar[15594]: # Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved 2010-04-16 13:25:34 MSG tar[15594]: # Visit http://monetdb.cwi.nl/ for further information 2010-04-16 13:25:34 MSG tar[15594]: # Listening for connection requests on mapi:monetdb://127.0.0.1:50001/ 2010-04-16 13:25:35 MSG tar[15594]: # MonetDB/SQL module v2.36.3 loaded 2010-04-16 13:25:35 MSG control[4302]: rdcuxsrv220:58146: started database 'tar' ... 2010-04-21 10:23:37 MSG merovingian[4302]: database 'tar' (15594) has crashed (dumped core) Using Sun's DBX tool to examine the crash: ... t@212 (l@212) terminated by signal SEGV (no mapping at the fault address) Current function is temp_create 87 temp_dup(b->batCacheid); (dbx) where current thread: t@212 =>[1] temp_create(b = (nil)), line 87 in "bat_utils.c" [2] ebat2real(b = 5714, ibase = 0), line 162 in "bat_utils.c" [3] delta_append_bat(bat = 0x104923c98, i = 0x10143ec98), line 234 in "bat_storage.c" [4] append_col(tr = 0x104fe1e98, c = 0x1045c7af8, i = 0x10143ec98, tpe = 5), line 267 in "bat_storage.c" [5] mvc_append_wrap(cntxt = 0xffffffff7f352c00, mb = 0x1050d5d98, stk = 0x101816018, pci = 0x1056a7c18), line 1120 in "sql.c" [6] runMALsequence(cntxt = 0xffffffff7f352c00, mb = 0x1050d5d98, startpc = 1, stoppc = 0, stk = 0x101816018, env = (nil), pcicaller = (nil)), line 2908 in "mal_interpreter.c" [7] callMAL(cntxt = 0xffffffff7f352c00, mb = 0x1050d5d98, env = 0xfffffffddabff908, argv = 0xfffffffddabff968, debug = '\0'), line 402 in "mal_interpreter.c" [8] SQLexecutePrepared(c = 0xffffffff7f352c00, be = 0x1050f0ec8, q = 0x104fe1b18), line 1196 in "sql_scenario.c" [9] SQLengineIntern(c = 0xffffffff7f352c00, be = 0x1050f0ec8), line 1249 in "sql_scenario.c" [10] SQLengine(c = 0xffffffff7f352c00), line 1349 in "sql_scenario.c" [11] runPhase(c = 0xffffffff7f352c00, phase = 4), line 363 in "mal_scenario.c" [12] runScenarioBody(c = 0xffffffff7f352c00), line 412 in "mal_scenario.c" [13] runScenario(c = 0xffffffff7f352c00), line 438 in "mal_scenario.c" [14] MSserveClient(dummy = 0xffffffff7f352c00), line 368 in "mal_session.c" (dbx) threads t@1 a l@1 ?() LWP suspended in __pollsys() t@2 a l@2 SERVERlistenThread() LWP suspended in __pollsys() t@3 a l@3 mvc_logmanager() LWP suspended in __pollsys() t@4 b l@4 umem_update_thread() sleep on (unknown) in __lwp_park() t@13 a l@13 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@14 a l@14 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@15 a l@15 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@16 a l@16 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@17 a l@17 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@18 a l@18 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@19 a l@19 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@20 a l@20 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@21 a l@21 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@22 a l@22 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@23 a l@23 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@24 a l@24 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@25 a l@25 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@26 a l@26 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@27 a l@27 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() t@28 a l@28 runDFLOWworker() sleep on 0x101ea9a48 in __lwp_park() o> t@212 a l@212 ?() signal SIGSEGV in temp_create() With Feb2010 release, I managed to load a much larger database without a crash. I will try loading this smaller data set again with the Feb2010 release and report what happens. In the meantime, can you give me some suggestions? Thanks. Hering

2 1

[MonetDB-users] Feb2010-SP1/Fedora 12/Ubuntu 9.10/Windows - creating output problem
by dariuszs 21 Apr '10

21 Apr '10

Hi, It looks like the same problem exists no matter what the OS (Fedora 12 or Ubuntu 9.10 or Windows) and this worked in Nov2009-SP1 release. When you try: 'copy select * from table1 limit 1000 into '/tmp/output.txt' You get: sql>copy select * from plk100 limit 1000 into '/tmp/output.txt'; MAPI = monetdb@localhost:50000 ACTION= read_line QUERY = copy select * from plk100 limit 1000 into '/tmp/output.txt'; ERROR = !Connection terminated Timer 1105.876 msec You have mail in /var/spool/mail/root [root@monetdb ~]# [root@monetdb /]# mserver5 --version MonetDB server v5.18.3 (64-bit), based on kernel v1.36.3 (64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Found 47.3GiB available memory, 16 available cpu cores Configured for prefix: /usr Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 1.0.0-beta4 10 Nov 2009 (compiled with OpenSSL 1.0.0-fips-beta4 10 Nov 2009) libxml2: 2.7.6 (compiled with 2.7.6) Compiled by: mockbuild@ (x86_64-redhat-linux-gnu) Compilation: gcc -O2 -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 : ld -IPA -m elf_x86_64 Please help. Thanks. Dariusz.

1 0

[MonetDB-users] monetdb/merovingian
by dariuszs 20 Apr '10

20 Apr '10

Hi, I've got this messages after rebooting the server and trying to start merovingian again: unable to open '/var/run/MonetDB/merovingian.pid' for writing: No such file or directory Software: Ubuntu 9.10 MonetDB server v5.18.3 (64-bit), based on kernel v1.36.3 (64-bit oids) Please help. Dariusz.

5 12

[MonetDB-users] Python Error
by Matthew Jones 20 Apr '10

20 Apr '10

Hey folks, I'm seeing an error in the Python API. When connecting to a remote Monet instance with the python client and setting the cursor's arraysize to something significant (100, as an example) then I get the following error: Traceback (most recent call last): File "afile.py", line 9, in <module> cur.execute("SELECT max(val), otherval" File "build/bdist.linux-x86_64/egg/monetdb/sql/cursors.py", line 203, in execute File "build/bdist.linux-x86_64/egg/monetdb/sql/cursors.py", line 445, in __store_result File "build/bdist.linux-x86_64/egg/monetdb/sql/cursors.py", line 529, in __parse_tuple File "build/bdist.linux-x86_64/egg/monetdb/sql/cursors.py", line 569, in __exception_handler monetdb.monetdb_exceptions.InterfaceError: length of row doesn't match header This doesn't happen when the client is used locally on the machine running the database. I will open a bug about this, also. It prevents the .arraysize cursor property from being used remotely. It's default value is 1, which causes the server to take a ridiculously long time to send back large data sets. 73, Matthew W. Jones (KI4ZIB) http://matburt.net

2 1

[MonetDB-users] Foreign key validation issue with "COPY INTO..." ?
by Matthieu Guamis 19 Apr '10

19 Apr '10

Hello, "COPY INTO" command fails with "FOREIGN KEY constraint 'xxx' violated" whereas "INSERT INTO" succeeded. Simple 3 tables example (it works with 2 tables, one referencing the other): CREATE TABLE a ( a1 VARCHAR(3) NOT NULL, CONSTRAINT pka PRIMARY KEY (a1) ); CREATE TABLE b ( b1 VARCHAR(3) NOT NULL, b2 VARCHAR(3) NOT NULL, CONSTRAINT pkb PRIMARY KEY (b1,b2), CONSTRAINT fk1 FOREIGN KEY (b2) REFERENCES a (a1) ); CREATE TABLE c ( c1 varchar(3) NOT NULL, c2 varchar(3) NOT NULL, c3 varchar(3), CONSTRAINT pkc PRIMARY KEY (c1,c2), CONSTRAINT fk2 FOREIGN KEY (c2) REFERENCES a (a1), CONSTRAINT fk3 FOREIGN KEY (c2,c3) REFERENCES b (b1,b2) ); Using INSERT INTO: sql>insert into a values ('aaa'); 1 affected row sql>insert into c values ('cc1','aaa',null); 1 affected row Using COPY INTO with one line input file "test.txt" containing : cc2|aaa| sql>COPY INTO c FROM '/home/mat/test.txt' USING DELIMITERS '|',' more>' NULL as ''; SQLException:assert:INSERT INTO: FOREIGN KEY constraint 'c.fk3' violated Bug or misunderstanding? Thanks a lot, Matthieu PS: mserver5 --version MonetDB server v5.18.3 (64-bit), based on kernel v1.36.3 (64-bit oids) Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008-2010 MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Found 2.0GiB available memory, 2 available cpu cores Configured for prefix: /usr Libraries: libpcre: 7.8 2008-09-05 (compiled with 7.8) openssl: OpenSSL 0.9.8g 19 Oct 2007 (compiled with OpenSSL 0.9.8g 19 Oct 2007) libxml2: 2.7.5 (compiled with 2.7.5) Compiled by: root@ubuntu-karmic-64 (x86_64-pc-linux-gnu) Compilation: gcc -O2 -Wall -O2 -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 : ld -IPA -m elf_x86_64 -Wl,-Bsymbolic-functions

4 4

[MonetDB-users] XRPC queries do not behave like Mclient queries
by Ryad Ben-El-Kezadri 16 Apr '10

16 Apr '10

Hello, 1°)I am querying Monetdb through the XRPC java API. I have implemented a xquery in a function in a XRPC module and I call it from java. I noticed that my XRPC module is not loaded when the xquery compares an attribute to an integer value (for instance $n[@attr=1]) In this case, I get the following error message embedded in the XRPC reply: Error occurred during execution fatal error: function #pf:number is not supported. xquery_module_load: could not load module. Comparing an attribute to a string works fine however (ex $n[@attr="1"]) 2°)What is strange is that the same function (fct) works perfect when I call it from the Mclient (instead of java). Example import module namespace f="xrpc-extract-function" at " http://127.0.0.1:50001/export/extract.xq"; f:fct("file.xml", 0, 1000000) 3°)I don't know if this problem is general or specifically related to my configuration. Indeed I had to load the server modules myself (else the server crashes) with the following command in the bat server script: "%MONETDB%\bin\Mserver.exe" --dbinit="module(pf_support);module(logger);module(xrpc_client);module(xrpc_server);module(pf_standoff);module(mkey);module(pathfinder);module(mapi);" --set "prefix=%MONETDB%" --set "exec_prefix=%MONETDB%" %MONETDBFARM% %* Your help will be really helpful, because right now I can only do string comparisons on attributes (which slows the program a lot,....). My guess is that, when invoked from java, Monetdb looks (at load time) for pf:number instead of fn:number to convert the string value of the attribute, but that this function does not exist Warm regards Ryad ////////////////////////////////////////// Here is my java call, I guess it is exaclty the same signature that with the Mclient (so there is no problem with it) String call = XRPCMessageMine.XRPC_SEQ(XRPCMessageMine.XRPC_ATOM("string", file)) + XRPCMessageMine.XRPC_SEQ(XRPCMessageMine.XRPC_ATOM("double", Double.toString(timeInterval[0]))) + XRPCMessageMine.XRPC_SEQ(XRPCMessageMine.XRPC_ATOM("double", Double.toString(timeInterval[1])));

1 0

[MonetDB-users] monetdb sql - same query different results
by dariuszs 16 Apr '10

16 Apr '10

Hi, Same query produces different results: sql>select count(*) from plk100 WHERE 0=0 and c15 in (select zip from zip_list) and ( c102 in ('1','0')) and ( c28 in ('1','0')) and ( c66 in ('01')); +-------+ | L73 | +=======+ | 14945 | +-------+ 1 tuple Timer 69.446 msec 1 rows sql>select count(*) from plk100 WHERE 0=0 and c15 in (select zip from zip_list) and ( c102 in ('1','0')) and ( c28 in ('1','0')) and ( c66 in ('01')); +-------+ | L73 | +=======+ | 57257 | +-------+ 1 tuple Timer 146.666 msec 1 rows sql> Please help.

2 8

[MonetDB-users] monetdb python API, howto install
by Martin Körner 16 Apr '10

16 Apr '10

Hello Guys, i have installed the MonetDB 5 SQL client-server package from http://monetdb.cwi.nl/downloads/Windows/Feb2010-SP1/ The downloaded file was MonetDB5-SQL-Installer-i386-20100322.msi. So i use a Windows XP 32bit system. My installed Python version is now 2.6. Now i want to access MonetDB with Python. But i found no way to install the MonetDB Python API. I tried it like it is shown on http://monetdb.cwi.nl/SQL/Documentation/The-Python-Library.html But there is no file 'setup.py' to install. Is there any other way to install the API? Where i can download an install package for the API? With best greetings from Germany, Martin -- heidemann added insight GmbH In der Weidbach 2 63477 Maintal Telefon: +49 6181 9080739 Internet: www.added-insight.com USt-Id DE 2130 86 540 Registernummer: HRB 91533 (Amtsgericht Hanau) Geschäftsführer: Dr. Jeffrey Heidemann ********************************************************************* Diese E-Mail kann vertrauliche und/oder rechtlich geschuetzte Informationen enthalten. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtuemlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. **********************************************************************

1 1

[MonetDB-users] MonetDB/XQuey - how to ignore DTDs?
by Roberto Cornacchia 15 Apr '10

15 Apr '10

Hi all, I wonder is there is an option to make MonetDB/XQuery shredder ignore DTD files. What triggered this question is the need to shred about 20M files, each of them including *the same* online DTD. What happens is that, for each xml file, the DTD is downloaded and shredded/used(?). It is not even cached (I tried using xquery_cacherules, but apparently it has no effect on DTDs). This makes shredding speed drop down to more than 3 seconds per document, which is not an option of course, as it would take me roughly 700 days to shred the entire collection :) Removing DTD link from the original xml files is not an option either, the collection is simply too big to be replicated. How can the DTD be ignored? Roberto -- | M.Sc. Roberto Cornacchia | CWI (Centrum voor Wiskunde en Informatica) | Science Park 123, 1098XG Amsterdam, The Netherlands | tel: +31 20 592 4322 , http://www.cwi.nl/~roberto

4 4

[MonetDB-users] grouping sets
by Nafees Ur Rehman 15 Apr '10

15 Apr '10

Hi, Whats is the syntax of grouping sets in monetdb? I am trying Select has_nurs,form,health,class,count(*) from nursery group by GROUPING SETS ((has_nurs,class),(form,class),(health,class)) but it does not work Regards Nafees Ur Rehman

3 3

Re: [MonetDB-users] [Monetdb-developers] MonetDB memory management
by Stefan de Konink 15 Apr '10

15 Apr '10

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Op 15-04-10 11:00, Xiao Lei schreef: > Then how can i release the memory? By not posting to me directly but reply to the mailinglist ;) It will not directly solve your problem, but keep other people in the loop. Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.14 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEAREKAAYFAkvG238ACgkQYH1+F2Rqwn1xdwCeOxnqWgALhsk4ue2vEv/D/ZsM IC0AnRyRAUabgy7Z2u2UZHGOXl4EJLYS =fsie -----END PGP SIGNATURE-----

2 1