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 ONE Support launchpad (Login required).

Search for additional results

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