Importing from Cloud to Server fails in MSSQLServer and MySQL due to Multiple identity/auto_increment columns specified for table 'AO_7CDE43_NOTIFICATION'

XMLWordPrintable

    • 14
    • Severity 2 - Major

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      For now, anyone who experience this issue, open a ticket in our cloud support so we can apply the fix in the affected database (cloud instance).

      Summary

      The table 'AO_7CDE43_NOTIFICATION' has another identity column: SCHEME_ID in Confluence Cloud which is non-existent in server instances and other cloud instances of the same version (still need to investigate the reason for this column).

      The restore will read a SQL statement that is unacceptable for ms sql server:

      Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian Notifications SPI Plugin(com.atlassian.plugin.notifications.notifications-module) #3.3.3 (table AO_7CDE43_NOTIFICATION):Error executing update for SQL statement 'CREATE TABLE AO_7CDE43_NOTIFICATION (
    ID INTEGER IDENTITY(1,1),
    NOTIFICATION_SCHEME_ID INTEGER,
    SCHEME_ID INTEGER IDENTITY(1,1),
CONSTRAINT pk_AO_7CDE43_NOTIFICATION_ID PRIMARY KEY(ID)
)'

      And will fail with:

      Caused by: java.sql.SQLException: Multiple identity columns specified for table 'AO_7CDE43_NOTIFICATION'. Only one identity column per table is allowed.

      The restore will read a SQL statement that is unacceptable for MySQL Server as well:

      Caused by: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian Notifications SPI Plugin(com.atlassian.plugin.notifications.notifications-module) #3.3.3 (table AO_7CDE43_NOTIFICATION):Error executing update for SQL statement 'CREATE TABLE AO_7CDE43_NOTIFICATION (
    ID INTEGER AUTO_INCREMENT,
    NOTIFICATION_SCHEME_ID INTEGER,
    SCHEME_ID INTEGER AUTO_INCREMENT,
    PRIMARY KEY(ID)
) ENGINE=InnoDB'

      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect table definition; there can be only one auto column and it must be defined as a key

            Assignee:
            Klaus (Inactive)
            Reporter:
            Artur J
            Votes:
            3 Vote for this issue
            Watchers:
            21 Start watching this issue

              Created:
              Updated:
              Resolved: