Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-10759

'KEYSTORE' table doesn't exist. BackupEntities couldn't backup database data

XMLWordPrintable

      Upon Confluence upgrade to 2.7 or later, admin may discover that the KEYSTORE table does not exist.

      An upgrade misconfiguration is known to can cause this. For example:

      1. Admin created a test Confluence instance of the latest version and new database, then shut it down
      2. Admin imported production database into this new instance
      3. Admin copied production instance's Confluence Home but kept the test instance's confluence.cfg.xml. This xml file contains the target version's build number.
      4. Admin started test instance in the hope that this will upgrade Confluence.
      5. Because Confluence see that the build number in confluence.cfg.xml is the same as the running Confluence version, the upgrade is skipped.

      Step 3 is wrong. The confluence.cfg.xml should also be reverted to the old build number (click here for Confluence Build Information).

      Sample error
      ERROR [DefaultQuartzScheduler_Worker-6] [confluence.importexport.impl.BackupExporter] backupEntities Couldn't backup database data.
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'confluencedb271.KEYSTORE' doesn't exist
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'confluencedb271.KEYSTORE' doesn't exist
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1027)

      This issue can be prevented had we have CONF-18085 implemented.

      See also CONF-13798

          Form Name

            [CONFSERVER-10759] 'KEYSTORE' table doesn't exist. BackupEntities couldn't backup database data

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2896535 ] New: CONFSERVER Bug Workflow v4 [ 2989381 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2787863 ] New: JAC Bug Workflow v3 [ 2896535 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2719727 ] New: JAC Bug Workflow v2 [ 2787863 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2388856 ] New: JAC Bug Workflow [ 2719727 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2265867 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2388856 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2209381 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2265867 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2194167 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2209381 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1920167 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2194167 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1730031 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1920167 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1686141 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1730031 ]

              Unassigned Unassigned
              rhartono Roy Hartono [Atlassian]
              Affected customers:
              1 This affects my team
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: