2836079 - IQ performance is degrading, then a stack trace is received. SAP IQ

• The IQ server performance starts degrading as seen in the iqmsg file:

  I. 09/05 04:50:37. 0006331579 ChkDone [NumTxnCP: 144]
  I. 09/05 04:50:37. 0006331579 PostChk
  I. 09/05 04:50:50. 0006331579 Chk
  I. 09/05 04:50:50. 0006331579 ChkDone [NumTxnCP: 141]
  I. 09/05 04:50:50. 0006331579 PostChk
  I. 09/05 04:51:01. 0006331579 Chk
  I. 09/05 04:51:02. 0006331579 ChkDone [NumTxnCP: 148]
  I. 09/05 04:51:02. 0006331579 PostChk
  I. 09/05 06:49:49. 0006341009 ChkDone [NumTxnCP: 248]
  I. 09/05 06:49:49. 0006341009 PostChk
  I. 09/05 06:50:00. 0006341009 Chk
  I. 09/05 06:50:00. 0006341009 ChkDone [NumTxnCP: 247]
  I. 09/05 06:50:01. 0006341009 PostChk
  I. 09/05 06:50:12. 0006341009 Chk
  I. 09/05 06:50:12. 0006341009 ChkDone [NumTxnCP: 253]
  I. 09/05 06:50:12. 0006341009 PostChk
  I. 09/05 07:21:16. 0006341009 ChkDone [NumTxnCP: 364]
  I. 09/05 07:21:16. 0006341009 PostChk
  I. 09/05 07:21:22. 0006341009 Chk
  I. 09/05 07:21:22. 0006341009 ChkDone [NumTxnCP: 358]
  I. 09/05 07:21:23. 0006341009 PostChk
  I. 09/05 07:21:31. 0006341009 Chk
  I. 09/05 07:21:31. 0006341009 ChkDone [NumTxnCP: 363]
  I. 09/05 07:21:31. 0006341009 PostChk

  On this server normal is around 100 Transactions.
  
  
• There are no errors in the iqmsg log nor the srvlog
  
  
• There is an unually high number of messages in the secondary node srvlog containing sp_iqmpxprocesstlvlog, for example:
  

  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,140...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,143...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,143...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,144...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,144...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,193...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,193...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,194...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,194...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,135...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,135...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,288...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,288...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,121...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,121...
  I. 09/05 05:10:32. [,1004228278,sp_iqmpxprocesstlvlog,122...
  I. 09/05 05:10:32. ],1004228278,sp_iqmpxprocesstlvlog,122...

• After some time, there is a stack:
  
  **************************************************
  *** SAP IQ Abort:
  *** From: dblib/db_catalogchain.cxx:1417
  *** PID: 23852
  *** Message: Non-Cursor active
  *** Thread: 854 (TID: 58)
  **************************************************
  ** Error from IQ connection: SA connHandle: 1004231068 SA connID: 232 IQ connID: 0006341009 User: dbo
  ** Time of error: 2019-09-05 12:05:32
  ** IQ Version: SAP IQ/16.0.110/10870/P/sp11.18
  ** OS info: IQ built on: Sun_Sparc/OS 5.10, Executed on: SunOS/dccps3238/5.10/Generic_150400-63/sun4v
  ** Command status when error occurred: COMMAND ACTIVE
  ** Command text:
  Dump all thread stacks at dblib/db_catalogchain.cxx:1417 for PID: 23852

• Stack contained:
  void db_CatalogTxnList::RollBack
  void db_Catalog::RollBack
  void st_txncb::RollbackToSavepoint
  void st_txnMgr::RollbackToSavepoint
  void st_command::DoCmdThroughResourceGate
  unsigned st_iqtxn::RollbackToSavepoint
  UIQTxn_RollbackToSavepoint
  void st_SAIQInterfaceInfo::callFunction
  void st_SAIQInterface::RunIQFunc
  void st_SAIQInterface::Execute
  void saint_iqthresholdtxn::RollbackToSavepoint
  void UndoLog::ul_undo(a_composite_savepoint)
  void DualUndoLog::ul_undo(a_composite_savepoint)
  void DB_Undo(Connection*,a_composite_savepoint)
  a_cursor*DoExecuteBodyLocal
  void DoExecuteStmt
  unsigned SQLAEngineSupport::ExecSQLStringWithEscapes
  unsigned IQUtilityData::FetchDataFromCursor
  void saint_iqthresholdddl::IQUtility
  void dbi_iq_utilities

SAP IQ 16.0 SP11

KBA , BC-SYB-IQ , Sybase IQ , Bug Filed