Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3625

XSDA3 error in concateTests in lang.LangHarnessJavaTest caused by bug in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE()

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: 10.3.3.1, 10.4.2.0, 10.5.1.1
    • Component/s: Store
    • Labels:
      None
    • Environment:
      iseries, ibm1.5.:
      java version "1.5.0"
      Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05)
      Classic VM (build 1.5, build JDK-1.5, native threads, jitc_de)
    • Bug behavior facts:
      Regression Test Failure

      Description

      I saw this test fail once with a similar error to DERBY-3180 and DERBY-3381.

      Unfortunately, possibly because it's an old harness test, the db and derby.log were not saved in the 'fail' directory.
      All I have is the stack trace from the output:

      1) concateTests(org.apache.derbyTesting.functionTests.tests.lang.LangHarnessJavaTest)java.sql.SQLException: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation.
      at java.lang.Throwable.<init>(Throwable.java:196)
      at java.lang.Exception.<init>(Exception.java:41)
      at java.sql.SQLException.<init>(SQLException.java:40)
      at org.apache.derby.impl.jdbc.EmbedSQLException.<init>(Unknown Source)
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(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.ConnectionChild.handleException(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedCallableStatement.executeStatement(Unknown Source)
      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
      at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.compressObjects(CleanDatabaseTestSetup.java:267)
      at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.cleanDatabase(CleanDatabaseTestSetup.java:166)
      at org.apache.derbyTesting.junit.CleanDatabaseTestSetup.setUp(CleanDatabaseTestSetup.java:109)
      at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
      at junit.extensions.TestSetup.run(TestSetup.java:23)
      at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
      Caused by: ERROR XSDA3: Limitation: Record cannot be updated or inserted due to lack of space on the page. Use the parameters derby.storage.pageSize and/or derby.storage.pageReservedSpace to work around this limitation.
      at java.lang.Throwable.<init>(Throwable.java:196)
      at java.lang.Exception.<init>(Exception.java:41)
      at org.apache.derby.iapi.error.StandardException.<init>(Unknown Source)
      at org.apache.derby.iapi.error.StandardException.<init>(Unknown Source)
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.store.raw.data.CopyRowsOperation.writeOptionalDataToBuffer(Unknown Source)
      at org.apache.derby.impl.store.raw.data.CopyRowsOperation.<init>(Unknown Source)
      at org.apache.derby.impl.store.raw.data.LoggableActions.actionCopyRows(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BasePage.copyInto(Unknown Source)
      at org.apache.derby.impl.store.raw.data.BasePage.copyAndPurge(Unknown Source)
      at org.apache.derby.impl.store.raw.data.StoredPage.moveRecordForCompressAtSlot(Unknown Source)
      at org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchRowsForCompress(Unknown Source)
      at org.apache.derby.impl.store.access.heap.HeapCompressScan.fetchNextGroup(Unknown Source)
      at org.apache.derby.iapi.db.OnlineCompress.defragmentRows(Unknown Source)
      at org.apache.derby.iapi.db.OnlineCompress.compressTable(Unknown Source)
      at org.apache.derby.catalog.SystemProcedures.SYSCS_INPLACE_COMPRESS_TABLE(Unknown Source)
      at org.apache.derby.exe.ac4388a4aax0119x3203xfc8fx0000783ef2472.g0(Unknown Source)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at org.apache.derby.impl.services.reflect.ReflectMethod.invoke(Unknown Source)
      at org.apache.derby.impl.sql.execute.CallStatementResultSet.open(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
      ... 24 more

        Attachments

        1. derby_log_wdebug.zip
          1.24 MB
          Katherine Marsden
        2. derby_log_wdebug2.zip
          8 kB
          Katherine Marsden
        3. derbylog.zip
          1.23 MB
          Katherine Marsden
        4. wombat.zip
          749 kB
          Katherine Marsden

          Issue Links

            Activity

              People

              • Assignee:
                mikem Mike Matrigali
                Reporter:
                myrna Myrna van Lunteren
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: