topic Timeout errors setting user space permissions in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/timeout-errors-setting-user-space-permissions/m-p/192240#M145370 <HTML><HEAD></HEAD><BODY><SPAN>Have Alfresco 3 installed and loaded with content for one of our customers. Some of the spaces have deeply nested folders with lots of documents. I am now trying to set the permissions for the folders which requires that I first uncheck the Inherit Permissions option. When I do this on a folder without many subfolders or documents it works find and quickly. But, on a higher level on folders with lots of subfolders and/or documents, it goes for awhile (sometime ~30 mins or more) and then returns the error:</SPAN><BR /><BR /><SPAN>A system error happened during the operation: could not update: [org.alfresco.repo.domain.hibernate.NodeImpl#479]</SPAN><BR /><BR /><SPAN>with the trailing number being different with each attempt. From the alfresco.log file:</SPAN><BR /><BR /><SPAN>16:02:55,687 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: could not update: [org.alfresco.repo.domain.hibernate.NodeImpl#477]</SPAN><BR /><SPAN>org.hibernate.exception.GenericJDBCException: could not update: [org.alfresco.repo.domain.hibernate.NodeImpl#477]</SPAN><BR /><SPAN>at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)</SPAN><BR /><SPAN>at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)</SPAN><BR /><SPAN>at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)</SPAN><BR /><SPAN>at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2430)</SPAN><BR /><SPAN>at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)</SPAN><BR /><SPAN>at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)</SPAN><BR /><SPAN>at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96)</SPAN><BR /><SPAN>at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:322)</SPAN><BR /><SPAN>at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:306)</SPAN><BR /><SPAN>at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:183)</SPAN><BR /><SPAN>at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)</SPAN><BR /><SPAN>at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)</SPAN><BR /><SPAN>at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.doResetAndRemove(HibernateSessionHelperResource.java:197)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.HibernateSessionHelperResource.resetAndRemoveMark(HibernateSessionHelperResource.java:170)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.HibernateSessionHelper.resetAndRemoveMark(HibernateSessionHelper.java:85)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.setFixedAcls(DMAccessControlListDAO.java:379)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.DMAccessControlListDAO.setInheritanceForChildren(DMAccessControlListDAO.java:308)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.DMPermissionsDaoComponentImpl.createAccessControlList(DMPermissionsDaoComponentImpl.java:93)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.AbstractPermissionsDaoComponentImpl.getMutableAccessControlList(AbstractPermissionsDaoComponentImpl.java:216)</SPAN><BR /><SPAN>at org.alfresco.repo.domain.hibernate.AbstractPermissionsDaoComponentImpl.setInheritParentPermissions(AbstractPermissionsDaoComponentImpl.java:511)</SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)</SPAN><BR /><SPAN>at $Proxy6.setInheritParentPermissions(Unknown Source)</SPAN><BR /><SPAN>at org.alfresco.repo.security.permissions.impl.PermissionServiceImpl.setInheritParentPermissions(PermissionServiceImpl.java:932)</SPAN><BR /><SPAN>at sun.reflect.GeneratedMethodAccessor1482.invoke(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)</SPAN><BR /><SPAN>at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)</SPAN><BR /><SPAN>at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)</SPAN><BR /><SPAN>at $Proxy16.setInheritParentPermissions(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.GeneratedMethodAccessor1482.invoke(Unknown Source)</SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)</SPAN><BR /><SPAN>at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)</SPAN><BR /><SPAN>at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)</SPAN><BR /><SPAN>at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:275)</SPAN><BR /><SPAN>at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)</SPAN><BR /><SPAN>at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)</SPAN><BR /><SPAN>at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166)</SPAN><BR /><SPAN>at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)</SPAN><BR /><SPAN>at $Proxy20.setInheritParentPermissions(Unknown Source)</SPAN><BR /><SPAN>at org.alfresco.web.bean.users.UserMembersBean.inheritPermissionsValueChanged(UserMembersBean.java:598)</SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</SPAN><BR /><SPAN>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</SPAN><BR /><SPAN>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</SPAN><BR /><SPAN>at java.lang.reflect.Method.invoke(Method.java:597)</SPAN><BR /><SPAN>at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)</SPAN><BR /><SPAN>at javax.faces.component.UIInput.broadcast(UIInput.java:244)</SPAN><BR /><SPAN>at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)</SPAN><BR /><SPAN>at javax.faces.component.UIViewRoot.processValidators(UIViewRoot.java:150)</SPAN><BR /><SPAN>at org.apache.myfaces.lifecycle.ProcessValidationsExecutor.execute(ProcessValidationsExecutor.java:32)</SPAN><BR /><SPAN>at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)</SPAN><BR /><SPAN>at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)</SPAN><BR /><SPAN>at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)</SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)</SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)</SPAN><BR /><SPAN>at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:81)</SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)</SPAN><BR /><SPAN>at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</SPAN><BR /><SPAN>at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)</SPAN><BR /><SPAN>at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)</SPAN><BR /><SPAN>at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)</SPAN><BR /><SPAN>at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)</SPAN><BR /><SPAN>at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)</SPAN><BR /><SPAN>at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)</SPAN><BR /><SPAN>at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)</SPAN><BR /><SPAN>at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)</SPAN><BR /><SPAN>at java.lang.Thread.run(Thread.java:619)</SPAN><BR /><SPAN>Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction</SPAN><BR /><SPAN>at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)</SPAN><BR /><SPAN>at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)</SPAN><BR /><SPAN>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)</SPAN><BR /><SPAN>at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)</SPAN><BR /><SPAN>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)</SPAN><BR /><SPAN>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019)</SPAN><BR /><SPAN>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937)</SPAN><BR /><SPAN>at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922)</SPAN><BR /><SPAN>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)</SPAN><BR /><SPAN>at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2412)</SPAN><BR /><SPAN>… 81 more</SPAN><BR /><BR /><SPAN>This is using a MySQL database (local on the Alfresco server).</SPAN><BR /><BR /><SPAN>Is there a solution to this or a workaround in the form, possibly, of an SQL query that can be run on the database tables to update the permissions there outside of the admin web interface?</SPAN><BR /><BR /><BR /><SPAN>Chris Stone</SPAN><BR /><SPAN>AxisInternet, Inc.</SPAN></BODY></HTML> Wed, 25 Mar 2009 19:14:10 GMT axisinternet 2009-03-25T19:14:10Z Timeout errors setting user space permissions https://connect.hyland.com/t5/alfresco-archive/timeout-errors-setting-user-space-permissions/m-p/192240#M145370 Have Alfresco 3 installed and loaded with content for one of our customers. Some of the spaces have deeply nested folders with lots of documents. I am now trying to set the permissions for the folders which requires that I first uncheck the Inherit Permissions option. When I do this on a folder with Wed, 25 Mar 2009 19:14:10 GMT https://connect.hyland.com/t5/alfresco-archive/timeout-errors-setting-user-space-permissions/m-p/192240#M145370 axisinternet 2009-03-25T19:14:10Z Re: Timeout errors setting user space permissions https://connect.hyland.com/t5/alfresco-archive/timeout-errors-setting-user-space-permissions/m-p/192241#M145371 <HTML><HEAD></HEAD><BODY><SPAN>I'm having the exact same problem and wondering the same thing. Any way to do this by brute force?</SPAN></BODY></HTML> Thu, 02 Jul 2009 11:25:42 GMT https://connect.hyland.com/t5/alfresco-archive/timeout-errors-setting-user-space-permissions/m-p/192241#M145371 adamthehutt 2009-07-02T11:25:42Z