Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 76963 invoked from network); 18 May 2009 16:59:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 18 May 2009 16:59:11 -0000 Received: (qmail 8084 invoked by uid 500); 18 May 2009 16:59:11 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 8033 invoked by uid 500); 18 May 2009 16:59:11 -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 8025 invoked by uid 99); 18 May 2009 16:59:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 May 2009 16:59:11 +0000 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; Mon, 18 May 2009 16:59:07 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 875B3234C004 for ; Mon, 18 May 2009 09:58:45 -0700 (PDT) Message-ID: <1952083272.1242665925540.JavaMail.jira@brutus> Date: Mon, 18 May 2009 09:58:45 -0700 (PDT) From: "Myrna van Lunteren (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (DERBY-4234) IOException: Incorrect function on rollback after expected duplicate key error (23505) 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 IOException: Incorrect function on rollback after expected duplicate key error (23505) -------------------------------------------------------------------------------------- Key: DERBY-4234 URL: https://issues.apache.org/jira/browse/DERBY-4234 Project: Derby Issue Type: Bug Affects Versions: 10.4.2.1 Environment: windows 2000, Service pack 4, ibm 1.5, (SR7). Reporter: Myrna van Lunteren I saw this failure in running access.sql with DES (derbyall/encryptionAll/encryptionDES/access) on a build off the 10.4 branch (build: 774615). There were no recent changes, not to the codeline nor to the machine, and subsequent runs haven't popped this again either... There was also no stack trace saved in the .tmp, just the errors. Still, here's the relevant stack trace from derby.log: -------------------------------------------------------------------------------- insert into foo (select foo2.a, 'even2', foo2.c from foo2) 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 'A' defined on 'FOO'. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) Cleanup action completed ------------ BEGIN SHUTDOWN ERROR STACK ------------- ERROR XSLA5: Cannot read log stream for some reason to rollback transaction {0}. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.abort(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source) at org.apache.derby.impl.tools.ij.ij.RollbackStatement(Unknown Source) at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) Caused by: java.io.IOException: Incorrect function. at java.io.RandomAccessFile.writeBytes(Native Method) at java.io.RandomAccessFile.write(RandomAccessFile.java:493) at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushLogAccessFile(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.flushBuffer(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.openBackwardsScan(Unknown Source) ... 15 more ============= begin nested exception, level (1) =========== java.io.IOException: Incorrect function. at java.io.RandomAccessFile.writeBytes(Native Method) at java.io.RandomAccessFile.write(RandomAccessFile.java:493) at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushLogAccessFile(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.flushBuffer(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.openBackwardsScan(Unknown Source) at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.abort(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source) at org.apache.derby.impl.tools.ij.ij.RollbackStatement(Unknown Source) at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) ============= end nested exception, level (1) =========== ------------ END SHUTDOWN ERROR STACK ------------- 2009-05-14 12:18:14.547 GMT Thread[main,5,main] (XID = 4137), (SESSIONID = 0), (DATABASE = wombat), (DRDAID = null), Cleanup action starting 2009-05-14 12:18:14.547 GMT Thread[main,5,main] (XID = 4137), (SESSIONID = 0), (DATABASE = wombat), (DRDAID = null), Failed Statement is: null ERROR XSTB0: An exception was thrown during transaction abort. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.abort(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source) at org.apache.derby.impl.tools.ij.ij.RollbackStatement(Unknown Source) at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) Caused by: ERROR XSLA5: Cannot read log stream for some reason to rollback transaction {0}. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown Source) ... 14 more Caused by: java.io.IOException: Incorrect function. at java.io.RandomAccessFile.writeBytes(Native Method) at java.io.RandomAccessFile.write(RandomAccessFile.java:493) at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushLogAccessFile(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.flushBuffer(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.openBackwardsScan(Unknown Source) ... 15 more ============= begin nested exception, level (1) =========== ERROR XSLA5: Cannot read log stream for some reason to rollback transaction {0}. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.abort(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source) at org.apache.derby.impl.tools.ij.ij.RollbackStatement(Unknown Source) at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) Caused by: java.io.IOException: Incorrect function. at java.io.RandomAccessFile.writeBytes(Native Method) at java.io.RandomAccessFile.write(RandomAccessFile.java:493) at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushLogAccessFile(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.flushBuffer(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.openBackwardsScan(Unknown Source) ... 15 more ============= end nested exception, level (1) =========== ============= begin nested exception, level (2) =========== java.io.IOException: Incorrect function. at java.io.RandomAccessFile.writeBytes(Native Method) at java.io.RandomAccessFile.write(RandomAccessFile.java:493) at org.apache.derby.impl.store.raw.log.LogAccessFile.writeToLog(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushDirtyBuffers(Unknown Source) at org.apache.derby.impl.store.raw.log.LogAccessFile.flushLogAccessFile(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.flushBuffer(Unknown Source) at org.apache.derby.impl.store.raw.log.LogToFile.openBackwardsScan(Unknown Source) at org.apache.derby.impl.store.raw.log.FileLogger.undo(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.abort(Unknown Source) at org.apache.derby.impl.store.access.RAMTransaction.abort(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.doRollback(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.userRollback(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.rollback(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source) at org.apache.derby.impl.tools.ij.ij.RollbackStatement(Unknown Source) at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) ============= end nested exception, level (2) =========== 2009-05-14 12:18:14.547 GMT Thread[main,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(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.close(Unknown Source) at org.apache.derby.impl.store.raw.xact.XactContext.cleanupOnError(Unknown Source) at org.apache.derby.iapi.services.context.ContextManager.cleanupOnError(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.cleanupOnError(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.rollback(Unknown Source) at org.apache.derby.impl.tools.ij.ij.RollbackStatement(Unknown Source) at org.apache.derby.impl.tools.ij.ij.ijStatement(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source) at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.go(Unknown Source) at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source) at org.apache.derby.impl.tools.ij.Main.main(Unknown Source) at org.apache.derby.tools.ij.main(Unknown Source) 2009-05-14 12:18:14.547 GMT Thread[main,5,main] Shutting down due to severe error.An exception was thrown during transaction abort. 2009-05-14 12:18:14.547 GMT: Shutting down instance a816c00e-0121-3f0e-8722-000012749b32 ------------------------------------------------- -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.