topic Updating Alfresco's DB (permission) scheme fails in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/updating-alfresco-s-db-permission-scheme-fails/m-p/194793#M147923 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I try to update our Alfresco installation to the latest SVN revision (r3009) and get the following error:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>6:52:50,157&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.<BR />16:53:01,786&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script /Users/hbf/icar/checkout/knowledge-center-icar/trunk/repository-server/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-24393.sql (Generated).<BR />16:53:02,030&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Executing database script /Users/hbf/icar/checkout/knowledge-center-icar/trunk/repository-server/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-org.hibernate.dialect.MySQLInnoDBDialect-24394.sql (Copied from classpath:alfresco/dbscripts/create/3.0/org.hibernate.dialect.MySQLInnoDBDialect/create-activities-extras.sql).<BR />16:53:02,380&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] All executed statements written to file /Users/hbf/icar/checkout/knowledge-center-icar/trunk/repository-server/tomcat/temp/Alfresco/AlfrescoSchemaUpdate-All_Statements-24395.sql.<BR />16:53:09,776 User:System WARN&nbsp; [node.index.FullIndexRecoveryComponent] The indexes are not synchronized with the database.<BR />16:53:10,335 User:System INFO&nbsp; [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /Users/hbf/icar/checkout/knowledge-center-icar/trunk/repository-server/alf_data<BR />16:53:10,778 User:System INFO&nbsp; [admin.patch.PatchExecuter] Checking for patches to apply …<BR />16:53:10,922 User:System INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;Applying patch 'patch.updateDmPermissions' (Update ACLs on all DM node objects to the new 3.0 permission model).<BR />16:59:13,921&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 10% complete, estimated complete at 9/14/08 5:53 PM.<BR />17:10:23,169&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 20% complete, estimated complete at 9/14/08 6:19 PM.<BR />17:18:38,154&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 25% complete, estimated complete at 9/14/08 6:34 PM.<BR />17:27:56,572&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 30% complete, estimated complete at 9/14/08 6:49 PM.<BR />18:04:41,844&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 35% complete, estimated complete at 9/14/08 8:17 PM.<BR />18:18:15,863&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 40% complete, estimated complete at 9/14/08 8:25 PM.<BR />18:34:36,536&nbsp; INFO&nbsp; [admin.patch.PatchExecuter] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Patch 45% complete, estimated complete at 9/14/08 8:38 PM.<BR />Exception in thread "TraceableThread-2-thread-9" java.lang.OutOfMemoryError: Java heap space<BR />Exception in thread "Timer-1" Exception in thread "PageSavingThread-wicket.website" Exception in thread "TraceableThread-2-thread-7" &nbsp;&nbsp;&nbsp;at java.util.concurrent.locks.AbstractQueuedSynchronizer.addWaiter(AbstractQueuedSynchronizer.java:546)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireInterruptibly(AbstractQueuedSynchronizer.java:762)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireInterruptibly(AbstractQueuedSynchronizer.java:1099)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.locks.ReentrantLock.lockInterruptibly(ReentrantLock.java:307)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:355)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:470)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:674)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:613)<BR />java.lang.OutOfMemoryError: Java heap space<BR />java.lang.OutOfMemoryError: Java heap space<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ConcurrentHashMap.isEmpty(ConcurrentHashMap.java:654)<BR />&nbsp;&nbsp;&nbsp;at org.apache.wicket.protocol.http.pagestore.DiskPageStore$PageSavingThread.run(DiskPageStore.java:943)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:613)<BR />java.lang.OutOfMemoryError: Java heap space<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.addConditionWaiter(AbstractQueuedSynchronizer.java:1657)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.locks.AbstractQueuedSynchronizer$ConditionObject.await(AbstractQueuedSynchronizer.java:1837)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.LinkedBlockingQueue.take(LinkedBlockingQueue.java:359)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor.getTask(ThreadPoolExecutor.java:470)<BR />&nbsp;&nbsp;&nbsp;at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:674)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:613)<BR />18:40:56,365 User:System ERROR [admin.patch.PatchExecuter] java.lang.NullPointerException<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.NodeImpl.hashCode(NodeImpl.java:153)<BR />&nbsp;&nbsp;&nbsp;at java.util.HashMap.put(HashMap.java:418)<BR />&nbsp;&nbsp;&nbsp;at java.util.HashSet.add(HashSet.java:194)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:221)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.fixOldDmAcls(DMAccessControlListDAO.java:199)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.patchAcls(DMAccessControlListDAO.java:175)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.impl.DmPermissionsPatch.applyInternal(DmPermissionsPatch.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:386)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1$1.execute(AbstractPatch.java:380)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:209)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:412)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch$1.doWork(AbstractPatch.java:376)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:585)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.AbstractPatch.apply(AbstractPatch.java:416)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatch(PatchServiceImpl.java:265)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchServiceImpl.access$200(PatchServiceImpl.java:56)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:208)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchServiceImpl$2.execute(PatchServiceImpl.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:294)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchServiceImpl.applyPatchAndDependencies(PatchServiceImpl.java:211)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchServiceImpl.applyOutstandingPatches(PatchServiceImpl.java:145)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)<BR />&nbsp;&nbsp;&nbsp;at $Proxy50.applyOutstandingPatches(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchExecuter.applyOutstandingPatches(PatchExecuter.java:89)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.admin.patch.PatchExecuter.onBootstrap(PatchExecuter.java:132)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.util.AbstractLifecycleBean.onApplicationEvent(AbstractLifecycleBean.java:62)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster$1.run(SimpleApplicationEventMulticaster.java:77)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:75)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:246)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:355)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:244)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:187)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContext.start(StandardContext.java:4216)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardService.start(StandardService.java:448)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Catalina.start(Catalina.java:552)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:585)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>My JVM has 2.5GB and the update consumes it all (allocated memory keeps growing during the update). Any idea what I could do in order to resolve this?</SPAN><BR /><BR /><SPAN>Thanks in advance,</SPAN><BR /><SPAN>Kaspar</SPAN></BODY></HTML> Sun, 14 Sep 2008 17:46:01 GMT hbf 2008-09-14T17:46:01Z Updating Alfresco's DB (permission) scheme fails https://connect.hyland.com/t5/alfresco-archive/updating-alfresco-s-db-permission-scheme-fails/m-p/194793#M147923 Hi,I try to update our Alfresco installation to the latest SVN revision (r3009) and get the following error:6:52:50,157&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.16:53:01,786&nbsp; INFO&nbsp; [domain.schema.SchemaBootstrap] Executing dat Sun, 14 Sep 2008 17:46:01 GMT https://connect.hyland.com/t5/alfresco-archive/updating-alfresco-s-db-permission-scheme-fails/m-p/194793#M147923 hbf 2008-09-14T17:46:01Z Re: Updating Alfresco's DB (permission) scheme fails https://connect.hyland.com/t5/alfresco-archive/updating-alfresco-s-db-permission-scheme-fails/m-p/194794#M147924 <HTML><HEAD></HEAD><BODY><SPAN>I have added a </SPAN><A href="https://issues.alfresco.com/jira/browse/ALFCOM-1942" rel="nofollow noopener noreferrer">JIRA</A><SPAN> issue for this.</SPAN></BODY></HTML> Mon, 15 Sep 2008 15:40:12 GMT https://connect.hyland.com/t5/alfresco-archive/updating-alfresco-s-db-permission-scheme-fails/m-p/194794#M147924 hbf 2008-09-15T15:40:12Z