I am working with WebSphere Process Server 6.1 which uses a Derby database by default. All worked well until now : I noted that several applications could not start as usual.. The exception which appears in my log is the following :
java.sql.SQLException: Failed to start database 'C:\IBM\WebSphere\ProcServer\profiles\ProcSrv01/databases/BPEDB', see the next exception for details.DSRA0010E: SQL State = XJ040, Error Code = 40,000
ERROR XSDB4: Page Page(1,Container(0, 7344)) is at version 165,588, the log file contains change version 167,691, either there are log records of this page missing, or this page did not get written out to disk properly.
Does anyone have a clue as to why all of a sudden I will be getting this error message?? I haven't changed anything in my settings or files, everything is the same that used to work.
Please let me know if anyone has seen this error before or know what I can do to fix it.
Thanks in advance for yout help,
Stan 120000HAGM267 Posts
Re: Derby Error XSDB42008-04-10T16:07:10ZThis is the accepted answer. This is the accepted answer.This indicates that the database has been corrupted - usually the only option is to recover from backup. The files in a database are a synchronized set and page versions are used in the transaction log to insure that the database files have not been changed (corrupted) unexpectedly. Some of external activities that can cause such an error is double booting the database or manually changing/deleting files in the database directory. I/O problems and hardware errors can also result in file corruption.
Have you had any serious failures on the machine? Have any tools or applications outside of process server been used to access the database?
I would recommend opening a support case with the Process Server group so they can investigate this failure more completely.
SystemAdmin 110000D4XK1525 Posts
Re: Derby Error XSDB42008-04-10T16:28:05ZThis is the accepted answer. This is the accepted answer.
- Stan 120000HAGM
No failures on the machine. But I noted that the problem started after a technical power cut. The machine was (carefully) shut down before, but at restarting, the error appeared...
No other application access the database...
I am beginner with Derby, but is it a way to recover this database in a correct state (I have not made any backup or anything else for it, but maybe it is automatically done by default?)...
Thanks for your answer..
Stan 120000HAGM267 Posts
Re: Derby Error XSDB42008-04-10T16:44:11ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
Title: Possible Data Loss After You Enable the "Write Cache Enabled"
Feature - http://support.microsoft.com/kb/281672