SAP Knowledge Base Article - Preview

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

Symptom

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)

==========


Read more...

Environment

  •  SAP IQ 16.0 SP11 PL20

Product

SAP IQ 16.0

Keywords

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

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.