Derby
  1. Derby
  2. DERBY-5581

store.LongColumnTest fails with testThreeColumnsShortAndLongAndShort(org.apache.derbyTesting.functionTests.tests.store.LongColumnTest: Unexpected SQL state. expected:<[XSCB6]> but was:<[nospc]>

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.9.1.0
    • Fix Version/s: None
    • Component/s: Store
    • Urgency:
      Low

      Description

      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

      1. diff_when_derby5581_occurred.txt
        9 kB
        Kathey Marsden
      2. failingRun.zip
        3.32 MB
        Kathey Marsden

        Issue Links

          Activity

          Hide
          Kathey Marsden added a comment -

          failingRun.zip is the fail directory from the failing run as well as the test output in rjall.out. The XATest failure is the result of the new test which still needs some cleanup.

          Show
          Kathey Marsden added a comment - failingRun.zip is the fail directory from the failing run as well as the test output in rjall.out. The XATest failure is the result of the new test which still needs some cleanup.
          Hide
          Kathey Marsden added a comment -

          This is the state of my client when the issue occurred. Just Brett's DERBY-5553 change, an new test in XATest (which still has some problems) and a println in Index Statistics. I don't think the patch is related but posting here for completeness. I did another run of suites.All with the same state and did not the failure.

          Show
          Kathey Marsden added a comment - This is the state of my client when the issue occurred. Just Brett's DERBY-5553 change, an new test in XATest (which still has some problems) and a println in Index Statistics. I don't think the patch is related but posting here for completeness. I did another run of suites.All with the same state and did not the failure.
          Hide
          Bryan Pendleton added a comment -

          > expected:<[XSCB6]> but was:<[nospc]>

          Perhaps "nospc" means that your disk filled up?

          Show
          Bryan Pendleton added a comment - > expected:< [XSCB6] > but was:< [nospc] > Perhaps "nospc" means that your disk filled up?
          Hide
          Knut Anders Hatlen added a comment -

          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.

          Show
          Knut Anders Hatlen added a comment - 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 .
          Hide
          Mike Matrigali added a comment -

          10.9 triage. Marking low, as it does not seem reproducible, leave open as place holder if anyone else sees
          it. Effort should first be spent fixing DERBY-4923.

          Show
          Mike Matrigali added a comment - 10.9 triage. Marking low, as it does not seem reproducible, leave open as place holder if anyone else sees it. Effort should first be spent fixing DERBY-4923 .

            People

            • Assignee:
              Unassigned
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development