XML restore fails if table has an ID greater than max int

XMLWordPrintable

    • 9.12
    • Severity 3 - Minor

      Issue Summary

      Cannot import a previously exported Jira backup if there is a table which has a column id greater than int

      Steps to Reproduce

      1. Set the table sequence to max int
      2. Create a record in the table
      3. Perform a Jira backup
      4. Attempt to restore the backup

      Expected Results

      Jira should restore successfully

      Actual Results

      The below exception is thrown in the atlassian-jira.log file:

      com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Assets Plugin(com.riadalabs.jira.plugins.insight) #20.3.5-SNAPSHOT (table AO_8542F1_IFJ_OBJ_ATTR):Error getting int value from result set.
    at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:26) ~[?:?]
    at com.atlassian.activeobjects.backup.SqlUtils.getIntFromResultSet(SqlUtils.java:74) ~[?:?]
    at com.atlassian.activeobjects.backup.PostgresSequencesAroundImporter.updateSequence(PostgresSequencesAroundImporter.java:70) ~[?:?]
    at com.atlassian.activeobjects.backup.PostgresSequencesAroundImporter.updateSequences(PostgresSequencesAroundImporter.java:56) ~[?:?]
    at com.atlassian.activeobjects.backup.PostgresSequencesAroundImporter.after(PostgresSequencesAroundImporter.java:43) ~[?:?]
    at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:52) ~[?:?]
    at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73) ~[?:?]
    at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:165) ~[?:?]

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Unassigned
            Reporter:
            Benjamin Suess
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: