[
https://issues.apache.org/jira/browse/DERBY-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13190930#comment-13190930
]
Knut Anders Hatlen commented on DERBY-5581:
-------------------------------------------
I think nospc means that there's no space left on the page. The exception is
supposed to be caught and handled internally, but that apparently doesn't
happen in this case. Might be related to DERBY-4923.
> store.LongColumnTest fails with
> testThreeColumnsShortAndLongAndShort(org.apache.derbyTesting.functionTests.tests.store.LongColumnTest:
> Unexpected SQL state. expected:<[XSCB6]> but was:<[nospc]>
> -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-5581
> URL: https://issues.apache.org/jira/browse/DERBY-5581
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.9.0.0
> Reporter: Kathey Marsden
> Attachments: diff_when_derby5581_occurred.txt, failingRun.zip
>
>
> Running tests in a client modified with some unrelated changes for DERBY-552
> I saw this failure.
> Rerunning just my new test and LongColumnTest I could not reproduce.
> I think likely not related to my change but just a highly intermittent
> issue. I am rerunning Suites.All.
> I will attach the fail directory, and the patch with current state of my
> client at the time of failure.
>
> 2)
> testThreeColumnsShortAndLongAndShort(org.apache.derbyTesting.functionTests.tests.store.LongColumnTest)junit.framework.ComparisonFailure:
> Unexpected SQL state. expected:<[XSCB6]> but was:<[nospc]>
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:790)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:833)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsShortAndLongAndShort(LongColumnTest.java:242)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:116)
> 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:57)
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:98)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2288)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1334)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:630)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:179)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsShortAndLongAndShort(LongColumnTest.java:239)
> ... 31 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:122)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
> ... 40 more
> Caused by: ERROR nospc: nospc.U
> at
> org.apache.derby.impl.store.raw.data.StoredPage.logRow(StoredPage.java:4062)
> at
> org.apache.derby.impl.store.raw.data.DirectActions.actionInsert(DirectActions.java:205)
> at
> org.apache.derby.impl.store.raw.data.BasePage.insertNoOverflow(BasePage.java:604)
> at
> org.apache.derby.impl.store.raw.data.BasePage.insertAtSlot(BasePage.java:525)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.insertAtSlot(StoredPage.java:6805)
> at
> org.apache.derby.impl.store.access.btree.BTreeController.do_load_insert(BTreeController.java:1110)
> at
> org.apache.derby.impl.store.access.btree.BTreeController.load(BTreeController.java:1545)
> at org.apache.derby.impl.store.access.btree.index.B2I.load(B2I.java:789)
> at
> org.apache.derby.impl.store.access.RAMTransaction.loadConglomerate(RAMTransaction.java:1237)
> at
> org.apache.derby.impl.store.access.RAMTransaction.recreateAndLoadConglomerate(RAMTransaction.java:905)
> at
> org.apache.derby.impl.store.access.RAMTransaction.createAndLoadConglomerate(RAMTransaction.java:864)
> at
> org.apache.derby.impl.sql.execute.CreateIndexConstantAction.executeConstantAction(CreateIndexConstantAction.java:846)
> at
> org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:443)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:324)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1242)
> ... 34 more
> 3)
> testThreeColumnsLongAndShortAndLong(org.apache.derbyTesting.functionTests.tests.store.LongColumnTest)junit.framework.ComparisonFailure:
> Unexpected SQL state. expected:<[XSCB6]> but was:<[nospc]>
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:790)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:833)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsLongAndShortAndLong(LongColumnTest.java:319)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:116)
> 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:57)
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:98)
> at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:256)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:424)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:353)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2288)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:82)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1334)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:630)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(EmbedStatement.java:179)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsLongAndShortAndLong(LongColumnTest.java:316)
> ... 31 more
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:42)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory40.java:122)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:71)
> ... 40 more
> Caused by: ERROR nospc: nospc.U
> at
> org.apache.derby.impl.store.raw.data.StoredPage.logRow(StoredPage.java:4062)
> at
> org.apache.derby.impl.store.raw.data.DirectActions.actionInsert(DirectActions.java:205)
> at
> org.apache.derby.impl.store.raw.data.BasePage.insertNoOverflow(BasePage.java:604)
> at
> org.apache.derby.impl.store.raw.data.BasePage.insertAtSlot(BasePage.java:525)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.insertAtSlot(StoredPage.java:6805)
> at
> org.apache.derby.impl.store.access.btree.BTreeController.do_load_insert(BTreeController.java:1110)
> at
> org.apache.derby.impl.store.access.btree.BTreeController.load(BTreeController.java:1545)
> at org.apache.derby.impl.store.access.btree.index.B2I.load(B2I.java:789)
> at
> org.apache.derby.impl.store.access.RAMTransaction.loadConglomerate(RAMTransaction.java:1237)
> at
> org.apache.derby.impl.store.access.RAMTransaction.recreateAndLoadConglomerate(RAMTransaction.java:905)
> at
> org.apache.derby.impl.store.access.RAMTransaction.createAndLoadConglomerate(RAMTransaction.java:864)
> at
> org.apache.derby.impl.sql.execute.CreateIndexConstantAction.executeConstantAction(CreateIndexConstantAction.java:846)
> at
> org.apache.derby.impl.sql.execute.MiscResultSet.open(MiscResultSet.java:61)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(GenericPreparedStatement.java:443)
> at
> org.apache.derby.impl.sql.GenericPreparedStatement.execute(GenericPreparedStatement.java:324)
> at
> org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(EmbedStatement.java:1242)
> ... 34 more
> 4)
> testThreeColumnsShortAndLongAndShort(org.apache.derbyTesting.functionTests.tests.store.LongColumnTest)junit.framework.ComparisonFailure:
> Unexpected SQL state. expected:<[XSCB6]> but was:<[nospc]>
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:790)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:833)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsShortAndLongAndShort(LongColumnTest.java:242)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:116)
> 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:57)
> 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:57)
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:99)
> at
> org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:364)
> at
> org.apache.derby.client.am.Statement.executeUpdate(Statement.java:512)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsShortAndLongAndShort(LongColumnTest.java:239)
> ... 40 more
> Caused by: org.apache.derby.client.am.SqlException: nospc.U
> at
> org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1836)
> at
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:1424)
> at
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:208)
> at
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:59)
> at
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:45)
> at
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:124)
> at
> org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:1420)
> at org.apache.derby.client.am.Statement.flowExecute(Statement.java:2144)
> at
> org.apache.derby.client.am.Statement.executeUpdateX(Statement.java:517)
> at
> org.apache.derby.client.am.Statement.executeUpdate(Statement.java:503)
> ... 41 more
> 5)
> testThreeColumnsLongAndShortAndLong(org.apache.derbyTesting.functionTests.tests.store.LongColumnTest)junit.framework.ComparisonFailure:
> Unexpected SQL state. expected:<[XSCB6]> but was:<[nospc]>
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:790)
> at
> org.apache.derbyTesting.junit.BaseJDBCTestCase.assertSQLState(BaseJDBCTestCase.java:833)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsLongAndShortAndLong(LongColumnTest.java:319)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:88)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
> at
> org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:116)
> 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:57)
> 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:57)
> Caused by: java.sql.SQLException: nospc.U
> at
> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(SQLExceptionFactory40.java:99)
> at
> org.apache.derby.client.am.SqlException.getSQLException(SqlException.java:364)
> at
> org.apache.derby.client.am.Statement.executeUpdate(Statement.java:512)
> at
> org.apache.derbyTesting.functionTests.tests.store.LongColumnTest.testThreeColumnsLongAndShortAndLong(LongColumnTest.java:316)
> ... 40 more
> Caused by: org.apache.derby.client.am.SqlException: nospc.U
> at
> org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1836)
> at
> org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:1424)
> at
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:208)
> at
> org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:59)
> at
> org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:45)
> at
> org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:124)
> at
> org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:1420)
> at org.apache.derby.client.am.Statement.flowExecute(Statement.java:2144)
> at
> org.apache.derby.client.am.Statement.executeUpdateX(Statement.java:517)
> at
> org.apache.derby.client.am.Statement.executeUpdate(Statement.java:503)
> ... 41 more
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
