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