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

SQL syntax error importing data with PosgreSQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • 4.4.3
    • 4.4.1
    • None
    • PostgreSQL 8.4

    Description

      Importing an XML backup into JIRA 4.4.1, the import fails with the error:

      and in the logs:

      2012-02-28 10:21:22,022 JiraImportTaskExecutionThread-1 ERROR anonymous 619x6x1 p4yysk 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error:
      CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" (
          "ACHIEVEMENT_ID" INTEGER,
          "CREATED_ON" TIMESTAMP(29,6),
          "ID" SERIAL,
          "NOTIFIED" BOOLEAN,
          "USER_WRAPPER_ID" INTEGER,
          PRIMARY KEY("ID")
      )
      ---
      com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error:
      CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" (
          "ACHIEVEMENT_ID" INTEGER,
          "CREATED_ON" TIMESTAMP(29,6),
          "ID" SERIAL,
          "NOTIFIED" BOOLEAN,
          "USER_WRAPPER_ID" INTEGER,
          PRIMARY KEY("ID")
      )
      ---
      
              at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:83)
              at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:55)
              at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:47)
              at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:45)
              at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:74)
              at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:152)
              at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347)
              at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479)
              at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209)
              at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65)
              at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
              at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147)
              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:441)
              at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
              at java.util.concurrent.FutureTask.run(FutureTask.java:138)
              at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
              at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
              at java.lang.Thread.run(Thread.java:662)
      Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ","
      ?Error importing                                                                                    
      

      Attachments

        1. jira_importerror_ao.png
          81 kB
          Jeff Turner

        Activity

          People

            Unassigned Unassigned
            97bf41494e76 Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: