2645236 - sp_iqmpxglobalcommit sbm_exception at call s_bm::ClearBits - SAP IQ  | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2645236 - sp_iqmpxglobalcommit sbm_exception at call s_bm::ClearBits - SAP IQ 

Symptom


  • Coordinator crash when executing sp_iqmpxglobalcommit.
  • In IQMSG, you will see a FREELIST ASSERTION REPORT, a non-fatal stack trace immediately followed by a fatal abort.

Excerpt of IQMSG

FREELIST ASSERTION REPORT slib/s_bm.cxx:1594
Internal method: s_bm::ClearBits(hos_recid startBit, hos_recid nbits)
this = 0x7fdd1b39daf8
startBit = 373744634
nbits = 16
Check values:
endingCount = 694833638
startingCount = 694833638
startingCount - nbits = 694833622
ASSERT(endingCount == startingCount - nbits) = FALSE
s_bm::Dump(this=0x7fdd1b39daf8): FL Structure Dump
s_bmidentity(this=0x7fdd1b39db10)={ver=1,flg=010c,pad=00000000,cnt=694833638,rb=@(364858561,1)}
bmdmp(this=0x7fdc0897f870): L1 Root (uid=0;main Bufman). bpP=1045440
L1: @(364858561,1): pda length: 1172, 9376B; data length: 2344, 9376B, blklen: 130944
L1: 0) Leaf @(364858577,1): part 0( 0), pos 2 {Boff 0 : 7} [bits 0 : 1045439]
L1: 1) Leaf @(364858593,1): part 1( 1), pos 4 {Boff 8 : 15} [bits 1045440 : 2090879]
L1: 2) Leaf @(364858609,1): part 2( 2), pos 6 {Boff 16 : 23} [bits 2090880 : 3136319]
L1: 3) Leaf @(364858625,1): part 3( 3), pos 8 {Boff 24 : 31} [bits 3136320 : 4181759]
L1: 4) Leaf @(364858641,1): part 4( 4), pos 10 {Boff 32 : 39} [bits 4181760 : 5227199]
L1: 5) Leaf @(364858657,1): part 5( 5), pos 12 {Boff 40 : 47} [bits 5227200 : 6272639]
L1: 6) Leaf @(364858673,1): part 6( 6), pos 14 {Boff 48 : 55} [bits 6272640 : 7318079]
L1: 7) Leaf @(364858689,1): part 7( 7), pos 16 {Boff 56 : 63} [bits 7318080 : 8363519]
L1: 8) Leaf @(364858705,1): part 8( 8), pos 18 {Boff 64 : 71} [bits 8363520 : 9408959]
L1: 9) Leaf @(364858721,1): part 9( 9), pos 20 {Boff 72 : 79} [bits 9408960 : 10454399]
L1: 10) Leaf @(364858737,1): part 10( 10), pos 22 {Boff 80 : 87} [bits 10454400 : 11499839]
...
L1: 70) ALL1, part 70( 70), pos 142 {Boff 560 : 567} [bits 73180800 : 74226239]
L1: 71) ALL1, part 71( 71), pos 144 {Boff 568 : 575} [bits 74226240 : 75271679]
...
L1: 1169) Leaf @(364876929,1): part 1169(1169), pos 2340 {Boff 9352 : 9359} [bits 1222119360 : 1223164799]
L1: 1170) Leaf @(364876945,1): part 1170(1170), pos 2342 {Boff 9360 : 9367} [bits 1223164800 : 1224210239]
L1: 1171) Leaf @(364876961,1): part 1171(1171), pos 2344 {Boff 9368 : 9375} [bits 1224210240 : 1225255679]

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_bm.cxx:1610 on thread 140583013738240 (TID 50)
** Bitmap result bitcount not in legal range.
** this=0x7fdc08980d10,error={num=1,os=0,id=2049,msg=-1009045},bmec=1
**

** Command text:
call "sp_iqmpxglobalcommit"(:?,:?,:?,:?,:?,:?)

sbm_exception::sbm_exception 
s_bm::ClearBits
s_dbmvbio::DeAllocate
s_blockmap::Deallocate
s_bufpartition::Destroy
s_blockmap::DestroyAllMappedPages()
st_txncb::CommitTransaction
st_txnMgr::CommitTransaction
db_CommitTransaction::Execute()


Exception Thrown from slib/s_bm.cxx:1610, Err# 1, tid 50 origtid 50
O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1009045, SQLState: 'QSA45', Severity: 14
Bitmap failed internal checks. You may have a damaged index. Please check your IQ message file for additional information.
-- (slib/s_bm.cxx 1610)


**************************************************
*** SAP IQ Abort:
*** From: stcxtlib/st_SAIQInterfacen.cxx:179
*** PID: 100401
*** Message: Unexpected throw from IQ command
*** Thread: 140583013738240 (TID: 50)
**************************************************

** Parser command text:
call "sp_iqmpxglobalcommit"(:?,:?,:?,:?,:?,:?)


st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholdtxn::CommitTxn
DB_Commit_Chgs(Connection*)
ri_commit(Connection*)
Connection::commit_work()
sp_iqmpxglobalcommit_internal(InternalProcCall&)
call_function(int(*)(InternalProcCall&),InternalProcCall&)
RunInternalProcedure(Connection*,a_context_ref*)
process_ext_int_remote_call(Connection*,a_context_ref*,unsigned,dfm_CallInfo*)
exec_procedure_stmt(Connection*,a_context_ref*,a_statement*,unsigned,unsigned)


Read more...

Environment

SAP IQ 16.0 SP 11 PL 17

Product

SAP IQ 16.0

Keywords

CR815034, CR#815034, 815034, s_dbmvbio::DeAllocate, s_blockmap::Deallocate, s_bufpartition::Destroy, s_blockmap::DestroyAllMappedPages stacktrace, stktrc, stack trace , 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.