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