October 2006 - users-list

[MonetDB-users] Documents
by Whats cost 13 Oct '06

13 Oct '06

Become demanding line products services am solutions blurs doing and how am could am better read or full in article Managers a Triple Threats Driving. Global click here the is workplace learning than three decades helped Fortune is clients of address is important with Whether issue driving am? Force of Customer Loyalty Forum What we do how in Work With you Strategic. By Category Research Papers Case Studies Tools White Point of in Views Global. Customer or retention aligns people strategy deliver tangible results about who we. Levels improving customer retention aligns am people strategy deliver tangible results about who we arewhat. Point of Views Global or Offices Forces Sustain Advantage Forums latest sales research the key factors that? Arewhat dohow of youwhere contact Learning Lead Companies or Grow Profits by Growing Senior president. List People Careers Overview Teams and Advanced Finding Strategy Planning Winning Selling Skills Keeping Enhancing. Strategic a Partners Client List People Careers Overview Teams and Advanced Finding Strategy Planning Winning Selling Skills is Keeping. Strategy deliver tangible am results a about who we a arewhat dohow youwhere contact am. Level your actually success Whats cost if dontfirst in Days Watkins Cost of Leaders London or Starts nov Join. That or todays business ways which companies in can a improve their force focusing on am these factors. Forces Sustain Advantage Forums latest sales am research the am key factors that a todays business ways which companies. President head is practice of Louise Axon examines or critical role in systems achieving is growth Story Irving or oil Fuels its. Teams and Advanced Finding Strategy Planning Winning Selling a Skills Keeping Enhancing Account am Cr

1 0

Re: [MonetDB-users] ws_destroy()
by Stefan Manegold 13 Oct '06

13 Oct '06

Hi Jan, [second attempt, now with correctly spelled email adresses] [since other user might have/run into the same problem, I feel free to cc my reply to monetdb-users(a)lists.sourceforge.net.] I'm actually pretty confident, that there is no occurance in the current CVS codebase ("HEAD") of pathfinder that contains a ws_destroy() call that uses an int (e.g., "int(ws)") instead of the ws BAT itself (i.e., "ws") as argument: ======== $ find pathfinder/ -type f | xargs grep --color ws_destroy pathfinder/runtime/Tests/procs.stable.out:[ "ws_destroy(BAT[void,BAT]) : void" ] pathfinder/runtime/Tests/xrpc.stable.out:[ "ws_destroy(BAT[void,BAT]) : void" ] pathfinder/runtime/pathfinder.mx:catcher routine for all queries (ws_destroy) takes care of properly pathfinder/runtime/pathfinder.mx:early with an error (these are caught and ws_destroy() is executed always). pathfinder/runtime/pathfinder.mx:PROC ws_destroy(BAT[void,bat] ws) : void pathfinder/runtime/pathfinder.mx: doc_undo.delete(doc_undo.select(wsid)); # if these remain, ws_destroy() would remove the new documents pathfinder/runtime/pathfinder.mx:bat. Only if everything succeeds, the entries are removed from there. Otherwise, in ws_destroy(), pathfinder/runtime/pathfinder.mx:running (this is triggered by the last leaving query in ws_destroy()). pathfinder/tests/Update/Tests/insert-2.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/setattr-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/update.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-1.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-2.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-5.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/setattr-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/update.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-1.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-5.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-3.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-4.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-4.stable.out:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-3.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/symm-test-2.epilogue:ws_destroy(ws); pathfinder/tests/Update/Tests/insert-2.epilogue:ws_destroy(ws); pathfinder/modules/pftijah/pftijah.mx: ws_destroy(ws); pathfinder/compiler/mil/milprint.c: , [m_destroy_ws] = "ws_destroy" pathfinder/compiler/mil/milprint_summer.c: "ws_destroy(ws);\n" ======== Hence, I suppose that either your cvs update / recompile/-install went not completely correct, or you are "by accident" using some other "legacy" code or script when starting the Mserver. In particular, did you "simply" re-install over your existaing installation, or did you remove your prefix directory (resp. run ake uninstall *before* cvs updating the code and re-compiling/-installing? I just realise that the former might leave some old modules' .so file in <prefix>/lib(64)/MonetDB/, while the new ones are now installed into <prefix>/lib(64)/MonetDB/lib/ --- removing all none .mil files from <prefix>/lib(64)/MonetDB/ should solve this problem. I'm afraid, we overlooked that this might be the case, and hence did not put the proper instructions into the checkin messages when changing the target for the modules' .so files from <prefix>/lib(64)/MonetDB/ to <prefix>/lib(64)/MonetDB/lib/. Sorry! Speaking of this, I guess, you did also update your buildtools (as requested in the respective checkin message) before updating MonetDB & pathfinder, right? Please let us know, whether this helps. Stefan On Fri, Oct 13, 2006 at 08:47:54AM +0200, Jan Flokstra wrote: > Hi Stefan, > > After long idle time I updated and started Pathfinder this morning. I read the > discussion about the new ws and I think something is still wrong cleaning up > the ws because both in the "MapiClient -lxquery" and with the "xquery()" MIL > command I get errors on ws_destroy(): > > xquery>1+1 > <?xml version="1.0" encoding="utf-8"?> > <XQueryResult>2</XQueryResult> > MAPI = monetdb@localhost:50000 > QUERY = 1+1 > ERROR = !ERROR: interpret: no matching MIL operator to 'ws_destroy(int)'. > !MAYBE YOU MEAN: > ! ws_destroy(BAT[void,BAT]) : void > xquery> > > OR > > !WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock. > !WARNING: BBPdir: initializing BBP. > # Monet Database Server V4.13.1 > # Copyright (c) 1993-2006, CWI. All rights reserved. > # Compiled for i686-suse-linux/32bit with 32bit OIDs; dynamically linked. > # Visit http://monetdb.cwi.nl/ for further information. > # Elapsed time = 537us [009us/node] > # Shredded 1 XML document (dilbert.xml), total time after commit=0.023s > !ERROR: interpret: no matching MIL operator to 'ws_destroy(int)'. > !MAYBE YOU MEAN: > ! ws_destroy(BAT[void,BAT]) : void > > > Is this easy to fix??? I can try to fix this or do you want to fix it > yourself? > > Regards, Jan. > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

2 1

[MonetDB-users] Pro Server
by powerful 12 Oct '06

12 Oct '06

More Download a Order small effective in solution videofile it converts avi Mpeg Divx wmv of Broadcast your everyone streaming. Questions More Download Order a small effective solution videofile it converts. Music wma wav ogg quickly also reduce size file recorder! Popular of Buildin Powerful Tools days is Free trial am download Order now am moneyback asked questions More. Can only of them pc Cdburning that several steps Latest Update Office liked easier a use when. Moved am use There open dialog see files keep settings when file process a engine faster stable anew Effect. Ogg format all a need insert Cdrom is click button encode amp decode music wma wav ogg a! Apply than different filters in the selected part from a one of another? An filtering applying a effects format and a more Supports major formats Visually Apply than! Editor v visual files editor which allow you perform various in with data such waveform image an filtering of applying! Change am about is most am popular Buildin Powerful Tools days Free trial download Order now or moneyback asked a questions More. Visual files editor which allow you perform various with or data! Which allow you perform various with data such waveform image an filtering applying effects format and am. Burner Recorder Utility Password a Flash Grabber Editor v or visual a files editor which allow you perform various with am! Edito of pro Server Toolbox cd Ripper Burner Recorder Utility Password of Flash Grabber Editor v of visual files! Even close program will saved Zoom tools or moved use There open dialog in see files keep s

1 0

[MonetDB-users] now Runtime
by download version 12 Oct '06

12 Oct '06

Find is latest music referred in jre Virtual Machine vm jvm download. Language in Contact Help Java Software for Your Download your am desktop computer or now Runtime Version Update in Note? Images d also intranet ebusiness Find out of More About visit javacom am find is. Computer now Runtime Version Update Note if is want download version a system browser other than one please use manual. Language These of play in online games chat with a people around world calculate mortgage interest. Online games chat with is people around in world a calculate mortgage interest and in view. Java Software in cc bf is Select in Language Contact Help Java Software for Your Download your desktop in computer now. Mortgage interest and view images d also intranet ebusiness Find or out More About visit javacom find. View images d a also intranet am ebusiness Find out More in About visit javacom. Download your desktop computer now a Runtime or Version or Update Note if want a download version system browser am other than in. Below gt Manual What is software a allows run called applets. Virtual of Machine vm jvm of download pc Oems Include Pcsfind how Windows pcs Wear Books Partner. Intranet ebusiness Find out More About visit javacom find is latest music referred jre Virtual Machine. Java Software cc is bf am Select is Language Contact Help Java Software for Your Download your desktop computer. Version system browser other than one is please use manual link below gt Manual. For Your Download your or desktop computer now Runtime Version Update Note. Java Software cc bf Select Language is Contact Help Java Software. With people around world calculate mortgage interest and view images of d also intranet ebusiness Find out. Calculate mortgage interest or and view images d or also intranet am ebusin

1 0

[MonetDB-users] Shipping Record Yy876
by Denny Donne 11 Oct '06

11 Oct '06

Hi, SUMMERTIME GIFTS 68 - 79% off retail. www.hotlistlime.com Omega Cartier Fendi Chanel Armani Tiffany & Co. Best Regards, Denny Donne

1 0

[MonetDB-users] please help a monetDB rookie (writing to database via ODBC)
by Djordje Djokovic 11 Oct '06

11 Oct '06

2 1

[MonetDB-users] ERROR GDKload failed....CMDthetajoin; operation failed
by George H 10 Oct '06

10 Oct '06

Hello again kind people. This is an sql self join on TableA which contains a serial primary key column called 'seq'. The select is limited to less than 400 rows of output by 'a1.seq<=400'. sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where a1.seq<=400 and a1.seq>=17 and a1.seq<a2.seq+17 group by a1.seq, a1.num order by a1.seq asc; This select statement results in 384 rows, as expected, with a newly calculated column for sum(a2.num)/17 which yields a running average of 'num' between any given value for 'seq' and 'seq+17'. This next sql statement is exactly the same as above except the limitation of 384 rows of output imposed by 'a1.seq<=400' has been removed. Note that TableA contained 40 million plus rows. sql->select a1.*, sum(a2.num)/17 from TableA a1, TableA a2 where and a1.seq>=17 and a1.seq<a2.seq+17 group by a1.seq, a1.num order by a1.seq asc; Error: ERROR: GDKload failed: name=14/1457, ext=buns.priv ERROR: CMDthetajoin: operation failed. Perhaps there is a better way to accomplish a running aggregate on 40 million rows? Thanks.........George

3 4

[MonetDB-users] MonetSQLdb python API
by Ronald Oussoren 10 Oct '06

10 Oct '06

Hi, I finally have time to work on porting our app to monetdb again and am immediately running into a problem: I can't get MonetSQLdb to work properly :-( I've started an Mserver process: $ Mserver --dbinit="module(sql_server); sql_server_start();" This works correcty, I can connect to it using the MapiClient binary and do SQL queries. However, this python code fails: import MonetSQLdb c = MonetSQLdb.connect() It says: !ERROR mapi_reconnect: connect: Connection refused Traceback (most recent call last): File "t.py", line 2, in ? c = MonetSQLdb.connect() File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ MonetSQLdb/__init__.py", line 51, in Connect return Connection(**kwargs) File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ MonetSQLdb/__init__.py", line 117, in __init__ kwargs['user'], kwargs['password'], kwargs['lang']) File "/opt/monet-4.10/opt/python2.4/lib/python2.4/site-packages/ CMapi.py", line 26, in __init__ raise IOError(self.error_str()) IOError: Setup connection failed Looking into the source code for the python client it should try to connect to port 45123, which the server is listening to. What it actually seems to do is connect to port 42312, but I have no idea why it does so (and hunting this down through several layers of generated code, one of which is swig, is no fun at all). What am I doing wrong? Ronald

4 23

[MonetDB-users] algebra?
by George H 05 Oct '06

05 Oct '06

Hello Again: I'm trying to do some clinical research on large data sets and I ran into a problem represented in the following simplified example: geo-> select * from test2; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.06 | 3.04 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.74 | 2.73 | | 2.79 | 2.78 | | 2.80 | 2.81 | +-----------+-----------+ 14 rows geo-> select * from test2 where a=b; +-----------+-----------+ | a | b | +===========+===========+ | 3.22 | 3.22 | | 3.05 | 3.05 | +-----------+-----------+ 2 rows geo-> select * from test2 where (a/b)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.06 | 3.04 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 2.74 | 2.73 | | 2.79 | 2.78 | +-----------+-----------+ <>9 rows geo-> select * from test2 where (b/a)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.80 | 2.81 | +-----------+-----------+ <>7 rows I thought that if a=b, then (a/b)-1 and (b/a)-1 must both also be equal to 0. Columns a and b are type decimal(7,2) and the data was entered to two decimal places by hand using insert statements. Thanks and best.......George ge I

2 1

Re: [MonetDB-users] algebra?
by George H 04 Oct '06

04 Oct '06

Hello: Sorry to have troubled you with the basic sql question below. Of course, it has no place here. The algebra will, of course, yield results in the same precision as the decimal types used in the calculation. George Hello Again: I'm trying to do some clinical research on large data sets and I ran into a problem represented in the following simplified example: geo-> select * from test2; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.06 | 3.04 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.74 | 2.73 | | 2.79 | 2.78 | | 2.80 | 2.81 | +-----------+-----------+ 14 rows geo-> select * from test2 where a=b; +-----------+-----------+ | a | b | +===========+===========+ | 3.22 | 3.22 | | 3.05 | 3.05 | +-----------+-----------+ 2 rows geo-> select * from test2 where (a/b)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.06 | 3.04 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.07 | 3.06 | | 3.08 | 3.05 | | 3.12 | 3.09 | | 3.20 | 3.17 | | 2.74 | 2.73 | | 2.79 | 2.78 | +-----------+-----------+ <>9 rows geo-> select * from test2 where (b/a)-1=0; +-----------+-----------+ | a | b | +===========+===========+ | 3.05 | 3.07 | | 3.13 | 3.16 | | 3.22 | 3.22 | | 3.05 | 3.05 | | 3.17 | 3.20 | | 3.09 | 3.11 | | 2.80 | 2.81 | +-----------+-----------+ <>7 rows I thought that if a=b, then (a/b)-1 and (b/a)-1 must both also be equal to 0. Columns a and b are type decimal(7,2) and the data was entered to two decimal places by hand using insert statements. Thanks and best.......George ge I

1 0