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

• 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)

SAP IQ 16.0 SP 11 PL 17

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 , Bug Filed