SAP Knowledge Base Article - Preview

2906390 - Deadlocks (SQL1205) reported on custom tables since migration to SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

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.