SAP Knowledge Base Article - Preview

2873900 - IQ server encounters deadlock status and caused unresponsive status. See "s_iqstore::AdjustFreeList" in stack dump - SAP IQ

Symptom

  • IQ server ran into hanging status,
  • IQ was not accessible, and had to be re-cycled frequently. 
  • The following messages appeared together: 

   I. 09/05 17:43:49. 0000004587 Disconnect: SA connHandle: 3518 SA connID: 54 IQ connID: 0000004587 User: p_rskmrp
   I. 09/05 17:44:17. 0000000424 Exception Thrown from slib/s_run.cxx:3446, Err# 0, tid 2241 origtid 2241
   I. 09/05 17:44:17. 0000000424 O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
   I. 09/05 17:44:17. 0000000424 [2188]: Statement interrupted by user
   ...

  • This issue looks like a deadlock between the sweeper threads and the ReleaseSavepoint thread (triggered by the commit).


Read more...

Environment

  • SAP IQ16.0 
  • SAP IQ16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

"s_iqstore::AdjustFreeList" ; "AdjustFreeList" ; deadlock ; hang ; unresponsive ; , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.