Failed to lock task

[Former Member]

Hi Pros,

We have upgraded to Hybris 1903 and we have been seeing below exceptions after the upgrade:

Would anyone know if this known issue or faced this issue and resolved it? Thanks in advance.

INFO | jvm1 | main | 2020/04/0605:34:35.140 | Exceptioninthread "TaskExecutor-master-2759-ProcessTask [10064767943606]" java.lang.IllegalStateException:Failedtolocktask#10064767943606.INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO.lock(TaskDAO.java:253) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.DefaultTaskService.processTask(DefaultTaskService.java:1461) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.DefaultTaskService.process(DefaultTaskService.java:1401) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.DefaultTaskService.processInTenant(DefaultTaskService.java:1370) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.DefaultTaskService$5.run(DefaultTaskService.java:1232) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atjava.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atjava.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atjava.base/java.lang.Thread.run(Thread.java:834) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.core.threadregistry.RegistrableThread.internalRun(RegistrableThread.java:141) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:131) INFO | jvm1 | main | 2020/04/0605:34:35.140 | Causedby:org.springframework.dao.DuplicateKeyException:PreparedStatementCallback; SQL [UPDATEtaskconditionsSETp_consumed= ? WHEREp_task= ?]; ORA-00001:uniqueconstraint (SAMS3.COND_IDX_951) violatedINFO | jvm1 | main | 2020/04/0605:34:35.140 | ; nestedexceptionisjava.sql.SQLIntegrityConstraintViolationException:ORA-00001:uniqueconstraint (SAMS3.COND_IDX_951) violatedINFO | jvm1 | main | 2020/04/0605:34:35.140 | INFO | jvm1 | main | 2020/04/0605:34:35.140 | atorg.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:242) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atorg.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atorg.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1442) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atorg.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:632) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atorg.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:861) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atorg.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:916) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO.update(TaskDAO.java:457) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO.lockInternal(TaskDAO.java:298) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO$9.execute(TaskDAO.java:279) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO$9.execute(TaskDAO.java:1) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.tx.Transaction.execute(Transaction.java:1181) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.tx.Transaction.execute(Transaction.java:1149) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO.lockWithTxRequired(TaskDAO.java:274) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atde.hybris.platform.task.impl.TaskDAO.lock(TaskDAO.java:249) INFO | jvm1 | main | 2020/04/0605:34:35.140 | ...9moreINFO | jvm1 | main | 2020/04/0605:34:35.140 | Causedby:java.sql.SQLIntegrityConstraintViolationException:ORA-00001:uniqueconstraint (SAMS3.COND_IDX_951) violatedINFO | jvm1 | main | 2020/04/0605:34:35.140 | INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) INFO | jvm1 | main | 2020/04/0605:34:35.140 | atoracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atde.hybris.platform.jdbcwrapper.interceptor.PreparedStatementWithJDBCInterceptor.lambda$5(PreparedStatementWithJDBCInterceptor.java:86) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atde.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.passThrough(SQLRecoverableExceptionHandler.java:101) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atde.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.get(SQLRecoverableExceptionHandler.java:59) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atde.hybris.platform.jdbcwrapper.interceptor.JDBCInterceptor.get(JDBCInterceptor.java:69) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atde.hybris.platform.jdbcwrapper.interceptor.PreparedStatementWithJDBCInterceptor.executeUpdate(PreparedStatementWithJDBCInterceptor.java:86) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atde.hybris.platform.jdbcwrapper.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:317) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atorg.springframework.jdbc.core.JdbcTemplate.lambda$update$0(JdbcTemplate.java:866) INFO | jvm1 | main | 2020/04/0605:34:35.141 | atorg.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:616)

[former_member1319880]

Hi,

Have you got solution for the same. We are facing same issue when we upgraded to 20.11