SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

SAP IQ 16.0 SP11

Product

SAP IQ 16.0

Keywords

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.