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)

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

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12466001 ] Default workflow, editable Closed status [ 12802811 ]
          Knut Anders Hatlen made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Mike Matrigali made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Mike Matrigali made changes -
          Assignee Mike Matrigali [ mikem ] Knut Anders Hatlen [ knutanders ]
          Fix Version/s 10.3.3.1 [ 12313143 ]
          Fix Version/s 10.4.2.1 [ 12313401 ]
          Fix Version/s 10.5.3.2 [ 12315436 ]
          Fix Version/s 10.6.2.3 [ 12315434 ]
          Fix Version/s 10.7.1.4 [ 12315902 ]
          Kathey Marsden made changes -
          Bug behavior facts Crash [ 10365 ] Crash,Seen in production [ 10365,10421 ]
          Affects Version/s 10.4.1.3 [ 12313111 ]
          Affects Version/s 10.3.3.0 [ 12313142 ]
          Mike Matrigali made changes -
          Assignee Knut Anders Hatlen [ knutanders ] Mike Matrigali [ mikem ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-5654 [ DERBY-5654 ]
          Kathey Marsden made changes -
          Affects Version/s 10.5.3.0 [ 12314117 ]
          Affects Version/s 10.4.1.3 [ 12313111 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.2 [ 12317968 ]
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.8.2.0 [ 12317955 ]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-5406 [ DERBY-5406 ]
          Knut Anders Hatlen made changes -
          Issue & fix info [Repro attached, Patch Available, High Value Fix] [High Value Fix, Repro attached]
          Knut Anders Hatlen made changes -
          Issue & fix info [Repro attached, High Value Fix] [High Value Fix, Patch Available, Repro attached]
          Knut Anders Hatlen made changes -
          Link This issue is related to DERBY-5358 [ DERBY-5358 ]
          Knut Anders Hatlen made changes -
          Attachment npe.diff [ 12488183 ]
          Knut Anders Hatlen made changes -
          Attachment D4275.java [ 12487984 ]
          Knut Anders Hatlen made changes -
          Attachment invalidation-during-compilation.diff [ 12487978 ]
          Knut Anders Hatlen made changes -
          Link This issue is duplicated by DERBY-5351 [ DERBY-5351 ]
          Knut Anders Hatlen made changes -
          Summary Query executions fail when compressing a table using SYSCS_UTIL.SYSCS_COMPRESS_ TABLE Query executions fail when compressing a table using SYSCS_UTIL.SYSCS_COMPRESS_TABLE
          Knut Anders Hatlen made changes -
          Status Reopened [ 4 ] In Progress [ 3 ]
          Kristian Waagan made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Knut Anders Hatlen made changes -
          Status In Progress [ 3 ] Resolved [ 5 ]
          Fix Version/s 10.8.1.6 [ 12316676 ]
          Resolution Fixed [ 1 ]
          Knut Anders Hatlen made changes -
          Fix Version/s 10.9.0.0 [ 12316344 ]
          Issue & fix info [Repro attached, Patch Available, High Value Fix] [High Value Fix, Repro attached]
          Knut Anders Hatlen made changes -
          Issue & fix info [High Value Fix, Repro attached] [High Value Fix, Patch Available, Repro attached]
          Knut Anders Hatlen made changes -
          Attachment d4275-1a.diff [ 12484753 ]
          Knut Anders Hatlen made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Knut Anders Hatlen made changes -
          Assignee Knut Anders Hatlen [ knutanders ]
          Knut Anders Hatlen made changes -
          Attachment invalidate-after.diff [ 12481068 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-3683 [ DERBY-3683 ]
          Kathey Marsden made changes -
          Labels derby_triage10_5_2
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-637 [ DERBY-637 ]
          Dag H. Wanvik made changes -
          Issue & fix info [High Value Fix] [High Value Fix, Repro attached]
          Dag H. Wanvik made changes -
          Issue & fix info [High Value Fix]
          Kathey Marsden made changes -
          Derby Categories [Crash] [Crash, High Value Fix]
          Sai Pullabhotla made changes -
          Field Original Value New Value
          Attachment CompressDBTest1.java [ 12410807 ]
          Attachment CompressDBTest2.java [ 12410808 ]
          Sai Pullabhotla created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development