2490143 - Index corruptions after upgrading to SAP IQ 16

• Upgrade from IQ 15.4 to IQ 16.
• After upgrade, DBCC (Data Base Consistency Check) reports no error
• After 1 day of activity the upgraded database could become corrupt with stack trace and FP damaged index and disk corruption errors.
• Some of the FP corrupt indexes can be rebuild
• For some other FP corrupt indexes, sp_iqrebuildindex fails with bufman errors.
• OS disk check finds no error

Excerpt of IQMSG


********************************************************
**
** Non-Fatal IQ Internal Error Detected
at slib/s_bm.cxx:1456 on thread 212 (TID 5)
Bitmap result bitcount not in legal range.
this=fffffffed57e7e68,error={num=1,os=0,id=2049,msg=-1009045},bmec=1
**
***************** This is the STACKTRACE ***************

void StackTraceForThisThread
sbm_exception::sbm_exception #Nvariant 1
void s_bm::SetBits
void s_VersioningBlockmap::Deallocate
void s_bufpartition::Destroy
void s_blockmap::DestroyAllMappedPages
void hs_dp::ConvertMetadataFrom15x
hs_dp::hs_dp #Nvariant 1
s_index*db_IndexDef::OpenSIndexWithLock
s_index*db_IndexDef::OpenSIndex
void dfe_BaseColumn::OpenIndexes
unsigned long long dfe_BaseColumn::GetNullCount
void opt_TableNode::RemoveRedundantDisjPreds
dfp*opt_TableNode::AnalyzeRangesOR
void opt_TableNode::AnalyzeRanges
void opt_TableNode::AnalyzeRanges
void opt_QueryTree::ProcessPredicates
void opt_Select::ProcessPredicates
void opt_Driver::OptimizeQueryExp
dfo_Root*opt_Driver::GenerateTree
.....

Exception Thrown from slib/s_bm.cxx:1456, Err# 1, tid 5 origtid 5
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 1456)

main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2928
expected: btype=14,pbn=77473158,txn=9617456869,sp=1,nlb=16,npb=16,iscmp=0,uid=52062950,blk=77473158,mn=2,upmn=2,flgs=0x80000008
head: btype=14,pbn=77473158,txn=9617456370,sp=335,nlb=16,npb=16,iscmp=0,ctr=131,cta=131,ver=1,pb=134,pus=57202
{212} buffer: 0x000e00100010838300000000049e2586000000023d3ebcf20000014f0186df72
{212} Expected Pad1: 134 (0x86), Pad2: 27366 (0x6ae6)
{212} Got Pad1: 134 (0x86), Pad2: 57202 (0xdf72)
There was an s_buf::Read() error during s_bufman::Find().

Disk corruptions could be found in IQMSG

Exception Thrown from slib/s_blockmap.cxx:5782, Err# 0, tid 7 origtid 7
O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
main Bufman: An error was detected on a database page. You may have a damaged index. For additional information, please check your IQ message file or run sp_iqcheckdb.
-- (slib/s_blockmap.cxx 5782)

• SAP IQ 15.4
• SAP IQ 16

KBA , BC-SYB-IQ , Sybase IQ , Problem