SAP Knowledge Base Article - Preview

2287030 - IQ server goes down with error "Unable to synchronize due to external event"

Symptom

  • IQ server goes down randomly with messages similar to these in .srvlog

--------------
I. 02/17 14:47:45. Trying to start SharedMemory link ...
I. 02/17 14:47:45. SharedMemory link started successfully
I. 02/17 14:47:45. Trying to start TCPIP link ...
I. 02/17 14:47:45. Starting on port 2640
I. 02/17 14:47:50. TCPIP link started successfully
I. 02/17 14:47:50. Now accepting requests
E. 02/17 14:50:02. Unable to synchronize due to external event - server shutting down
I. 02/17 14:50:02. Database server shutdown due to HUP signal
I. 02/17 14:50:02. Starting checkpoint of "LP1" (LP1.db) at Wed Feb 17 2016 14:50
I. 02/17 14:50:02. Finished checkpoint of "LP1" (LP1.db) at Wed Feb 17 2016 14:50
I. 02/17 14:50:02. TCPIP listener on IP address 0.0.0.0:2640 is exiting
I. 02/17 14:50:03. Database server stopped at Wed Feb 17 2016 14:50
--------------

  • .iqmsg shows that the database shutdown is not abrupt. Shutdown is clean.

--------------
I. 02/17 14:50:00. 0000000076 Collation CESU8BIN, Case Respect, Blank Padding On, Comparisons are Conditioned
I. 02/17 14:50:00. 0000000076 Txn 809785 0 0
I. 02/17 14:50:00. 0000000076 Cmt 809786
I. 02/17 14:50:00. 0000000076 PostCmt 0
I. 02/17 14:50:02. 0000000081 Chk
I. 02/17 14:50:02. 0000000081 ChkDone [NumTxnCP: 0]
I. 02/17 14:50:02. 0000000081 PostChk
I. 02/17 14:50:02. 0000000000 CloseDatabase
--------------

  • There is no connection OR CRON job which is shutting the database down on purpose.
    There are no user events created in IQ database. There is no xp_cmdshell() execution from within IQ.
    DBA observes that any unrelated and simple CRON job run is bringing down IQ database.


Read more...

Environment

  • SAP IQ 16 SP 10+
  • Redhat Linux 7.2

Product

SAP IQ 16.0

Keywords

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.