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

Query executions fail when compressing a table using SYSCS_UTIL.SYSCS_COMPRESS_TABLE

    Details

    • Urgency:
      Normal
    • Issue & fix info:
      High Value Fix, Repro attached
    • Bug behavior facts:
      Crash, Seen in production

      Description

      Query executions (SELECT and/or UPDATE) fail with serious exceptions while the table is being compressed using SYSCS_UTIL.SYSCS_COMPRESS_ TABLE. The compression eventually finishes normally, but the queries keep failing with the same error until the database is rebooted. More information about this can be found on the Derby mailing list at http://www.nabble.com/Issue-with-SYSCS_UTIL.SYSCS_COMPRESS_-TABLE-td23892893.html. The exception stacktrace is below:

      Caused by: java.sql.SQLException: The conglomerate (71,409) requested does not exist.
      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.EmbedPreparedStatement.executeQuery(Unknown Source)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
      ... 25 more
      Caused by: ERROR XSAI2: The conglomerate (71,409) requested does not exist.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
      at org.apache.derby.impl.store.access.btree.index.B2IFactory.readConglomerate(Unknown Source)
      at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)
      at org.apache.derby.impl.store.access.BackingStoreHashTableFromScan.<init>(Unknown Source)
      at org.apache.derby.impl.store.access.RAMTransaction.createBackingStoreHashtableFromScan(Unknown Source)
      at org.apache.derby.impl.sql.execute.HashScanResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.JoinResultSet.openRight(Unknown Source)
      at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.JoinResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.UnionResultSet.getNextRowCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.SortResultSet.getRowFromResultSet(Unknown Source)
      at org.apache.derby.impl.sql.execute.SortResultSet.getNextRowFromRS(Unknown Source)
      at org.apache.derby.impl.sql.execute.SortResultSet.loadSorter(Unknown Source)
      at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.SortResultSet.openCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)
      at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)

        Attachments

        1. npe.diff
          1 kB
          Knut Anders Hatlen
        2. invalidation-during-compilation.diff
          2 kB
          Knut Anders Hatlen
        3. invalidate-after.diff
          1 kB
          Knut Anders Hatlen
        4. d4275-1a.diff
          11 kB
          Knut Anders Hatlen
        5. D4275.java
          2 kB
          Knut Anders Hatlen
        6. CompressDBTest2.java
          8 kB
          Sai Pullabhotla
        7. CompressDBTest1.java
          9 kB
          Sai Pullabhotla

          Issue Links

            Activity

              People

              • Assignee:
                knutanders Knut Anders Hatlen
                Reporter:
                psai Sai Pullabhotla
              • Votes:
                4 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: