2356872 - Steps to restore a secondary node in IQ multiplex after it is excluded | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2356872 - Steps to restore a secondary node in IQ multiplex after it is excluded

Symptom

A secondary node will shutdown itself automatically if it is excluded from the IQ multiplex.
  • Error in stderr:
inc_rpcCmdHandler::CallRemoteRPC:Connect() Failed
  • Error in iqmsg:
I. 08/18 11:21:01. 0000000006 Disposition: SQLSTATE:52012  [ No recovery!! ]
I. 08/18 11:21:01. 0000000006 ***Emergency Shutdown***
I. 08/18 11:21:01. 0000000006 Exception Thrown from db_iqutility.cxx:4038, Err# 46, tid 3 origtid 3
I. 08/18 11:21:01. 0000000006    O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
I. 08/18 11:21:01. 0000000006 [21051]: Secondary server cannot maintain catalog sync.
-- (db_iqutility.cxx 4038)
I. 08/18 11:21:01. 0000000006 sp_mpxprocesstlvlog exception, SQLSTATE=QCB11 [Secondary server cannot maintain catalog sync.
-- (db_iqutility.cxx 4038) ]
  • Error in .srvlog:
...
I. 08/18 11:20:56. Starting on port 2639
I. 08/18 11:21:01.     TCPIP link started successfully
I. 08/18 11:21:01. HTTP listener starting on port 8080
I. 08/18 11:21:01. Now accepting requests
E. 08/18 11:21:01. Login procedure 'sp_startup_procedure' caused SQLSTATE '42501'
E. 08/18 11:21:01. Permission denied: you do not have permission to execute the procedure "sp_startup_procedure"
E. 08/18 11:21:01. Login procedure 'sp_startup_procedure' caused SQLSTATE '42501'
E. 08/18 11:21:01. Permission denied: you do not have permission to execute the procedure "sp_startup_procedure"
E. 08/18 11:21:01. Login procedure 'sp_startup_procedure' caused SQLSTATE '42501'
E. 08/18 11:21:01. Permission denied: you do not have permission to execute the procedure "sp_startup_procedure"
E. 08/18 11:21:01. Login procedure 'sp_startup_procedure' caused SQLSTATE '42501'
E. 08/18 11:21:01. Permission denied: you do not have permission to execute the procedure "sp_startup_procedure"
I. 08/18 11:21:01. Database server shutdown due to HUP signal
I. 08/18 11:21:02. HTTP listener on IP address (::):8080 is exiting
I. 08/18 11:21:02. Starting checkpoint of "cmslpg" (cmslpg.db) at Thu Aug 18 2016 11:21
I. 08/18 11:21:02. TCPIP listener on IP address (::):2639 is exiting
I. 08/18 11:21:02. TCPIP listener on IP address 0.0.0.0:2639 is exiting
I. 08/18 11:21:02. Finished checkpoint of "cmslpg" (cmslpg.db) at Thu Aug 18 2016 11:21
I. 08/18 11:21:02. Database server stopped at Thu Aug 18 2016 11:21
  • Output of sp_iqmpxinfo:
server_id
server_name
connection_info
db_path
role
status
mpx_mode
inc_state
coordinator_failover
current_version
active_versions
private_connection_info
mipc_priv_state
mipc_public_state
1
iq95
host=10.146.64.95:2639,(fe80::217:a4ff:fe77:28%2):2639, (fe80::217:a4ff:fe77:2a%3):2639
/opt/sybase/cmslpg/cmslpg.db
coordinator
included
coordinator
N/A
iq170
0
NULL
NULL
active
active
2
iq170
host=MHEN03BL02:2639
/opt/sybase/cmslpg/cmslpg.db
reader
included
reader
active
iq170
0
NULL
NULL
not responding
active
3
iq83
host=iqpsym03:2639
/opt/sybase/cmslpg/cmslpg.db
reader
excluded
unknown
timed out
iq170
0
NULL
NULL
not responding
not responding

Read more...

Environment

Sybase IQ 15.4

SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.