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
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards 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