SAP Knowledge Base Article - Preview

2617932 - Sporadic IPHR s_corruptdiskblkhdrexception errors in multiplex system after CN rollbacks - SAP IQ 16

Symptom

  • Affects only SAP IQ multiplex systems where a large number of rollback operations happen in the CN Coordinator node.

  • There must be at least one MPX writer node updating disk blocks at the same time within a SQL Cursor opened with HOLD option.

  • Sporadic IPHR errors across multiple physical block numbers (PBNs) start to get reported in the iqmsg file.

    I. 02/19 20:15:20. 0000006018 {945} main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:2954 into buffer 2513a8c8
    I. 02/19 20:15:20. 0000006018 {945} expected: btype=14,pbn=318134644,txn=99509992,sp=1,nlb=16,npb=16,iscmp=0,uid=3385997,blk=318134644,mn=1006,upmn=1006,flgs=0x80000008

    I. 02/19 20:15:20. 0000006018 There was an s_buf::Read() error during s_bufman::Find().
    I. 02/19 20:15:20. 0000006018 The following exception is from GetBlockmapEntryInfo
    I. 02/19 20:15:20. 0000006018 Blockmap Member Variables for 4b9a29d758
    I. 02/19 20:15:20. 0000006018 From slib/s_dpidx.cxx:594

    I. 02/19 20:15:20. 0000006018 Exception Thrown from slib/s_blockmap.cxx:7094, Err# 0, tid 936 origtid 936
    I. 02/19 20:15:20. 0000006018 O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
    I. 02/19 20:15:20. 0000006018 [20060]: 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 7094)
  • This can lead to DBCC corruptions reported by sp_iqcheckdb leaving damaged table objects that need to be rebuilt.

  • A variety transaction failures and stacktraces can start to appear, either Non-Fatal or server aborts.


Read more...

Environment

  •  SAP IQ 16.x multiplex systems on all platforms

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

sybase, bufferman, corruption, abort, fail, crash, upgrade, CR813457, CR#813457, 813457, CR813586, CR#813586, 813586, 173680, bug173680,  co-ordinator, stktrc, 'stack trace', checkdb, dbcc, iq16, disc, querry, blockmap, '16.1', worse, IPHR, , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.