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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.