SAP Knowledge Base Article - Preview

2266026 - Error slib/s_bufman.cxx:5582 blockmap userlocked during flush - SAP IQ

Symptom

IQ sencondary server crashes at s_bufman::PrivateFlush while loading data.

Stacktrace as below:

I. 01/13 03:53:00. 0000002326 **************************************************
I. 01/13 03:53:00. 0000002326 ***   SAP IQ Abort:
I. 01/13 03:53:00. 0000002326 ***      From:  slib/s_bufman.cxx:5582
I. 01/13 03:53:00. 0000002326 ***      PID: 27688
I. 01/13 03:53:00. 0000002326 ***      Message: blockmap userlocked during flush
I. 01/13 03:53:00. 0000002326 ***      Thread: 47059714681152  (TID: 15)
I. 01/13 03:53:00. 0000002326 **************************************************
...
I. 01/13 03:53:00. 0000002326
    ***************** This is the STACKTRACE ***************
I. 01/13 03:53:00. 0000002326
===== Thread Number  47059714681152  (IQ connID: 0000002326) =====
I. 01/13 03:53:00. 0000002326 pc: 0x2accf4d38a42 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
I. 01/13 03:53:00. 0000002326 pc: 0x2accf4d390b1 ucstkgentrace(int, int)+0x121
I. 01/13 03:53:00. 0000002326 pc: 0x2accf4d3a2fe DumpAllThreads(char const*, unsigned int, int)+0x12e
I. 01/13 03:53:00. 0000002326 pc: 0x2accf4abda7e hos_ABORT(char const*, unsigned int, char const*, char*, char*)+0x19e
I. 01/13 03:53:00. 0000002326 pc: 0x2accf4eaeadb s_bufman::PrivateFlush(unsigned long long)+0x8ab
I. 01/13 03:53:00. 0000002326 pc: 0x2accf4eaec4b s_bufman::FlushToDisk(unsigned long long)+0x1b
I. 01/13 03:53:00. 0000002326 pc: 0x2accf6bb1340 st_txncb::FlushCoalesce(st_txncb::coalesce, hos_mutex_lock&)+0x8e0
I. 01/13 03:53:00. 0000002326 pc: 0x2accf6bb8c7d st_txncb::FlushForCommit()+0x29d

 

Alternate forms of the stack are as follows:

##########  ABORT EXAMPLE 1 #####################################

pc: 0xfffffd7fe454196b void s_bufman::PrivateFlush(unsigned long long)+0x5bf(0x0, 0x0)
pc: 0xfffffd7fe4542b39 void s_bufman::FlushToDisk(unsigned long long)+0x21(0xfffffd7fe655c3f0, 0xfffffd7fe655c3b0)
pc: 0xfffffd7fe61dd159 void st_txncb::FlushCoalesce(st_txncb::coalesce,hos_mutex_lock&)+0x105(0xfffffd7feb90b820, 0xfffffd7fe42e85c4)
pc: 0xfffffd7fe61dc939 void st_txncb::FlushForCommit()+0x1c1(0x4cb8d0, 0x4cb878)
pc: 0xfffffd7fe6201717 void st_txnMgr::FlushForCommit()+0x103(0xfffffd7feb90c5e0, 0xfffffd7fe42e85c4)
pc: 0xfffffd7fe4fcb28a void st_command::DoCmdThroughResourceGate()+0x1c2(0xfffffd7fe6bc38d0, 0xcc00000002)
pc: 0xfffffd7fe5023a07 unsigned st_iqtxn::FlushForCommit(UIConnection*)+0x23(0x0, 0xfffffd7feb90dda0)

##########  ABORT EXAMPLE 2 #####################################

pc: 0xfffffd7fe4fcb28a void st_command::DoCmdThroughResourceGate()+0x1c2(0xfffffd7fe6bc37b0, 0x1b00000002)
pc: 0xfffffd7fe5023ac3 unsigned st_iqtxn::PostCommitTxn(UIConnection*)+0x23(0xfffffd7fea96cb10, 0xfffffd7fea96dd90)
pc: 0xfffffd7fe39ff060 UIQTxn_PostCommitTxn+0x18(0xfffffd7fea96cb68, 0xfffffd7fea96dd90)
pc: 0xfffffd7fe502847c void st_SAIQInterfaceInfo::callFunction()+0x1c(0xfffffd7fea96dd80, 0x29adc1f0c8)
pc: 0xfffffd7fe50adb75 void st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x28d(0x17d01, 0xfffffd7ffe206d7d)
pc: 0xfffffd7fe5028a91 void st_SAIQInterface::Execute(int,void*,unsigned(*)(void*,void*),void*,unsigned)+0x259(0xfffffd7f0f0d4060, 0xfffffd7f00000000)
pc: 0xfffffd7fe439cc79 void saint_iqthresholdtxn::PostCommitTxn(IConnection*)+0x51(0x0, 0xfe2026a0)

##########  ABORT EXAMPLE 3 #####################################

pc: 0xfffffd7fe4f6960b s_bm::~s_bm()+0x193(0x0, 0xfffffd7fdb69cd20)
pc: 0xfffffd7fe4f69680 __SLIP.DELETER__H+0x14(0xfffffd7fe6984dd0, 0x1b300000001)
pc: 0xfffffd7fe4663f93 void hs_dpInsert::FinishedInsert()+0x1db(0x1cc2a9eb4000, 0x2a25b7aa38)
pc: 0xfffffd7fe3e328f5 void dfiio_FP::FinishedInsert()+0x41(0xfffffd7f00000001, 0x6)
pc: 0xfffffd7fe3e300af int dfo_IndexInsert::FinalFetchOpus()+0x197(0xfffffd7fdb69d160, 0x6fd7045ee)
pc: 0xfffffd7fe3c640e4 void df_CombinerFinalFetchHelper::DoFinalFetch(dfo*,int)+0x88(0xfffffd7fdb69d6a0, 0xfffffd7fe3e304af)
pc: 0xfffffd7fe3c5acc1 int df_CombinerFinalFetchHelper::ExecWork(int&,unsigned)+0x431(0x0, 0x299a899000)
pc: 0xfffffd7fe433683e void workAllocator::DoWork(unsigned)+0x21a(0x0, 0xfffffd7fe6533630)

####### ABORT Example 4 ########################################

I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe4e0566c void hs_vdo::Update(const hs_vdorecid&,const void*,unsigned long)+0x3b0(0x0, 0xffffffff)
I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe50f79a5 void db_TableDef::FlushMetadata()+0x8d(0xfffffd7fe6987750, 0xfffffd7fe6bb8978)
I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe50e0dc5 void db_CatalogTxnList::FlushMetadata()+0x125(0x0, 0x0)
I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe61e70b7 void st_txncb::ReleaseSavepoint(st_txnsp*)+0x2af(0xfffffd7fea32b5a8, 0xfffffd7fe68f8680)
I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe61e6cd8 void st_txncb::ReleaseSavepoint(unsigned)+0x118(0x297c651df8, 0x297c651e38)
I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe4fcd87e void st_command::DoCmdThroughResourceGate()+0x1c2(0xfffffd7fe6bc6ae0, 0x1200000002)
I. 10/05 00:06:22. 0000340111 pc: 0xfffffd7fe50261d5 unsigned st_iqtxn::ReleaseSavepoint(UIConnection*,unsigned)+0x25(0xfffffd7fff2d3cc0, 0xfffffd7fea32d1a0)

 


Read more...

Environment

  • SAP IQ 15.2
  • SAP IQ 15.4
  • SAP IQ16

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

blockmap userlocked during flush, s_bufman::PrivateFlush, s_bufman::FlushToDisk ,slib/s_bufman.cxx , KBA , iq abort , BC-SYB-IQ , Sybase IQ , Bug Filed

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.