[DERBY-6774] background post commit threads cause ASSERTS/errors on interaction with alter table add column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.3
• Fix Version/s: 10.12.1.1
• Component/s: SQL
• Labels: derby_backport_reject_10_11
• Issue & fix info: Patch Available
• Assignee: Mike Matrigali
• Reporter: Mike Matrigali
• Created: 25/Nov/14 03:44
• Updated: 09/Sep/16 09:51
• Resolved: 14/Jan/15 20:03

Description

intermittent error in sane test runs in some nightly runs.

java.sql.SQLException: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: org.apache.derby.shared.common.sanity.AssertFailureASSERT FAILED Expected (column_id == format_ids.length)column_id = 1format_ids.length = 2format_ids = [I@2abb6423XJ001.U
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:112)
at org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:321)
at org.apache.derby.client.am.ClientStatement.execute(ClientStatement.java:990)
at org.apache.derbyTesting.functionTests.tests.lang.AlterTableTest.testAddIdentityColumn(AlterTableTest.java:377)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:120)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBareOverridable(BaseJDBCTestCase.java:443)
at org.apache.derbyTesting.junit.BaseJDBCTestCase.runBare(BaseJDBCTestCase.java:460)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:58)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:58)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:58)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
Caused by: ERROR XJ001: DERBY SQL error: ERRORCODE: 0, SQLSTATE: XJ001, SQLERRMC: org.apache.derby.shared.common.sanity.AssertFailureASSERT FAILED Expected (column_id == format_ids.length)column_id = 1format_ids.length = 2format_ids = [I@2abb6423XJ001.U
at org.apache.derby.client.am.ClientStatement.completeSqlca(ClientStatement.java:2109)
at org.apache.derby.client.am.ClientStatement.completeExecuteImmediate(ClientStatement.java:1676)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:209)
at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:60)
at org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:47)
at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:142)
at org.apache.derby.client.am.ClientStatement.readExecuteImmediate(ClientStatement.java:1672)
at org.apache.derby.client.am.ClientStatement.flowExecute(ClientStatement.java:2401)
at org.apache.derby.client.am.ClientStatement.executeX(ClientStatement.java:995)
at org.apache.derby.client.am.ClientStatement.execute(ClientStatement.java:981)

Issue Links

• relates to: DERBY-6780 change conglomerate cache to handle concurrency and alter table add column calls.
• relates to: DERBY-4057 Space is not reclaimed if transaction is rolled back