SAP Knowledge Base Article - Preview

2490143 - Index corruptions after upgrading to SAP IQ 16

Symptom

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


Read more...

Environment

  • SAP IQ 15.4
  • SAP IQ 16

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

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.