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
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.