db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6774) background post commit threads cause ASSERTS/errors on interaction with alter table add column
Date Fri, 12 Dec 2014 20:14:13 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14244709#comment-14244709
] 

ASF subversion and git services commented on DERBY-6774:
--------------------------------------------------------

Commit 1645055 from mikem@apache.org in branch 'code/trunk'
[ https://svn.apache.org/r1645055 ]

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

Renable the tests that were failing on some platforms, and adds tests that
were failing consistently in my environment (laptop, windows 7, ibm17). 

The fix was to insure that background threads waited on table intent lock 
before going to the conglomerate cache.

Before doing this an inconsistent conglomerate would sometimes be faulted into 
the cache between time when alter table abort was invalidating the cache and 
abort had finished backing out the alter table. Then a subsequent alter table 
would fail as it correctly passed in that there was 1 existing column, but the
conglomerate cache thought there were 2 columns.

> background post commit threads cause ASSERTS/errors on interaction with alter table add
column
> ----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-6774
>                 URL: https://issues.apache.org/jira/browse/DERBY-6774
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.11.1.3
>            Reporter: Mike Matrigali
>            Assignee: Mike Matrigali
>         Attachments: derby-6774_diff.txt
>
>
> 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)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message