Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-35543

XML restore to MySQL and HSQLDB fails

    XMLWordPrintable

Details

    Description

      XML restore for certain DBs seems to fail. It works without issue on PostgreSQL.

      2013-10-16 14:53:39,794 JiraImportTaskExecutionThread-1 ERROR admin 893x1747x1 14hteje fe80:0:0:0:8249:71ff:fe12:a58f%5 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore
      com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian JIRA - Plugins - Invite User(com.atlassian.jira.jira-invite-user-plugin) #1.13 (table AO_97EDAB_USERINVITATION):Error executing update for SQL statement 'CREATE TABLE PUBLIC.AO_97EDAB_USERINVITATION (
          EXPIRY DATETIME,
          ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
          NVARCHAR(255) VARCHAR(255),
          REDEEMED BOOLEAN,
          SENDER_USERNAME VARCHAR(255),
          TOKEN VARCHAR(255),
          PRIMARY KEY(ID)
      )'
      	at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30)
      	at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:53)
      	at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:42)
      	at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:84)
      	at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:62)
      	at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50)
      	at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49)
      	at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)
      	at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158)
      	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:482)
      	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:688)
      	at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:278)
      	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66)
      	at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29)
      	at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179)
      	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)
      	at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:138)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
      	at java.lang.Thread.run(Thread.java:695)
      Caused by: java.sql.SQLException: Wrong data type: ( in statement [CREATE TABLE PUBLIC.AO_97EDAB_USERINVITATION (
          EXPIRY DATETIME,
          ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
          NVARCHAR(]
      	at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      	at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
      	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
      	at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37)
      	... 20 more

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              bberenberg Boris Berenberg (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: