Bugs item #2787609, was opened at 2009-05-05 21:28 Message generated for change (Comment added) made by wwinston You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787609&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: XML Group: MonetDB4 "stable" Status: Open Resolution: None Priority: 5 Private: No Submitted By: winston (wwinston) Assigned to: Nobody/Anonymous (nobody) Summary: Error loading XML documents into new database Initial Comment: Sorry to bother you again, but I am having problems loading documents. I tried loading documents two different ways and I get two different errors. BACKGROUND: After successfully loading several documents, monetDB crashed and damaged the database which is documented in bug report "crashes on shredding of large XML 1.2 GB XMark document - ID: 2785756" ACTION TAKEN: So I decided to reload the same files that I previously loaded successfully. I took these steps: (1) deleted all of the files and directories in %APPDATA%/monetDB, (2) reran the DB4-XQuery 20090324 Installer to REPAIR the MonetDB4 installation, (3) restarted MonetDB4 server per your instructions in Bug Report 2693363, and (4) attempted to reload the same documents that loaded OK previously. SERVER STARTUP: C:\MonetDB\MonetDB4>mserver # MonetDB Server v4.28.2 # based on GDK v1.28.2 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-, MonetDB B.V.. All rights reserved. # Compiled for i686-pc-win32/32bit with 32bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. MonetDB>module(mapi); MonetDB>module(pf_support); MonetDB>module(logger); MonetDB>module(mkey); MonetDB>module(xrpc_server); MonetDB>module(xrpc_client); MonetDB>module(pf_standoff); MonetDB>module(pathfinder); # PF/Tijah module v0.9.0 loaded. http://dbappl.cs.utwente.nl/pftijah # MonetDB/XQuery module v0.28.2 loaded (default back-end is 'algebra') # XRPC administrative console at http://127.0.0.1:50001/admin MonetDB> =x=x=x= This is the outcome for the FIRST ATTEMPT to load a document: C:\MonetDB\MonetDB4>mclient -l xquery xquery>pf:add-doc("C:\Projects\data\XMarkStandard\fact0.xml","fact0.xml","fact0") more><> MAPI = mone...@localhost:50000 QUERY = pf:add-doc("C:\Projects\data\XMarkStandard\fact0.xml","fact0.xml","fact0") ERROR = !ERROR: interpret: no matching MIL operator to 'ws_create(int)'. xquery> =x=x=x= This is the outcome for the SECOND ATTEMPT via the ADD DOCUMENT button on the WEB SERVER on Port 50001: !ERROR: "add-doc execution failed at the remote side" !ERROR: HTTP/1.1 404 !ERROR: HTTP Response: <?xml version="1.0" encoding="utf-8"?> <env:Envelope xmlns:env="http://www.w3.org/2003/05/soap-envelope";> <env:Body> <env:Fault> <env:Code> <env:Value>env:Sender</env:Value> </env:Code> <env:Reason> <env:Text xml:lang="en">Error occurred during execution. !ERROR: interpret: no matching MIL operator to 'usec()'. </env:Text> </env:Reason> </env:Fault> </env:Body> </env:Envelope> =x=x=x= Please advise. ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-05-06 21:03 Message: So, I am now able to load documents again from the server side, but when I issue queries from the client side, I get MIL errors. C:\MonetDB\MonetDB4>mclient -t -lx q1.xq MAPI = mone...@localhost:50000 QUERY = let $auction := doc("fact0.xml") return for $b in $auction//open_auction//listitem return $b ERROR = !ERROR: interpret: no matching MIL operator to 'usec()'. Timer 34.586 msec Press any key to continue . . . ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-05-06 20:48 Message: Correction: the server side needs to have the backslash escaped, ie, doubled, and a semi-colon is needed at the end of the line. MonetDB>shred_doc("C:\\Projects\\data\\XMarkStandard\\fact0.xml","fact0.xml"); ---------------------------------------------------------------------- Comment By: winston (wwinston) Date: 2009-05-06 20:46 Message: I am able to load documents on the server side when I use the shred_doc() server command. MonetDB>shred_doc("C:\Projects\data\XMarkStandard\fact0.xml","fact0.xml"); ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787609&group_id=56967 ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
