2138534 - Table lock not released by coordinator when writer node aborts - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2138534 - Table lock not released by coordinator when writer node aborts - SAP IQ

Symptom

  • writer node in a SAP IQ multiplex has terminated abruptly leaving table locks in the Coordinator node
  • transactions in the coordinator requesting update access to the locked table start failing with sqlcode -210 st_sacbexception exceptions
I. 01/22 16:54:41. 0000431196 Connect:  SA connHandle: 104590  SA connID: 3  IQ connID: 0000431196  User: dbo
I. 01/22 16:54:41. 0000431196    sqlcode -210
I. 01/22 16:54:41. 0000431196    string_id 2169
I. 01/22 16:54:41. 0000431196    _sqlstate 67792968
I. 01/22 16:54:41. 0000431196    odbc30state 67108865
I. 01/22 16:54:41. 0000431196    sybcode 8405
I. 01/22 16:54:41. 0000431196    severity 21
I. 01/22 16:54:41. 0000431196    odbc20state 67108865
I. 01/22 16:54:41. 0000431196 Exception Thrown from dblib/db_catalog.cxx:2930, Err# 0, tid 13 origtid 13
I. 01/22 16:54:41. 0000431196    O/S Err#: 0, ErrID: 5122 (st_sacbexception); SQLCode: 0, SQLState: '00000', Severity: 10
  • After a restart of the writer node transactions requiring update access to the locked table start failing with GThrow sqlcode -210 inc_CommandHandlerException errors
I. 01/22 16:54:41. 0000002767 GThrow sqlcode : -210
I. 01/22 16:54:41. 0000002767 Exception Thrown from dblib/db_catalog.cxx:877, Err# 5, tid 11 origtid 11
I. 01/22 16:54:41. 0000002767    O/S Err#: 0, ErrID: 12291 (inc_CommandHandlerException); SQLCode: -210, SQLState: '42W18', Severity: 21
I. 01/22 16:54:41. 0000002767 [2169]: User 'another user' has the row in '<table_name>' locked

 


Read more...

Environment

SAP IQ 16 SP04.x  and above multiplex environments

Product

SAP IQ 16.0

Keywords

SA lock, hang, stuck, abort, Sybase, , KBA , BC-SYB-IQ , Sybase IQ , 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.