Migration 2.1 vers 3b
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Alfresco Hub
- :
- Forum Archive
- :
- Re: Migration 2.1 vers 3b
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Migration 2.1 vers 3b
Bonjour,
Je réalise quelques essais de migration du référentiel pour passer en version 3b.
Je n'ai pas (encore) installé openoffice, imagemagick et SWF2PDF.
La mise à jour côté modèle MySQL s'est déroulée sans soucis.
En revanche l'application du premier patch plante après avoir passé le cap des 20%.
Voici ce que donne le log :
Avez-vous eu ce type de problémes ?
Merci d'avance pour votre aide !
Nicolas
Un extrait du log plus détaillé: hibernate en debug, juste avant l'apparition de l'erreur :
Je réalise quelques essais de migration du référentiel pour passer en version 3b.
Je n'ai pas (encore) installé openoffice, imagemagick et SWF2PDF.
La mise à jour côté modèle MySQL s'est déroulée sans soucis.
En revanche l'application du premier patch plante après avoir passé le cap des 20%.
Voici ce que donne le log :
10:34:34,470 ERROR [org.alfresco.repo.content.transform.magick.AbstractImageMagickContentTransformer] ImageMagickContentTransformer not available: Failed to perform ImageMagick transformation:
Execution result:
os: Linux
command: convert /home/alfresco/alfresco-3b/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_source_56128.gif /home/alfresco/alfresco-3b/tomcat/temp/Alfresco/ImageMagickContentTransformer_init_target_56129.png
succeeded: false
exit code: 1
out:
err: java.io.IOException: convert: not found
10:34:39,909 INFO [org.alfresco.config.xml.XMLConfigService$PropertyConfigurer] Loading properties file from class path resource [alfresco/file-servers.properties]
10:34:42,425 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] preRegister called. Server=com.sun.jmx.mbeanserver.JmxMBeanServer@26cbb7db, name=log4j:logger=org.alfresco.repo.admin.patch.PatchExecuter
10:34:42,426 DEBUG [org.alfresco.repo.admin.patch.impl.DeploymentMigrationPatch] preRegister called. Server=com.sun.jmx.mbeanserver.JmxMBeanServer@26cbb7db, name=log4j:logger=org.alfresco.repo.admin.patch.impl.DeploymentMigrationPatch
10:34:42,429 DEBUG [org.alfresco.repo.version.VersionMigrator] preRegister called. Server=com.sun.jmx.mbeanserver.JmxMBeanServer@26cbb7db, name=log4j:logger=org.alfresco.repo.version.VersionMigrator
10:34:47,791 ERROR [org.alfresco.repo.content.transform.swf.PDFToSWFContentTransformer] Failed to start SWF2PDF transformer:
Execution result:
os: Linux
command: pdf2swf -V
succeeded: false
exit code: 1
out:
err: java.io.IOException: pdf2swf: not found
10:34:58,285 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
10:35:07,189 INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] No changes were made to the schema.
10:35:12,569 ERROR [org.alfresco.util.exec.RuntimeExecBootstrapBean] Bootstrap command failed:
Execution result:
os: Linux
command: "soffice" "-accept=socket,host=localhost,port=8100;urp;StarOffice.ServiceManager" "-env:UserInstallation=file://oouser" -nologo -headless -nofirststartwizard -nocrashrep -norestore
succeeded: false
exit code: 2
out:
err: java.io.IOException: "soffice": not found
10:35:22,176 INFO [org.alfresco.repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /srv/alfresco/content
10:35:22,637 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Checking for patches to apply …
10:35:22,699 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.savedSearchesFolder, description=Assure la présence du répertoire de 'Sauvegarde des Recherches'., fixesFromSchema=0, fixesToSchema=1, targetSchema=2, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,701 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updatePermissionData, description=Mises à jour des permissions de 'folder' to 'cmobject'., fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,706 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.guestUser, description=Ajoute l'utilisateur Invitém l'espace Invité ; et met à jour les permissions sur l'espace racine, l'espace Invité et l'utilisateur Invité. , fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,708 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.fixNodeSerializableValues, description=Assure que la valeur des propriétés ne sont pas stockées comme Sérialisables, si possible, fixesFromSchema=0, fixesToSchema=3, targetSchema=4, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,709 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.savedSearchesFolder, description=Assure la présence du répertoire de 'Sauvegarde des Recherches'., fixesFromSchema=0, fixesToSchema=1, targetSchema=2, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,711 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.savedSearchesPermission, description=Fixe les permissions nécessaires sur le répertoire de 'sauvegarde des recherches'., fixesFromSchema=0, fixesToSchema=4, targetSchema=5, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,746 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.authoritiesFolder, description=Vérifie l'existence du dossier des autorités de l'utilisateur [JIRA: AR-497]., fixesFromSchema=0, fixesToSchema=0, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,747 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.guestUser, description=Ajoute l'utilisateur Invitém l'espace Invité ; et met à jour les permissions sur l'espace racine, l'espace Invité et l'utilisateur Invité. , fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,749 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updatePermissionData, description=Mises à jour des permissions de 'folder' to 'cmobject'., fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,750 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updateGuestPermission, description=Renommage de la permission invité de 'Guest' à 'Consumer', fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,752 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.guestUser, description=Ajoute l'utilisateur Invitém l'espace Invité ; et met à jour les permissions sur l'espace racine, l'espace Invité et l'utilisateur Invité. , fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,753 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updatePermissionData, description=Mises à jour des permissions de 'folder' to 'cmobject'., fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,754 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updateGuestPermission, description=Renommage de la permission invité de 'Guest' à 'Consumer', fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,765 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.guestPersonPermission, description=Modification de la permission de l'utilisateur Invité de "Invité" à "Lecture", fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,794 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.guestUser, description=Ajoute l'utilisateur Invitém l'espace Invité ; et met à jour les permissions sur l'espace racine, l'espace Invité et l'utilisateur Invité. , fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,796 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updatePermissionData, description=Mises à jour des permissions de 'folder' to 'cmobject'., fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,801 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updateGuestPermission, description=Renommage de la permission invité de 'Guest' à 'Consumer', fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,802 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.spacesRootPermission, description=Modification de la permission de l'Espace Racine de "Invité" à "Lecture", fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,804 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.categoryRootPermission, description=Fixe les permissions sur le dossier 'Catégorie Racine'., fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,805 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.guestUser, description=Ajoute l'utilisateur Invitém l'espace Invité ; et met à jour les permissions sur l'espace racine, l'espace Invité et l'utilisateur Invité. , fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,806 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updatePermissionData, description=Mises à jour des permissions de 'folder' to 'cmobject'., fixesFromSchema=0, fixesToSchema=2, targetSchema=3, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,808 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.updateGuestPermission, description=Renommage de la permission invité de 'Guest' à 'Consumer', fixesFromSchema=0, fixesToSchema=5, targetSchema=6, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,809 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.contentPermission, description=Mise à jour des permissions de 'cm:content' à 'sys:base', fixesFromSchema=0, fixesToSchema=6, targetSchema=7, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,810 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch was already successfully applied:
patch: AppliedPatch[ id=patch.descriptorUpdate, description=Mise à jour du descripteur de l'Entrepot, fixesFromSchema=0, fixesToSchema=11, targetSchema=12, appliedToSchema=12, appliedToServer=2.1.0 (484) - Community Network, appliedOnDate=2008-11-12 03:25:24.0, wasExecuted=false, succeeded=true, report=Pas approprié au schéma 12]
10:35:22,813 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Patch schema version number check against repo version:
repo schema version: 1.2.1
patch: Patch[ id=patch.updateDmPermissions, description=patch.updateDmPermissions.description, fixesFromSchema=0, fixesToSchema=124, targetSchema=125]
10:35:22,813 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.updateDmPermissions' (Update ACLs on all DM node objects to the new 3.0 permission model).
10:36:23,895 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 6847/74816
10:37:24,438 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 12783/74816
10:37:26,250 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Patch 10% complete, estimated complete at 11/20/08 10:47 AM.
10:38:45,198 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 15560/74816
10:38:45,239 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Patch 20% complete, estimated complete at 11/20/08 10:52 AM.
10:39:10,484 ERROR [org.hibernate.AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)
at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
10:39:10,528 ERROR [org.hibernate.AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)
at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
10:39:10,532 ERROR [org.hibernate.AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)
at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
10:39:10,536 ERROR [org.hibernate.AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)
at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
10:39:10,541 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)
at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
10:39:10,667 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] Applied patch:
AppliedPatch[ id=patch.updateDmPermissions, description=Update ACLs on all DM node objects to the new 3.0 permission model, fixesFromSchema=0, fixesToSchema=124, targetSchema=125, appliedToSchema=12, appliedToServer=3.0.0 (b 1164) - Labs, appliedOnDate=Thu Nov 20 10:39:10 CET 2008, wasExecuted=true, succeeded=false, report=org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:19…]
10:39:10,673 ERROR [org.hibernate.AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:575)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:662)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:632)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:314)
at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:431)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:308)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
10:40:02,509 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:40:02,778 INFO [org.alfresco.repo.admin.patch.PatchExecuter] No patches were required.
10:40:02,937 INFO [org.alfresco.repo.module.ModuleServiceImpl] Found 0 module(s).
10:40:33,299 ERROR [org.alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
10:40:33,300 ERROR [org.alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
10:40:34,033 WARN [org.alfresco.util.OpenOfficeConnectionTester] An initial OpenOffice connection could not be established.
10:40:34,083 INFO [org.alfresco.service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_15-b04; maximum heap size 989.875MB
10:40:34,084 INFO [org.alfresco.service.descriptor.DescriptorService] Alfresco started (Labs): Current version 3.0.0 (b 1164) schema 131 - Installed version 1.2.1 schema 12
10:40:34,233 DEBUG [org.alfresco.repo.version.VersionMigrator] Found 67 version histories in old version store
10:40:37,276 WARN [org.alfresco.repo.version.VersionMigrator] Skipped background deletion of 67 old version histories (not migrated)
10:40:37,277 DEBUG [org.alfresco.repo.version.VersionMigrator] Completed background deletion of 0 migrated version histories (from old version store) in 3 secs
10:41:04,254 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:42:05,441 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:43:05,465 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:44:05,481 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:45:05,493 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:46:05,505 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
10:47:05,516 DEBUG [org.alfresco.repo.admin.patch.PatchExecuter] 0/74816
Avez-vous eu ce type de problémes ?
Merci d'avance pour votre aide !
Nicolas
OS:
Linux SUSE sous VMWARE
DATA:
NAS NETAPP montage NFS (indexes hors NFS)
DB:
MYSQL 5.1
OPENOFFICE:
OOo2.4
ALFRESCO:
2.1 COMMUNITY
Auth NTLM avec AD
Un extrait du log plus détaillé: hibernate en debug, juste avant l'apparition de l'erreur :
16:04:33,367 DEBUG [org.hibernate.engine.StatefulPersistenceContext] initializing non-lazy collections
16:04:33,367 DEBUG [org.hibernate.loader.Loader] done entity load
16:04:33,368 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] calling onSave()
16:04:33,368 DEBUG [org.hibernate.event.def.AbstractSaveEventListener] executing identity-insert immediately
16:04:33,368 DEBUG [org.hibernate.cache.UpdateTimestampsCache] Pre-invalidating space [alf_access_control_list]
16:04:33,368 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 16463, globally: 16478)
16:04:33,368 DEBUG [org.hibernate.SQL] insert into alf_access_control_list (version, acl_id, latest, acl_version, inherits, inherits_from, type, inherited_acl, is_versioned, requires_version, acl_change_set) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
16:04:33,583 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 16464, globally: 16479)
16:04:35,467 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7923], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7923] (uninitialized)
16:04:35,467 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7923], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7923] (uninitialized)
16:04:35,467 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7] (uninitialized)
16:04:35,467 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7] (uninitialized)
16:04:35,467 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#2], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#2] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#2], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#2] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#1], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#1] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#1], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#1] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#10], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#10] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#10], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#10] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#11], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#11] (uninitialized)
16:04:35,468 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#11], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#11] (uninitialized)
16:04:35,469 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#9865], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#9865] (uninitialized)
16:04:35,469 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#9865], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#9865] (uninitialized)
16:04:35,469 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#10102], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#10102] (uninitialized)
16:04:35,469 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#10102], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#10102] (uninitialized)
16:04:35,563 ERROR [org.hibernate.AssertionFailure] an assertion failure occured (this may indicate a bug in Hibernate, but is more likely due to unsafe use of the session)
org.hibernate.AssertionFailure: null id in org.alfresco.repo.domain.hibernate.DbAccessControlListImpl entry (don't flush the Session after an exception occurs)
at org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
at org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:157)
at org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:113)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)
at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAclsImpl(DMAccessControlListDAO.java:275)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:195)
at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)
at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy49.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
16:04:35,689 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7923], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7923] (uninitialized)
16:04:35,689 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7923], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7923] (uninitialized)
16:04:35,689 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7], was: [org.alfresco.repo.domain.hibernate.NodeImpl.properties#7] (uninitialized)
16:04:35,689 DEBUG [org.hibernate.engine.Collections] Collection found: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7], was: [org.alfresco.repo.domain.hibernate.NodeImpl.aspects#7] (uninitialized)
Labels
26 Replies
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
J'ai fait machine arrière pour passer par une étape intermédiaire de migration de la 2.1 à la 2.9b.
La migration s'est bien passée, un petit soucis avec le fichier readme.ftl dans le data dictionnary.
J'avais ces erreurs dans le log :
Après vérification tout semblait foctionner correctement (sauf l'identification NTLM, mais au vu du post de Michael, j'ai pas insisté).
Je me suis donc lancé dans la migration vers la 3b. Ca coince toujours
J'ai les mêmes erreurs (voir post précédent).
Je crois que je vais ouvrir une fiche JIRA: https://issues.alfresco.com/jira/browse/ALFCOM-2099
Une idée, une suggestion d'ici là ?
Merci d'avance.
Nicolas
La migration s'est bien passée, un petit soucis avec le fichier readme.ftl dans le data dictionnary.
J'avais ces erreurs dans le log :
10:49:37,626 INFO [org.alfresco.repo.admin.patch.PatchExecuter] Applying patch 'patch.webscripts3' (patch.webscripts3.description).
10:49:39,320 ERROR [org.alfresco.repo.admin.patch.PatchExecuter] org.alfresco.error.AlfrescoRuntimeException: Bootstrap failed
at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:441)
at org.alfresco.repo.admin.patch.impl.GenericBootstrapPatch.applyInternal(GenericBootstrapPatch.java:126)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:356)
at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:350)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:166)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:361)
at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:346)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:299)
at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:364)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:278)
at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)
at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)
at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy45.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:241)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:349)
at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
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:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.alfresco.service.cmr.view.ImporterException: Failed to import package at line 7; column 20 due to error: Failed to set content property on stream closure:
node: workspace://SpacesStore/0d1459d5-cb97-11dc-8817-b153f30eb905
property: {http://www.alfresco.org/model/content/1.0}content
writer: ContentAccessor[ contentUrl=store://2008/11/21/10/49/b5d93c95-b7b1-11dd-8675-655ccc06be05.bin, mimetype=text/html, size=1371, encoding=UTF-8, locale=en_US]
at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:190)
at org.alfresco.repo.importer.ImporterComponent.parserImport(ImporterComponent.java:360)
at org.alfresco.repo.importer.ImporterComponent.importView(ImporterComponent.java:224)
at org.alfresco.repo.importer.ImporterBootstrap.bootstrap(ImporterBootstrap.java:423)
… 63 more
Caused by: org.alfresco.service.cmr.repository.ContentIOException: Failed to set content property on stream closure:
node: workspace://SpacesStore/0d1459d5-cb97-11dc-8817-b153f30eb905
property: {http://www.alfresco.org/model/content/1.0}content
writer: ContentAccessor[ contentUrl=store://2008/11/21/10/49/b5d93c95-b7b1-11dd-8675-655ccc06be05.bin, mimetype=text/html, size=1371, encoding=UTF-8, locale=en_US]
at org.alfresco.repo.content.RoutingContentService$WriteStreamListener.contentStreamClosed(RoutingContentService.java:577)
at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel$1.execute(AbstractContentAccessor.java:357)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:236)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:185)
at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.fireChannelClosed(AbstractContentAccessor.java:367)
at org.alfresco.repo.content.AbstractContentAccessor$CallbackFileChannel.implCloseChannel(AbstractContentAccessor.java:336)
at java.nio.channels.spi.AbstractInterruptibleChannel.close(Unknown Source)
at java.nio.channels.Channels$1.close(Unknown Source)
at java.io.FilterOutputStream.close(Unknown Source)
at org.springframework.util.FileCopyUtils.copy(FileCopyUtils.java:132)
at org.alfresco.repo.content.AbstractContentWriter.putContent(AbstractContentWriter.java:423)
at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importContent(ImporterComponent.java:671)
at org.alfresco.repo.importer.ImporterComponent$NodeImporter.importNode(ImporterComponent.java:574)
at org.alfresco.repo.importer.view.ViewParser.importNode(ViewParser.java:847)
at org.alfresco.repo.importer.view.ViewParser.processEndType(ViewParser.java:811)
at org.alfresco.repo.importer.view.ViewParser.processEndElement(ViewParser.java:791)
at org.alfresco.repo.importer.view.ViewParser.parse(ViewParser.java:182)
… 66 more
Caused by: java.lang.IllegalStateException: Non-unique path: found : /app:company_home/app:user_homes 0
at org.alfresco.repo.security.person.AbstractHomeFolderProvider.resolvePath(AbstractHomeFolderProvider.java:318)
at org.alfresco.repo.security.person.AbstractHomeFolderProvider.getPathNodeRef(AbstractHomeFolderProvider.java:300)
at org.alfresco.repo.security.person.UIDBasedHomeFolderProvider.getHomeFolder(UIDBasedHomeFolderProvider.java:74)
at org.alfresco.repo.security.person.AbstractHomeFolderProvider$OnCreateNode.doWork(AbstractHomeFolderProvider.java:360)
at org.alfresco.repo.security.person.AbstractHomeFolderProvider$OnCreateNode.doWork(AbstractHomeFolderProvider.java:345)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:299)
at org.alfresco.repo.security.person.AbstractHomeFolderProvider.onCreateNode(AbstractHomeFolderProvider.java:329)
at org.alfresco.repo.security.person.HomeFolderManager.onCreateNode(HomeFolderManager.java:128)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.policy.JavaBehaviour$JavaMethodInvocationHandler.invoke(JavaBehaviour.java:179)
at $Proxy5.onCreateNode(Unknown Source)
at sun.reflect.GeneratedMethodAccessor241.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.policy.PolicyFactory$MultiHandler.invoke(PolicyFactory.java:251)
at org.alfresco.repo.policy.$Proxy83.onCreateNode(Unknown Source)
at org.alfresco.repo.node.AbstractNodeServiceImpl.invokeOnCreateNode(AbstractNodeServiceImpl.java:252)
at org.alfresco.repo.node.db.DbNodeServiceImpl.createNode(DbNodeServiceImpl.java:413)
at sun.reflect.GeneratedMethodAccessor244.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy3.createNode(Unknown Source)
at sun.reflect.GeneratedMethodAccessor244.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
at $Proxy4.createNode(Unknown Source)
at sun.reflect.GeneratedMethodAccessor244.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:241)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:241)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:175)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:175)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy3.createNode(Unknown Source)
at org.alfresco.repo.security.person.PersonServiceImpl.createPerson(PersonServiceImpl.java:625)
at org.alfresco.repo.security.person.PersonServiceImpl.createMissingPerson(PersonServiceImpl.java:598)
at org.alfresco.repo.security.person.PersonServiceImpl.getPerson(PersonServiceImpl.java:204)
at org.alfresco.repo.usage.ContentUsageImpl.getUserUsage(ContentUsageImpl.java:365)
at org.alfresco.repo.usage.ContentUsageImpl.decrementUserUsage(ContentUsageImpl.java:320)
at org.alfresco.repo.usage.ContentUsageImpl.onUpdateProperties(ContentUsageImpl.java:221)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.policy.JavaBehaviour$JavaMethodInvocationHandler.invoke(JavaBehaviour.java:179)
at $Proxy8.onUpdateProperties(Unknown Source)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.policy.PolicyFactory$MultiHandler.invoke(PolicyFactory.java:251)
at org.alfresco.repo.policy.$Proxy76.onUpdateProperties(Unknown Source)
at org.alfresco.repo.node.AbstractNodeServiceImpl.invokeOnUpdateProperties(AbstractNodeServiceImpl.java:341)
at org.alfresco.repo.node.db.DbNodeServiceImpl.setProperty(DbNodeServiceImpl.java:1159)
at sun.reflect.GeneratedMethodAccessor240.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
at org.alfresco.repo.transaction.TransactionResourceInterceptor.invoke(TransactionResourceInterceptor.java:138)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy3.setProperty(Unknown Source)
at sun.reflect.GeneratedMethodAccessor240.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
at $Proxy4.setProperty(Unknown Source)
at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:236)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:252)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:252)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
at $Proxy3.setProperty(Unknown Source)
at org.alfresco.repo.content.RoutingContentService$WriteStreamListener.contentStreamClosed(RoutingContentService.java:557)
… 82 more
Après vérification tout semblait foctionner correctement (sauf l'identification NTLM, mais au vu du post de Michael, j'ai pas insisté).
Je me suis donc lancé dans la migration vers la 3b. Ca coince toujours
J'ai les mêmes erreurs (voir post précédent).
Je crois que je vais ouvrir une fiche JIRA: https://issues.alfresco.com/jira/browse/ALFCOM-2099
Une idée, une suggestion d'ici là ?
Merci d'avance.
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Bonjour,
Je ne parviens toujours pas à migrer cette version 2.1 vers la 3.0b, j'ai un peu progressé mais je bloque toujours sur la même étape.
Je suis tombé un peu par hasard sur de mauvaises données dans le repository: une suppression massive (4Go de docs ) qui a mal tourné via CIFS. :shock:
Du coup, il existait des noeuds fantômes dans le référentiel: concrétement, côté base de données, j'avais des lignes en doublon dans la table "alf_node_status".
Pour un même noeud, je trouvais un protocol en "Workspace" et un autre en "Archive".
Côté application, les documents et les espaces de stockage ne possédaient plus de chemin.
Pour nettoyer ces incohérences, j'ai purgé les documents et les workspaces via l'application web (ce qui m'a pris un certain temps !)
La base de données n'était toujours pas conforme, j'ai donc supprimé les occurences en doublon dont le protocol était à "workspace".
J'ai pu enfin purger ces éléments de la poubelle.
Résultat des courses: la migration plante toujours sur l'application du même patch, à 20%, mais la manip précédente a débloqué le passage des patchs suivants.
Au final, je n'ai (toujours) pas un Alfresco 3b complétement operationnel. :mrgreen:
Il tourne avec "le frein à main tiré", très très lentement, il doit manquer des indexes, ou qqes éléments, côté MySQL car la moindre demande sollicite le process MySQL durant de longues périodes !
La version 3.0c étant sortie, une lueur d'espoir est apparue.
Hélas, cela fait trois jours pleins que le processus de migration tourne avec un process MySQL au taquet et reste sur l'étape:
Une dernière remarque, lors du test de la version 3.0c, à blanc, j'ai constaté que l'authentification NTLM fonctionne seulement si le serveur CIFS est activé dans le fichier de configuration files.properties. Autre remarque, si l'adresse est une URL xxx.xxx.xxx.xxx le SSO ne fonctionne pas, il faut pour les tests associer le nom de la machine dans le fichier host de Windows.
Comme toujours, pistes, ideés et informations sont les bienvenues.
Merci d'avance.
Nicolas
Je ne parviens toujours pas à migrer cette version 2.1 vers la 3.0b, j'ai un peu progressé mais je bloque toujours sur la même étape.
Je suis tombé un peu par hasard sur de mauvaises données dans le repository: une suppression massive (4Go de docs ) qui a mal tourné via CIFS. :shock:
Du coup, il existait des noeuds fantômes dans le référentiel: concrétement, côté base de données, j'avais des lignes en doublon dans la table "alf_node_status".
Pour un même noeud, je trouvais un protocol en "Workspace" et un autre en "Archive".
Côté application, les documents et les espaces de stockage ne possédaient plus de chemin.
Pour nettoyer ces incohérences, j'ai purgé les documents et les workspaces via l'application web (ce qui m'a pris un certain temps !)
La base de données n'était toujours pas conforme, j'ai donc supprimé les occurences en doublon dont le protocol était à "workspace".
J'ai pu enfin purger ces éléments de la poubelle.
Résultat des courses: la migration plante toujours sur l'application du même patch, à 20%, mais la manip précédente a débloqué le passage des patchs suivants.
Au final, je n'ai (toujours) pas un Alfresco 3b complétement operationnel. :mrgreen:
Il tourne avec "le frein à main tiré", très très lentement, il doit manquer des indexes, ou qqes éléments, côté MySQL car la moindre demande sollicite le process MySQL durant de longues périodes !
La version 3.0c étant sortie, une lueur d'espoir est apparue.
Hélas, cela fait trois jours pleins que le processus de migration tourne avec un process MySQL au taquet et reste sur l'étape:
INFO [org.alfresco.repo.domain.schema.SchemaBootstrap] Executing database script /home/alfresco/alfresco3c/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-24505.sql (Copied from classpath:alfresco/dbscripts/upgrade/2.2/org.hibernate.dialect.MySQLInnoDBDialect/upgrade-from-2.1.sql).INSERT INTO t_alf_child_assoc
(
id, version,
parent_node_id, child_node_id,
child_node_name, child_node_name_crc,
type_qname_id,
qname_ns_id, qname_localname,
is_primary, assoc_index
)
SELECT
ca.id, 1,
ca.parent_node_id, ca.child_node_id,
ca.child_node_name, child_node_name_crc,
tqn.qname_id,
tqndyn.namespace_id, tqndyn.local_name,
ca.is_primary, ca.assoc_index
FROM
alf_child_assoc ca
JOIN t_qnames_dyn tqndyn ON (ca.qname = tqndyn.qname)
JOIN t_qnames tqn ON (ca.type_qname = tqn.qname)
;
Une dernière remarque, lors du test de la version 3.0c, à blanc, j'ai constaté que l'authentification NTLM fonctionne seulement si le serveur CIFS est activé dans le fichier de configuration files.properties. Autre remarque, si l'adresse est une URL xxx.xxx.xxx.xxx le SSO ne fonctionne pas, il faut pour les tests associer le nom de la machine dans le fichier host de Windows.
Comme toujours, pistes, ideés et informations sont les bienvenues.
Merci d'avance.
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Yeeeeeeeeessssssssss !
La version 3 stable (ou presque) nous permet de passer le cap de cette maudite migration !!!
Tout se passe bien à l'execpetion de la reprise des anciennes version des documents.
Ca plante copieusement !
Par contre un gros soucis sur les premières tentatives de migration de cette version, un des scripts SQL tournait plus de 60 heures sans arriver au bout (pour 48 Go de docs).
Voici se script pour MySQL un peu amélioré, on est passé à moins de 4 heures :mrgreen: )
Voici le script upgrade-from-2.1.sql un peu amélioré en termes de perf :
************** A VERIFIER D'ABORD DANS UN ENVIRONNEMENT DE TEST ***************
A suivre pour les versions, on creuse…
La version 3 stable (ou presque) nous permet de passer le cap de cette maudite migration !!!
Tout se passe bien à l'execpetion de la reprise des anciennes version des documents.
Ca plante copieusement !
13:45:35,442 ERROR [org.alfresco.repo.version.VersionMigrator] Skipping migration of: workspace://lightWeightVersionStore/4a6366f1-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:381)
at org.alfresco.repo.version.VersionMigrator$1.execute(VersionMigrator.java:367)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:320)
at org.alfresco.repo.version.VersionMigrator.migrateVersions(VersionMigrator.java:365)
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:320)
at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:227)
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:437)
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:320)
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:296)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy56.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.refresh(AbstractApplicationContext.java:355)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
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:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
13:45:36,426 WARN [org.alfresco.repo.version.VersionMigrator] Skipped migration of 1 old version histories (migrate failed)
13:45:36,426 INFO [org.alfresco.repo.version.VersionMigrator] Completed migration of 0 old version histories (to new version store) in 1 secs
Par contre un gros soucis sur les premières tentatives de migration de cette version, un des scripts SQL tournait plus de 60 heures sans arriver au bout (pour 48 Go de docs).
Voici se script pour MySQL un peu amélioré, on est passé à moins de 4 heures :mrgreen: )
Voici le script upgrade-from-2.1.sql un peu amélioré en termes de perf :
************** A VERIFIER D'ABORD DANS UN ENVIRONNEMENT DE TEST ***************
–
– Title: Apply schema modifications to upgrade from 2.1
– Database: MySQL
– Since: V2.2 Schema 91
– Author: Derek Hulley
–
– In order to streamline the upgrade, all modifications to large tables need to
– be handled in as few steps as possible. This usually involves as few ALTER TABLE
– statements as possible. The general approach is:
– Create a table with the correct structure, including indexes and CONSTRAINTs
– Copy pristine data into the new table
– Drop the old table
– Rename the new table
–
– Please contact support@alfresco.com if you need assistance with the upgrade.
–
– ——————————-
– Build Namespaces and QNames –
– ——————————-
CREATE TABLE alf_namespace
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
uri VARCHAR(100) NOT NULL,
PRIMARY KEY (id),
UNIQUE (uri)
) ENGINE=InnoDB;
CREATE TABLE alf_qname
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
ns_id BIGINT NOT NULL,
local_name VARCHAR(200) NOT NULL,
INDEX fk_alf_qname_ns (ns_id),
CONSTRAINT fk_alf_qname_ns FOREIGN KEY (ns_id) REFERENCES alf_namespace (id),
PRIMARY KEY (id),
UNIQUE (ns_id, local_name)
) ENGINE=InnoDB;
– Create temporary table to hold static QNames
CREATE TABLE t_qnames
(
qname VARCHAR(255) NOT NULL,
namespace VARCHAR(100),
localname VARCHAR(200),
qname_id BIGINT,
INDEX tidx_tqn_qn (qname),
INDEX tidx_tqn_ns (namespace),
INDEX tidx_tqn_ln (localname)
) ENGINE=InnoDB;
– Populate the table with all known static QNames
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.type_qname FROM alf_node s LEFT OUTER JOIN t_qnames t ON (s.type_qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.qname FROM alf_node_aspects s LEFT OUTER JOIN t_qnames t ON (s.qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.qname FROM alf_node_properties s LEFT OUTER JOIN t_qnames t ON (s.qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.qname FROM avm_aspects s LEFT OUTER JOIN t_qnames t ON (s.qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.name FROM avm_aspects_new s LEFT OUTER JOIN t_qnames t ON (s.name = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.qname FROM avm_node_properties s LEFT OUTER JOIN t_qnames t ON (s.qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.qname FROM avm_node_properties_new s LEFT OUTER JOIN t_qnames t ON (s.qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.qname FROM avm_store_properties s LEFT OUTER JOIN t_qnames t ON (s.qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.type_qname FROM alf_node_assoc s LEFT OUTER JOIN t_qnames t ON (s.type_qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.type_qname FROM alf_child_assoc s LEFT OUTER JOIN t_qnames t ON (s.type_qname = t.qname) WHERE t.qname IS NULL
);
INSERT INTO t_qnames (qname)
(
SELECT DISTINCT s.type_qname FROM alf_permission s LEFT OUTER JOIN t_qnames t ON (s.type_qname = t.qname) WHERE t.qname IS NULL
);
– Extract the namespace and localnames from the QNames
UPDATE t_qnames SET namespace = CONCAT('FILLER-', SUBSTR(SUBSTRING_INDEX(qname, '}', 1), 2));
UPDATE t_qnames SET localname = SUBSTRING_INDEX(qname, '}', -1);
– Move the Namespaces to their new home
INSERT INTO alf_namespace (uri, version)
(
SELECT
distinct(x.namespace), 1
FROM
(
SELECT t.namespace, n.uri FROM t_qnames t LEFT OUTER JOIN alf_namespace n ON (n.uri = t.namespace)
) x
WHERE
x.uri IS NULL
);
– Move the Localnames to their new home
INSERT INTO alf_qname (ns_id, local_name, version)
(
SELECT
x.ns_id, x.t_localname, 1
FROM
(
SELECT n.id AS ns_id, t.localname AS t_localname, q.local_name AS q_localname
FROM t_qnames t
JOIN alf_namespace n ON (n.uri = t.namespace)
LEFT OUTER JOIN alf_qname q ON (q.local_name = t.localname)
) x
WHERE
q_localname IS NULL
GROUP BY x.ns_id, x.t_localname
);
– Record the new qname IDs
UPDATE t_qnames t SET t.qname_id =
(
SELECT q.id FROM alf_qname q
JOIN alf_namespace ns ON (q.ns_id = ns.id)
WHERE ns.uri = t.namespace AND q.local_name = t.localname
);
OPTIMIZE TABLE t_qnames;
– —————————-
– SHORTCUT:
– Up to this point, we have been extracting static data. The data can be dumped and loaded
– to do faster testing of the ugprades:
– mysqldump derek1 alf_qname alf_namespace t_qnames > extracted-qnames.sql
– Load the dump file and continue from this point
– —————————-
– Create temporary table for dynamic (child) QNames
CREATE TABLE t_qnames_dyn
(
qname VARCHAR(255) NOT NULL,
namespace VARCHAR(100),
namespace_id BIGINT,
local_name VARCHAR(255),
INDEX tidx_qnd_qn (qname),
INDEX tidx_qnd_ns (namespace)
) ENGINE=InnoDB;
– Populate the table with the child association paths
– Query OK, 415312 rows affected (1 min 11.91 sec)
INSERT INTO t_qnames_dyn (qname)
(
SELECT distinct(qname) FROM alf_child_assoc
);
– Extract the Namespace
– Query OK, 415312 rows affected (20.03 sec)
UPDATE t_qnames_dyn SET namespace = CONCAT('FILLER-', SUBSTR(SUBSTRING_INDEX(qname, '}', 1), 2));
– Extract the Localname
– Query OK, 415312 rows affected (16.22 sec)
UPDATE t_qnames_dyn SET local_name = SUBSTRING_INDEX(qname, '}', -1);
– Move the namespaces to the their new home
– Query OK, 4 rows affected (34.59 sec)
INSERT INTO alf_namespace (uri, version)
(
SELECT
distinct(x.namespace), 1
FROM
(
SELECT t.namespace, n.uri FROM t_qnames_dyn t LEFT OUTER JOIN alf_namespace n ON (n.uri = t.namespace)
) x
WHERE
x.uri IS NULL
);
– Record the new namespace IDs
– Query OK, 415312 rows affected (10.41 sec)
UPDATE t_qnames_dyn t SET t.namespace_id = (SELECT ns.id FROM alf_namespace ns WHERE ns.uri = t.namespace);
– Recoup some storage
ALTER TABLE t_qnames_dyn DROP COLUMN namespace;
OPTIMIZE TABLE t_qnames_dyn;
– —————————-
– Populate the Permissions –
– —————————-
– This is a small table so we change it in place
ALTER TABLE alf_permission
DROP INDEX type_qname,
ADD COLUMN type_qname_id BIGINT NULL AFTER id
;
UPDATE alf_permission p SET p.type_qname_id =
(
SELECT q.id
FROM alf_qname q
JOIN alf_namespace ns ON (q.ns_id = ns.id)
WHERE CONCAT('{', SUBSTR(ns.uri, 8), '}', q.local_name) = p.type_qname
);
ALTER TABLE alf_permission
DROP COLUMN type_qname,
MODIFY COLUMN type_qname_id BIGINT NOT NULL AFTER id,
ADD UNIQUE (type_qname_id, name),
ADD INDEX fk_alf_perm_tqn (type_qname_id),
ADD CONSTRAINT fk_alf_perm_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname (id)
;
– ——————-
– Build new Store –
– ——————-
CREATE TABLE t_alf_store
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
protocol VARCHAR(50) NOT NULL,
identifier VARCHAR(100) NOT NULL,
root_node_id BIGINT,
PRIMARY KEY (id),
UNIQUE (protocol, identifier)
) TYPE=InnoDB;
– ————————–
– Populate the ADM nodes –
– ————————–
CREATE TABLE t_alf_node (
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
store_id BIGINT NOT NULL,
uuid VARCHAR(36) NOT NULL,
transaction_id BIGINT NOT NULL,
node_deleted bit NOT NULL,
type_qname_id BIGINT NOT NULL,
acl_id BIGINT,
audit_creator VARCHAR(255),
audit_created VARCHAR(30),
audit_modifier VARCHAR(255),
audit_modified VARCHAR(30),
audit_accessed VARCHAR(30),
INDEX idx_alf_node_del (node_deleted),
INDEX fk_alf_node_acl (acl_id),
INDEX fk_alf_node_tqn (type_qname_id),
INDEX fk_alf_node_txn (transaction_id),
INDEX fk_alf_node_store (store_id),
CONSTRAINT fk_alf_node_acl FOREIGN KEY (acl_id) REFERENCES alf_access_control_list (id),
CONSTRAINT fk_alf_node_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname (id),
CONSTRAINT fk_alf_node_txn FOREIGN KEY (transaction_id) REFERENCES alf_transaction (id),
CONSTRAINT fk_alf_node_store FOREIGN KEY (store_id) REFERENCES t_alf_store (id),
PRIMARY KEY (id),
UNIQUE (store_id, uuid)
) TYPE=InnoDB;
– Fill the store table
INSERT INTO t_alf_store (version, protocol, identifier, root_node_id)
SELECT 1, protocol, identifier, root_node_id FROM alf_store
;
– Summarize the alf_node_status table
CREATE TABLE t_summary_nstat
(
node_id BIGINT(20) NOT NULL,
transaction_id BIGINT(20) DEFAULT NULL,
PRIMARY KEY (node_id)
) TYPE=InnoDB;
INSERT INTO t_summary_nstat (node_id, transaction_id)
SELECT node_id, transaction_id FROM alf_node_status WHERE node_id IS NOT NULL;
– Copy data over
LOCK TABLES
t_alf_node WRITE,
alf_node AS n READ,
t_summary_nstat AS nstat READ,
t_alf_store AS s READ,
t_qnames AS q READ
;
INSERT INTO t_alf_node
(
id, version, store_id, uuid, transaction_id, node_deleted, type_qname_id, acl_id,
audit_creator, audit_created, audit_modifier, audit_modified, audit_accessed
)
SELECT STRAIGHT_JOIN
n.id, 1, s.id, n.uuid, nstat.transaction_id, false, q.qname_id, n.acl_id,
null, null, null, null, null
FROM
alf_node n
JOIN t_qnames q ON (q.qname = n.type_qname)
JOIN t_summary_nstat nstat ON (nstat.node_id = n.id)
JOIN t_alf_store s ON (s.protocol = n.protocol AND s.identifier = n.identifier)
;
UNLOCK TABLES;
DROP TABLE t_summary_nstat;
– Hook the store up to the root node
ALTER TABLE t_alf_store
ADD INDEX fk_alf_store_root (root_node_id),
ADD CONSTRAINT fk_alf_store_root FOREIGN KEY (root_node_id) REFERENCES t_alf_node (id)
;
– —————————–
– Populate Version Counter –
– —————————–
CREATE TABLE t_alf_version_count
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
store_id BIGINT NOT NULL UNIQUE,
version_count INTEGER NOT NULL,
INDEX fk_alf_vc_store (store_id),
CONSTRAINT fk_alf_vc_store FOREIGN KEY (store_id) REFERENCES t_alf_store (id),
PRIMARY KEY (id)
) TYPE=InnoDB;
INSERT INTO t_alf_version_count
(
version, store_id, version_count
)
SELECT
1, s.id, vc.version_count
FROM
alf_version_count vc
JOIN t_alf_store s ON (s.protocol = vc.protocol AND s.identifier = vc.identifier)
;
DROP TABLE alf_version_count;
ALTER TABLE t_alf_version_count RENAME TO alf_version_count;
– —————————–
– Populate the Child Assocs –
– —————————–
CREATE TABLE t_alf_child_assoc
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
parent_node_id BIGINT NOT NULL,
type_qname_id BIGINT NOT NULL,
child_node_name_crc BIGINT NOT NULL,
child_node_name VARCHAR(50) NOT NULL,
child_node_id BIGINT NOT NULL,
qname_ns_id BIGINT NOT NULL,
qname_localname VARCHAR(255) NOT NULL,
is_primary BIT,
assoc_index INTEGER,
INDEX idx_alf_cass_qnln (qname_localname),
INDEX fk_alf_cass_pnode (parent_node_id),
INDEX fk_alf_cass_cnode (child_node_id),
INDEX fk_alf_cass_tqn (type_qname_id),
INDEX fk_alf_cass_qnns (qname_ns_id),
CONSTRAINT fk_alf_cass_pnode foreign key (parent_node_id) REFERENCES t_alf_node (id),
CONSTRAINT fk_alf_cass_cnode foreign key (child_node_id) REFERENCES t_alf_node (id),
CONSTRAINT fk_alf_cass_tqn foreign key (type_qname_id) REFERENCES alf_qname (id),
CONSTRAINT fk_alf_cass_qnns foreign key (qname_ns_id) REFERENCES alf_namespace (id),
PRIMARY KEY (id),
UNIQUE (parent_node_id, type_qname_id, child_node_name_crc, child_node_name)
) TYPE=InnoDB;
LOCK TABLES
t_alf_child_assoc WRITE,
alf_child_assoc AS ca READ,
t_qnames_dyn AS tqndyn READ,
t_qnames AS tqn READ
;
INSERT INTO t_alf_child_assoc
(
id, version,
parent_node_id,
type_qname_id,
child_node_name_crc, child_node_name,
child_node_id,
qname_ns_id, qname_localname,
is_primary, assoc_index
)
SELECT STRAIGHT_JOIN
ca.id, 1,
ca.parent_node_id,
tqn.qname_id,
ca.child_node_name_crc, ca.child_node_name,
ca.child_node_id,
tqndyn.namespace_id, tqndyn.local_name,
ca.is_primary, ca.assoc_index
FROM
alf_child_assoc ca
JOIN t_qnames_dyn tqndyn ON (ca.qname = tqndyn.qname)
JOIN t_qnames tqn ON (ca.type_qname = tqn.qname)
;
UNLOCK TABLES;
– Clean up
DROP TABLE t_qnames_dyn;
DROP TABLE alf_child_assoc;
ALTER TABLE t_alf_child_assoc RENAME TO alf_child_assoc;
– —————————-
– Populate the Node Assocs –
– —————————-
CREATE TABLE t_alf_node_assoc
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
source_node_id BIGINT NOT NULL,
target_node_id BIGINT NOT NULL,
type_qname_id BIGINT NOT NULL,
INDEX fk_alf_nass_snode (source_node_id),
INDEX fk_alf_nass_tnode (target_node_id),
INDEX fk_alf_nass_tqn (type_qname_id),
CONSTRAINT fk_alf_nass_snode FOREIGN KEY (source_node_id) REFERENCES t_alf_node (id),
CONSTRAINT fk_alf_nass_tnode FOREIGN KEY (target_node_id) REFERENCES t_alf_node (id),
CONSTRAINT fk_alf_nass_tqn FOREIGN KEY (type_qname_id) REFERENCES alf_qname (id),
PRIMARY KEY (id),
UNIQUE (source_node_id, target_node_id, type_qname_id)
) TYPE=InnoDB;
LOCK TABLES
t_alf_node_assoc WRITE,
alf_node_assoc AS na READ,
t_qnames AS tqn READ
;
INSERT INTO t_alf_node_assoc
(
id, version,
source_node_id, target_node_id,
type_qname_id
)
SELECT STRAIGHT_JOIN
na.id, 1,
na.source_node_id, na.target_node_id,
tqn.qname_id
FROM
alf_node_assoc na
JOIN t_qnames tqn ON (na.type_qname = tqn.qname)
;
UNLOCK TABLES;
– Clean up
DROP TABLE alf_node_assoc;
ALTER TABLE t_alf_node_assoc RENAME TO alf_node_assoc;
– —————————-
– Populate the Usage Deltas –
– —————————-
CREATE TABLE t_alf_usage_delta
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL,
node_id BIGINT NOT NULL,
delta_size BIGINT NOT NULL,
INDEX fk_alf_usaged_n (node_id),
CONSTRAINT fk_alf_usaged_n FOREIGN KEY (node_id) REFERENCES t_alf_node (id),
PRIMARY KEY (id)
) TYPE=InnoDB;
INSERT INTO t_alf_usage_delta
(
id, version,
node_id,
delta_size
)
SELECT
ud.id, 1,
ud.node_id,
ud.delta_size
FROM
alf_usage_delta ud
; – (optional)
– Clean up
DROP TABLE alf_usage_delta; – (optional)
ALTER TABLE t_alf_usage_delta RENAME TO alf_usage_delta;
– —————————–
– Populate the Node Aspects –
– —————————–
CREATE TABLE t_alf_node_aspects
(
node_id BIGINT NOT NULL,
qname_id BIGINT NOT NULL,
INDEX fk_alf_nasp_n (node_id),
INDEX fk_alf_nasp_qn (qname_id),
CONSTRAINT fk_alf_nasp_n FOREIGN KEY (node_id) REFERENCES t_alf_node (id),
CONSTRAINT fk_alf_nasp_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id),
PRIMARY KEY (node_id, qname_id)
) TYPE=InnoDB;
LOCK TABLES
t_alf_node_aspects WRITE,
alf_node_aspects AS na READ,
t_qnames AS tqn READ
;
– Note the omission of sys:referencable. This is implicit.
INSERT INTO t_alf_node_aspects
(
node_id, qname_id
)
SELECT
na.node_id,
tqn.qname_id
FROM
alf_node_aspects na
JOIN t_qnames tqn ON (na.qname = tqn.qname)
WHERE
tqn.qname != '{http://www.alfresco.org/model/system/1.0}referenceable'
;
UNLOCK TABLES;
– Clean up
DROP TABLE alf_node_aspects;
ALTER TABLE t_alf_node_aspects RENAME TO alf_node_aspects;
– ———————————
– Populate the AVM Node Aspects –
– ———————————
CREATE TABLE t_avm_aspects
(
node_id BIGINT NOT NULL,
qname_id BIGINT NOT NULL,
INDEX fk_avm_nasp_n (node_id),
INDEX fk_avm_nasp_qn (qname_id),
CONSTRAINT fk_avm_nasp_n FOREIGN KEY (node_id) REFERENCES avm_nodes (id),
CONSTRAINT fk_avm_nasp_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id),
PRIMARY KEY (node_id, qname_id)
) TYPE=InnoDB;
INSERT INTO t_avm_aspects
(
node_id, qname_id
)
SELECT
aspects_old.node_id,
tqn.qname_id
FROM
avm_aspects aspects_old
JOIN t_qnames tqn ON (aspects_old.qname = tqn.qname)
;
INSERT INTO t_avm_aspects
(
node_id, qname_id
)
SELECT
anew.id,
tqn.qname_id
FROM
avm_aspects_new anew
JOIN t_qnames tqn ON (anew.name = tqn.qname)
LEFT JOIN avm_aspects aold ON (anew.id = aold.node_id AND anew.name = aold.qname)
WHERE
aold.id IS NULL
;
– Clean up
DROP TABLE avm_aspects;
DROP TABLE avm_aspects_new;
ALTER TABLE t_avm_aspects RENAME TO avm_aspects;
– ———————————-
– Migrate Sundry Property Tables –
– ———————————-
– Create temporary mapping for property types
CREATE TABLE t_prop_types
(
type_name VARCHAR(15) NOT NULL,
type_id INTEGER NOT NULL,
PRIMARY KEY (type_name)
) TYPE=InnoDB;
INSERT INTO t_prop_types values ('NULL', 0);
INSERT INTO t_prop_types values ('BOOLEAN', 1);
INSERT INTO t_prop_types values ('INTEGER', 2);
INSERT INTO t_prop_types values ('LONG', 3);
INSERT INTO t_prop_types values ('FLOAT', 4);
INSERT INTO t_prop_types values ('DOUBLE', 5);
INSERT INTO t_prop_types values ('STRING', 6);
INSERT INTO t_prop_types values ('DATE', 7);
INSERT INTO t_prop_types values ('DB_ATTRIBUTE', 8);
INSERT INTO t_prop_types values ('SERIALIZABLE', 9);
INSERT INTO t_prop_types values ('MLTEXT', 10);
INSERT INTO t_prop_types values ('CONTENT', 11);
INSERT INTO t_prop_types values ('NODEREF', 12);
INSERT INTO t_prop_types values ('CHILD_ASSOC_REF', 13);
INSERT INTO t_prop_types values ('ASSOC_REF', 14);
INSERT INTO t_prop_types values ('QNAME', 15);
INSERT INTO t_prop_types values ('PATH', 16);
INSERT INTO t_prop_types values ('LOCALE', 17);
INSERT INTO t_prop_types values ('VERSION_NUMBER', 18);
OPTIMIZE TABLE t_prop_types;
– Modify the avm_store_properties table
CREATE TABLE t_avm_store_properties
(
id BIGINT NOT NULL AUTO_INCREMENT,
avm_store_id BIGINT,
qname_id BIGINT NOT NULL,
actual_type_n integer NOT NULL,
persisted_type_n integer NOT NULL,
multi_valued bit NOT NULL,
boolean_value bit,
long_value BIGINT,
float_value float,
double_value DOUBLE PRECISION,
string_value TEXT,
serializable_value blob,
INDEX fk_avm_sprop_store (avm_store_id),
INDEX fk_avm_sprop_qname (qname_id),
CONSTRAINT fk_avm_sprop_store FOREIGN KEY (avm_store_id) REFERENCES avm_stores (id),
CONSTRAINT fk_avm_sprop_qname FOREIGN KEY (qname_id) REFERENCES alf_qname (id),
PRIMARY KEY (id)
) TYPE=InnoDB;
INSERT INTO t_avm_store_properties
(
avm_store_id,
qname_id,
actual_type_n, persisted_type_n,
multi_valued, boolean_value, long_value, float_value, double_value, string_value, serializable_value
)
SELECT
p.avm_store_id,
tqn.qname_id,
ptypes_actual.type_id, ptypes_persisted.type_id,
p.multi_valued, p.boolean_value, p.long_value, p.float_value, p.double_value, p.string_value, p.serializable_value
FROM
avm_store_properties p
JOIN t_qnames tqn ON (p.qname = tqn.qname)
JOIN t_prop_types ptypes_actual ON (ptypes_actual.type_name = p.actual_type)
JOIN t_prop_types ptypes_persisted ON (ptypes_persisted.type_name = p.persisted_type)
;
DROP TABLE avm_store_properties;
ALTER TABLE t_avm_store_properties RENAME TO avm_store_properties;
– Modify the avm_node_properties_new table
CREATE TABLE t_avm_node_properties
(
node_id BIGINT NOT NULL,
qname_id BIGINT NOT NULL,
actual_type_n INTEGER NOT NULL,
persisted_type_n INTEGER NOT NULL,
multi_valued BIT NOT NULL,
boolean_value BIT,
long_value BIGINT,
float_value FLOAT,
double_value DOUBLE PRECISION,
string_value TEXT,
serializable_value BLOB,
INDEX fk_avm_nprop_n (node_id),
INDEX fk_avm_nprop_qn (qname_id),
CONSTRAINT fk_avm_nprop_n FOREIGN KEY (node_id) REFERENCES avm_nodes (id),
CONSTRAINT fk_avm_nprop_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id),
PRIMARY KEY (node_id, qname_id)
) TYPE=InnoDB;
INSERT INTO t_avm_node_properties
(
node_id,
qname_id,
actual_type_n, persisted_type_n,
multi_valued, boolean_value, long_value, float_value, double_value, string_value, serializable_value
)
SELECT
p.node_id,
tqn.qname_id,
ptypes_actual.type_id, ptypes_persisted.type_id,
p.multi_valued, p.boolean_value, p.long_value, p.float_value, p.double_value, p.string_value, p.serializable_value
FROM
avm_node_properties_new p
JOIN t_qnames tqn ON (p.qname = tqn.qname)
JOIN t_prop_types ptypes_actual ON (ptypes_actual.type_name = p.actual_type)
JOIN t_prop_types ptypes_persisted ON (ptypes_persisted.type_name = p.persisted_type)
;
INSERT INTO t_avm_node_properties
(
node_id,
qname_id,
actual_type_n, persisted_type_n,
multi_valued, boolean_value, long_value, float_value, double_value, string_value, serializable_value
)
SELECT
p.node_id,
tqn.qname_id,
ptypes_actual.type_id, ptypes_persisted.type_id,
p.multi_valued, p.boolean_value, p.long_value, p.float_value, p.double_value, p.string_value, p.serializable_value
FROM
avm_node_properties p
JOIN t_qnames tqn ON (p.qname = tqn.qname)
JOIN t_prop_types ptypes_actual ON (ptypes_actual.type_name = p.actual_type)
JOIN t_prop_types ptypes_persisted ON (ptypes_persisted.type_name = p.persisted_type)
LEFT OUTER JOIN t_avm_node_properties tanp ON (tqn.qname_id = tanp.qname_id)
WHERE
tanp.qname_id IS NULL
;
DROP TABLE avm_node_properties_new;
DROP TABLE avm_node_properties;
ALTER TABLE t_avm_node_properties RENAME TO avm_node_properties;
– —————–
– Build Locales –
– —————–
CREATE TABLE alf_locale
(
id BIGINT NOT NULL AUTO_INCREMENT,
version BIGINT NOT NULL DEFAULT 1,
locale_str VARCHAR(20) NOT NULL,
PRIMARY KEY (id),
UNIQUE (locale_str)
) TYPE=InnoDB;
INSERT INTO alf_locale (id, locale_str) VALUES (1, '.default');
– Locales come from the attribute table which was used to support MLText persistence
– Query OK, 0 rows affected (17.22 sec)
INSERT INTO alf_locale (locale_str)
SELECT DISTINCT(ma.mkey)
FROM alf_node_properties np
JOIN alf_attributes a1 ON (np.attribute_value = a1.id)
JOIN alf_map_attribute_entries ma ON (ma.map_id = a1.id)
;
– ——————————-
– Migrate ADM Property Tables –
– ——————————-
CREATE TABLE t_alf_node_properties
(
node_id BIGINT NOT NULL,
qname_id BIGINT NOT NULL,
locale_id BIGINT NOT NULL,
list_index smallint NOT NULL,
actual_type_n INTEGER NOT NULL,
persisted_type_n INTEGER NOT NULL,
boolean_value BIT,
long_value BIGINT,
float_value FLOAT,
double_value DOUBLE PRECISION,
string_value TEXT,
serializable_value BLOB,
INDEX fk_alf_nprop_n (node_id),
INDEX fk_alf_nprop_qn (qname_id),
INDEX fk_alf_nprop_loc (locale_id),
CONSTRAINT fk_alf_nprop_n FOREIGN KEY (node_id) REFERENCES t_alf_node (id),
CONSTRAINT fk_alf_nprop_qn FOREIGN KEY (qname_id) REFERENCES alf_qname (id),
CONSTRAINT fk_alf_nprop_loc FOREIGN KEY (locale_id) REFERENCES alf_locale (id),
PRIMARY KEY (node_id, qname_id, list_index, locale_id)
) TYPE=InnoDB;
– Copy values over
LOCK TABLES
t_alf_node_properties WRITE,
alf_node_properties AS np READ,
t_prop_types AS ptypes_actual READ,
t_prop_types AS ptypes_persisted READ,
t_qnames AS tqn READ;
INSERT INTO t_alf_node_properties
(
node_id, qname_id, locale_id, list_index,
actual_type_n,
persisted_type_n,
boolean_value, long_value, float_value, double_value,
string_value,
serializable_value
)
SELECT
np.node_id,
(select tqn.qname_id from t_qnames tqn where np.qname = tqn.qname) as qname_id,
1,
-1,
(select ptypes_actual.type_id from t_prop_types ptypes_actual where ptypes_actual.type_name = np.actual_type) as actual_type_id,
(select ptypes_persisted.type_id from t_prop_types ptypes_persisted where ptypes_persisted.type_name = np.persisted_type) as persisted_type_id,
np.boolean_value,
np.long_value,
np.float_value,
np.double_value,
np.string_value,
np.serializable_value
FROM
alf_node_properties np
WHERE
np.attribute_value IS NULL
;
UNLOCK TABLES;
– Update cm:auditable properties on the nodes
UPDATE t_alf_node n SET audit_creator =
(
SELECT
string_value
FROM
t_alf_node_properties np
JOIN alf_qname qn ON (np.qname_id = qn.id)
JOIN alf_namespace ns ON (qn.ns_id = ns.id)
WHERE
np.node_id = n.id AND
ns.uri = 'FILLER-http://www.alfresco.org/model/content/1.0' AND
qn.local_name = 'creator'
);
UPDATE t_alf_node n SET audit_created =
(
SELECT
string_value
FROM
t_alf_node_properties np
JOIN alf_qname qn ON (np.qname_id = qn.id)
JOIN alf_namespace ns ON (qn.ns_id = ns.id)
WHERE
np.node_id = n.id AND
ns.uri = 'FILLER-http://www.alfresco.org/model/content/1.0' AND
qn.local_name = 'created'
);
UPDATE t_alf_node n SET audit_modifier =
(
SELECT
string_value
FROM
t_alf_node_properties np
JOIN alf_qname qn ON (np.qname_id = qn.id)
JOIN alf_namespace ns ON (qn.ns_id = ns.id)
WHERE
np.node_id = n.id AND
ns.uri = 'FILLER-http://www.alfresco.org/model/content/1.0' AND
qn.local_name = 'modifier'
);
UPDATE t_alf_node n SET audit_modified =
(
SELECT
string_value
FROM
t_alf_node_properties np
JOIN alf_qname qn ON (np.qname_id = qn.id)
JOIN alf_namespace ns ON (qn.ns_id = ns.id)
WHERE
np.node_id = n.id AND
ns.uri = 'FILLER-http://www.alfresco.org/model/content/1.0' AND
qn.local_name = 'modified'
);
– Remove the unused cm:auditable properties
– SHORTCUT:
– The qname_id values can be determined up front
– SELECT * FROM
– alf_qname
– JOIN alf_namespace ON (alf_qname.ns_id = alf_namespace.id)
– WHERE
– alf_namespace.uri = 'FILLER-http://www.alfresco.org/model/content/1.0' AND
– alf_qname.local_name IN ('creator', 'created', 'modifier', 'modified')
– ;
– DELETE t_alf_node_properties
– FROM t_alf_node_properties
– WHERE
– qname_id IN (13, 14, 23, 24);
DELETE t_alf_node_properties
FROM t_alf_node_properties
JOIN alf_qname ON (t_alf_node_properties.qname_id = alf_qname.id)
JOIN alf_namespace ON (alf_qname.ns_id = alf_namespace.id)
WHERE
alf_namespace.uri = 'FILLER-http://www.alfresco.org/model/content/1.0' AND
alf_qname.local_name IN ('creator', 'created', 'modifier', 'modified')
;
– Copy all MLText values over
INSERT INTO t_alf_node_properties
(
node_id, qname_id, locale_id, list_index,
actual_type_n, persisted_type_n,
boolean_value, long_value, float_value, double_value,
string_value,
serializable_value
)
SELECT STRAIGHT_JOIN
np.node_id, tqn.qname_id, loc.id, -1,
-1, 0,
FALSE, 0, 0, 0,
a2.string_value,
a2.serializable_value
FROM
alf_node_properties np
JOIN t_qnames tqn ON (np.qname = tqn.qname)
JOIN alf_attributes a1 ON (np.attribute_value = a1.id)
JOIN alf_map_attribute_entries ma ON (ma.map_id = a1.id)
JOIN alf_attributes a2 ON (ma.attribute_id = a2.id)
JOIN alf_locale loc ON (ma.mkey = loc.locale_str)
; – (OPTIONAL)
UPDATE t_alf_node_properties
SET actual_type_n = 6, persisted_type_n = 6, serializable_value = NULL
WHERE actual_type_n = -1 AND string_value IS NOT NULL
;
UPDATE t_alf_node_properties
SET actual_type_n = 9, persisted_type_n = 9
WHERE actual_type_n = -1 AND serializable_value IS NOT NULL
;
DELETE FROM t_alf_node_properties WHERE actual_type_n = -1;
– Delete the node properties and move the fixed values over
DROP TABLE alf_node_properties;
ALTER TABLE t_alf_node_properties RENAME TO alf_node_properties;
CREATE TABLE t_del_attributes
(
id BIGINT NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO t_del_attributes
SELECT id FROM alf_attributes WHERE type = 'M'
;
DELETE t_del_attributes
FROM t_del_attributes
JOIN alf_map_attribute_entries ma ON (ma.attribute_id = t_del_attributes.id)
;
DELETE t_del_attributes
FROM t_del_attributes
JOIN alf_list_attribute_entries la ON (la.attribute_id = t_del_attributes.id)
;
DELETE t_del_attributes
FROM t_del_attributes
JOIN alf_global_attributes ga ON (ga.attribute = t_del_attributes.id)
;
INSERT INTO t_del_attributes
SELECT a.id FROM t_del_attributes t
JOIN alf_map_attribute_entries ma ON (ma.map_id = t.id)
JOIN alf_attributes a ON (ma.attribute_id = a.id)
;
DELETE alf_map_attribute_entries
FROM alf_map_attribute_entries
JOIN t_del_attributes t ON (alf_map_attribute_entries.map_id = t.id)
;
DELETE alf_attributes
FROM alf_attributes
JOIN t_del_attributes t ON (alf_attributes.id = t.id)
;
DROP TABLE t_del_attributes;
– —————————————————
– Remove the FILLER- values from the namespace uri –
– —————————————————
UPDATE alf_namespace SET uri = '.empty' WHERE uri = 'FILLER-';
UPDATE alf_namespace SET uri = SUBSTR(uri, 8) WHERE uri LIKE 'FILLER-%';
– ——————
– Final clean up –
– ——————
DROP TABLE t_qnames;
DROP TABLE t_prop_types;
DROP TABLE alf_node_status;
ALTER TABLE alf_store DROP INDEX FKBD4FF53D22DBA5BA, DROP FOREIGN KEY FKBD4FF53D22DBA5BA; – (OPTIONAL)
ALTER TABLE alf_store DROP FOREIGN KEY alf_store_root; – (OPTIONAL)
DROP TABLE alf_node;
ALTER TABLE t_alf_node RENAME TO alf_node;
DROP TABLE alf_store;
ALTER TABLE t_alf_store RENAME TO alf_store;
– ————————————-
– Modify index and constraint names –
– ————————————-
ALTER TABLE alf_attributes DROP INDEX fk_attributes_n_acl, DROP FOREIGN KEY fk_attributes_n_acl; – (optional)
ALTER TABLE alf_attributes DROP INDEX fk_attr_n_acl; – (optional)
ALTER TABLE alf_attributes
ADD INDEX fk_alf_attr_acl (acl_id)
;
ALTER TABLE alf_audit_date DROP INDEX adt_woy_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_date_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_y_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_q_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_m_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_dow_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_doy_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_dom_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_hy_idx; – (optional)
ALTER TABLE alf_audit_date DROP INDEX adt_wom_idx; – (optional)
ALTER TABLE alf_audit_date
ADD INDEX idx_alf_adtd_woy (week_of_year),
ADD INDEX idx_alf_adtd_q (quarter),
ADD INDEX idx_alf_adtd_wom (week_of_month),
ADD INDEX idx_alf_adtd_dom (day_of_month),
ADD INDEX idx_alf_adtd_doy (day_of_year),
ADD INDEX idx_alf_adtd_dow (day_of_week),
ADD INDEX idx_alf_adtd_m (month),
ADD INDEX idx_alf_adtd_hy (half_year),
ADD INDEX idx_alf_adtd_fy (full_year),
ADD INDEX idx_alf_adtd_dat (date_only)
;
ALTER TABLE alf_audit_fact DROP INDEX adt_user_idx; – (optional)
ALTER TABLE alf_audit_fact DROP INDEX adt_store_idx; – (optional)
ALTER TABLE alf_audit_fact
DROP INDEX FKEAD18174A0F9B8D9, DROP FOREIGN KEY FKEAD18174A0F9B8D9,
DROP INDEX FKEAD1817484342E39, DROP FOREIGN KEY FKEAD1817484342E39,
DROP INDEX FKEAD18174F524CFD7, DROP FOREIGN KEY FKEAD18174F524CFD7
;
ALTER TABLE alf_audit_fact
ADD INDEX idx_alf_adtf_ref (store_protocol, store_id, node_uuid),
ADD INDEX idx_alf_adtf_usr (user_id),
ADD INDEX fk_alf_adtf_src (audit_source_id),
ADD CONSTRAINT fk_alf_adtf_src FOREIGN KEY (audit_source_id) REFERENCES alf_audit_source (id),
ADD INDEX fk_alf_adtf_date (audit_date_id),
ADD CONSTRAINT fk_alf_adtf_date FOREIGN KEY (audit_date_id) REFERENCES alf_audit_date (id),
ADD INDEX fk_alf_adtf_conf (audit_conf_id),
ADD CONSTRAINT fk_alf_adtf_conf FOREIGN KEY (audit_conf_id) REFERENCES alf_audit_config (id)
;
ALTER TABLE alf_audit_source DROP INDEX app_source_app_idx; – (optional)
ALTER TABLE alf_audit_source DROP INDEX app_source_ser_idx; – (optional)
ALTER TABLE alf_audit_source DROP INDEX app_source_met_idx; – (optional)
ALTER TABLE alf_audit_source
ADD INDEX idx_alf_adts_met (method),
ADD INDEX idx_alf_adts_ser (service),
ADD INDEX idx_alf_adts_app (application)
;
ALTER TABLE alf_global_attributes DROP FOREIGN KEY FK64D0B9CF69B9F16A; – (optional)
ALTER TABLE alf_global_attributes DROP INDEX FK64D0B9CF69B9F16A; – (optional)
– alf_global_attributes.attribute is declared unique. Indexes may automatically have been created.
ALTER TABLE alf_global_attributes
ADD INDEX fk_alf_gatt_att (attribute); – (optional)
ALTER TABLE alf_global_attributes
ADD CONSTRAINT fk_alf_gatt_att FOREIGN KEY (attribute) REFERENCES alf_attributes (id)
;
ALTER TABLE alf_list_attribute_entries DROP INDEX FKC7D52FB02C5AB86C, DROP FOREIGN KEY FKC7D52FB02C5AB86C; – (optional)
ALTER TABLE alf_list_attribute_entries DROP INDEX FKC7D52FB0ACD8822C, DROP FOREIGN KEY FKC7D52FB0ACD8822C; – (optional)
ALTER TABLE alf_list_attribute_entries
ADD INDEX fk_alf_lent_att (attribute_id),
ADD CONSTRAINT fk_alf_lent_att FOREIGN KEY (attribute_id) REFERENCES alf_attributes (id),
ADD INDEX fk_alf_lent_latt (list_id),
ADD CONSTRAINT fk_alf_lent_latt FOREIGN KEY (list_id) REFERENCES alf_attributes (id)
;
ALTER TABLE alf_map_attribute_entries DROP INDEX FK335CAE26AEAC208C, DROP FOREIGN KEY FK335CAE26AEAC208C; – (optional)
ALTER TABLE alf_map_attribute_entries DROP INDEX FK335CAE262C5AB86C, DROP FOREIGN KEY FK335CAE262C5AB86C; – (optional)
ALTER TABLE alf_map_attribute_entries
ADD INDEX fk_alf_matt_matt (map_id),
ADD CONSTRAINT fk_alf_matt_matt FOREIGN KEY (map_id) REFERENCES alf_attributes (id),
ADD INDEX fk_alf_matt_att (attribute_id),
ADD CONSTRAINT fk_alf_matt_att FOREIGN KEY (attribute_id) REFERENCES alf_attributes (id)
;
ALTER TABLE alf_transaction DROP INDEX idx_commit_time_ms; – (optional)
ALTER TABLE alf_transaction
ADD COLUMN commit_time_ms BIGINT NULL
; – (optional)
ALTER TABLE alf_transaction
DROP INDEX FKB8761A3A9AE340B7, DROP FOREIGN KEY FKB8761A3A9AE340B7,
ADD INDEX fk_alf_txn_svr (server_id),
ADD CONSTRAINT fk_alf_txn_svr FOREIGN KEY (server_id) REFERENCES alf_server (id),
ADD INDEX idx_alf_txn_ctms (commit_time_ms)
;
UPDATE alf_transaction SET commit_time_ms = id WHERE commit_time_ms IS NULL;
ALTER TABLE avm_child_entries DROP INDEX fk_avm_ce_child, DROP FOREIGN KEY fk_avm_ce_child; – (optional)
ALTER TABLE avm_child_entries DROP INDEX fk_avm_ce_parent, DROP FOREIGN KEY fk_avm_ce_parent; – (optional)
ALTER TABLE avm_child_entries
ADD INDEX fk_avm_ce_child (child_id),
ADD CONSTRAINT fk_avm_ce_child FOREIGN KEY (child_id) REFERENCES avm_nodes (id),
ADD INDEX fk_avm_ce_parent (parent_id),
ADD CONSTRAINT fk_avm_ce_parent FOREIGN KEY (parent_id) REFERENCES avm_nodes (id)
;
ALTER TABLE avm_history_links DROP INDEX fk_avm_hl_desc, DROP FOREIGN KEY fk_avm_hl_desc; – (optional)
ALTER TABLE avm_history_links DROP INDEX fk_avm_hl_ancestor, DROP FOREIGN KEY fk_avm_hl_ancestor; – (optional)
ALTER TABLE avm_history_links DROP INDEX idx_avm_hl_revpk; – (optional)
ALTER TABLE avm_history_links
ADD INDEX fk_avm_hl_desc (descendent),
ADD CONSTRAINT fk_avm_hl_desc FOREIGN KEY (descendent) REFERENCES avm_nodes (id),
ADD INDEX fk_avm_hl_ancestor (ancestor),
ADD CONSTRAINT fk_avm_hl_ancestor FOREIGN KEY (ancestor) REFERENCES avm_nodes (id),
ADD INDEX idx_avm_hl_revpk (descendent, ancestor)
;
ALTER TABLE avm_merge_links DROP INDEX fk_avm_ml_to, DROP FOREIGN KEY fk_avm_ml_to; – (optional)
ALTER TABLE avm_merge_links DROP INDEX fk_avm_ml_from, DROP FOREIGN KEY fk_avm_ml_from; – (optional)
ALTER TABLE avm_merge_links
ADD INDEX fk_avm_ml_to (mto),
ADD CONSTRAINT fk_avm_ml_to FOREIGN KEY (mto) REFERENCES avm_nodes (id),
ADD INDEX fk_avm_ml_from (mfrom),
ADD CONSTRAINT fk_avm_ml_from FOREIGN KEY (mfrom) REFERENCES avm_nodes (id)
;
ALTER TABLE avm_nodes DROP INDEX fk_avm_n_acl, DROP FOREIGN KEY fk_avm_n_acl; – (optional)
ALTER TABLE avm_nodes DROP INDEX fk_avm_n_store, DROP FOREIGN KEY fk_avm_n_store; – (optional)
ALTER TABLE avm_nodes DROP INDEX idx_avm_n_pi; – (optional)
ALTER TABLE avm_nodes
ADD INDEX fk_avm_n_acl (acl_id),
ADD CONSTRAINT fk_avm_n_acl FOREIGN KEY (acl_id) REFERENCES alf_access_control_list (id),
ADD INDEX fk_avm_n_store (store_new_id),
ADD CONSTRAINT fk_avm_n_store FOREIGN KEY (store_new_id) REFERENCES avm_stores (id),
ADD INDEX idx_avm_n_pi (primary_indirection)
;
ALTER TABLE avm_stores DROP INDEX fk_avm_s_root, DROP FOREIGN KEY fk_avm_s_root; – (optional)
ALTER TABLE avm_stores
ADD INDEX fk_avm_s_acl (acl_id),
ADD CONSTRAINT fk_avm_s_acl FOREIGN KEY (acl_id) REFERENCES alf_access_control_list (id),
ADD INDEX fk_avm_s_root (current_root_id),
ADD CONSTRAINT fk_avm_s_root FOREIGN KEY (current_root_id) REFERENCES avm_nodes (id)
;
ALTER TABLE avm_version_layered_node_entry DROP INDEX FK182E672DEB9D70C, DROP FOREIGN KEY FK182E672DEB9D70C; – (optional)
ALTER TABLE avm_version_layered_node_entry
ADD INDEX fk_avm_vlne_vr (version_root_id),
ADD CONSTRAINT fk_avm_vlne_vr FOREIGN KEY (version_root_id) REFERENCES avm_version_roots (id)
;
ALTER TABLE avm_version_roots DROP INDEX idx_avm_vr_version; – (optional)
ALTER TABLE avm_version_roots DROP INDEX idx_avm_vr_revuq; – (optional)
ALTER TABLE avm_version_roots DROP INDEX fk_avm_vr_root, DROP FOREIGN KEY fk_avm_vr_root; – (optional)
ALTER TABLE avm_version_roots DROP INDEX fk_avm_vr_store, DROP FOREIGN KEY fk_avm_vr_store; – (optional)
ALTER TABLE avm_version_roots
ADD INDEX idx_avm_vr_version (version_id),
ADD INDEX idx_avm_vr_revuq (avm_store_id, version_id),
ADD INDEX fk_avm_vr_root (root_id),
ADD CONSTRAINT fk_avm_vr_root FOREIGN KEY (root_id) REFERENCES avm_nodes (id),
ADD INDEX fk_avm_vr_store (avm_store_id),
ADD CONSTRAINT fk_avm_vr_store FOREIGN KEY (avm_store_id) REFERENCES avm_stores (id)
;
–
– Record script finish
–
DELETE FROM alf_applied_patch WHERE id = 'patch.db-V2.2-Upgrade-From-2.1';
INSERT INTO alf_applied_patch
(id, description, fixes_from_schema, fixes_to_schema, applied_to_schema, target_schema, applied_on_date, applied_to_server, was_executed, succeeded, report)
VALUES
(
'patch.db-V2.2-Upgrade-From-2.1', 'Manually executed script upgrade V2.2: Upgrade from 2.1',
0, 85, -1, 91, null, 'UNKOWN', 1, 1, 'Script completed'
);
A suivre pour les versions, on creuse…
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Bonjour,
J'ai moi aussi des problèmes avec les versions des documents… elles n'apparaissent plus!
Avez-vous trouver une solution ou des pistes?
J'ai également des soucis avec le CIFS, certains dossiers ne sont plus consultables alors qu'ils le sont parfaitement avec l'explorateur internet…
Avez-vous constaté le même phénomène?
Merci.
J'ai moi aussi des problèmes avec les versions des documents… elles n'apparaissent plus!
Avez-vous trouver une solution ou des pistes?
J'ai également des soucis avec le CIFS, certains dossiers ne sont plus consultables alors qu'ils le sont parfaitement avec l'explorateur internet…
Avez-vous constaté le même phénomène?
Merci.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Bonjour,
Nous n'avons pas encore mis en service le CIFS, nous allons d'abord nous attacher à récupérer nos anciennes versions de documents(environ 70 docs).
Avez-vous eu l'occasion de vérifier l'intégrité de la reprise des droits de votre référentiel ? Car le modéle, pour la gestion des droits, côté base de données change pas mal, ces modifications étaient à l'origine de nos blocages avec les version 3a, 3b et 3c.
Nous avons monté un atelier avec les sources 3 afin d'executer pas à pas ce satané VersionMigrator :mrgreen: et voir où ça coince.
Nous vous tenons au courant de nos avancées le plus rapidement possible !
Nicolas
Nous n'avons pas encore mis en service le CIFS, nous allons d'abord nous attacher à récupérer nos anciennes versions de documents(environ 70 docs).
Avez-vous eu l'occasion de vérifier l'intégrité de la reprise des droits de votre référentiel ? Car le modéle, pour la gestion des droits, côté base de données change pas mal, ces modifications étaient à l'origine de nos blocages avec les version 3a, 3b et 3c.
Nous avons monté un atelier avec les sources 3 afin d'executer pas à pas ce satané VersionMigrator :mrgreen: et voir où ça coince.
Nous vous tenons au courant de nos avancées le plus rapidement possible !
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Bonjour,
N'hésitez pas à consulter JIRA pour voir si le problème a été remonté (je ne l'ai pas trouvé personnellement), et le signaler le cas échéant.
=> http://issues.alfresco.com/
N'hésitez pas à consulter JIRA pour voir si le problème a été remonté (je ne l'ai pas trouvé personnellement), et le signaler le cas échéant.
=> http://issues.alfresco.com/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Bonjour,
quelques nouvelles du front : la migration des versions rencontre plusieurs problémes :
Bref nous avons environs 20 documents (sans compter leurs versions) qui posent de gros soucis au patch.
Celui-ci ne gérant pas la reprise sur incident et tout étant dans une seule et même transaction, il est très compliqué de débugger la chose !
Il nous semble qu'une soution simple pourrait consister à supprimer les vieux documents versionnés (mais difficile de les localiser) avant de migrer de la version 2.1 vers la 3.
Pour l'heure, nous décidons de perdre les versions antérieures des 20 documents et de modifier le patch de migration en ce sens afin qu'il traite correctement les 50 documents restants. Croisons les doigts ! :roll:
Effectivement, rien côté JIRA et je ferais un petit post quand nous aurons terminé nos tests.
A suivre donc…
Nicolas
quelques nouvelles du front : la migration des versions rencontre plusieurs problémes :
- Avec des versions anciennes de documents versionnés par une version antérieure à la 1.4, la récupération d'une propriété absente (nodedbid) provoque une erreur fatale.
Avec des versions de documents qui sont dans l'espace archive (poubelle), ce pourrait être une bonne idée de vider ce conteneur avant la migration.
Avec des versions de documents qui ont été supprimées (nous trouvons dans le conteneur de version un fichier du style mondocument.doc (copie de travail))
Bref nous avons environs 20 documents (sans compter leurs versions) qui posent de gros soucis au patch.
Celui-ci ne gérant pas la reprise sur incident et tout étant dans une seule et même transaction, il est très compliqué de débugger la chose !
Il nous semble qu'une soution simple pourrait consister à supprimer les vieux documents versionnés (mais difficile de les localiser) avant de migrer de la version 2.1 vers la 3.
Pour l'heure, nous décidons de perdre les versions antérieures des 20 documents et de modifier le patch de migration en ce sens afin qu'il traite correctement les 50 documents restants. Croisons les doigts ! :roll:
Effectivement, rien côté JIRA et je ferais un petit post quand nous aurons terminé nos tests.
A suivre donc…
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Découverte du jour :
Nous avons perdu dans la migration la plupart de templates de presentation que nous avions réalisés.
Soit le fichier apparait mais pointe vers un binaire du File System qui n'existe pas (ou plus)
Soit le fichier n'existe plus du tout.
Je continue mon état des lieux.
A suivre…
Nicolas
Nous avons perdu dans la migration la plupart de templates de presentation que nous avions réalisés.
Soit le fichier apparait mais pointe vers un binaire du File System qui n'existe pas (ou plus)
Soit le fichier n'existe plus du tout.
Je continue mon état des lieux.
A suivre…
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Migration 2.1 vers 3b
Merci Nicolas pour tous ces retours.
Nous sommes aussi en 2.1 et je teste régulièrement les dernières LABS. Pour le moment, je stagne toujours à la configuration initiale en 3.0 stable (je n'arrive pas à faire fonctionner CIFS avec passthru et un contrôleur de domaine Active Directory).
J'espère que cette étape pourra être passée et la suite de la migration va sans doute nous réserver pas mal de surprise car notre repository fait plusieurs dizaines de gigas avec des fichiers versionnés notamment, …
C'est étrange d'avoir tous ces soucis et que l'on en entende pas plus parler. N'y a-t-il personne à être confrontés à cette même problématique ?
Ou alors, tous les clients qui migrent auraient l'appui efficace du support d'Alfresco …
Votre retour d'expérience sur cette migration est particulièrement instructif, je vous suis avec beaucoup d'attention.
Bonne continuation et j'espère que vous arriverez au bout !
Nous sommes aussi en 2.1 et je teste régulièrement les dernières LABS. Pour le moment, je stagne toujours à la configuration initiale en 3.0 stable (je n'arrive pas à faire fonctionner CIFS avec passthru et un contrôleur de domaine Active Directory).
J'espère que cette étape pourra être passée et la suite de la migration va sans doute nous réserver pas mal de surprise car notre repository fait plusieurs dizaines de gigas avec des fichiers versionnés notamment, …
C'est étrange d'avoir tous ces soucis et que l'on en entende pas plus parler. N'y a-t-il personne à être confrontés à cette même problématique ?
Ou alors, tous les clients qui migrent auraient l'appui efficace du support d'Alfresco …
Votre retour d'expérience sur cette migration est particulièrement instructif, je vous suis avec beaucoup d'attention.
Bonne continuation et j'espère que vous arriverez au bout !
The Archive
Content from pre 2016 and from language groups that have been closed.
Content is read-only.
Latest Articles
- configuration envoi de mail Exchange
- Issue with MOVE Request (502) When Using Session T...
- Problemas al visual archivo desde alfresco
- Rendre obligatoire la saisie d'une propriété d'un ...
- Language dans l'entrepot
- Error al implementar Alfresco en AWS
- Alfresco Content Application und Share no se carga...
- set the number of characters to insert in the titl...
- Unidades de red webdav
- En inicio, aparece Error al cargar elementos en re...
- Alfresco RM in Community 6.2
- Obtener enlace público de una imagen
- sessiones
- Problems with my own ssl and Solr
- No deja borrar espacios
We use cookies on this site to enhance your user experience
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.