Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 7094 invoked from network); 12 Mar 2009 23:39:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Mar 2009 23:39:12 -0000 Received: (qmail 74135 invoked by uid 500); 12 Mar 2009 23:39:12 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 74107 invoked by uid 500); 12 Mar 2009 23:39:12 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 74098 invoked by uid 99); 12 Mar 2009 23:39:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Mar 2009 16:39:11 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Mar 2009 23:39:10 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 9CABD234C053 for ; Thu, 12 Mar 2009 16:38:50 -0700 (PDT) Message-ID: <213984062.1236901130640.JavaMail.jira@brutus> Date: Thu, 12 Mar 2009 16:38:50 -0700 (PDT) From: "Myrna van Lunteren (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4075) ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)) when running MailJdbc (Embedded) system tests In-Reply-To: <489690741.1235684701893.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12681548#action_12681548 ] Myrna van Lunteren commented on DERBY-4075: ------------------------------------------- The run on linux failed after about 15 hours with some corruption occurring: - ERROR XSLAD: log Record at instant 6,347,963,620,272 in log file 1,478 corrupted . Expected log record length 0, real length 32,709. This run I ran without derby.properties, so the derby.log only has errors, not the full statement text, but there are these details around the time of the error: last error recorded before the XSLAD and around it: --------------------------------------------------------- 2009-03-12 08:59:51.164 GMT Thread[Refresh Thread,5,main] (XID = 373637), (SESSIONID = 1), (DATABASE = mailsdb), (DRDAID = null), Failed Statement is: insert into REFRESH.ATTACH (id,attach_id,attachment) values (?,?,?) with 3 parameters begin parameter #1: 3505 :end parameter begin parameter #2: 5 :end parameter begin parameter #3: BLOB(org.apache.derby.iapi.types.RawToBinaryFormatStream@2a062a06) :end parameter ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'ATTACH__PK' defined on 'ATTACH'. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:303) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(IndexChanger.java:439) at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(IndexChanger.java:383) at org.apache.derby.impl.sql.execute.IndexChanger.insert(IndexChanger.java:589) at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(IndexSetChanger.java:267) at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(RowChangerImpl.java:453) at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(InsertResultSet.java:1022) at org.apache.derby.impl.sql.execute.InsertResultSet.open(InsertResultSet.java:495) at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:416) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:297) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1235) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdateEmbedPreparedStatement.java:294) at org.apache.derbyTesting.system.mailjdbc.utils.DbTasks.insertMail(DbTasks.java:396) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.insertMail(Refresh.java:99) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.doWork(Refresh.java:75) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.run(Refresh.java:51) ------------ BEGIN SHUTDOWN ERROR STACK ------------- ERROR XSLAD: log Record at instant 6,347,963,620,272 in log file 1,478 corrupted. Expected log record length 0, real length 32,709. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:373) at org.apache.derby.impl.store.raw.log.Scan.getNextRecordBackward(Scan.java:376) at org.apache.derby.impl.store.raw.log.Scan.getNextRecord(Scan.java:204) at org.apache.derby.impl.store.raw.log.FileLogger.undo(FileLogger.java:939) at org.apache.derby.impl.store.raw.xact.Xact.popSavePoints(Xact.java:2209) at org.apache.derby.impl.store.raw.xact.Xact.rollbackToSavePoint(Xact.java:1562) at org.apache.derby.impl.store.access.RAMTransaction.rollbackToSavePoint(RAMTransaction.java:2022) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.internalRollbackToSavepoint(GenericLanguageConnectionContext.java:1512) at org.apache.derby.impl.sql.conn.GenericStatementContext.cleanupOnError(GenericStatementContext.java:578) at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(ContextManager.java:333) at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(TransactionResourceImpl.java:419) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleExceptionTransactionResourceImpl.java:337) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:294) at org.apache.derbyTesting.system.mailjdbc.utils.DbTasks.insertMail(DbTasks.java:396) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.insertMail(Refresh.java:99) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.doWork(Refresh.java:75) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.run(Refresh.java:51) ------------ END SHUTDOWN ERROR STACK ------------- New exception raised during cleanup Cannot rollback transaction 373637, trying to compensate Page Operation: Page(23062,Container(0, 1056)) pageVersion 10 : Update Slot=0 recordId=8 operation with null ERROR XSLA8: Cannot rollback transaction 373637, trying to compensate Page Operation: Page(23062,Container(0, 1056)) pageVersion 10 : Update Slot=0 recordId=operation with null at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:366) at org.apache.derby.impl.store.raw.log.FileLogger.undo(FileLogger.java:1046) at org.apache.derby.impl.store.raw.xact.Xact.popSavePoints(Xact.java:2209) at org.apache.derby.impl.store.raw.xact.Xact.rollbackToSavePoint(Xact.java:1562) at org.apache.derby.impl.store.access.RAMTransaction.rollbackToSavePoint(RAMTransaction.java:2022) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.internalRollbackToSavepoint(GenericLanguageConnectionContext.java:1512) at org.apache.derby.impl.sql.conn.GenericStatementContext.cleanupOnError (GenericStatementContext.java:578) at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(ContextManager.java:333) at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(TransactionResourceImpl.java:419) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleExceptionTransactionResourceImpl.java:337) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:294) at org.apache.derbyTesting.system.mailjdbc.utils.DbTasks.insertMail(DbTasks.java:396) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.insertMail(Refresh.java:99) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.doWork(Refresh.java:75) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.run(Refresh.java:51) ============= end nested exception, level (1) =========== 2009-03-12 08:59:52.752 GMT: Shutting down instance a816c00e-011f-f6a2-11a8-000000097630 ---------------------------------------------------------------- 2009-03-12 08:59:52.753 GMT Thread[Refresh Thread,5,main] Less severe exception raised during cleanup (ignored) An attempt was made to close a transaction that was still active. The transaction has been aborted. ERROR 40XT4: An attempt was made to close a transaction that was still active. The transaction has been aborted. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:276) at org.apache.derby.impl.store.raw.xact.Xact.close(Xact.java:1136) at org.apache.derby.impl.store.raw.xact.XactContext.cleanupOnError(XactContext.java:140) at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(ContextManager.java:333) at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(TransactionResourceImpl.java:419) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:337) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1323) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(EmbedPreparedStatement.java:1648) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(EmbedPreparedStatement.java:294) at org.apache.derbyTesting.system.mailjdbc.utils.DbTasks.insertMail(DbTasks.java:396) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.insertMail(Refresh.java:99) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.doWork(Refresh.java:75) at org.apache.derbyTesting.system.mailjdbc.tasks.Refresh.run(Refresh.java:51) Cleanup action completed > ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)) when running MailJdbc (Embedded) system tests > ------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-4075 > URL: https://issues.apache.org/jira/browse/DERBY-4075 > Project: Derby > Issue Type: Bug > Affects Versions: 10.5.0.0 > Environment: windows 2000 professional, ibm 1.6 (sr2), revision 10.5: 745360 > Reporter: Myrna van Lunteren > Priority: Blocker > Fix For: 10.5.0.0 > > Attachments: Activity.out, d4075_debugchange.diff, derbylog.zip, performance.out > > > I started the org.apache.derbyTesting.system.mailJdbc Embedded test and after about 1 day it ran into an apparently corrupted database. > 2009-02-19 14:02:44.221 GMT Thread[Refresh Thread,5,main] (XID = 349909), (SESSIONID = 1), (DATABASE = mailsdb), (DRDAID = null), Failed Statement is: insert into REFRESH.INBOX(from_name,to_name,date,Message,attach_id,size_problem) values (?,?,?,?,?,?) with 6 parameters begin parameter #1: ABCE :end parameter begin parameter #2: WXYY :end parameter begin parameter #3: 2009-02-19 06:02:43.705 :end parameter begin parameter #4: CLOB(org.apache.derby.iapi.types.ReaderToUTF8Stream@41ba41ba) :end parameter begin parameter #5: 0 :end parameter begin parameter #6: This column is used only to by pass the space problem. If the problem still exists, then we are going to have a serious issue here.***************************************************************************************************** :end parameter > ERROR XSDBB: Unknown page format at page Page(613,Container(0, 1024)), page dump follows: Hex dump: > The error up to that point appear to me no different from other errors that this test is expected to produce (40001, 23505, 4XL01) except that the very first error is a grant error. > I think we can't have a release until this corruption is explained away or fixed. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.