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: Closed
>Resolution: Out of Date
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Wouter Alink (vzzzbx)
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-03-05 12:01

Message:
Logged In: YES 
user_id=621590
Originator: YES

I can't reproduce this bug with the new supertarball. (i'm closing it)

----------------------------------------------------------------------

Comment By: Sjoerd Mullender (sjoerd)
Date: 2007-03-01 11:39

Message:
Logged In: YES 
user_id=43607
Originator: NO

I think this bug was fixed in CVS on Feb 2.  Unless you can reproduce this
with the current release, MonetDB5 5.0.0_beta2, I would suggest that we
close this bug.

----------------------------------------------------------------------

Comment By: Fabian (mr-meltdown)
Date: 2007-02-28 14:32

Message:
Logged In: YES 
user_id=963970
Originator: NO

We only updated the website this morning, so you have an old version. 
Sorry.

----------------------------------------------------------------------

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

Reply via email to