SAP Knowledge Base Article - Preview

3271013 - Secondary node loses connection to coordinator - SAP IQ

Symptom

Secondary node loses connection to coordinator so all writers receive "SQL Anywhere Error -1014101: Timed out while trying to get startup acknowledgement from coordinator" error. 

The only way to resolve this is to restart the secondary node. It doesn't re-establish connection automatically though coordinator node is absolutely fine.

The secondary node received message about coordinator offline:

=====

[MpxTrace-INC]-inclib/inc_PoolHeartbeat.cxx:00482 Coordinator is not alive
[MpxTrace-INC]-inclib/inc_PoolHeartbeat.cxx:00747 Connection is already disconnected
[MpxTrace-INC]-inclib/inc_PoolHeartbeat.cxx:00505 Coordinator is offline
[MpxTrace-INC]-inclib/inc_CommandHandler.cxx:00707 Heart beat state is OFFLINE or NOT ALIVE, for server_id:0
[MpxTrace-INC]-inclib/inc_PoolHeartbeat.cxx:00505 Coordinator is offline
[MpxTrace-INC]-inclib/inc_CommandHandler.cxx:00707 Heart beat state is OFFLINE or NOT ALIVE, for server_id:0
[MpxTrace-INC]-inclib/inc_PoolHeartbeat.cxx:00482 Coordinator is not alive
[MpxTrace-INC]-inclib/inc_PoolHeartbeat.cxx:00747 Connection is already disconnected
[MpxTrace-INC]-inclib/inc_CommandHandler.cxx:02634 inc_CommandHandler::InquireRLV Connection attempt to server_id:0 failed

===== 

In the coordinator log:

====

Exception Thrown from dblib/db_catalog.cxx:819, Err# 395, tid 2 origtid 2
O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1014101, SQLState: 'QDD87', Severity: 14
Timed out while trying to get startup acknowledgement from coordinator

======


Read more...

Environment

  • SAP IQ 16.1 SP05 PL02
  • 2-node MPX cluster
  • LINUX 

Keywords

MPX cluster Secondary node loses connection Coordinator is not alive  Heart beat state is OFFLINE or NOT ALIVE inc_CommandHandler::InquireRLV Connection attempt to server_id:0 failed Timed out while trying to get startup acknowledgement from coordinator SQL Anywhere Error -1014101 827382 CR 827382 CR# 827382 , 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 for Me (Login required).

Search for additional results

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