2705929 - FREELIST ASSERTION REPORT with stack trace on s_bm::ClearBits

Writer node hang in production multiplex after non-fatal stacktrace with freelist assertion. IQ must be killed and restarted.

=======

Excerpt of IQMSG

FREELIST ASSERTION REPORT slib/s_bm.cxx:1594
Internal method: s_bm::ClearBits(hos_recid startBit, hos_recid nbits)
this = 0x2580d37308
startBit = 142258406
nbits = 4
Check values:
endingCount = 12964304
startingCount = 12964305
startingCount - nbits = 12964301
ASSERT(endingCount == startingCount - nbits) = FALSE
s_bm::Dump(this=0x2580d37308): FL Structure Dump
s_bmidentity(this=0x2580d37320)={ver=1,flg=010c,pad=00000000,cnt=12964305,rb=@(2,1)}
bmdmp(this=0x14c99d1c0): L1 Root (uid=0;temp Bufman). bpP=2091904
L1: @(2,1): pda length: 136, 1088B; data length: 272, 1088B, blklen: 262016
L1: 0) Leaf @(18,1): part 0( 0), pos 2 {Boff 0 : 7} [bits 0 : 2091903]
L1: 1) Leaf @(34,1): part 1( 1), pos 4 {Boff 8 : 15} [bits 2091904 : 4183807]
......
......
......
L1: 135) Leaf @(248936833,1): part 135( 135), pos 272 {Boff 1080 : 1087} [bits 282407040 : 284498943]

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_bm.cxx:1610 on thread XXXXXXXX (TID YY)
** Bitmap result bitcount not in legal range.
** this=0x14c99df90,error={num=1,os=0,id=2049,msg=-1009045},bmec=1
.....
.....
** IQ Version: SAP IQ/16.0.110/11355/P/sp11.20
** OS info: IQ built on: RS6000MP/AIX 6.1.0, Executed on: AIX/iqstb/2/7/00F6B3EE4C00
** Command status when error occured: CURSOR ACTIVE
** Parser command text:
select cast(xxxxxxxxxxxxxxxxxxxxxxxxxxxxx)

***************** This is the STACKTRACE ***************

sbm_exception::sbm_exception
s_bm::ClearBits
s_dbmvbio::DeAllocate
s_blockmap::Deallocate
s_blockmap::Deallocate
s_blockmap::DestroyAllMappedPages
hs_csort::~hs_csort
dfo_cOrderBy::~dfo_cOrderBy
dfo_cOrderByParaIn::~dfo_cOrderByParaIn
dfo_cOrderByParaExch::~dfo_cOrderByParaExch
dfo::DestroyLastLeaf
dfo_Root::~dfo_Root
st_cursor::~st_cursor
st_cursorIQtoSA::~st_cursorIQtoSA
df_CloseCursor::~df_CloseCursor
st_iqdml::CloseCursor
UIQDML_CloseCursor
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::CloseCursor
df_OmniRowScan::Complete
dfo_Scan::DoComplete
dfo_Base::Fetch
dfo_Root::DoFetch
dfo_Base::Fetch
dfo_Root::DoFetchRelative
dfo_Root::FetchRelative
DB_Search_fetch
do_move_cursor
move_cursor
dbi_prefetch
db__prefetch
RequestProcedure::call
Context::call
Worker::call_on_stack
TopProcedure::call

******************* End of STACKTRACE ******************
**
** End of stack trace from Non-Fatal IQ Internal Error slib/s_bm.cxx:1610
**
********************************************************

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

==========

•  SAP IQ 16.0 SP11 PL20

MPX Multiplex writer coordinator FREELIST ASSERTION REPORT stack trace s_bm::ClearBits s_dbmvbio::DeAllocate s_blockmap::Deallocate s_blockmap::DestroyAllMappedPages 817013 hang , KBA , BC-SYB-IQ , Sybase IQ , Problem