Bugs item #2144912, was opened at 2008-10-03 21:18 Message generated for change (Comment added) made by stmane You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2144912&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: None Group: MonetDB4 "stable" Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: marspluto (juntezhang) Assigned to: Ying Zhang (yingying) Summary: ERROR = !ERROR: CMDtj_throw2collection: operation failed. Initial Comment: I am trying to restore a database that was backed up. I used the admin GUI, but it is not very stable, likely because of my libxml2 version... So I am trying to do it directly in the mclient. The backup seems to be going ok. $mclient -lx xquery>import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/"; at "/home/xxx/mdb/share/MonetDB/xrpc/admin/admin.xq"; adm:backup("backup1") more><> I then delete everything in the current database, which was in my case the collection "KB". xquery>import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/"; at "/home/xxx/mdb/share/MonetDB/xrpc/admin/admin.xq"; adm:del-col("KB") more><> Then I try to restore the backed up database. However, I get an error when I try to restore: import module namespace adm = "http://monetdb.cwi.nl/XQuery/admin/"; at "/home/xxx/mdb/share/MonetDB/xrpc/admin/admin.xq"; adm:restore("backup1", 10) more><> ERROR = !ERROR: CMDtj_throw2collection: operation failed. I noticed that this error was occurring after I was figuring out why a backed up database was not working when importing it on another computer using the Admin GUI (only giving me errors while executing queries). I tried to restore the database on the same computer using the Admin GUI, and it was also not working. So I used the mclient directly, and it gave me that error. I would like to backup a database. I also would like to share that database with someone else, and share it between computers with different versions of MonetDB. The sum size of my files is about 1GB, consisting of a few million library records in pretty flat structure. Thanks, junte ---------------------------------------------------------------------- >Comment By: Stefan Manegold (stmane) Date: 2009-08-11 11:17 Message: The order differences occur only without property checking (i.e., "-d0" instead of "-d1[0]"); hence, I guess they are triggered by some sortedness property only being set with property checking enabled. There is no (easy) way to make testing ignore the order differences (assuming they are indeed acceptable, i.e., semantically correct). One solution would be to ensure deterministic order in all cases, i.e., by adding an "order by" ... ---------------------------------------------------------------------- Comment By: Ying Zhang (yingying) Date: 2009-08-06 15:40 Message: The problem is not showing up in the systems currently tested, hence, closing I think the output is normal, because I get the same output by directly calling pf:documents-unsafe($colname) using MPS and Algebra. How can I mark the order differences as acceptable? ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2009-08-05 13:55 Message: Given that the xrpc/admin tests seem to work (except for order differences on Fedora10, GNU.64.64.d.0), what is the status of this bug? ---------------------------------------------------------------------- Comment By: Ying Zhang (yingying) Date: 2009-02-17 16:29 Message: This case is tested by the test: runtime/xrpc/admin/backup_restore This test times out om Fedora 8 variants: http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/GNU.64.32.d.1-Fedora8/runtime_xrpc_admin/backup_restore.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/GNU.64.64.d.0-Fedora8/runtime_xrpc_admin/backup_restore.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/GNU.64.64.d.1-Fedora8/runtime_xrpc_admin/backup_restore.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/GNU.64.64.s.1-Fedora8/runtime_xrpc_admin/backup_restore.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/Int.64.32.d.1-Fedora8/runtime_xrpc_admin/backup_restore.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/Int.64.64.d.1-Fedora8/runtime_xrpc_admin/backup_restore.err.00.html On Windows, it fails with a syntax error http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/Int.32.32.d.1-Windows5.1/runtime_xrpc_admin/db_stats_noxrpc.err.00.html http://monetdb.cwi.nl/testing/projects/monetdb/Stable/pathfinder/.mTestsg103/Int.64.32.d.1-Windows5.2/runtime_xrpc_admin/db_stats_noxrpc.err.00.html These problems are related with the other bug: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2406824&group_id=56967 ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-17 13:08 Message: So, what do the xrpc admin tests say then? Is this problem reproducible, or does it work as expected? In the first case, please poin to the failing test the reproduces the problem, in the latter case, point to the succeeding test and close this one, e.g., with "works for me". Thanks. ---------------------------------------------------------------------- Comment By: Ying Zhang (yingying) Date: 2009-02-17 12:39 Message: Thanks for the reminder. However, there is no need to add a test for this case, as it is already covered by the admin function tests. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-02-15 21:38 Message: Jennie, since you already tried to reproduce the problem, you you please add a test for it? Then we can see how it works with the upcoming release ... Thanks! ---------------------------------------------------------------------- Comment By: marspluto (juntezhang) Date: 2008-10-15 13:10 Message: Hi Jennie, - how did you install monetdb/xquery? I installed the June release from CVS. - which OS are you using Fedora Core 6 (desktop) and FC 9 on the server. - specification of your machine. Desktop: Intel D 3GHZ, 2GB main memory, 250GB harddisk. Server: Quad Core, 16GB main memory, 6x500GB. If you need more information, let me know. junte ---------------------------------------------------------------------- Comment By: Ying Zhang (yingying) Date: 2008-10-07 11:20 Message: Hello Junte, I tried your query on with the stable version (compiled from cvs source) on a 64bits AMD machine with Fedora 8, but I could not reproduce your problem. Could you please give us more information about - how did you install monetdb/xquery? - which OS are you using - specification of your machine. Regards, Jennie ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2144912&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
