Bugs item #1670739, was opened at 2007-02-28 12:12 Message generated for change (Comment added) made by vzzzbx You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1670739&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: SQL/Core Group: MonetDB5 5.0_beta1 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Niels Nes (nielsnes) Summary: SQL: Corrupt database after restart Initial Comment: MonetDB5 (5.16.2, from SuperSourceBall, with SQL enabled) After a seamingly clean exit (using \q on the mserver command prompt) the database is corrupt. see output below. I think it has something to do with a (SQL) query that is still running in the background. I checked the rights on the BACKUP folder, but they are fine could it be that a slash is missing in: the destination path: bat/15/1556.desc instead of bat15/1556.desc? bash-3.1$ ./mserver5 --dbinit="include sql;" --config=/home/xiraf/monetdb5.conf # MonetDB Server v5.0.0_beta1 # Copyright (c) 1993-2007 CWI, all rights reserved # Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked # dbname:xiraf # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see /home/xiraf/monetdb5.conf) >\q bash-3.1$ ./mserver5 --dbinit="include sql;" --config=/home/xiraf/monetdb5.conf !ERROR: force_move: link(bat/BACKUP/1556.desc,bat15/1556.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat/BACKUP/2112.desc,bat21/2112.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat/BACKUP/1706.desc,bat17/1706.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat/BACKUP/1632.desc,bat16/1632.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat/BACKUP/1762.desc,bat17/1762.desc)=-1 !OS: No such file or directory !ERROR: force_move: link(bat/BACKUP/2036.desc,bat20/2036.desc)=-1 !OS: No such file or directory !ERROR: BBPrecover: recovery failed. Please check whether your disk is full or write-protected. !FATAL: BBPinit: cannot properly process bat/BACKUP. ---------------------------------------------------------------------- >Comment By: Wouter Alink (vzzzbx) Date: 2007-02-28 14:30 Message: Logged In: YES user_id=621590 Originator: YES i used the SuperSourceTarball that was on the monetdb.nl website yesterday and the monetdb_install.sh script with the option: --enable-sql. i recall some messages about this topic a few days ago on the user or developer list. I can reproduce it anytime (by stopping mserver after a query on a dataset of +- 1000000 tuples (a join on string-values)). removing the log-folder and the db-folder helps to get monetdb startup again. ---------------------------------------------------------------------- Comment By: Sjoerd Mullender (sjoerd) Date: 2007-02-28 12:58 Message: Logged In: YES user_id=43607 Originator: NO I cannot reproduce this. Did you build MonetDB5 yourself? Is your MonetDB up-to-date? There have been changes in the area of path separators, so if MonetDB5 and MonetDB don't agree, errors are possible. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1670739&group_id=56967 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
