Symptom
- Multiplex environment
- The command "drop user" cause "Emergency Shutdown"
Excerpt of IQMSG
Shared IQ Store update DDL statement:
drop user "My_IQ_User"
Disposition: SQLSTATE:42W19
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19
..... Lots of similar "dropped" message .....
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 Excerpt of sybipc06.iqmsg.20260205
***Emergency Shutdown***
Exception Thrown from dblib/db_iqutility.cxx:5167, Err# 46, tid 140222450317056 origtid 140222450317056
O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
[21051]: Secondary server cannot maintain catalog sync.
-- (dblib/db_iqutility.cxx 5167)
sp_mpxprocesstlvlog exception, SQLSTATE=QCB11 [Secondary server cannot maintain catalog sync.
-- (dblib/db_iqutility.cxx 5167) ]
Read more...
Environment
SAP IQ 16.1
Product
Keywords
MPX, crash, abort, 42W19, "cannot maintain catalog sync" , 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.
SAP Knowledge Base Article - Preview