confluence7.4.6导入备份失败 求解

导入失败，请查看日志文件获取更多信息。com.atlassian.confluence.importexport.lmportExportException: Unable to complete importbecause the data does not match the constraints in the Confluence schema. Cause.MySQLIntegrityConstraintViolationException: Column "USERNAME' cannot be null 

1、故障起因：

        confluence版本是7.4.6 ，用每日自动备份的文件去另一台相同环境的服务器上恢复，就提示失败了  Username字段设置允许为空  但是也不行，卡在%29

2、日志：

2023-06-13 11:13:32,395 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7201: "Upgrade to build number: 7201" - Ok
2023-06-13 11:13:32,395 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7110: "Reindex all blogs." - Ok
2023-06-13 11:13:32,395 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7109: "Drop and update some low performance indexes on EVENTS table for Synchrony" - Ok
2023-06-13 11:13:32,395 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7108: "Update index sp_comp_idx when the definition is not correct" - Ok
2023-06-13 11:13:32,395 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7106: "Drop the hibernate 2 constraints in preparation for them to be re-created in the hibernate 5 naming style" - Ok
2023-06-13 11:13:32,395 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7105: "Drop or update some low performance indexes on CONTENT" - Ok
2023-06-13 11:13:32,396 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7104: "Set the mime type for csv files to text/csv" - Ok
2023-06-13 11:13:32,396 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 7101: "Migrate over Documentation theme settings to Custom Page Settings in the default theme" - Ok
2023-06-13 11:13:32,399 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6439: "Reindexes all PersonalInformation objects, creating them for any users that do not have one." - Ok
2023-06-13 11:13:32,399 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6430: "Upgrade to build number: 6430" - Ok
2023-06-13 11:13:32,403 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6424: "Adds missing multi-column unique constraints to the Crowd database tables" - Ok
2023-06-13 11:13:32,408 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6423: "Cleaning data that violates constraints we want to add in the next migration task" - Ok
2023-06-13 11:13:32,408 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6422: "Upgrade to build number: 6422" - Ok
2023-06-13 11:13:32,411 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6412: "Delete all FileStore IDs" - Ok
2023-06-13 11:13:32,412 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6406: "Reindex all spaces" - Ok
2023-06-13 11:13:32,412 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6403: "Upgrade to build number: 6403" - Ok
2023-06-13 11:13:32,412 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6193: "Rebuild the Confluence favourites index" - Ok
2023-06-13 11:13:32,412 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6193: "Rebuild the Confluence favourites index" - Ok
2023-06-13 11:13:32,412 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6189: "Upgrade to build number: 6189" - Ok
2023-06-13 11:13:32,415 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6180: "Adds a multi-column index to content table that speeds up many common queries." - Ok
2023-06-13 11:13:32,416 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6175: "Upgrade to build number: 6175" - Ok
2023-06-13 11:13:32,416 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 6169: "Upgrade to build number: 6169" - Not Ok
2023-06-13 11:13:32,416 INFO [Caesium-1-4] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Backward compatibility for export: "Upgrade to build number: 6169" prevents compatibility before 6169
2023-06-13 11:13:33,618 WARN [Caesium-1-4] [activeobjects.confluence.backup.LoggingBackupProgressMonitor] beginBackup Begin Active objects backup, change log level to INFO for com.atlassian.activeobjects.confluence.backup for more detailed logging.
 -- url: /setup/finishsetup.action | traceId: c4de059216e6694e | userName: anonymous | referer: http://10.50.55.85:8090/setup/setupadministrator-start.action | action: finishsetup
2023-06-13 11:13:34,206 WARN [Caesium-1-4] [activeobjects.confluence.backup.LoggingBackupProgressMonitor] endBackup Completed active objects backup.
 -- url: /setup/finishsetup.action | traceId: c4de059216e6694e | userName: anonymous | referer: http://10.50.55.85:8090/setup/setupadministrator-start.action | action: finishsetup
2023-06-13 11:13:34,287 ERROR [Caesium-1-4] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job webhooks.history.daily.cleanup.runner#webhooks.history.daily.cleanup.job failed to run
 -- url: /setup/finishsetup.action | traceId: c4de059216e6694e | userName: anonymous | referer: http://10.50.55.85:8090/setup/setupadministrator-start.action | action: finishsetup
java.lang.IllegalStateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here
        at org.springframework.orm.hibernate.SessionFactoryUtils.getSession(SessionFactoryUtils.java:316)
        at org.springframework.orm.hibernate.SessionFactoryUtils.getSession(SessionFactoryUtils.java:194)
        at com.atlassian.hibernate.SpringPluginHibernateSessionFactory.getSession(SpringPluginHibernateSessionFactory.java:23)
        at jdk.internal.reflect.GeneratedMethodAccessor339.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26)
        at com.sun.proxy.$Proxy476.getSession(Unknown Source)
        at jdk.internal.reflect.GeneratedMethodAccessor339.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
        at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
        at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
        at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
        at com.sun.proxy.$Proxy1144.getSession(Unknown Source)
        at com.atlassian.activeobjects.confluence.ConfluenceTenantAwareDataSourceProvider$SessionFactoryDataSource.getConnection(ConfluenceTenantAwareDataSourceProvider.java:81)
        at com.atlassian.activeobjects.internal.DataSourceProviderActiveObjectsFactory$ActiveObjectsDataSource.getConnection(DataSourceProviderActiveObjectsFactory.java:113)
        at jdk.internal.reflect.GeneratedMethodAccessor340.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at net.java.ao.builder.DelegatingDisposableDataSourceHandler.delegate(DelegatingDisposableDataSourceHandler.java:37)
        at net.java.ao.builder.DelegatingDisposableDataSourceHandler.invoke(DelegatingDisposableDataSourceHandler.java:30)
        at com.sun.proxy.$Proxy2446.getConnection(Unknown Source)
        at net.java.ao.DatabaseProvider.getConnection(DatabaseProvider.java:860)
        at net.java.ao.EntityManager.deleteWithSQL(EntityManager.java:588)
        at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.deleteWithSQL(EntityManagedActiveObjects.java:126)
        at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.deleteWithSQL(TenantAwareActiveObjects.java:287)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.base/java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
        at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)
        at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)
        at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
        at com.sun.proxy.$Proxy1355.deleteWithSQL(Unknown Source)
        at com.atlassian.webhooks.internal.dao.AoInvocationHistoryDao.deleteDailyCountsOlderThan(AoInvocationHistoryDao.java:116)
        at com.atlassian.webhooks.internal.dao.AsyncInvocationHistoryDao.deleteDailyCountsOlderThan(AsyncInvocationHistoryDao.java:77)
        at com.atlassian.webhooks.internal.history.DefaultInvocationHistoryService$DailyCleanupJobRunner.runJob(DefaultInvocationHistoryService.java:334)
        at com.atlassian.confluence.impl.schedule.caesium.JobRunnerWrapper.doRunJob(JobRunnerWrapper.java:117)
        at com.atlassian.confluence.impl.schedule.caesium.JobRunnerWrapper.lambda$runJob$0(JobRunnerWrapper.java:87)
        at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContextInternal(VCacheRequestContextManager.java:84)
        at com.atlassian.confluence.impl.vcache.VCacheRequestContextManager.doInRequestContext(VCacheRequestContextManager.java:68)
        at com.atlassian.confluence.impl.schedule.caesium.JobRunnerWrapper.runJob(JobRunnerWrapper.java:87)
        at com.atlassian.scheduler.core.JobLauncher.runJob(JobLauncher.java:134)
        at com.atlassian.scheduler.core.JobLauncher.launchAndBuildResponse(JobLauncher.java:106)
        at com.atlassian.scheduler.core.JobLauncher.launch(JobLauncher.java:90)
        at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.launchJob(CaesiumSchedulerService.java:435)
        at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeLocalJob(CaesiumSchedulerService.java:402)
        at com.atlassian.scheduler.caesium.impl.CaesiumSchedulerService.executeQueuedJob(CaesiumSchedulerService.java:380)
        at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeJob(SchedulerQueueWorker.java:66)
        at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.executeNextJob(SchedulerQueueWorker.java:60)
        at com.atlassian.scheduler.caesium.impl.SchedulerQueueWorker.run(SchedulerQueueWorker.java:35)
        at java.base/java.lang.Thread.run(Unknown Source)
2023-06-13 11:13:34,290 WARN [Caesium-1-4] [impl.schedule.caesium.JobRunnerWrapper] runJob Scheduled job webhooks.history.daily.cleanup.runner#webhooks.history.daily.cleanup.job completed unsuccessfully with response JobRunnerResponse[runOutcome=FAILED,message='IllegalStateException: No Hibernate Session bound to thread, and configuration does not allow creation of non-transactional one here']
 -- url: /setup/finishsetup.action | traceId: c4de059216e6694e | userName: anonymous | referer: http://10.50.55.85:8090/setup/setupadministrator-start.action | action: finishsetup
2023-06-13 11:14:37,061 WARN [http-nio-8090-exec-7] [confluence.util.profiling.DefaultActivityMonitor] close Exceeded the threshold of 60000 ms: ActivitySnapshot{startTime=1686626016712, threadId=64, threadName='http-nio-8090-exec-7', userId='admin', type='web-request', summary='/welcome.action'}
 -- referer: http://10.50.55.85:8090/login.action?os_destination=%2Fdashboard.action&permissionViolation=true | url: /welcome.action | traceId: 1c6344c122414eab | userName: admin
2023-06-13 11:14:42,103 INFO [http-nio-8090-exec-4] [confluence.importexport.actions.ImportLongRunningTask] runInternal Beginning import by user admin
2023-06-13 11:14:42,369 WARN [http-nio-8090-exec-4] [confluence.importexport.xmlimport.DeferredOperations] reportOutstandingOperations Uncompleted deferred operations waiting for:[class = com.atlassian.confluence.user.ConfluenceUserImpl, id = ]
 -- referer: http://10.50.55.85:8090/welcome.action | url: /rest/onboarding/1/space | traceId: 9d09da286bb075c2 | userName: admin
2023-06-13 11:14:42,370 WARN [http-nio-8090-exec-4] [confluence.importexport.xmlimport.DeferredOperations] reportOutstandingOperations Set property creator on class = com.atlassian.confluence.spaces.Space, id = 2228225 to class = com.atlassian.confluence.user.ConfluenceUserImpl, id = 
 -- referer: http://10.50.55.85:8090/welcome.action | url: /rest/onboarding/1/space | traceId: 9d09da286bb075c2 | userName: admin
2023-06-13 11:14:42,371 WARN [http-nio-8090-exec-4] [confluence.importexport.xmlimport.DeferredOperations] reportOutstandingOperations Set property lastModifier on class = com.atlassian.confluence.spaces.Space, id = 2228225 to class = com.atlassian.confluence.user.ConfluenceUserImpl, id = 
 -- referer: http://10.50.55.85:8090/welcome.action | url: /rest/onboarding/1/space | traceId: 9d09da286bb075c2 | userName: admin
2023-06-13 11:14:42,452 INFO [http-nio-8090-exec-4] [confluence.importexport.actions.ImportLongRunningTask] runInternal Finished import.
2023-06-13 11:14:42,470 WARN [perm-delta-cache-receiver] [gatekeeper.evaluator.cache.SpaceCache] warn No space with key SPC1 found in the cache. Recreating the space object...
 -- referer: http://10.50.55.85:8090/setup/setupdbtype.action | url: /setup/setuppaths.action | traceId: 009539e49f10d0de | userName: anonymous | action: setuppaths
2023-06-13 11:14:43,064 WARN [AtlassianEvent::CustomizableThreadFactory-1] [plugins.tasklist.transformer.DefaultInlineTaskRenderedFieldsExtractor] buildDescription Unable to extract links from the Inline Task title. The Inline Task will be created without a description.
 -- url: /rest/onboarding/1/space | referer: http://10.50.55.85:8090/welcome.action | traceId: 9d09da286bb075c2 | userName: admin