AnsweredAssumed Answered

1.3.0 -> 1.4 Integrity violation (how can I diagnose?)

Question asked by raphael on Nov 6, 2006
Dear users and developers,

I'm trying to upgrade from an alfresco 1.3.0 tomcat community edition to a 1.4 tomcat community edition.
I first tried upgrading by following the upgrade instructions in the release note (note that I can't find alfresco 1.3.1… Maybe a typo?) but didn't managed to get 1.4 up'n running this way. As mentioned in other topics I'm now trying to bootstrap an 1.4 in the Import/Export way.

So, I exported the full repository of my 1.3.0 and created a vm with a fresh 1.4 and the mandatory restore-context.xml and restore directory.

When alfresco bootstrap it starts importing ACPs but fails on one of them complaining of integrity violations (alfresco.log follows)… How can I diagnose the exact origin of these integrity violations so that I can fix them in the original repository before exporting it?

Thanks in advance and keep the good work.
Raphaël
P.S. System : Debian GNU/Linux sarge, sun j2sdk 1.5update8
P.S.2 alfresco.log:

21:52:08,200 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script: /opt/alfresco/tomcat/temp/Alfresco/AlfrescoSchemaCreate-org.hibernate.dialect.MySQLInnoDBDialect-45635.sql
21:52:10,448 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script: classpath:alfresco/dbscripts/create/1.4/${db.script.dialect}/post-create-indexes.sql
21:52:11,045 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Created store: user://alfrescoUserStore
21:52:11,051 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Importing alfresco/extension/restore/Export_users.acp
21:52:11,312 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import started at Mon Nov 06 21:52:11 UTC 2006 (1162849931311)
21:52:12,822 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import completed at Mon Nov 06 21:52:12 UTC 2006 (1162849932822)
21:52:12,822 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import duration: 1511 ms (Note: excluding commit time)
21:52:12,823 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Nodes created: 12
21:52:12,823 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Nodes linked: 0
21:52:12,823 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Aspects Added: 0
21:52:12,823 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Properties set: 84
21:52:12,823 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Content set: 0
21:52:12,823 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Permissions set: 0
21:52:13,151 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Created store: system://system
21:52:13,159 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Importing alfresco/extension/restore/Export_system.acp
21:52:13,161 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import started at Mon Nov 06 21:52:13 UTC 2006 (1162849933161)
21:52:13,267 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import completed at Mon Nov 06 21:52:13 UTC 2006 (1162849933267)
21:52:13,267 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import duration: 106 ms (Note: excluding commit time)
21:52:13,267 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Nodes created: 2
21:52:13,268 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Nodes linked: 0
21:52:13,268 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Aspects Added: 0
21:52:13,268 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Properties set: 26
21:52:13,268 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Content set: 0
21:52:13,268 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Permissions set: 0
21:52:13,357 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Created store: workspace://lightWeightVersionStore
21:52:13,499 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Importing alfresco/extension/restore/Export_versions.acp
21:52:13,516 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import started at Mon Nov 06 21:52:13 UTC 2006 (1162849933515)
21:52:48,029 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import completed at Mon Nov 06 21:52:48 UTC 2006 (1162849968029)
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap] Import duration: 34514 ms (Note: excluding commit time)
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Nodes created: 812
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Nodes linked: 47
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Aspects Added: 0
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Properties set: 6796
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Content set: 47
21:52:48,030 DEBUG [org.alfresco.repo.importer.ImporterBootstrap]  Permissions set: 1
21:52:48,336 ERROR [org.alfresco.repo.node.integrity.IntegrityChecker] Found 5 integrity violations:
The association source multiplicity has been violated:
   Association: Association[ class=ClassDef[name={http://www.alfresco.org/model/versionstore/1.0}version], name={http://www.alfresco.org/model/versionstore/1.0}successor, target class={http://www.alfresco.org/model/versionstore/1.0}version, source role=null, target role=null]
   Required source Multiplicity: 1..1
   Actual source Multiplicity: 0
The association source multiplicity has been violated:
   Association: Association[ class=ClassDef[name={http://www.alfresco.org/model/versionstore/1.0}version], name={http://www.alfresco.org/model/versionstore/1.0}successor, target class={http://www.alfresco.org/model/versionstore/1.0}version, source role=null, target role=null]
   Required source Multiplicity: 1..1
   Actual source Multiplicity: 0
The association source multiplicity has been violated:
   Association: Association[ class=ClassDef[name={http://www.alfresco.org/model/versionstore/1.0}version], name={http://www.alfresco.org/model/versionstore/1.0}successor, target class={http://www.alfresco.org/model/versionstore/1.0}version, source role=null, target role=null]
   Required source Multiplicity: 1..1
   Actual source Multiplicity: 0
The association source multiplicity has been violated:
   Association: Association[ class=ClassDef[name={http://www.alfresco.org/model/versionstore/1.0}version], name={http://www.alfresco.org/model/versionstore/1.0}successor, target class={http://www.alfresco.org/model/versionstore/1.0}version, source role=null, target role=null]
   Required source Multiplicity: 1..1
   Actual source Multiplicity: 0
The association source multiplicity has been violated:
   Association: Association[ class=ClassDef[name={http://www.alfresco.org/model/versionstore/1.0}version], name={http://www.alfresco.org/model/versionstore/1.0}successor, target class={http://www.alfresco.org/model/versionstore/1.0}version, source role=null, target role=null]
   Required source Multiplicity: 1..1
   Actual source Multiplicity: 0
21:52:48,819 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Transaction didn't commit
org.alfresco.repo.node.integrity.IntegrityException: Integrity failure
        at org.alfresco.repo.node.integrity.IntegrityChecker.checkIntegrity(IntegrityChecker.java:611)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.flush(AlfrescoTransactionSupport.java:518)
        at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:589)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:657)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:482)
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:469)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionAfterReturning(TransactionAspectSupport.java:266)
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:397)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:441)
        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:670)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
        at org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
21:52:48,825 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:448)
        at org.alfresco.repo.importer.ImporterBootstrap.onBootstrap(ImporterBootstrap.java:670)
        at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:54)
        at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:45)
        at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:225)
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:323)
        at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:134)
        at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3692)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4127)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
        at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:804)
        at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:693)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:472)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1118)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
        at org.apache.catalina.core.StandardService.start(StandardService.java:450)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:536)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:275)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: javax.transaction.RollbackException: Transaction didn't commit: Integrity failure
        at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:404)
        at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:441)
        … 33 more

Outcomes