AVM Deployment Attempt Cleaner

[lynnders]

I enabled the AVM Deployment Attempt Cleaner. I've configured the deployment-attempt-cleaner-context.xml
to delete reports that are older than 100 days.

This task has started to fail because one of the nodes is locked. The whole job fails and will no longer delete any reports.

Error:

11:20:00,017 User:admin DEBUG [repo.avm.AVMDeploymentAttemptCleaner] Finding old deploymentattempt nodes using query: @wca\:deployattempttime:[0001\-01\-01T00:00:00 TO 2012\-3\-13T00:00:00]
11:20:00,217 User:admin DEBUG [repo.avm.AVMDeploymentAttemptCleaner] Deleting 344 old deployment attempts
11:20:00,394 User:admin DEBUG [repo.avm.AVMDeploymentAttemptCleaner] Deleted deployment attempt: workspace://SpacesStore/a5233a86-a107-4992-b100-0bf8eb47be44
11:20:00,510 User:admin DEBUG [repo.avm.AVMDeploymentAttemptCleaner] Deleted deployment attempt: workspace://SpacesStore/e7a0615c-a1bd-42bd-a1fb-2b65be285ab5
…
…
11:20:05,238 User:admin DEBUG [repo.avm.AVMDeploymentAttemptCleaner] Deleted deployment attempt: workspace://SpacesStore/6793ca78-455f-4a2a-9517-b1dadfcfa318
11:20:05,336 User:admin DEBUG [repo.avm.AVMDeploymentAttemptCleaner] Deleted deployment attempt: workspace://SpacesStore/b2257c1d-6d37-4627-8eb7-e0d8755bec8d
11:20:05,473  ERROR [quartz.core.JobRunShell] Job DEFAULT.avmDeploymentAttemptCleanerDetail threw an unhandled Exception:
org.alfresco.service.cmr.lock.NodeLockedException: 04020012 Can not perform operation since the node (id:0124f126-27ae-4e62-b8d6-79b01850ff7e) is locked.
        at org.alfresco.repo.lock.LockServiceImpl.checkForLock(LockServiceImpl.java:502)
        at org.alfresco.repo.lock.LockServiceImpl.beforeDeleteNode(LockServiceImpl.java:545)
        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:597)
        at org.alfresco.repo.policy.JavaBehaviour$JavaMethodInvocationHandler.invoke(JavaBehaviour.java:179)
        at $Proxy19.beforeDeleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor630.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.policy.PolicyFactory$MultiHandler.invoke(PolicyFactory.java:306)
        at org.alfresco.repo.policy.$Proxy193.beforeDeleteNode(Unknown Source)
        at org.alfresco.repo.node.AbstractNodeServiceImpl.invokeBeforeDeleteNode(AbstractNodeServiceImpl.java:357)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.deletePrimaryChildren(DbNodeServiceImpl.java:851)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.deleteNode(DbNodeServiceImpl.java:792)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy10.deleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy11.deleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy10.deleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy10.deleteNode(Unknown Source)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner.cleanAttempts(AVMDeploymentAttemptCleaner.java:158)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner.access$000(AVMDeploymentAttemptCleaner.java:49)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1$1.execute(AVMDeploymentAttemptCleaner.java:105)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1$1.execute(AVMDeploymentAttemptCleaner.java:102)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:234)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1.doWork(AVMDeploymentAttemptCleaner.java:109)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1.doWork(AVMDeploymentAttemptCleaner.java:98)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner.execute(AVMDeploymentAttemptCleaner.java:114)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleanerJob.execute(AVMDeploymentAttemptCleanerJob.java:60)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
11:20:05,474  ERROR [quartz.core.ErrorLogger] Job (DEFAULT.avmDeploymentAttemptCleanerDetail threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.service.cmr.lock.NodeLockedException: 04020012 Can not perform operation since the node (id:0124f126-27ae-4e62-b8d6-79b01850ff7e) is locked.]
        at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: org.alfresco.service.cmr.lock.NodeLockedException: 04020012 Can not perform operation since the node (id:0124f126-27ae-4e62-b8d6-79b01850ff7e) is locked.
        at org.alfresco.repo.lock.LockServiceImpl.checkForLock(LockServiceImpl.java:502)
        at org.alfresco.repo.lock.LockServiceImpl.beforeDeleteNode(LockServiceImpl.java:545)
        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:597)
        at org.alfresco.repo.policy.JavaBehaviour$JavaMethodInvocationHandler.invoke(JavaBehaviour.java:179)
        at $Proxy19.beforeDeleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor630.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.policy.PolicyFactory$MultiHandler.invoke(PolicyFactory.java:306)
        at org.alfresco.repo.policy.$Proxy193.beforeDeleteNode(Unknown Source)
        at org.alfresco.repo.node.AbstractNodeServiceImpl.invokeBeforeDeleteNode(AbstractNodeServiceImpl.java:357)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.deletePrimaryChildren(DbNodeServiceImpl.java:851)
        at org.alfresco.repo.node.db.DbNodeServiceImpl.deleteNode(DbNodeServiceImpl.java:792)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy10.deleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
        at $Proxy11.deleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:306)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:274)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy10.deleteNode(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor634.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
        at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:147)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
        at $Proxy10.deleteNode(Unknown Source)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner.cleanAttempts(AVMDeploymentAttemptCleaner.java:158)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner.access$000(AVMDeploymentAttemptCleaner.java:49)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1$1.execute(AVMDeploymentAttemptCleaner.java:105)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1$1.execute(AVMDeploymentAttemptCleaner.java:102)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:327)
        at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:234)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1.doWork(AVMDeploymentAttemptCleaner.java:109)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner$1.doWork(AVMDeploymentAttemptCleaner.java:98)
        at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:514)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleaner.execute(AVMDeploymentAttemptCleaner.java:114)
        at org.alfresco.repo.avm.AVMDeploymentAttemptCleanerJob.execute(AVMDeploymentAttemptCleanerJob.java:60)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        … 1 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The locked node is owned by our 'editorial3' user. This user became corrupt and we couldn't log on with their credentials, so I deleted the user. Even though I can no longer see them in the users section - I'm unable to add an new editorial3 user so they're not completely deleted. But this post isn't about the corrupt user.

How can I remove the lock so that the job can delete this node?

I've queried the node browser with the noderef that is erroring:

workspace://SpacesStore/0124f126-27ae-4e62-b8d6-79b01850ff7e‍

Here are some node details:

{http://www.alfresco.org/model/wcmappmodel/1.0}deployversion   11851
{http://www.alfresco.org/model/wcmappmodel/1.0}deployservertargetused   default
{http://www.alfresco.org/model/wcmappmodel/1.0}deploysuccessful   true
{http://www.alfresco.org/model/wcmappmodel/1.0}deployserverusernameused   admin
{http://www.alfresco.org/model/content/1.0}expiryDate   –null–
{http://www.alfresco.org/model/system/1.0}node-uuid   0124f126-27ae-4e62-b8d6-79b01850ff7e
{http://www.alfresco.org/model/content/1.0}creator   editorial3
{http://www.alfresco.org/model/content/1.0}modifier   editorial3
{http://www.alfresco.org/model/wcmappmodel/1.0}deployendtime   Mon Jan 23 14:45:02 GMT 2012
{http://www.alfresco.org/model/content/1.0}lockOwner   editorial3
{http://www.alfresco.org/model/content/1.0}content   contentUrl=store://2012/1/23/14/45/08c2d552-aabd-439e-ad02-40ea107d8f35.bin|mimetype=text/plain|size=2010|encoding=utf-8|locale=en_GB_
{http://www.alfresco.org/model/wcmappmodel/1.0}deployexcludesused   .*web\.xml$,.*loginStatus\.jsp$,.*taglibs\.jsp$
{http://www.alfresco.org/model/wcmappmodel/1.0}deploystarttime   Mon Jan 23 14:44:45 GMT 2012
{http://www.alfresco.org/model/content/1.0}modified   Thu Jan 26 12:36:41 GMT 2012
{http://www.alfresco.org/model/wcmappmodel/1.0}deployserverurlused   –null–
{http://www.alfresco.org/model/content/1.0}created   Mon Jan 23 14:45:02 GMT 2012
{http://www.alfresco.org/model/system/1.0}store-protocol   workspace
{http://www.alfresco.org/model/content/1.0}lockType   READ_ONLY_LOCK
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[lynnders]

Alfresco 3.2r
Mysql
Linux