Symptom
- 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]
Read more...
Environment
- SAP Hana Platform Edition 1.0
- SAP Hana Platform Edition 2.0
Product
Keywords
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.