integrity constraint violation: unique constraint or index violation: COND_IDX_951

[eahmetyldrm]

Caused by: java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: COND_IDX_951
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
	at de.hybris.platform.jdbcwrapper.interceptor.PreparedStatementWithJDBCInterceptor.lambda$5(PreparedStatementWithJDBCInterceptor.java:86)
	at de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.passThrough(SQLRecoverableExceptionHandler.java:101)
	at de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.get(SQLRecoverableExceptionHandler.java:59)
	at de.hybris.platform.jdbcwrapper.interceptor.JDBCInterceptor.get(JDBCInterceptor.java:69)
	at de.hybris.platform.jdbcwrapper.interceptor.PreparedStatementWithJDBCInterceptor.executeUpdate(PreparedStatementWithJDBCInterceptor.java:86)
	at de.hybris.platform.jdbcwrapper.PreparedStatementImpl.executeUpdate(PreparedStatementImpl.java:313)
	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:882)
	at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:875)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:638)
	... 20 more
Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation: COND_IDX_951
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.error.Error.error(Unknown Source)
	at org.hsqldb.index.IndexAVL.insert(Unknown Source)
	at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)
	at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)
	at org.hsqldb.TransactionManagerMVCC.addInsertAction(Unknown Source)
	at org.hsqldb.Session.addInsertAction(Unknown Source)
	at org.hsqldb.Table.insertSingleRow(Unknown Source)
	at org.hsqldb.StatementDML.update(Unknown Source)
	at org.hsqldb.StatementDML.executeUpdateStatement(Unknown Source)
	at org.hsqldb.StatementDML.getResult(Unknown Source)
	at org.hsqldb.StatementDMQL.execute(Unknown Source)
	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
	at org.hsqldb.Session.execute(Unknown Source)
	... 31 more
Exception in thread "TaskExecutor-master-242-ProcessTask [8804940448694]" java.lang.IllegalStateException: Failed to lock task #8804940448694.
	at de.hybris.platform.task.impl.TaskDAO.lock(TaskDAO.java:255)
	at de.hybris.platform.task.impl.DefaultTaskService.processTask(DefaultTaskService.java:1444)
	at de.hybris.platform.task.impl.DefaultTaskService.process(DefaultTaskService.java:1384)
	at de.hybris.platform.task.impl.DefaultTaskService.processInTenant(DefaultTaskService.java:1353)
	at de.hybris.platform.task.impl.DefaultTaskService$5.run(DefaultTaskService.java:1215)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
	at de.hybris.platform.core.threadregistry.RegistrableThread.internalRun(RegistrableThread.java:144)
	at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:134)
Caused by: org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [UPDATE taskconditions SET p_consumed = ? WHERE p_task = ?]; integrity constraint violation: unique constraint or index violation: COND_IDX_951; nested exception is java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation: COND_IDX_951
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:238)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:654)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:875)
	at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:936)
	at de.hybris.platform.task.impl.TaskDAO.update(TaskDAO.java:458)
	at de.hybris.platform.task.impl.TaskDAO.lockInternal(TaskDAO.java:300)
	at de.hybris.platform.task.impl.TaskDAO.access$1(TaskDAO.java:288)
	at de.hybris.platform.task.impl.TaskDAO$9.execute(TaskDAO.java:281)
	at de.hybris.platform.task.impl.TaskDAO$9.execute(TaskDAO.java:1)
	at de.hybris.platform.tx.Transaction.execute(Transaction.java:1183)
	at de.hybris.platform.tx.Transaction.execute(Transaction.java:1148)
	at de.hybris.platform.task.impl.TaskDAO.lockWithTxRequired(TaskDAO.java:276)
	at de.hybris.platform.task.impl.TaskDAO.lock(TaskDAO.java:251)
	... 9 more


Why am I getting this error?

[geffchang]

What were you doing that caused this error? Opening backoffice? Running sync or indexing?

[PrashanthPundalik]

Hi,

Did you resolve this issue? facing same error