3066406 - SQL code: 131 occurred while accessing table

• The following ABAP dump is shown in ST22 transaction code:

DBSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB
DD.MM.YYY HH:MM:SS

SQL error "SQL code: 131" occurred while accessing table "<TABLE>".
Database error text: "SQL message: transaction rolled back by lock wait
timeout: Lock-wait time out exceeded [OWNER=<owner id>, TYPE=RECORD_LOCK,
CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]"

• Corresponding dev wp trace is referring to below entries:

M  *** WARNING => big time diff

C  *** ERROR => EXECUTE C_0037 on connection 0, rc=131
 [dbslsdb.cpp  10058]
C  SQLCODE    : 131
C  SQLERRTEXT : transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=<owner id>, TYPE=RE\
C               CORD_LOCK, CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE]
C  sc_p=7f76d0bded08,no=37,idc_p=7f76d0c53350,con=0,act=1,slen=<slen>,smax=<smax>,#vars=24,stmt=<stmt id>,table=<table name>
C  stmtid = <3/<table name>                                   /536870913/20180718113238>
C  UPDATE ... <statement text>
C  <statement text>
B  ***LOG BY4=> sql error 131    performing UPD on table <table>                          [dbtrtab      4033]

B  ***LOG BY0=> transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=<owner id>, TYPE=RECORD_LOCK, CURRENT_MODE=EXCLUSIVE, REQUESTED_MODE=EXCLUSIVE] [dbtrtab      4033]

• SAP Hana Platform Edition 1.0
• SAP Hana Platform Edition 2.0

hana 1.0, hana 2.0, sql code 131, sqlcode 131, 131, record lock, DBSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB, lock wait timeout , KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB-ENG , SAP HANA DB Engines , Problem