SAP Knowledge Base Article - Preview

2465051 - A secondary multiplex server got crashed with "stcxtlib\st_server.cxx:996" while executing a checkpoint.

Symptom

A secondary multiplex server got crashed with an incomplete stacktrace twice a day while executing a checkpoint.

1. 1st Crash
  Got crashed while executing a checkpoint in the middle of processing ev_begintxn.
  1) iqmsg
    I. 04/27 14:03:00. 0000339793 Chk
    I. 04/27 14:03:00. 0000339793 ChkDone [NumTxnCP: 8]
    I. 04/27 14:03:00. 0000339793 PostChk
    I. 04/27 14:03:00. 0000339793 **************************************************
    I. 04/27 14:03:00. 0000339793 *** SAP IQ Abort:
    I. 04/27 14:03:00. 0000339793 *** From: stcxtlib\st_server.cxx:996
    ..............
    ..............
    I. 04/27 14:03:00. 0000339793 <unknown>
    ............................
    I. 04/27 14:03:00. 0000339793 <unknown>
    I. 04/27 14:03:00. 0000339793 CheckpointEnd(..................
    I. 04/27 14:03:00. 0000339793 DB_Do_Checkpoint(..................
    I. 04/27 14:03:00. 0000339793 DB_Checkpoint(..................
    I. 04/27 14:03:00. 0000339793 dbi_checkpoint(..................
    I. 04/27 14:03:00. 0000339793 DoExecuteBodyLocal(..................
    I. 04/27 14:03:00. 0000339793 DoExecuteBody(..................
    I. 04/27 14:03:00. 0000339793 DoExecuteStmt(..................

  2) srvlog
    I. 04/27 14:00:39. Cache size adjusted to 78292K
    I. 04/27 14:01:30. Starting checkpoint of "SNODE_02" (IQDB.db) at Thu Apr 27 2017 14:01
    I. 04/27 14:01:30. Finished checkpoint of "SNODE_02" (IQDB.db) at Thu Apr 27 2017 14:01
    I. 04/27 14:03:00. Starting checkpoint of "SNODE_02" (IQDB.db) at Thu Apr 27 2017 14:03
    I. 04/27 14:08:23. Connection terminated abnormally
    I. 04/27 14:08:23. Connection terminated abnormally

2. 2nd Crash (I. 04/27 15:14:33. 0000001844)
  Crashed also while executing a checkpoint.

  1) iqmsg
    I. 04/27 15:14:33. 0000001844 Chk
    I. 04/27 15:14:33. 0000001844 slib\s_bmfreelist.cxx:1597 [this=000000003289C4F0,bm=00000007215B4B38] Verify error: free list expecting _bitcnt = 353336 (0x56438), = actual count = 215926 (0x34b76)
    I. 04/27 15:14:33. 0000001844 s_bm::Verify(this=00000007215B4B38):
    I. 04/27 15:14:33. 0000001844 s_bmidentity(this=00000007215B4B50)={ver=1,flg=010c,pad=00000000,cnt=353336,rb=@(2,1)}
    ....................
    I. 04/27 15:14:33. 0000001844 Page 370 (0x172) prev 354 (0x162) next 0 (0x0) unit: LF
    I. 04/27 15:14:33. 0000001844 Page count: 24, Block count: 384, Size: 3 MB
    I. 04/27 15:14:33. 0000001844
    I. 04/27 15:14:33. 0000001844 **************************************************
    I. 04/27 15:14:33. 0000001844 *** SAP IQ Abort:
    I. 04/27 15:14:33. 0000001844 *** From: slib\s_db.cxx:4791
    I. 04/27 15:14:33. 0000001844 *** Rethrown from: oslib\hos_throw.cxx:313
    .................
    .................
    ===== Thread Number 3124 (IQ connID: 0000001844) =====
    I. 04/27 15:14:33. 0000001844 <unknown>
    I. 04/27 15:14:33. 0000001844 <unknown>
    ..................
    I. 04/27 15:14:33. 0000001844 <unknown>
    I. 04/27 15:14:33. 0000001844 CheckpointBegin(..................
    I. 04/27 15:14:33. 0000001844 DB_Do_Checkpoint(..................
    I. 04/27 15:14:33. 0000001844 DB_Checkpoint(..................
    I. 04/27 15:14:33. 0000001844 DbAutoCkpt::force_checkpoint(..................
    I. 04/27 15:14:33. 0000001844 DbAutoCkpt::sample(..................
    I. 04/27 15:14:33. 0000001844 DbAutoCkpt::do_request(..................
    I. 04/27 15:14:33. 0000001844 Worker::spawn(..................
    I. 04/27 15:14:33. 0000001844 RQInternalBaseItem::do_work(..................

  2) srvlog
    I. 04/27 14:44:32. Starting checkpoint of "SNODE_02" (IQDB.db) at Thu Apr 27 2017 14:44
    I. 04/27 14:44:33. Finished checkpoint of "SNODE_02" (IQDB.db) at Thu Apr 27 2017 14:44
    I. 04/27 15:14:33. Starting checkpoint of "SNODE_02" (IQDB.db) at Thu Apr 27 2017 15:14


Read more...

Environment

SAP IQ16 SP11 PL06
Windows 2003

Product

SAP IQ 16.0

Keywords

SAP IQ, IQ, Crash, Checkpoint, CR 807696, CR 807696, CR807696, CheckpointEnd, DB_Do_Checkpoint, CheckpointBegin, stcxtlib\st_server, slib\s_db , 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.