db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: corrupt database
Date Fri, 27 Jan 2012 16:48:36 GMT
Mojo Nixon <steve.b.ferguson@gmail.com> writes:

> I am no derby expert, but I have done the following before, with good
> results. Make a backup copy of all the database files, in case it doesn't
> work. Then delete the files in the log directory and try to boot the
> database. You might lose some transactions, but should be able to open the
> database again. 

If you do this there is no guarantee the database is in a transactionally
consistent state: some transactions may be half persisted, so do this at
your own risk, and vet the data after.

Dag


>
>
>
> loiewest wrote:
>> 
>> I have a database that won't open in ij or the application that uses it.
>> I get the message
>> ERROR XSLAO: Recovery failed unexpected problem log record is Not first
>> but transaction is not in transaction table : 1551743.
>> Any ideas as to how to fix this problem?
>> 

Mime
View raw message