Symptom
Random secondary node crash with "Secondary server cannot maintain catalog sync" error.
Secondary node .iqmsg file shows information similar to following.
---
I. 02/28 03:04:37. 0000000006 Disposition: SQLSTATE:52010 [ No recovery!! ]
I. 02/28 03:04:37. 0000000006 ***Emergency Shutdown***
I. 02/28 03:04:37. 0000000006 Exception Thrown from dblib/db_iqutility.cxx:4513, Err# 46, tid 6 origtid 6
I. 02/28 03:04:37. 0000000006 O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
I. 02/28 03:04:37. 0000000006 [21051]: Secondary server cannot maintain catalog sync.
-- (dblib/db_iqutility.cxx 4513)
I. 02/28 03:04:37. 0000000006 sp_mpxprocesstlvlog exception, SQLSTATE=QCB11 [Secondary server cannot maintain catalog sync.
-- (dblib/db_iqutility.cxx 4513) ]
Read more...
Environment
SAP IQ 16.x
Product
Keywords
Emergency Shutdown , sp_mpxprocesstlvlog , "Secondary server cannot maintain catalog sync" , tlvlog , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.