Symptom
- Since database migration to SAP ASE a lot of deadlock errors are being reported in SM21 with ST22 dump like this:
Category Installation Errors
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time dd.mm.yyyy hh:MM:ss
Short Text
SQL error "SQL code: 0" occurred while accessing table "ZXXXX".
[...]
DB C1(1205) [40001] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id [/bas/753_REL/src/dbs/syb/dbsyb.c#50649]
DB C1 #0, process id #625) encountered a deadlock situation. Please re-run your comma /bas/753_REL/src/dbs/syb/dbsyb.c#50649]
DB C1nd. [/bas/753_REL/src/dbs/syb/dbsyb.c#50649]
DB C1sql statement is ==> <truncated_SQL_statement_may_appear_here>
[/bas/753_REL/src/dbs/syb/dbsyb.c#50649]
- From related developper trace you'll find the complete SQL statement :
C ERROR: -1 in function StartSelect (execute) [line 30116]
C (1205) [40001] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id
C #0, process id #625) encountered a deadlock situation. Please re-run your comma
C nd.
C
C sql statement is ==> <SQL_statement_here>
C /* R3:<program>:<id> T:Z<table> M:<client> */
C
C transaction aborted by server
B ***LOG BYO=> deadlock aborts transaction [dbsh 1207]
B SQL code: 1205, SQL text: [ASE Error SQL1205:40001][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Your server command (family id #0, process id #625) encountered a deadlock sit
B
- Same Deadlock errors also reported in the ASE error log.
- $SYBASE/$SYBASE_ASE/install/<SID>.log for Unix, %SYBASE%\%SYBASE_ASE%\install\<SID>.log for Windows platforms
- Involved tables reported in the deadlock messages are custom tables (Z tables).
- Statistics of those tables are being updated regularly thru ATM of DBACockpit.
- Involved tables are "volatile" tables, which means contents can vary from empty to very large at run time, so data changing/moving all the time.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
deadlock, custom table, Z table, concurrency threshold, concurrency_opt_threshold, SQL1205 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.