3322926 - Deadlock with SQL error 129 occurring after implementing Note 3244609

You have successfully implemented the patches recommended in SAP Note 3244609 and are still observing deadlock with the database error message similar to the excerpt below.

Category               ABAP programming error
Runtime Errors         DBSQL_SQL_DEADLOCK_DETECTED
Except.                CX_SY_OPEN_SQL_DB
Application Component  BC-XXX
----------------------------------------------------------------------------------------------------

Database error number: "SQL code: 129" Database error text: SQL message: transaction rolled back by an internal error: table unique constraint violation on pos=0 for table xxxx


Before this, you can notice errors and cancelations related to transactions using ESH in indexserver traces.

[52xxx]{356xxx}[-1/-1] 2023-04-04 18:18:37.561761 e esh              BuiltinProcedureSearch.cpp(00707) : exception  1: no.2040026  (Basis/Execution/impl/JobExecutorUtil.cpp:666) TID: 52322
    Transaction was canceled
exception throw location:
   0: 0x00007fec33497366 in Execution::JobFinalObjectImpl::checkAndThrowException(bool, bool)+0x272 at Basis/Execution/impl/JobExecutorUtil.cpp:666 (libhdbbasis.so)
   1: 0x00007fec33460a55 in Execution::JobObjectImpl::wait(bool, bool)+0x151 at Basis/Execution/impl/JobExecutorImpl.cpp:1025 (libhdbbasis.so) 

HANA 2.0

rollback, deadlock, SQL error 129, unique constraint violation, kernel, patch, ESH_SEARCH error: exception 9620008: Query execution failed, DBSQL_SQL_INTERNAL_DB_ERROR , KBA , HAN-DB , SAP HANA Database , Problem