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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.