SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

  • SAP IQ 16.1 SP03 PL09 and higher
  • SAP IQ 16.1 SP04 PL04 and higher

Its not expected to be platform dependant , however thus far this has only been reported on Linux 64-bit

Product

SAP IQ 16.1

Keywords

sybase, crash, fail, CR823581, CR#823581, abort, bufferman, checkdb, corrupt, upgrade, sporadic, inconcistant, , 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.