[Résolu]Migration 2.1 vers 3.2

cancel
Showing results for 
Search instead for 
Did you mean: 
nicolas_4463
Member II

[Résolu]Migration 2.1 vers 3.2

Bonjour,
Nous entamons une nouvelle tentative de migration de la version 2.1 vers la version 3.2.
Fort (enfin si on peut dire) de notre tentative 2.1 vers 3LabsStable, nous avons bon espoir d'arriver au bout de l'exercice.  Smiley Very Happy

Comme pour les essais précédents, nous tiendrons à jour notre progression afin d'aider, autant que faire ce peut, les courageux  :lol:

Premier plantage :
Notre réferentiel 2.1 comporte des documents en vrac lié à un bug fixé par un module. cf : https://issues.alfresco.com/jira/browse/AR-2212
Ce point bloque le passage d'un des premiers scripts de migration côté base de données (erreur de contrainte d'intégrité).
Il faut donc faire un peu de ménage préalable pour que le référentiel ne comporte pas ce genre d'anomalie.
Après nettoyage, les scripts tourne toujours.

A suivre…

La migration est allée un peu plus loin…
Avec des plantages bien copieux :mrgreen:
Certains sont toujours les mêmes que ceux rencontrés avec la 3labsStable.
Et puis un lot de nouveaux.
Misére ! Les bras m'en tombent.  :cry:

Nicolas
11 Replies
nicolas_4463
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Voici la liste de nos ennuis :
Premier plantage:
Lié à une table manquante, un post similiaire est envoyé sur le forum en anglais : http://forums.alfresco.com/en/viewtopic.php?f=8&t=20219
Il est associé à un JIRA : https://issues.alfresco.com/jira/browse/ALFCOM-3240
Il est demandé de tester la migration intermédiaire par la version 3labsStable. Ce que nous essayons en ce moment.

03:41:11,886 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: drop table avm_issuer_ids
   Error: Unknown table 'avm_issuer_ids'
   File: /home/alfresco/alfresco-3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-6754.sql
   Line: 45
03:41:11,889 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'avm_issuer_ids'
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1072)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1026)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:841)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:812)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:748)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1238)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
03:41:11,893 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06310000 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1366)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'avm_issuer_ids'
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1026)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1072)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1026)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:841)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:812)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:748)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1238)
   … 35 more

Second plantage:
La l'histoire recommence nous avions les mêmes soucis avec le VersionMigrator pour la 3labsSatble. A l'origine il semblait que les contenus concernés étaient ceux versionnés dans une version d'Alfresco 1.X. Aujourd'hui, les documents en echec sont récents et datent d'un versionning avec la version 2.1.  :mrgreen:
Force est de constater que notre lightWeightVersionStore est dans un état plus qu'inquiétant et nous savons pas si c'est normal.
Nous avons plusieurs fichiers stockés qui n'existent plus en tant que binaire (pas mal de fichiers (copie de travail)).
Du coup, il semble normal que le patch de migration la 3Labs Stable s'effondre !

10:07:14,043 INFO  [org.alfresco.repo.version.VersionMigrator] Found 76 version histories in old version store (in 0 secs)
10:07:14,468 ERROR [org.alfresco.repo.version.VersionMigrator] Skipping migration of: workspace://lightWeightVersionStore/4f0ccb24-4d37-11db-bfe8-3fc8da89251a
java.lang.NullPointerException
   at org.alfresco.repo.version.VersionMigrator.v2CreateNewVersion(VersionMigrator.java:199)
   at org.alfresco.repo.version.VersionMigrator.migrateVersionHistory(VersionMigrator.java:165)
   at org.alfresco.repo.version.VersionMigrator$1.execute(VersionMigrator.java:401)
   at org.alfresco.repo.version.VersionMigrator$1.execute(VersionMigrator.java:387)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.version.VersionMigrator.migrateVersions(VersionMigrator.java:385)
   at org.alfresco.repo.admin.patch.impl.MigrateVersionStorePatch.applyInternal(MigrateVersionStorePatch.java:104)
   at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:388)
   at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:382)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:233)
   at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:414)
   at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:378)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
   at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:418)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:294)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:231)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:229)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:234)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:168)
   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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy69.applyOutstandingPatches(Unknown Source)
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:89)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
10:07:14,794 ERROR [org.alfresco.repo.version.VersionMigrator] Skipping migration of batch size (1): java.lang.NullPointerException

Troisième plantage:
C'est une nouveauté pour cette nouvelle version.

10:10:34,488 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]    Applying patch 'patch.authorityMigration' (Copies any old authorities from the user store to the spaces store.).
10:10:48,132 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] 06310002 java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider.resolvePath(AbstractHomeFolderProvider.java:259)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider.getPathNodeRef(AbstractHomeFolderProvider.java:244)
   at org.alfresco.repo.security.person.UIDBasedHomeFolderProvider.getHomeFolder(UIDBasedHomeFolderProvider.java:74)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider$OnCreateNode.doWork(AbstractHomeFolderProvider.java:298)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider$OnCreateNode.doWork(AbstractHomeFolderProvider.java:283)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider.onCreateNode(AbstractHomeFolderProvider.java:270)
   at org.alfresco.repo.security.person.HomeFolderManager.onCreateNode(HomeFolderManager.java:136)
   at org.alfresco.repo.security.person.PersonServiceImpl$3.execute(PersonServiceImpl.java:559)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.security.person.PersonServiceImpl.makeHomeFolderIfRequired(PersonServiceImpl.java:555)
   at org.alfresco.repo.security.person.PersonServiceImpl.getPersonOrNull(PersonServiceImpl.java:319)
   at org.alfresco.repo.security.person.PersonServiceImpl.personExists(PersonServiceImpl.java:298)
   at org.alfresco.repo.security.authority.AuthorityServiceImpl.addAuthority(AuthorityServiceImpl.java:261)
   at org.alfresco.repo.admin.patch.impl.AuthorityMigrationPatch.migrateAuthorities(AuthorityMigrationPatch.java:139)
   at org.alfresco.repo.admin.patch.impl.AuthorityMigrationPatch.migrateAuthorities(AuthorityMigrationPatch.java:143)
   at org.alfresco.repo.admin.patch.impl.AuthorityMigrationPatch.migrateAuthorities(AuthorityMigrationPatch.java:143)
   at org.alfresco.repo.admin.patch.impl.AuthorityMigrationPatch.applyInternal(AuthorityMigrationPatch.java:193)
   at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:388)
   at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:382)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:233)
   at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:414)
   at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:378)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
   at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:418)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:294)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:231)
   at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:229)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:234)
   at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:168)
   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.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy69.applyOutstandingPatches(Unknown Source)
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:89)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
10:10:55,705 ERROR [org.alfresco.repo.admin.patch.PatchExecuter]
=== Failed to apply patch         ===
ID: patch.authorityMigration
RESULT:
06310002 java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider.resolvePath(AbstractHomeFolderProvider.java:259)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider.getPathNodeRef(AbstractHomeFolderProvider.java:244)
   at org.alfresco.repo.security.person.UIDBasedHomeFolderProvider.getHomeFolder(UIDBasedHomeFolderProvider.java:74)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider$OnCreateNode.doWork(AbstractHomeFolderProvider.java:298)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider$OnCreateNode.doWork(AbstractHomeFolderProvider.java:283)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:489)
   at org.alfresco.repo.security.person.AbstractHomeFolderProvider.onCreateNode(AbstractHomeFolderProvider.java:270)
   at org.alfresco.repo.security.person.HomeFolderManager.onCreateNode(HomeFolderManager.java:136)
   at org.alfresco…

Quatrième plantage:
Tout neuf aussi!  :mrgreen:

10:10:55,711 INFO  [org.alfresco.repo.admin.patch.PatchExecuter]
=== Applied patch                 ===
ID: patch.zonedAuthorities
RESULT:
Imported view into bootstrap location: /sys:system (workspace://SpacesStore/6f14d118-0d88-11db-b9d0-e519a942c761)
=====================================
10:10:55,711 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 06310003 Not all patches could be applied
   at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:124)
   at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)

A suivre…

Nicolas
nicolas_4463
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Bonjour,
Nous voici un peu plus avancé, enfin, j'espére !  :shock:
Nous avons donc ajouté la migration transitoire par la version 3Labs Stable.
Elle se passe correctement à l'exception de la migration des documents versionnés.

Au démarrage de la migration de la 3 Stable vers la 3.2, nous avons eu une erreur de script SQL:
15:19:34,067 INFO  [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco/alfresco-3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-39490.sql (Copied from classpath:alfresco/dbscripts/upgrade/3.2/org.hibernate.dialect.MySQLInnoDBDialect/remove-AVM-issuer.sql).
15:19:34,083 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Statement execution failed:
   SQL: insert into avm_nodes
select
(select max(id)+1 from avm_nodes),
class_type, vers, version_id, guid, creator, owner, lastModifier, createDate, modDate, accessDate, is_root, store_new_id, acl_id, deletedType, layer_id, indirection, indirection_version, primary_indirection, opacity, content_url, mime_type, encoding, length
from avm_nodes where id = 0
   Error: Incorrect integer value: 'System' for column 'createDate' at row 1
   File: /home/alfresco/alfresco-3.2/tomcat/temp/Alfresco/AlfrescoSchema-MySQLInnoDBDialect-Update-39490.sql
   Line: 20
15:19:34,084 ERROR [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema auto-update failed
java.sql.SQLException: Incorrect integer value: 'System' for column 'createDate' at row 1
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1072)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1026)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:841)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:812)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:748)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1238)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
15:19:34,097 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07030000 Schema auto-update failed
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1366)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.sql.SQLException: Incorrect integer value: 'System' for column 'createDate' at row 1
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)
   at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)
   at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeStatement(SchemaBootstrap.java:1072)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptFile(SchemaBootstrap.java:1026)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.executeScriptUrl(SchemaBootstrap.java:841)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.checkSchemaPatchScripts(SchemaBootstrap.java:812)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.updateSchema(SchemaBootstrap.java:748)
   at org.alfresco.repo.domain.schema.SchemaBootstrap.onBootstrap(SchemaBootstrap.java:1238)
   … 35 more
L'ordre des colonnes ne correspondait pas à ce que nous avions en base.
Le script Remove-AVM-issuer.sql est corrigé comme suit :

insert into avm_nodes
select
(select max(id)+1 from avm_nodes),
class_type, vers, version_id, creator, owner, lastModifier, createDate, modDate, accessDate, is_root,
store_new_id, acl_id, deletedType, layer_id, indirection, primary_indirection, opacity, content_url, mime_type, encoding, length, guid, indirection_version
from avm_nodes where id = 0;

La correction de la requête nous permet de pousser peu plus loin mais pas beaucoup plus. Nous avons une erreur d'indexation lucene :
16:01:36,117 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07030000 Reindex failure for org.alfresco.repo.node.index.FullIndexRecoveryComponent
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:271)
   at org.alfresco.repo.node.index.IndexRecoveryBootstrapBean.onBootstrap(IndexRecoveryBootstrapBean.java:35)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: java.lang.RuntimeException: Error during run with lock.
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2273)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.<init>(IndexInfo.java:575)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.getIndexInfo(IndexInfo.java:365)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneBase.initialise(AbstractLuceneBase.java:106)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.getSearcher(ADMLuceneSearcherImpl.java:147)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneIndexerAndSearcherFactory.getSearcher(ADMLuceneIndexerAndSearcherFactory.java:119)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.getSearcher(AbstractLuceneIndexerAndSearcherFactory.java:467)
   at org.alfresco.repo.search.impl.lucene.AbstractLuceneIndexerAndSearcherFactory.getSearcher(AbstractLuceneIndexerAndSearcherFactory.java:89)
   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.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy34.getSearcher(Unknown Source)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:83)
   at org.alfresco.repo.node.index.AbstractReindexComponent.isTxnIdPresentInIndex(AbstractReindexComponent.java:450)
   at org.alfresco.repo.node.index.AbstractReindexComponent.isTxnPresentInIndex(AbstractReindexComponent.java:375)
   at org.alfresco.repo.node.index.AbstractReindexComponent.areTxnsInIndex(AbstractReindexComponent.java:539)
   at org.alfresco.repo.node.index.FullIndexRecoveryComponent.reindexImpl(FullIndexRecoveryComponent.java:194)
   at org.alfresco.repo.node.index.AbstractReindexComponent$1.execute(AbstractReindexComponent.java:256)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:326)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:262)
   … 36 more
Caused by: java.io.IOException: read past EOF
   at org.apache.lucene.store.BufferedIndexInput.refill(BufferedIndexInput.java:151)
   at org.apache.lucene.store.BufferedIndexInput.readByte(BufferedIndexInput.java:38)
   at org.apache.lucene.store.IndexInput.readInt(IndexInput.java:68)
   at org.apache.lucene.index.FieldsReader.<init>(FieldsReader.java:84)
   at org.apache.lucene.index.SegmentReader.initialize(SegmentReader.java:357)
   at org.apache.lucene.index.SegmentReader.get(SegmentReader.java:306)
   at org.apache.lucene.index.SegmentReader.get(SegmentReader.java:269)
   at org.apache.lucene.index.DirectoryIndexReader$1.doBody(DirectoryIndexReader.java:100)
   at org.apache.lucene.index.SegmentInfos$FindSegmentsFile.run(SegmentInfos.java:653)
   at org.apache.lucene.index.DirectoryIndexReader.open(DirectoryIndexReader.java:115)
   at org.apache.lucene.index.IndexReader.open(IndexReader.java:316)
   at org.apache.lucene.index.IndexReader.open(IndexReader.java:227)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.buildReferenceCountingIndexReader(IndexInfo.java:1945)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.access$1200(IndexInfo.java:141)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$2.doWork(IndexInfo.java:636)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2342)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2262)
   … 58 more

Une recherche rapide dans le forum nous donne un post auquel répondait Michael.
Il encourageait le gars à patienter jusqu'à l'arrivée de la 3.2 qui devrait régler son soucis !  Smiley Surprisedops:
Bon, nous voilà bien!
En ce moment même les indexes et les backups sont détruits et un recovery=FULL tourne. J'avoue que tout ce qui peut être croisé l'est, y compris les doigts ! Smiley Very Happy

A suivre…
Nicolas
nicolas_4463
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Bonjour,
Ce matin pas de bonnes nouvelles, l'indexation est bel et bien plantée :
18:33:26,610 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    10 % complete.
18:36:02,295 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    20 % complete.
18:57:01,641 ERROR [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index merger failed to recover - suspending
java.lang.RuntimeException: Error during run with lock.
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2273)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.access$4500(IndexInfo.java:141)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger.recoverImpl(IndexInfo.java:3177)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$AbstractSchedulable.run(IndexInfo.java:3019)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
   at java.lang.Thread.run(Thread.java:595)
Caused by: java.io.FileNotFoundException: /mnt/alfrescovol/alfresco/content/lucene-indexes/workspace/SpacesStore/ee78e4a2-33ad-4375-a66f-1383757cadf8/_0.fdx (No such file or directory)
   at java.io.RandomAccessFile.open(Native Method)
   at java.io.RandomAccessFile.<init>(RandomAccessFile.java:212)
   at org.apache.lucene.store.FSDirectory$FSIndexInput$Descriptor.<init>(FSDirectory.java:552)
   at org.apache.lucene.store.FSDirectory$FSIndexInput.<init>(FSDirectory.java:582)
   at org.apache.lucene.store.FSDirectory.openInput(FSDirectory.java:488)
   at org.apache.lucene.store.FSDirectory.openInput(FSDirectory.java:482)
   at org.apache.lucene.store.Directory.copy(Directory.java:190)
   at org.apache.lucene.store.RAMDirectory.<init>(RAMDirectory.java:73)
   at org.apache.lucene.store.RAMDirectory.<init>(RAMDirectory.java:84)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.buildReferenceCountingIndexReader(IndexInfo.java:1944)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.access$1200(IndexInfo.java:141)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo$Merger$2.doWork(IndexInfo.java:3236)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2342)
   at org.alfresco.repo.search.impl.lucene.index.IndexInfo.doWithFileLock(IndexInfo.java:2262)
   … 6 more
18:57:01,701 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   240 failed with error: 07030001 Exception in Transaction..
18:59:48,836 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   241 failed with error: 07030002 Exception in Transaction..
18:59:50,072 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   242 failed with error: 07030003 Exception in Transaction..
19:00:10,806 ERROR [org.alfresco.repo.search.impl.lucene.index.IndexInfo] Index merger has recovered - resuming …
19:00:12,022 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   245 failed with error: 07030004 Exception in Transaction..
19:02:12,981 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   246 failed with error: 07030005 Exception in Transaction..
19:02:12,989 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   247 failed with error: 07030006 Exception in Transaction..
19:02:12,997 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   248 failed with error: 07030007 Exception in Transaction..
19:02:13,005 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   249 failed with error: 07030008 Exception in Transaction..
19:02:13,013 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   250 failed with error: 07030009 Exception in Transaction..
19:02:13,330 INFO  [org.alfresco.repo.node.index.FullIndexRecoveryComponent]    30 % complete.
19:03:42,463 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   252 failed with error: 07030010 Exception in Transaction..
19:03:42,476 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   253 failed with error: 07030011 Exception in Transaction..
19:03:42,522 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   255 failed with error: 07030012 Exception in Transaction..
19:03:56,201 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   256 failed with error: 07030013 Exception in Transaction..
19:04:01,557 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   257 failed with error: 07030014 Exception in Transaction..
19:04:01,562 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   258 failed with error: 07030015 Exception in Transaction..
19:04:02,858 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   259 failed with error: 07030016 Exception in Transaction..
19:04:02,865 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   260 failed with error: 07030017 Exception in Transaction..
19:04:18,406 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   261 failed with error: 07030018 Exception in Transaction..
19:04:22,597 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   262 failed with error: 07030019 Exception in Transaction..
19:04:22,614 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   263 failed with error: 07030020 Exception in Transaction..
19:04:22,626 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   264 failed with error: 07030021 Exception in Transaction..
19:04:22,648 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   265 failed with error: 07030022 Exception in Transaction..
19:04:30,034 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   266 failed with error: 07030023 Exception in Transaction..
19:04:30,039 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   267 failed with error: 07030024 Exception in Transaction..
19:04:30,047 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   268 failed with error: 07030025 Exception in Transaction..
19:04:31,679 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   269 failed with error: 07030026 Exception in Transaction..
19:04:31,683 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   270 failed with error: 07030027 Exception in Transaction..
19:04:41,656 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   271 failed with error: 07030028 Exception in Transaction..
19:04:41,664 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   272 failed with error: 07030029 Exception in Transaction..
19:04:43,291 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   273 failed with error: 07030030 Exception in Transaction..
19:04:43,301 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   274 failed with error: 07030031 Exception in Transaction..
19:04:43,310 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   275 failed with error: 07030032 Exception in Transaction..
19:04:47,476 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   276 failed with error: 07030033 Exception in Transaction..
19:04:52,873 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   277 failed with error: 07030034 Exception in Transaction..
19:04:52,877 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   278 failed with error: 07030035 Exception in Transaction..
19:04:52,880 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   279 failed with error: 07030036 Exception in Transaction..
19:04:52,886 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   280 failed with error: 07030037 Exception in Transaction..
19:05:03,205 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   281 failed with error: 07030038 Exception in Transaction..
19:05:03,211 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   282 failed with error: 07030039 Exception in Transaction..
19:05:03,219 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   283 failed with error: 07030040 Exception in Transaction..
19:05:03,230 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   284 failed with error: 07030041 Exception in Transaction..
19:05:03,242 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   285 failed with error: 07030042 Exception in Transaction..
19:05:10,490 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   286 failed with error: 07030043 Exception in Transaction..
19:05:11,964 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   287 failed with error: 07030044 Exception in Transaction..
19:05:11,967 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   288 failed with error: 07030045 Exception in Transaction..
19:05:11,970 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   289 failed with error: 07030046 Exception in Transaction..
19:05:11,973 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   290 failed with error: 07030047 Exception in Transaction..
19:05:20,730 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   291 failed with error: 07030048 Exception in Transaction..
19:05:23,540 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   292 failed with error: 07030049 Exception in Transaction..
19:05:24,825 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   293 failed with error: 07030050 Exception in Transaction..
19:05:26,077 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   294 failed with error: 07030051 Exception in Transaction..
19:05:26,099 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   295 failed with error: 07030052 Exception in Transaction..
19:05:27,411 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   296 failed with error: 07030053 Exception in Transaction..
19:05:34,289 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   297 failed with error: 07030054 Exception in Transaction..
19:05:34,292 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   298 failed with error: 07030055 Exception in Transaction..
19:05:34,295 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   299 failed with error: 07030056 Exception in Transaction..
19:05:34,299 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   300 failed with error: 07030057 Exception in Transaction..
19:05:43,010 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   301 failed with error: 07030058 Exception in Transaction..
19:05:43,017 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   302 failed with error: 07030059 Exception in Transaction..
19:05:43,027 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   303 failed with error: 07030060 Exception in Transaction..
19:05:46,017 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
   at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3032)
   at com.mysql.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:4606)
   at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:328)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:312)
   at org.hibernate.transaction.JDBCTransaction.rollbackAndResetAutoCommit(JDBCTransaction.java:183)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:162)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
   at java.lang.Thread.run(Thread.java:595)
19:05:49,840 WARN  [org.springframework.jdbc.support.SQLErrorCodesFactory] Error loading SQL error codes from config file
org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]; nested exception is java.lang.OutOfMemoryError: Java heap space
Caused by: java.lang.OutOfMemoryError: Java heap space
19:05:49,846 WARN  [org.springframework.jdbc.support.SQLErrorCodesFactory] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Connection com.mysql.jdbc.ConnectionImpl@12b0305b is closed.
Caused by: java.sql.SQLException: Connection com.mysql.jdbc.ConnectionImpl@12b0305b is closed.
   at org.apache.commons.dbcp.DelegatingConnection.checkOpen(DelegatingConnection.java:354)
   at org.apache.commons.dbcp.DelegatingConnection.getMetaData(DelegatingConnection.java:310)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.getMetaData(PoolingDataSource.java:234)
   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.hibernate.jdbc.BorrowedConnectionProxy.invoke(BorrowedConnectionProxy.java:50)
   at $Proxy5.getMetaData(Unknown Source)
   at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:189)
   at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:224)
   at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:215)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:133)
   at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:98)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.getDefaultJdbcExceptionTranslator(HibernateTransactionManager.java:741)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:715)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:604)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
   at java.lang.Thread.run(Thread.java:595)
19:05:49,855 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   304 failed with error: 07030061 Exception in Transaction..
19:05:49,864 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   305 failed with error: 07030062 Exception in Transaction..
19:05:55,900 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   306 failed with error: 07030063 Exception in Transaction..
19:05:55,904 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   307 failed with error: 07030064 Exception in Transaction..
19:05:55,907 ERROR [org.alfresco.util.transaction.SpringAwareUserTransaction] Application exception overridden by rollback exception
java.lang.Exception
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
   at java.lang.Thread.run(Thread.java:595)
19:05:55,908 ERROR [org.alfresco.repo.transaction.RetryingTransactionHelper] Rollback failure.  Normal retry behaviour will resume.
org.springframework.jdbc.UncategorizedSQLException: Hibernate flushing: Cannot release connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Already closed.; nested exception is java.sql.SQLException: Already closed.
Caused by: java.sql.SQLException: Already closed.
   at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:84)
   at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:181)
   at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.closeConnection(LocalDataSourceConnectionProvider.java:95)
   at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:451)
   at org.hibernate.jdbc.ConnectionManager.aggressiveRelease(ConnectionManager.java:406)
   at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:293)
   at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:225)
   at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:174)
   at org.springframework.orm.hibernate3.HibernateTransactionManager.doRollback(HibernateTransactionManager.java:597)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:753)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.completeTransactionAfterThrowing(SpringAwareUserTransaction.java:562)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.rollback(SpringAwareUserTransaction.java:532)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:387)
   at org.alfresco.repo.node.index.AbstractReindexComponent$ReindexWorkerRunnable.run(AbstractReindexComponent.java:780)
   at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
   at java.lang.Thread.run(Thread.java:595)
19:05:55,908 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   308 failed with error: 07030065 Exception in Transaction..
19:05:55,912 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   309 failed with error: 07030066 Exception in Transaction..
19:05:55,916 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   310 failed with error: 07030067 Exception in Transaction..
19:05:57,975 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   311 failed with error: 07030068 Exception in Transaction..
19:06:06,723 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   312 failed with error: 07030069 Exception in Transaction..
19:06:06,729 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   313 failed with error: 07030070 Exception in Transaction..
19:06:06,733 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   314 failed with error: 07030071 Exception in Transaction..
19:06:06,744 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   315 failed with error: 07030072 Exception in Transaction..
19:06:06,761 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   316 failed with error: 07030073 Exception in Transaction..
19:06:13,501 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   317 failed with error: 07030074 Exception in Transaction..
19:06:13,504 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   318 failed with error: 07030075 Exception in Transaction..
19:06:13,509 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   319 failed with error: 07030076 Exception in Transaction..
19:06:13,512 ERROR [org.alfresco.repo.node.index.AbstractReindexComponent.threads] Reindexer   320 failed with error: 07030077 Exception in Transaction..
19:06:15,110 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.alfresco.error.AlfrescoRuntimeException: 07030079 Reindex failure for org.alfresco.repo.node.index.FullIndexRecoveryComponent
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:271)
   at org.alfresco.repo.node.index.IndexRecoveryBootstrapBean.onBootstrap(IndexRecoveryBootstrapBean.java:35)
   at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)
   at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)
   at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
   at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)
   at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)
   at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:617)
   at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)
   at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
   at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:189)
   at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
   at org.alfresco.web.app.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:69)
   at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
   at org.apache.catalina.core.StandardContext.start(StandardContext.java:4342)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:627)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
   at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
   at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
   at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
   at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
   at org.apache.catalina.core.StandardService.start(StandardService.java:516)
   at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
   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:288)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Caused by: org.alfresco.error.AlfrescoRuntimeException: 07030078 Exception in Transaction.
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:403)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)
   at org.alfresco.repo.node.index.AbstractReindexComponent.reindex(AbstractReindexComponent.java:262)
   … 36 more
Caused by: java.lang.OutOfMemoryError: Java heap space
19:06:19,934 INFO  [org.alfresco.config.JBossEnabledWebApplicationContext] Refreshing org.alfresco.config.JBossEnabledWebApplicationContext@2d3eeea1: display name [Root WebApplicationContext]; startup date [Mon Aug 03 19:06:19 CEST 2009]; root of context hierarchy
19:06:20,350 INFO  [org.alfresco.config.JBossEnabledWebApplicationContext] Bean factory for application context [org.alfresco.config.JBossEnabledWebApplicationContext@2d3eeea1]: org.springframework.beans.factory.support.DefaultListableBeanFactory@4a3b0f0c
19:06:21,400 INFO  [org.alfresco.web.scripts.DeclarativeRegistry] Registered 24 Web Scripts (+0 failed), 26 URLs
Nous sommes découragés, comme lors de chaque tentative de migration…  :roll:
Peut-être une piste que nous suivons, le changement de version de lucene ne supporterait définitivement plus le système de fichier NFS.
Nous avons tout déplacé et relancé la migration avec reconstruction d'indexes mais même avec de 2 Go de mémoire cela n'a pas été suffisant nous avons eu une erreur Memory Heap Space.
Nous passons à 4Go et c'est reparti pour un tour  Smiley Happy

Nicolas
paul_lahitte
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Franchement ça donne envie .

Je tente la même de 2.1 en passant par 3DLabs mais configurer LDAP dans cette version est tellement long que je me demande si les 2 semaines prévues y suffiront.
Pour cette migration quel est votre avis , vaut il mieux arreter tout de suite (mon répository est de 120go les indexes lucenes 29Go) ?

J'ai d'ailleurs du  passer en reiserfs car le nombre de fichiers dans les indexses lucenes dépassait les fameux 32000 sous répertoires et une reindexation aurait pris plus de 5 jours …
nicolas_4463
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Bonjour,
Mon avis, pour l'heure, serait de vous dire halte au feu !
Impossible de restaurer les indexes Lucene dans la version 3.2 et cela malgré le passage hors NFS: Cette piste n'est peut être pas la bonne. Smiley Surprisedops:

Nous sommes arrivés à une plate-forme de test stable (enfin à priori) avec la version 3labs stable. Dont la migration s'est déroulé sans encombre.
Pour résumer l'operation:
    1) Copie de la machine de production (Machine virtuelle) pour en faire une dédié aux tests.
    2) Copie du système de fichier Alfresco pour en faire un volume dédiée aux tests.
    Pour ne pas planter la migration:
    3) Suppression des éventuels fichiers en vrac dans le référentiel (souvent liés à des time-out lors de suppressions très longues)
    4) Suppression manuelle du ligtWeightVersionStore directement dans le référentiel à l'aide de requête SQL (c'est très experimental  :mrgreen: )
    5) Correction des requêtes SQL exécutés par le processus de migration pour corriger une erreur de select et surtout pour avoir des temps de traitement inférieurs à un week end !
    6) Configuration de l'Alfresco à blanc sur instance de base vierge et système de fichier local.
    7) Remise en service des options du style CIFS, SSO sur NTLM, langage, Type MIME, etc… toujours sur Alfresco à blanc.
    8 ) Arrêt
    9) Paramétrage vers l'instance et le système de fichiers de tests et zou!! On lance
    Ce que nous faisons durant les longues heures de la migration relève plus de rites Vaudou, et je ne pense pas qu'ils apportent grand chose.  Smiley Very Happy

    10) Fin de la migration, on jete un oeil au fichier log.
    Là, soit on pleure, soit on s'embrasse et on débouche une bouteille. L'avantage c'est que le budget bouteilles est peu conséquent.  :lol:
Trêve de plaisanterie, nous continuons, sans trop d'espoir, de creuser la 3.2 qui brille comme un sapin de noël dans une vitrine.
Mais, je crois, une fois n'est pas coutume, qu'il va falloir attendre que le voltage corresponde à la guirlande, que la hauteur du plafond permette au sapin de tenir droit et que nos prises électriques soit au nouveau standard  :lol:

A suivre donc !

Nicolas
michaelh
Active Member

Re: [Résolu]Migration 2.1 vers 3.2

Bonjour,
Peut-être une piste que nous suivons, le changement de version de lucene ne supporterait définitivement plus le système de fichier NFS.
Il ne l'a jamais supporté. Ce qui est étonnant c'est que ça n'ait pas posé de problèmes avant, pas que la migration soit difficile.
Nous avons tout déplacer et relancé la migration avec reconstruction d'indexes mais même avec de 2 Go de mémoire cela n'a pas été suffisant nous avons eu une erreur Memory Heap Space.
Plutôt que d'ajouter de la RAM, postez la ligne JAVA_OPTS de votre configuration (alfresco.sh). Quelque chose me dit que c'est bancal de ce coté.
nicolas_4463
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Bonjour Michael,
Voici nos différents essais et les paramétrages du JAVA_OPTS:

Premier coup, plantage à 20-30% avec un OutOfMemory : heap space

export JAVA_OPTS="-Xms512m –Xmx2048m -XX:MaxPermSize=512m -server"

Deuxième coup, plantage à 50-60% avec un OutofMemory : GC overhead limit exceeded

export JAVA_OPTS="-Xms512m -Xmx5120m -XX:MaxPermSize=384m -server"

Troisième coup, plantage à 80% avec un OutOfMemory : heap space

export GC="-XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:+CMSIncrementalPacing -XX:-UseGCOverheadLimit"
export JAVA_OPTS="-Xms512m -Xmx5120m -XX:MaxPermSize=384m -server ${GC}"

Une petite question complémentaire au passage:
Par nos expériences passées avec JackRabbit et les changements de version de Lucene, nous avons anticipé la reconstruction des indexes Lucene au cours de la migration. Nous démarrons systématiquement avec un index.recovery=FULL.
A votre avis, avons-nous eu raison de faire cette action ?

Merci pour votre aide !

Nicolas
hint
Member II

Re: [Résolu]Migration 2.1 vers 3.2

Bonjour à tous,

Je travaille avec Nicolas sur cette belle aventure qu'est la migration d'Alfresco …

Enfin une bonne nouvelle, nous avons réussi à migrer notre Alfresco en 3.2 … youpi … il ne reste plus qu'à vérifier que tout y est

Je suis en train de rédiger un petit récapitulatif de ce que nous avons du faire que je posterai dès que possible, et en attendant, pour la reconstruction des indexs, voici nos paramètres JVM :


export GC="-XX:+UseConcMarkSweepGC -XX:+CMSIncrementalMode -XX:+CMSIncrementalPacing -XX:-UseGCOverheadLimit"
export JAVA_OPTS="-Xms512m -Xmx14336m -XX:MaxPermSize=384m -server ${GC}"

Pour info, nous avons à peu près 60000 fichiers dans le contentstore (55 Go) qui nous ont générés 600 Mo d'index.

Bonne chance à vous.
michaelh
Active Member

Re: [Résolu]Migration 2.1 vers 3.2

Excellente nouvelle !

Le retour d'expérience est très intéressant, merci pour ça.

Petit question, le système d'exploitation est en 32 ou 64 bits ? J'imagine que c'est 64 parce que vous parlez de 4Go de RAM à un moment donné, mais j'ai le doute (je demande ça parce que la JVM ne sait pas gérer plus de 2Go - en fait un peu moins - en 32 bits et que de fait il faut parfois jongler plus avec les paramètres associés).