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.
  • 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 

Product

SAP IQ 16.1

Keywords

MPX cluster 827382 CR 827382 CR# 827382 , KBA , BC-SYB-IQ , Sybase IQ , Known Error

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.