2287638 - IQ secondary server got crashed with "slib/s_bufman" -- SAP IQ16.0 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2287638 - IQ secondary server got crashed with "slib/s_bufman" -- SAP IQ16.0

Symptom

1.   The IQ database was upgraded to SP10 PL08 from SP08 PL 20, even on SP11.10
      An IQ secondary writer server got crashed with "blockmap userlocked during flush" message while replaying tlvlog using ev_begintxn.

  
 I. 02/29 20:45:56. 0000000592 **************************************************
 I. 02/29 20:45:56. 0000000592 ***   SAP IQ Abort:
 I. 02/29 20:45:56. 0000000592 ***      From:  slib/s_bufman.cxx:5593
 I. 02/29 20:45:56. 0000000592 ***      PID: 38255
 I. 02/29 20:45:56. 0000000592 ***      Message: blockmap userlocked during flush
 I. 02/29 20:45:56. 0000000592 ***      Thread: 140281677063936  (TID: 9)
 I. 02/29 20:45:56. 0000000592 **************************************************

2.  According to message log, the secondary server got crashed while processing ev_begintxn as below.


 I. 02/29 20:45:56. 0000000592 Connect:  SA connHandle: 1000000578  SA connID: 32  IQ connID: 0000000592  User: dbo
 I. 02/29 20:45:56. 0000000592 ev_begintxn started
 .....................
 .....................
 I. 02/29 20:45:56. 0000000592 TxnWt 3874023 0 3874113
 I. 02/29 20:45:56. 0000000592 blockmap userlocked during flush; _blockmap @ 0x7f95b44aae98
 I. 02/29 20:45:56. 0000000592 Blockmap Member Variables for 0x7f95b44aae98
 I. 02/29 20:45:56. 0000000592 From dblib/db_table.cxx:3009
 I. 02/29 20:45:56. 0000000592   _nextPartitionForHelperFlush = 0
 .....................
 .....................
 I. 02/29 20:45:56. 0000000592 [s_blockmap_identity]
 I. 02/29 20:45:56. 0000000592 _UniqueId: 729349
 I. 02/29 20:45:56. 0000000592 _RootBlockId: 1171153723
 I. 02/29 20:45:56. 0000000592 _NEntries: 8
 I. 02/29 20:45:56. 0000000592 _LastWriterTxnId: 3874023
 I. 02/29 20:45:56. 0000000592 _LastWriterSavePoint: 414
 I. 02/29 20:45:56. 0000000592 _FanOutAndFlags2: 0x8
 I. 02/29 20:45:56. 0000000592 _Flags: 0xcd
 I. 02/29 20:45:56. 0000000592 _Version: 1
 I. 02/29 20:45:56. 0000000592 _NLinks: 1
 I. 02/29 20:45:56. 0000000592 _EntriesPerLink: 9972
 I. 02/29 20:45:56. 0000000592 _FirstAvailLink: 0
 I. 02/29 20:45:56. 0000000592 _MaxLink: 1
 I. 02/29 20:45:56. 0000000592 _ModNum: 91
 I. 02/29 20:45:56. 0000000592 _RootModNum: 90
 I. 02/29 20:45:56. 0000000592 [end s_blockmap_identity]
 I. 02/29 20:45:56. 0000000592 
 I. 02/29 20:45:56. 0000000592 **************************************************
 I. 02/29 20:45:56. 0000000592 ***   SAP IQ Abort:

3. Abort thread stack
 hos_ABORT(.....................
 s_bufman::PrivateFlush(.....................
 s_bufman::FlushToDisk(.....................
 st_txncb::FlushCoalesce(.....................
 st_txncb::FlushForCommit()+.....................
 st_txnMgr::FlushForCommit()+.....................
 st_command::DoCmdThroughResourceGate()+.....................
 st_iqtxn::FlushForCommit(.....................
 UIQTxn_FlushForCommit+.....................
 st_SAIQInterfaceInfo::callFunction()+.....................
 st_SAIQInterface::RunIQFunc(.....................
 st_SAIQInterface::Execute(.....................
 saint_iqthresholdtxn::FlushForCommit(.....................

4. From searching through SAP Notes

    
 [CR 789421]
 hos_ABORT(.....................
 SigHndlr+0x41(.....................
 _fini+0x173fc216(.....................
 s_bufman::PrivateFlush(.....................
 s_bufman::FlushToDisk(.....................
 st_txncb::FlushCoalesce(.....................
 st_txncb::FlushForCommit()+.....................
 st_txnMgr::FlushForCommit()+.....................
 st_command::DoCmdThroughResourceGate()+.....................
 st_iqtxn::FlushForCommit(.....................
 UIQTxn_FlushForCommit+.....................
 st_SAIQInterfaceInfo::callFunction()+.....................
 st_SAIQInterface::RunIQFunc(.....................
 st_SAIQInterface::Execute(.....................
 saint_iqthresholdtxn::FlushForCommit(.....................


Read more...

Environment

IQ 16.0 SP10.8 & SP11.10  IQ-Multiplex

Product

SAP IQ 16.0

Keywords

SAP IQ, crash, s_bufman, blockmap userlocked during flush, s_bufman::PrivateFlush, slib/s_bufman, PrivateFlush, s_bufman::FlushToDisk, FlushToDisk, CR 796339, CR796339, CR#796339, CR 789421, CR789421, CR#789421, CR810916 , , 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 ONE Support launchpad (Login required).

Search for additional results

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