com.atlassian.jira.exception.DataAccessException: Unable to complete the export due to an error in the cloning command 2016-09-12 19:21:39.562605500 at com.atlassian.jira.config.database.export.AbstractExportDatabaseManager.cloneMainDatabaseToExportDatabase(AbstractExportDatabaseManager.java:76) 2016-09-12 19:21:39.562609500 at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntitiesWithExportDatabase(DefaultSaxEntitiesExporter.java:137)

Atlassian JIRA | Ryan Mook [Atlassian] | 8 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    h3. Summary It is not possible to create a JIRA backup on JIRA Cloud, either with the {{Create Backup for Cloud}} or the {{Create Backup for Server}} option h3. Environment Atlassian Cloud JIRA 1000.319.1 h3. Steps to Reproduce create a backup on a JIRA Cloud instance using either the {{Create Backup for Cloud}} or the {{Create Backup for Server}} either with or without attachments enabled. h3. Expected Results A backup is created h3. Actual Results The error message Woah! Something went wrong! Unexpected error during export has occurred is displayed.   The below exception is thrown in the log file: {noformat} 2016-09-12 19:21:18.188166500 2016-09-12 19:21:18,185 http-nio-2993-exec-1 INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.o.backupmanager.rest.RootResource] Starting OnDemand backup 2016-09-12 19:21:18.195905500 2016-09-12 19:21:18,195 http-nio-2993-exec-1 INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.ondemand.backupmanager.BackupProcessManagerImpl] Generated task id = 01d94065-b6ec-4e66-aa6c-2258a9a9de28 2016-09-12 19:21:18.201401500 2016-09-12 19:21:18,200 http-nio-2993-exec-1 INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.o.backupmanager.rest.RootResource] OnDemand backup finished 2016-09-12 19:21:18.355780500 2016-09-12 19:21:18,354 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.a.a.export.DefaultSaxEntitiesExporter.privacy-safe] Exporting entities via the external export database 2016-09-12 19:21:18.356207500 2016-09-12 19:21:18,356 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.a.a.export.DefaultSaxEntitiesExporter.privacy-safe] Trying to acquire lock for completing an export. 2016-09-12 19:21:18.356357500 2016-09-12 19:21:18,356 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.a.a.export.DefaultSaxEntitiesExporter.privacy-safe] Successfully retrieved the lock 2016-09-12 19:21:18.358403500 2016-09-12 19:21:18,356 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.c.d.export.AbstractExportDatabaseManager.privacy-safe] Starting process for cloning main database to export database 2016-09-12 19:21:18.362906500 2016-09-12 19:21:18,362 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.c.d.export.AbstractExportDatabaseManager.privacy-safe] Clearing data from export database 2016-09-12 19:21:24.188000500 2016-09-12 19:21:24,187 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.c.d.export.AbstractExportDatabaseManager.privacy-safe] Ignoring these tables in export: [] 2016-09-12 19:21:24.188002500 2016-09-12 19:21:24,187 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.c.d.export.AbstractExportDatabaseManager.privacy-safe] Cloning main database to export database command has started 2016-09-12 19:21:39.560976500 2016-09-12 19:21:39,559 Long running task: OnDemandBackup ERROR sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.c.d.export.AbstractExportDatabaseManager.privacy-safe] There was an error executing the clone command: pg_restore: [archiver (db)] Error while PROCESSING TOC: 2016-09-12 19:21:39.560978500 pg_restore: [archiver (db)] Error from TOC entry 19; 1255 59203 FUNCTION drop_flyway_table() jira 2016-09-12 19:21:39.560979500 pg_restore: [archiver (db)] could not execute query: ERROR: function "drop_flyway_table" already exists with same argument types 2016-09-12 19:21:39.560989500 Command was: 2016-09-12 19:21:39.560989500 CREATE FUNCTION drop_flyway_table() RETURNS integer 2016-09-12 19:21:39.560990500 LANGUAGE plpgsql 2016-09-12 19:21:39.560990500 AS $$ 2016-09-12 19:21:39.560990500 BEGIN 2016-09-12 19:21:39.560990500 BEGIN 2016-09-12 19:21:39.560990500 DROP TABLE flyway_sche... 2016-09-12 19:21:39.560994500 WARNING: errors ignored on restore: 1 2016-09-12 19:21:39.560994500 2016-09-12 19:21:39.560995500 2016-09-12 19:21:39,560 Long running task: OnDemandBackup INFO sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.j.a.a.export.DefaultSaxEntitiesExporter.privacy-safe] Unlocked the export database so now others may use it. 2016-09-12 19:21:39.562582500 2016-09-12 19:21:39,561 Long running task: OnDemandBackup ERROR sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.o.backupmanager.rest.OnDemandBackupTask] Failure during task executing. Task's service: com.atlassian.ondemand.backupmanager.service.JiraBackupService@1ad474 2016-09-12 19:21:39.562584500 com.atlassian.ondemand.backupmanager.backuppolicy.BackupManagerException: Error: PROBLEM_DURING_EXPORT. 2016-09-12 19:21:39.562584500 com.atlassian.jira.exception.DataAccessException: Unable to complete the export due to an error in the cloning command 2016-09-12 19:21:39.562594500 at com.atlassian.ondemand.backupmanager.service.JiraBackupService.backup(JiraBackupService.java:162) 2016-09-12 19:21:39.562594500 at com.atlassian.ondemand.backupmanager.rest.OnDemandBackupTask.run(OnDemandBackupTask.java:86) 2016-09-12 19:21:39.562595500 at com.atlassian.ondemand.backupmanager.longrunning.ManagedTask.run(ManagedTask.java:35) 2016-09-12 19:21:39.562595500 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) 2016-09-12 19:21:39.562599500 at java.util.concurrent.FutureTask.run(FutureTask.java:266) 2016-09-12 19:21:39.562599500 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 2016-09-12 19:21:39.562604500 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 2016-09-12 19:21:39.562605500 at java.lang.Thread.run(Thread.java:745) 2016-09-12 19:21:39.562605500 Caused by: com.atlassian.jira.exception.DataAccessException: Unable to complete the export due to an error in the cloning command 2016-09-12 19:21:39.562605500 at com.atlassian.jira.config.database.export.AbstractExportDatabaseManager.cloneMainDatabaseToExportDatabase(AbstractExportDatabaseManager.java:76) 2016-09-12 19:21:39.562609500 at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntitiesWithExportDatabase(DefaultSaxEntitiesExporter.java:137) 2016-09-12 19:21:39.562610500 at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntities(DefaultSaxEntitiesExporter.java:110) 2016-09-12 19:21:39.562610500 at com.atlassian.ondemand.backupmanager.service.JiraBackupService.exportJIRA(JiraBackupService.java:330) 2016-09-12 19:21:39.562614500 at com.atlassian.ondemand.backupmanager.service.JiraBackupService.backup(JiraBackupService.java:138) 2016-09-12 19:21:39.562614500 2016-09-12 19:21:39,562 Long running task: OnDemandBackup WARN sysadmin 1161x21940x1 psmc0h 193.240.188.96 /rest/obm/1.0/runbackup [c.a.o.backupmanager.rest.OnDemandBackupTask] com.atlassian.ondemand.backupmanager.service.JiraBackupService@1ad474 fails to provide text via configured resource bundle. Can't find resource for bundle java.util.PropertyResourceBundle, key backupmanager.PROBLEM_DURING_EXPORT. Trying to resolve directly {noformat} h3. Workaround None h3. Notes Fix is currently being implemented      

    Atlassian JIRA | 8 months ago | Ryan Mook [Atlassian]
    com.atlassian.jira.exception.DataAccessException: Unable to complete the export due to an error in the cloning command 2016-09-12 19:21:39.562605500 at com.atlassian.jira.config.database.export.AbstractExportDatabaseManager.cloneMainDatabaseToExportDatabase(AbstractExportDatabaseManager.java:76) 2016-09-12 19:21:39.562609500 at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntitiesWithExportDatabase(DefaultSaxEntitiesExporter.java:137)

    Root Cause Analysis

    1. com.atlassian.jira.exception.DataAccessException

      Unable to complete the export due to an error in the cloning command 2016-09-12 19:21:39.562605500 at com.atlassian.jira.config.database.export.AbstractExportDatabaseManager.cloneMainDatabaseToExportDatabase(AbstractExportDatabaseManager.java:76) 2016-09-12 19:21:39.562609500 at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntitiesWithExportDatabase(DefaultSaxEntitiesExporter.java:137)

      at com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntities()
    2. com.atlassian.jira
      DefaultSaxEntitiesExporter.exportEntities
      1. com.atlassian.jira.action.admin.export.DefaultSaxEntitiesExporter.exportEntities(DefaultSaxEntitiesExporter.java:110)
      1 frame
    3. com.atlassian.ondemand
      JiraBackupService.exportJIRA
      1. com.atlassian.ondemand.backupmanager.service.JiraBackupService.exportJIRA(JiraBackupService.java:330)
      1 frame