SAP Knowledge Base Article - Preview

3159068 - SAP IQ aborts with stack symbols 'inc_MpxConnection::RunSQL' & 'inc_PoolHeartbeat::AckToCoordinator' frequently -- SAP IQ

Symptom

A writer secondary node aborts with stacktrace frequently.

===== Thread Number 140500576364288 =====
pc: 0x7fc8fca9f5a8 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x38
pc: 0x7fc8fca9fe01 ucstkgentrace(int, int)+0x141
pc: 0x7fc8fcaa066f DumpAllThreads(char const*, unsigned int, int)+0x2cf
pc: 0x7fc8fc80a648 hos_ABORT(char const*, unsigned int, char const*, char*, char*, sigcontext*)+0x748
pc: 0x7fc8fd709911 SigHndlr+0x51
pc: 0x7fd235d05680 <unknown>
pc: 0x7fc90714154e <unknown>
pc: 0x7fc90712d087 <unknown>
pc: 0x7fc90712d1e0 <unknown>
pc: 0x7fc8fda75b88 inc_MpxConnection::RunSQL(inc_sql_type, void**, int)+0x1028
pc: 0x7fc8fd9f9331 inc_Heartbeat::RunSQL(inc_sql_type, void**)+0x41
pc: 0x7fc8fd9f9eb3 inc_PoolHeartbeat::AckToCoordinator(unsigned int, unsigned int, unsigned int, unsigned int, unsigned long long)+0x83
pc: 0x7fc8fd73b166 st_globalFlMgr::SendFLAckToCoordinator(unsigned int, unsigned int, int)+0x76
pc: 0x7fc8feea8ce4 st_txnMgr::ResetWriterFreelist(st_database const*, unsigned int, dbServerType)+0x144
pc: 0x7fc8fd9f9f98 inc_PoolHeartbeat::TryToReleaseFreelist()+0x88
pc: 0x7fc8fd9fac08 inc_PoolHeartbeat::Monitor()+0x918
pc: 0x7fc8fc826fd7 hos_daemon::Task(hos_daemon*, int const*)+0x1b7

there is no other helpful information from .iqmsg/.srvlog files.


Read more...

Environment

  • SAP IQ 16.1 SP04.08 Linux_x86-64
  • A writer secondary node

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

inc_PoolHeartbeat::AckToCoordinator, AckToCoordinator, CR826273, 826273, 800722, , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

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