com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)

Atlassian JIRA | Mauro Fernandez Badii [Atlassian] | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    It is not possible to import a 15GB Confluence backup with attachments created on v5.2 OD13 on another OnDemand Confluence Standalone instance with the same version. {color:red}Import works correctly on a Confluence OnDemand v5.2 OD13 running locally.{color} *Error shown when importing:* {noformat} ... ERROR: duplicate key value violates unique constraint "cp_unique_group" {noformat} *Note:* The backup was created from a Jira + Confluence instance *To replicate:* 1. Start test instance (if not active already) (it has ram extended to 768MB to avoid NotEnoughMemory) 2. Log in and try to Import Site using file Confluence-backup-20130807.zip *What I did:* 1. Created a new OnDemand instance Confluence Standalone (icebat-54.0 to match customers) 2. provide it more ram (it will fail because of NotEnoughMemory if not) using [this documentation|https://sdog.jira.com/wiki/display/JST/2013/07/01/The+new+way+to+customise+OnDemand+instances]: * edit the /data/icebat/local.yaml file and add the following line: confluence::max_heap: "768m" * run: /sw/studio/$(cat /data/icebat/version)/install/install-confluence-standalone.sh 3. moved the file to the new instance using [a script|https://confluence.atlassian.com/display/ONDEMANDKB/Can't+Download+Large+Files+from+OnDemand+WebDAV] to avoid disconnections 4. verified md5 5. tried to import through the Import Site section. *Full Log:* {noformat} 2013-08-07 03:55:51.873140500 2013-08-07 03:55:51,872 INFO [Long running task: Importing data] [atlassian.confluence.importexport.Importer] doImport Running pre-import tasks 2013-08-07 03:55:51.873716500 2013-08-07 03:55:51,873 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.FileBackupImporter] extractRestoreFile Extracting backup file [ /data/jirastudio/webdav/Confluence-backup-20130807.zip ] to [ /data/jirastudio/confluence/home/temp/import_08072013_035551 ] 2013-08-07 04:11:50.548083500 2013-08-07 04:11:50,546 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] preImport Switching scheduler to standby mode 2013-08-07 04:11:50.548409500 2013-08-07 04:11:50,548 INFO [Long running task: Importing data] [atlassian.confluence.importexport.Importer] doImport Running main import 2013-08-07 04:11:50.548732500 2013-08-07 04:11:50,548 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] doImportInternal Starting import of data 2013-08-07 04:11:51.280065500 2013-08-07 04:11:51,278 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Importing XML 2013-08-07 04:12:04.015729500 2013-08-07 04:12:03,974 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 5734506 2013-08-07 04:12:04.015732500 2013-08-07 04:12:03,982 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 16875647 2013-08-07 04:12:06.223366500 2013-08-07 04:12:06,177 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 16318484 2013-08-07 04:12:12.492035500 2013-08-07 04:12:12,490 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 36963752 2013-08-07 04:12:13.003059500 2013-08-07 04:12:12,969 INFO [Long running task: Importing data] [pre.whitelist.bandanafilters.BandanaGlobalSettingsFilter] process Accepting Bandana entry [_GLOBAL/com.atlassian.confluence.core.DefaultFormatSettingsManager]. 2013-08-07 04:12:18.872390500 2013-08-07 04:12:18,869 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user daniel.fraser@datacom.com.au 2013-08-07 04:12:19.120640500 2013-08-07 04:12:19,119 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user jon.varova@datacom.com.au 2013-08-07 04:12:29.332333500 2013-08-07 04:12:29,304 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 46039226 2013-08-07 04:12:29.956953500 2013-08-07 04:12:29,955 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user derek.choi@apra.gov.au 2013-08-07 04:12:32.203985500 2013-08-07 04:12:32,202 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 22675613 2013-08-07 04:12:36.259598500 2013-08-07 04:12:36,181 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user rene.pisani@dbb.org.au 2013-08-07 04:12:36.358207500 2013-08-07 04:12:36,357 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user bernard.yam@dbb.org.au 2013-08-07 04:12:36.487393500 2013-08-07 04:12:36,484 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user kylie.lester@dbb.org.au 2013-08-07 04:12:36.606629500 2013-08-07 04:12:36,605 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user ruth.pepin@dbb.org.au 2013-08-07 04:12:36.875514500 2013-08-07 04:12:36,874 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 3441197 2013-08-07 04:12:36.884947500 2013-08-07 04:12:36,884 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 3441133 2013-08-07 04:12:37.036112500 2013-08-07 04:12:37,035 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 48201754 2013-08-07 04:12:42.493970500 2013-08-07 04:12:42,491 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user james.booth 2013-08-07 04:12:46.758858500 2013-08-07 04:12:46,753 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 10485829 2013-08-07 04:12:46.758861500 2013-08-07 04:12:46,757 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user daniel.hili@virginaustralia.com 2013-08-07 04:12:47.623696500 2013-08-07 04:12:47,621 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 10485769 2013-08-07 04:12:59.042592500 2013-08-07 04:12:59,040 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user acgceo.greg.cork 2013-08-07 04:13:05.253820500 2013-08-07 04:13:05,238 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 30048262 2013-08-07 04:13:05.615371500 2013-08-07 04:13:05,614 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user mariely@epo.org 2013-08-07 04:13:05.877790500 2013-08-07 04:13:05,876 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user peter_tawadros@coffey.com 2013-08-07 04:13:05.997787500 2013-08-07 04:13:05,997 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user mitchell_dowd@coffey.com 2013-08-07 04:13:06.128349500 2013-08-07 04:13:06,127 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user sample.client@tempuri.org 2013-08-07 04:13:06.245054500 2013-08-07 04:13:06,244 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user sample.client2@tempuri.org 2013-08-07 04:13:15.417012500 2013-08-07 04:13:15,414 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490670 2013-08-07 04:13:15.417016500 2013-08-07 04:13:15,416 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490668 2013-08-07 04:13:15.417018500 2013-08-07 04:13:15,416 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490669 2013-08-07 04:13:15.417533500 2013-08-07 04:13:15,417 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490666 2013-08-07 04:13:15.418558500 2013-08-07 04:13:15,418 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490667 2013-08-07 04:13:15.419179500 2013-08-07 04:13:15,418 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490664 2013-08-07 04:13:15.419658500 2013-08-07 04:13:15,419 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490665 2013-08-07 04:13:15.420250500 2013-08-07 04:13:15,419 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490662 2013-08-07 04:13:15.421388500 2013-08-07 04:13:15,420 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490663 2013-08-07 04:13:15.421937500 2013-08-07 04:13:15,421 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490660 2013-08-07 04:13:15.422527500 2013-08-07 04:13:15,422 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490661 2013-08-07 04:13:15.423054500 2013-08-07 04:13:15,422 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490658 2013-08-07 04:13:15.423633500 2013-08-07 04:13:15,423 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490659 2013-08-07 04:13:15.425421500 2013-08-07 04:13:15,425 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490657 2013-08-07 04:13:15.425981500 2013-08-07 04:13:15,425 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490656 2013-08-07 04:13:15.469562500 2013-08-07 04:13:15,468 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490705 2013-08-07 04:13:15.766060500 2013-08-07 04:13:15,764 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490618 2013-08-07 04:13:15.770115500 2013-08-07 04:13:15,769 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2491222 2013-08-07 04:13:15.893132500 2013-08-07 04:13:15,884 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999007 2013-08-07 04:13:15.893134500 2013-08-07 04:13:15,885 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998896 2013-08-07 04:13:15.972384500 2013-08-07 04:13:15,971 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998942 2013-08-07 04:13:15.973147500 2013-08-07 04:13:15,972 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998954 2013-08-07 04:13:15.977188500 2013-08-07 04:13:15,976 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998962 2013-08-07 04:13:15.983222500 2013-08-07 04:13:15,982 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 12157051 2013-08-07 04:13:15.983881500 2013-08-07 04:13:15,983 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 12157146 2013-08-07 04:13:15.984620500 2013-08-07 04:13:15,984 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999158 2013-08-07 04:13:15.985492500 2013-08-07 04:13:15,985 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999159 2013-08-07 04:13:15.986155500 2013-08-07 04:13:15,985 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999160 2013-08-07 04:13:15.986708500 2013-08-07 04:13:15,986 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999186 2013-08-07 04:13:16.013612500 2013-08-07 04:13:16,012 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999563 2013-08-07 04:13:16.311135500 2013-08-07 04:13:16,310 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user sam.wang 2013-08-07 04:13:16.756958500 2013-08-07 04:13:16,755 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999652 2013-08-07 04:13:16.777912500 2013-08-07 04:13:16,777 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2000110 2013-08-07 04:13:17.106474500 2013-08-07 04:13:17,105 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999944 2013-08-07 04:13:17.683623500 2013-08-07 04:13:17,679 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user jcheng@cabrini.com.au 2013-08-07 04:13:19.925140500 2013-08-07 04:13:19,924 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user greg.scott 2013-08-07 04:13:20.440234500 2013-08-07 04:13:20,438 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 45220038 2013-08-07 04:13:20.820264500 2013-08-07 04:13:20,818 INFO [Long running task: Importing data] [pre.whitelist.bandanafilters.BandanaGlobalSettingsFilter] process Accepting Bandana entry [_GLOBAL/atl.confluence.plugins.confluence-daily-summary-email:admin.defaultSchedule]. 2013-08-07 04:13:20.839815500 2013-08-07 04:13:20,839 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998849 2013-08-07 04:13:20.865812500 2013-08-07 04:13:20,865 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998854 2013-08-07 04:13:20.873267500 2013-08-07 04:13:20,872 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998855 2013-08-07 04:13:20.894446500 2013-08-07 04:13:20,893 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998850 2013-08-07 04:13:20.897859500 2013-08-07 04:13:20,897 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998851 2013-08-07 04:13:20.899592500 2013-08-07 04:13:20,899 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998852 2013-08-07 04:13:20.900532500 2013-08-07 04:13:20,900 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998853 2013-08-07 04:13:21.367151500 2013-08-07 04:13:21,360 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 19988565 2013-08-07 04:13:27.318369500 2013-08-07 04:13:27,316 WARN [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions SQL Error: 0, SQLState: 23505 2013-08-07 04:13:27.318371500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.318768500 2013-08-07 04:13:27,318 ERROR [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.318769500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.320043500 2013-08-07 04:13:27,319 ERROR [Long running task: Importing data] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2013-08-07 04:13:27.320045500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.320956500 2013-08-07 04:13:27,320 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.pages.Page] [Id[id]=27820133, Property[position]=, Property[title]=UNIFY hosted Development environment, Property[bodyContents]=, Property[version]=12, Property[creator]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=ff8080813fc39c17013fc39d724f0014], Property[creationDate]=2012-09-26 12:15:10.973, Property[lastModifier]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=ff8080813fc39c17013fc39d724f0014], Property[lastModificationDate]=2012-09-27 11:31:14.944, Property[versionComment]=, Property[originalVersion]=com.atlassian.confluence.pages.Page[Id[id]=27820106], Property[contentStatus]=current] 2013-08-07 04:13:27.320967500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.330332500 2013-08-07 04:13:27,326 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: 2013-08-07 04:13:27.330334500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.330335500 com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) 2013-08-07 04:13:27.330394500 at $Proxy331.performImport(Unknown Source) 2013-08-07 04:13:27.330394500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330395500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330397500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330398500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330398500 at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) 2013-08-07 04:13:27.330402500 at $Proxy331.performImport(Unknown Source) 2013-08-07 04:13:27.330402500 at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:88) 2013-08-07 04:13:27.330403500 at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) 2013-08-07 04:13:27.330405500 at com.atlassian.ondemand.confluenceimporter.service.importer.OnDemandImportLongRunningTask.runInternal(OnDemandImportLongRunningTask.java:155) 2013-08-07 04:13:27.330406500 at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) 2013-08-07 04:13:27.330406500 at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) 2013-08-07 04:13:27.330408500 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) 2013-08-07 04:13:27.330409500 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) 2013-08-07 04:13:27.330410500 at java.util.concurrent.FutureTask.run(FutureTask.java:138) 2013-08-07 04:13:27.330410500 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) 2013-08-07 04:13:27.330411500 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) 2013-08-07 04:13:27.330415500 at java.lang.Thread.run(Thread.java:662) 2013-08-07 04:13:27.330415500 Caused by: net.sf.hibernate.exception.ConstraintViolationException: could not insert: [com.atlassian.confluence.security.ContentPermission#1114124] 2013-08-07 04:13:27.330416500 at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:53) 2013-08-07 04:13:27.330417500 at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) 2013-08-07 04:13:27.330419500 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) 2013-08-07 04:13:27.330419500 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) 2013-08-07 04:13:27.330420500 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) 2013-08-07 04:13:27.330421500 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) 2013-08-07 04:13:27.330422500 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) 2013-08-07 04:13:27.330423500 at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) 2013-08-07 04:13:27.330424500 at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) 2013-08-07 04:13:27.330424500 at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) 2013-08-07 04:13:27.330425500 at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103) 2013-08-07 04:13:27.330435500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:108) 2013-08-07 04:13:27.330436500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:60) 2013-08-07 04:13:27.330436500 ... 46 more {noformat} *Extra:* We are unable to extract the contents from the Backup file. Errors shown when trying to extract backup contents using 7za: {noformat} example-instance:/data/jirastudio/webdav]# 7za t Confluence-backup-20130807.zip 7-Zip (A) [64] 9.20 Copyright (c) 1999-2010 Igor Pavlov 2010-11-18 p7zip Version 9.20 (locale=en_AU.UTF-8,Utf16=on,HugeFiles=on,2 CPUs) Processing archive: Confluence-backup-20130807.zip Testing config/ehcache.xml Unsupported Method Testing plugin-data/com.atlassian.activeobjects.confluence.spi/activeObjectsBackupRestoreProvider.pdata Unsupported Method Testing entities.xml Unsupported Method Testing exportDescriptor.properties Unsupported Method Testing attachments/4981015/5144693/1 Unsupported Method Testing attachments/4981015/5144694/1 Unsupported Method Testing attachments/8388780/8486999/1 Unsupported Method Testing attachments/32538735/33095685/1 Unsupported Method ... and so on for like 50% of the files... {noformat}

    Atlassian JIRA | 4 years ago | Mauro Fernandez Badii [Atlassian]
    com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
  2. 0

    It is not possible to import a 15GB Confluence backup with attachments created on v5.2 OD13 on another OnDemand Confluence Standalone instance with the same version. {color:red}Import works correctly on a Confluence OnDemand v5.2 OD13 running locally.{color} *Error shown when importing:* {noformat} ... ERROR: duplicate key value violates unique constraint "cp_unique_group" {noformat} *Note:* The backup was created from a Jira + Confluence instance *To replicate:* 1. Start test instance (if not active already) (it has ram extended to 768MB to avoid NotEnoughMemory) 2. Log in and try to Import Site using file Confluence-backup-20130807.zip *What I did:* 1. Created a new OnDemand instance Confluence Standalone (icebat-54.0 to match customers) 2. provide it more ram (it will fail because of NotEnoughMemory if not) using [this documentation|https://sdog.jira.com/wiki/display/JST/2013/07/01/The+new+way+to+customise+OnDemand+instances]: * edit the /data/icebat/local.yaml file and add the following line: confluence::max_heap: "768m" * run: /sw/studio/$(cat /data/icebat/version)/install/install-confluence-standalone.sh 3. moved the file to the new instance using [a script|https://confluence.atlassian.com/display/ONDEMANDKB/Can't+Download+Large+Files+from+OnDemand+WebDAV] to avoid disconnections 4. verified md5 5. tried to import through the Import Site section. *Full Log:* {noformat} 2013-08-07 03:55:51.873140500 2013-08-07 03:55:51,872 INFO [Long running task: Importing data] [atlassian.confluence.importexport.Importer] doImport Running pre-import tasks 2013-08-07 03:55:51.873716500 2013-08-07 03:55:51,873 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.FileBackupImporter] extractRestoreFile Extracting backup file [ /data/jirastudio/webdav/Confluence-backup-20130807.zip ] to [ /data/jirastudio/confluence/home/temp/import_08072013_035551 ] 2013-08-07 04:11:50.548083500 2013-08-07 04:11:50,546 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] preImport Switching scheduler to standby mode 2013-08-07 04:11:50.548409500 2013-08-07 04:11:50,548 INFO [Long running task: Importing data] [atlassian.confluence.importexport.Importer] doImport Running main import 2013-08-07 04:11:50.548732500 2013-08-07 04:11:50,548 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] doImportInternal Starting import of data 2013-08-07 04:11:51.280065500 2013-08-07 04:11:51,278 INFO [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Importing XML 2013-08-07 04:12:04.015729500 2013-08-07 04:12:03,974 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 5734506 2013-08-07 04:12:04.015732500 2013-08-07 04:12:03,982 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 16875647 2013-08-07 04:12:06.223366500 2013-08-07 04:12:06,177 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 16318484 2013-08-07 04:12:12.492035500 2013-08-07 04:12:12,490 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 36963752 2013-08-07 04:12:13.003059500 2013-08-07 04:12:12,969 INFO [Long running task: Importing data] [pre.whitelist.bandanafilters.BandanaGlobalSettingsFilter] process Accepting Bandana entry [_GLOBAL/com.atlassian.confluence.core.DefaultFormatSettingsManager]. 2013-08-07 04:12:18.872390500 2013-08-07 04:12:18,869 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user daniel.fraser@datacom.com.au 2013-08-07 04:12:19.120640500 2013-08-07 04:12:19,119 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user jon.varova@datacom.com.au 2013-08-07 04:12:29.332333500 2013-08-07 04:12:29,304 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 46039226 2013-08-07 04:12:29.956953500 2013-08-07 04:12:29,955 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user derek.choi@apra.gov.au 2013-08-07 04:12:32.203985500 2013-08-07 04:12:32,202 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 22675613 2013-08-07 04:12:36.259598500 2013-08-07 04:12:36,181 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user rene.pisani@dbb.org.au 2013-08-07 04:12:36.358207500 2013-08-07 04:12:36,357 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user bernard.yam@dbb.org.au 2013-08-07 04:12:36.487393500 2013-08-07 04:12:36,484 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user kylie.lester@dbb.org.au 2013-08-07 04:12:36.606629500 2013-08-07 04:12:36,605 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user ruth.pepin@dbb.org.au 2013-08-07 04:12:36.875514500 2013-08-07 04:12:36,874 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 3441197 2013-08-07 04:12:36.884947500 2013-08-07 04:12:36,884 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 3441133 2013-08-07 04:12:37.036112500 2013-08-07 04:12:37,035 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 48201754 2013-08-07 04:12:42.493970500 2013-08-07 04:12:42,491 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user james.booth 2013-08-07 04:12:46.758858500 2013-08-07 04:12:46,753 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 10485829 2013-08-07 04:12:46.758861500 2013-08-07 04:12:46,757 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user daniel.hili@virginaustralia.com 2013-08-07 04:12:47.623696500 2013-08-07 04:12:47,621 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 10485769 2013-08-07 04:12:59.042592500 2013-08-07 04:12:59,040 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user acgceo.greg.cork 2013-08-07 04:13:05.253820500 2013-08-07 04:13:05,238 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 30048262 2013-08-07 04:13:05.615371500 2013-08-07 04:13:05,614 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user mariely@epo.org 2013-08-07 04:13:05.877790500 2013-08-07 04:13:05,876 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user peter_tawadros@coffey.com 2013-08-07 04:13:05.997787500 2013-08-07 04:13:05,997 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user mitchell_dowd@coffey.com 2013-08-07 04:13:06.128349500 2013-08-07 04:13:06,127 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user sample.client@tempuri.org 2013-08-07 04:13:06.245054500 2013-08-07 04:13:06,244 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user sample.client2@tempuri.org 2013-08-07 04:13:15.417012500 2013-08-07 04:13:15,414 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490670 2013-08-07 04:13:15.417016500 2013-08-07 04:13:15,416 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490668 2013-08-07 04:13:15.417018500 2013-08-07 04:13:15,416 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490669 2013-08-07 04:13:15.417533500 2013-08-07 04:13:15,417 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490666 2013-08-07 04:13:15.418558500 2013-08-07 04:13:15,418 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490667 2013-08-07 04:13:15.419179500 2013-08-07 04:13:15,418 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490664 2013-08-07 04:13:15.419658500 2013-08-07 04:13:15,419 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490665 2013-08-07 04:13:15.420250500 2013-08-07 04:13:15,419 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490662 2013-08-07 04:13:15.421388500 2013-08-07 04:13:15,420 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490663 2013-08-07 04:13:15.421937500 2013-08-07 04:13:15,421 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490660 2013-08-07 04:13:15.422527500 2013-08-07 04:13:15,422 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490661 2013-08-07 04:13:15.423054500 2013-08-07 04:13:15,422 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490658 2013-08-07 04:13:15.423633500 2013-08-07 04:13:15,423 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490659 2013-08-07 04:13:15.425421500 2013-08-07 04:13:15,425 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490657 2013-08-07 04:13:15.425981500 2013-08-07 04:13:15,425 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490656 2013-08-07 04:13:15.469562500 2013-08-07 04:13:15,468 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490705 2013-08-07 04:13:15.766060500 2013-08-07 04:13:15,764 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2490618 2013-08-07 04:13:15.770115500 2013-08-07 04:13:15,769 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2491222 2013-08-07 04:13:15.893132500 2013-08-07 04:13:15,884 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999007 2013-08-07 04:13:15.893134500 2013-08-07 04:13:15,885 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998896 2013-08-07 04:13:15.972384500 2013-08-07 04:13:15,971 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998942 2013-08-07 04:13:15.973147500 2013-08-07 04:13:15,972 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998954 2013-08-07 04:13:15.977188500 2013-08-07 04:13:15,976 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998962 2013-08-07 04:13:15.983222500 2013-08-07 04:13:15,982 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 12157051 2013-08-07 04:13:15.983881500 2013-08-07 04:13:15,983 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 12157146 2013-08-07 04:13:15.984620500 2013-08-07 04:13:15,984 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999158 2013-08-07 04:13:15.985492500 2013-08-07 04:13:15,985 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999159 2013-08-07 04:13:15.986155500 2013-08-07 04:13:15,985 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999160 2013-08-07 04:13:15.986708500 2013-08-07 04:13:15,986 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999186 2013-08-07 04:13:16.013612500 2013-08-07 04:13:16,012 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999563 2013-08-07 04:13:16.311135500 2013-08-07 04:13:16,310 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user sam.wang 2013-08-07 04:13:16.756958500 2013-08-07 04:13:16,755 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999652 2013-08-07 04:13:16.777912500 2013-08-07 04:13:16,777 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 2000110 2013-08-07 04:13:17.106474500 2013-08-07 04:13:17,105 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1999944 2013-08-07 04:13:17.683623500 2013-08-07 04:13:17,679 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user jcheng@cabrini.com.au 2013-08-07 04:13:19.925140500 2013-08-07 04:13:19,924 INFO [Long running task: Importing data] [procesors.pre.usergroup.UserPreprocessor] process Creating user greg.scott 2013-08-07 04:13:20.440234500 2013-08-07 04:13:20,438 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 45220038 2013-08-07 04:13:20.820264500 2013-08-07 04:13:20,818 INFO [Long running task: Importing data] [pre.whitelist.bandanafilters.BandanaGlobalSettingsFilter] process Accepting Bandana entry [_GLOBAL/atl.confluence.plugins.confluence-daily-summary-email:admin.defaultSchedule]. 2013-08-07 04:13:20.839815500 2013-08-07 04:13:20,839 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998849 2013-08-07 04:13:20.865812500 2013-08-07 04:13:20,865 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998854 2013-08-07 04:13:20.873267500 2013-08-07 04:13:20,872 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998855 2013-08-07 04:13:20.894446500 2013-08-07 04:13:20,893 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998850 2013-08-07 04:13:20.897859500 2013-08-07 04:13:20,897 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998851 2013-08-07 04:13:20.899592500 2013-08-07 04:13:20,899 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998852 2013-08-07 04:13:20.900532500 2013-08-07 04:13:20,900 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 1998853 2013-08-07 04:13:21.367151500 2013-08-07 04:13:21,360 INFO [Long running task: Importing data] [procesors.pre.usergroup.PersonalInformationPreprocessor] process Updating UserPersonalInformation entity with username for user: null, entityId: 19988565 2013-08-07 04:13:27.318369500 2013-08-07 04:13:27,316 WARN [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions SQL Error: 0, SQLState: 23505 2013-08-07 04:13:27.318371500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.318768500 2013-08-07 04:13:27,318 ERROR [Long running task: Importing data] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.318769500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.320043500 2013-08-07 04:13:27,319 ERROR [Long running task: Importing data] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session 2013-08-07 04:13:27.320045500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.320956500 2013-08-07 04:13:27,320 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.pages.Page] [Id[id]=27820133, Property[position]=, Property[title]=UNIFY hosted Development environment, Property[bodyContents]=, Property[version]=12, Property[creator]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=ff8080813fc39c17013fc39d724f0014], Property[creationDate]=2012-09-26 12:15:10.973, Property[lastModifier]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=ff8080813fc39c17013fc39d724f0014], Property[lastModificationDate]=2012-09-27 11:31:14.944, Property[versionComment]=, Property[originalVersion]=com.atlassian.confluence.pages.Page[Id[id]=27820106], Property[contentStatus]=current] 2013-08-07 04:13:27.320967500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.330332500 2013-08-07 04:13:27,326 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: 2013-08-07 04:13:27.330334500 -- referer: https://example-instance.jira-dev.com/wiki/admin/import/importconfluencesite.action | url: /wiki/admin/import/doimportconfluencesite.action | userName: mbadii | action: doimportconfluencesite 2013-08-07 04:13:27.330335500 com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) 2013-08-07 04:13:27.330394500 at $Proxy331.performImport(Unknown Source) 2013-08-07 04:13:27.330394500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330395500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330397500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330398500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330398500 at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) 2013-08-07 04:13:27.330402500 at $Proxy331.performImport(Unknown Source) 2013-08-07 04:13:27.330402500 at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:88) 2013-08-07 04:13:27.330403500 at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) 2013-08-07 04:13:27.330405500 at com.atlassian.ondemand.confluenceimporter.service.importer.OnDemandImportLongRunningTask.runInternal(OnDemandImportLongRunningTask.java:155) 2013-08-07 04:13:27.330406500 at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:26) 2013-08-07 04:13:27.330406500 at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) 2013-08-07 04:13:27.330408500 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) 2013-08-07 04:13:27.330409500 at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) 2013-08-07 04:13:27.330410500 at java.util.concurrent.FutureTask.run(FutureTask.java:138) 2013-08-07 04:13:27.330410500 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) 2013-08-07 04:13:27.330411500 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) 2013-08-07 04:13:27.330415500 at java.lang.Thread.run(Thread.java:662) 2013-08-07 04:13:27.330415500 Caused by: net.sf.hibernate.exception.ConstraintViolationException: could not insert: [com.atlassian.confluence.security.ContentPermission#1114124] 2013-08-07 04:13:27.330416500 at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:53) 2013-08-07 04:13:27.330417500 at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) 2013-08-07 04:13:27.330419500 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source) 2013-08-07 04:13:27.330419500 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) 2013-08-07 04:13:27.330420500 at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) 2013-08-07 04:13:27.330421500 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) 2013-08-07 04:13:27.330422500 at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) 2013-08-07 04:13:27.330423500 at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) 2013-08-07 04:13:27.330424500 at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) 2013-08-07 04:13:27.330424500 at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source) 2013-08-07 04:13:27.330425500 at com.atlassian.security.xml.RestrictedXMLReader.parse(RestrictedXMLReader.java:103) 2013-08-07 04:13:27.330435500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.parseBackup(DefaultXmlImporter.java:108) 2013-08-07 04:13:27.330436500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:60) 2013-08-07 04:13:27.330436500 ... 46 more {noformat} *Extra:* We are unable to extract the contents from the Backup file. Errors shown when trying to extract backup contents using 7za: {noformat} example-instance:/data/jirastudio/webdav]# 7za t Confluence-backup-20130807.zip 7-Zip (A) [64] 9.20 Copyright (c) 1999-2010 Igor Pavlov 2010-11-18 p7zip Version 9.20 (locale=en_AU.UTF-8,Utf16=on,HugeFiles=on,2 CPUs) Processing archive: Confluence-backup-20130807.zip Testing config/ehcache.xml Unsupported Method Testing plugin-data/com.atlassian.activeobjects.confluence.spi/activeObjectsBackupRestoreProvider.pdata Unsupported Method Testing entities.xml Unsupported Method Testing exportDescriptor.properties Unsupported Method Testing attachments/4981015/5144693/1 Unsupported Method Testing attachments/4981015/5144694/1 Unsupported Method Testing attachments/8388780/8486999/1 Unsupported Method Testing attachments/32538735/33095685/1 Unsupported Method ... and so on for like 50% of the files... {noformat}

    Atlassian JIRA | 4 years ago | Mauro Fernandez Badii [Atlassian]
    com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)

    Root Cause Analysis

    1. com.atlassian.confluence.importexport.ImportExportException

      Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: PSQLException: ERROR: duplicate key value violates unique constraint "cp_unique_group" 2013-08-07 04:13:27.330350500 at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:72) 2013-08-07 04:13:27.330351500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:386) 2013-08-07 04:13:27.330353500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:354) 2013-08-07 04:13:27.330354500 at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:119) 2013-08-07 04:13:27.330358500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:193) 2013-08-07 04:13:27.330359500 at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) 2013-08-07 04:13:27.330360500 at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:47) 2013-08-07 04:13:27.330363500 at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:48) 2013-08-07 04:13:27.330364500 at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) 2013-08-07 04:13:27.330366500 at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:206) 2013-08-07 04:13:27.330367500 at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75) 2013-08-07 04:13:27.330368500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:82) 2013-08-07 04:13:27.330371500 at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:72) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330372500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330373500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330376500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330376500 at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) 2013-08-07 04:13:27.330377500 at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) 2013-08-07 04:13:27.330378500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) 2013-08-07 04:13:27.330380500 at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) 2013-08-07 04:13:27.330381500 at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) 2013-08-07 04:13:27.330382500 at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 2013-08-07 04:13:27.330386500 at $Proxy92.performImport(Unknown Source) 2013-08-07 04:13:27.330386500 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 2013-08-07 04:13:27.330387500 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 2013-08-07 04:13:27.330387500 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 2013-08-07 04:13:27.330388500 at java.lang.reflect.Method.invoke(Method.java:597) 2013-08-07 04:13:27.330393500 at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)

      at $Proxy331.performImport()
    2. Unknown
      $Proxy331.performImport
      1. $Proxy331.performImport(Unknown Source)
      1 frame
    3. Java RT
      NativeMethodAccessorImpl.invoke0
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      1 frame