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.
SAP Knowledge Base Article - Preview