3006048 - IPHR error Non_Fatal s_trycatch.cxx stack at s_buf::DumpOnBufmanError, s_blockmap.cxx at s_blockmap::FindAndMakeDirtiable and s_barray.cxx at s_mergeFINALWriter::LoadPageForMerge - SAP IQ

• Customers must be already running on a IQ version containing the fixes for both these KBAs
• 2840171 - IPHR error followed by a s_trycatch.cxx Non-Fatal stack at s_buf::DumpOnBufmanError and a s_blockmap.cxx at s_ROBlockmapCursor::Find - SAP IQ
• 2709384 - LOAD TABLE or INSERT could cause error BArray page header mismatch Internal Inconsistency - SAP IQ

• On very rare and random occasions  an UPDATE, LOAD or INSERT transaction starts to throw a series of Non-Fatal errors following on from a main Bufman Incorrect Page Header Read (IPHR).
• A subsequent DBCC sp_iqcheckdb consistency check or verify on one or more tables involved in the failing query will also fail with the same IPHR and Non-Fatal stacks. The DBCC does not run successfully.
• One or more columns in the affcted tables will become unusable / corrupted.
• The IPHR errors reported will be strictly in a consistant and limited range of physical block numbers.

The following are examples of the sequence of error messages and stack traces seen 

• Non-Fatal IQ Internal Error Detected at slib/s_trycatch.cxx:3159 ,

stack trace ...

s_buf::DumpOnBufmanError
s_buf::ReadBufAndVerify
s_buf::Read
s_bufpartition::Find
s_blockmap::FindAndMakeDirtiable
s_bArrayCursor::FindForMerge
s_mergeFINALWriter::LoadPageForMerge
s_mergeFINALWriter::DoInsert()

additional messages ...

[hos_InMemMsgLog::BroadcastDumpInMemMsgLog} from slib/s_buf.cxx:3703
[QMap] s_buf::ReadBufAndVerify(0x7fa8edb43a70): Quarantine buffer due to IPHR
There was an s_buf::Read() error during s_bufman::Find().
Warning: s_blockmap is throwing while user locked.

• Informational stack trace from Diagnostic Stacktrace in s_blockmap::ThrowError for user locked blockmap at slib/s_blockmap.cxx:13525

stacktrace ....

s_blockmap::ThrowError
s_blockmap::FindAndMakeDirtiable
s_bArrayCursor::FindForMerge
s_mergeFINALWriter::LoadPageForMerge
s_mergeFINALWriter::DoInsert()
hs_dpInsert::Insert
dfiio_FP::FinalFetchOpus()
dfo_IndexInsert::FinalFetchOpus()
dfo::FinalFetch()

additional messages ...

Exception Thrown from slib/s_blockmap.cxx:7400
O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14

• Non-Fatal IQ Internal Error Detected at slib/s_barray.cxx:11770
  
  stack trace ...

s_mergeFINALWriter::LoadPageForMerge
s_mergeFINALWriter::DoInsert()
hs_dpInsert::Insert
dfiio_FP::FinalFetchOpus()
dfo_IndexInsert::FinalFetchOpus()
dfo::FinalFetch()
df_CombinerFinalFetchHelper::DoFinalFetch

additional messages ...

INFO [hos_InMemMsgLog::BroadcastDumpInMemMsgLog] from slib/s_barray.cxx:11785
Exception Thrown from slib/s_barray.cxx:11790
O/S Err#: 0, ErrID: 2065 (hs_BArrayexception); SQLCode: -1009149, SQLState: 'QSB45', Severity: 14
BArray page header mismatch Internal Inconsistency:
Exception Thrown from slib/s_blockmap.cxx:7400
main Bufman: An error was detected on a database page. You may have a damaged index.
Cleaning pending errors from slib/s_bmCur.cxx:972

• SAP IQ 16.1 SP03 PL09 and higher
• SAP IQ 16.1 SP04 PL04 and higher
  This issue is not expected to be platform dependant, however thus far this has only been reported on Linux 64-bit

sybase, crash, fail, CR823581, CR#823581, abort, bufferman, checkdb, corrupt, upgrade, sporadic, inconcistant, , KBA , BC-SYB-IQ , Sybase IQ , Problem