topic Timer Start Event 'forgotten' in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/timer-start-event-forgotten/m-p/209103#M162233 <HTML><HEAD></HEAD><BODY><SPAN>Hi all, </SPAN><BR /><BR /><SPAN>I run a process every 10 minutes that GETs from one REST API and POSTs to another. For a little while now I have found that the timer start event is 'forgotten' at unpredictable intervals. These are the symptoms I observe: </SPAN><BR /><BR /><SPAN>- If an exception occurs during one of the REST calls then the insert of the next job seems to be skipped (and therefore the job does not run again)</SPAN><BR /><SPAN>- Once in this state it is not possible to delete the process definition, i.e. processEngine.getRepositoryService().deleteDeployment(id, true);&nbsp; </SPAN><BR /><BR /><SPAN>Today, however I have noticed that the job has stopped again only this time I have this in the ACT_RU_JOB table: </SPAN><BR /><BR /><SPAN>```</SPAN><BR /><SPAN>| 10074293 |&nbsp;&nbsp; 16 | timer | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | LogCalls:1:10046996 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -3 | 10074305&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | </SPAN><BR /><SPAN>### Error updating database.&nbsp; Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction</SPAN><BR /><SPAN>### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.insertTimer-Inline</SPAN><BR /><SPAN>### The error occurred while setting … | 2015-06-20 22:59:39 | R/2015-06-20T20:05:38/PT10M | timer-start-event | {"activityId":"LogCalls"} | tenant&nbsp;&nbsp; |</SPAN><BR /><SPAN>```</SPAN><BR /><SPAN> </SPAN><BR /><SPAN>Any suggestions of where to investigate would be appreciated. </SPAN><BR /><SPAN>Tim </SPAN><BR /></BODY></HTML> Sun, 21 Jun 2015 19:02:33 GMT tstephen 2015-06-21T19:02:33Z Timer Start Event 'forgotten' https://connect.hyland.com/t5/alfresco-archive/timer-start-event-forgotten/m-p/209103#M162233 Hi all, I run a process every 10 minutes that GETs from one REST API and POSTs to another. For a little while now I have found that the timer start event is 'forgotten' at unpredictable intervals. These are the symptoms I observe: - If an exception occurs during one of the REST calls then the insert Sun, 21 Jun 2015 19:02:33 GMT https://connect.hyland.com/t5/alfresco-archive/timer-start-event-forgotten/m-p/209103#M162233 tstephen 2015-06-21T19:02:33Z Re: Timer Start Event 'forgotten' https://connect.hyland.com/t5/alfresco-archive/timer-start-event-forgotten/m-p/209104#M162234 <HTML><HEAD></HEAD><BODY><SPAN>I'll try to reproduce it, </SPAN><BR /><SPAN>but will be perfect if you have the possibility to provide a test showing this issue.</SPAN></BODY></HTML> Mon, 22 Jun 2015 12:20:52 GMT https://connect.hyland.com/t5/alfresco-archive/timer-start-event-forgotten/m-p/209104#M162234 vasile_dirla 2015-06-22T12:20:52Z