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

a crash during re-encryption of an existing database with lot of tables can make database unrecoverable on a next boot.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6, 10.3.1.4
    • Fix Version/s: 10.2.1.6, 10.3.1.4
    • Component/s: Store
    • Labels:
      None

      Description

      While running reencryt crash/recovery functional test with 1000 tables (>2000 containers) , I hit a following boot failire.

      ERROR XJ040: Failed to start database 'wombat_pwd_en', see the next exception fo
      r details.
      ERROR XSTB0: An exception was thrown during transaction abort.
      java.sql.SQLException: Failed to start database 'wombat_pwd_en', see the next ex

      ============= begin nested exception, level (1) ===========

      ERROR XSRS4: Error renaming file (during backup) from E:\suresht\adhoctests\reencryption\dbs\wombat_pwd_en\seg0\c340.dat to E:\suresht\adhoctests\reencryption\dbs\wombat_pwd_en\seg0\n340.dat.

      After bit of debugging ; my suspicion is this problem is happening becuase of more than one log file switch during re-encryption and current
      re-encryption recovery code does not seem to handle it correctly.

        Attachments

        1. ASF.LICENSE.NOT.GRANTED--stk.txt
          8 kB
          Suresh Thalamati
        2. derby-1786.diff
          24 kB
          Suresh Thalamati

          Activity

            People

            • Assignee:
              tsuresh Suresh Thalamati
              Reporter:
              tsuresh Suresh Thalamati
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: