SAP Knowledge Base Article - Preview

2751738 - Table corruption: main Bufman: Incorrect page header read; from slib/s_trycatch - SAP IQ

Symptom

After upgrade, in two examples (it could be in any upgrade situation):

  • from 15.4 to 16.1 SP03 
  • from 16.0 SP11 PL23 to 16.0 SP11 PL24

Errors reported both on HG and FP indexes.  

When a corruption was detected on a table, a drop table and/or rebuild tables recieves the following errors:

drop table DBA.mytable;

Msg 21, Level 14, State: 0
SQL anywhere Error -1009039, 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.

iqmsg file shows:

  ..
  .. [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.
  .. {1055} main Bufman: Incorrect page header read; from slib/s_trycatch.cxx:3033 into buffer 12f1ef460
  .. {1055} expected: btype=4,pbn=10391356908,txn=323088977,sp=0,nlb=16,npb=3,iscmp=1,uid=349115583,blk=10,mn=23,upmn=23,flgs=0x80000018
  .. {1055} head: btype=17,pbn=10391356908,txn=317962162,sp=2,nlb=16,npb=1,iscmp=0,ctr=131,cta=131,ver=1,pb=78,pus=39063
  .. {1055} buffer: 0x0011001000018383000000026b5f85ec0000000012f3b7b200000002014e9897
  .. {1055} Expected Pad1: 191 (0xbf), Pad2: 10 (0x000a)
  .. {1055} Got Pad1: 78 (0x4e), Pad2: 39063 (0x9897)
  ..  ** slib/s_trycatch.cxx:3033
  ..   **  Current command:  COMMAND ACTIVE
  ..   **  Command text: 
  .. drop table "DBA"."mytable"
  .. There was an s_buf::Read() error during s_bufman::Find().
  .. Exception Thrown from slib/s_blockmap.cxx:7192, Err# 0, tid 1048 origtid 1048
  ..    O/S Err#: 0, ErrID: 2100 (s_corruptdiskblkhdrexception); SQLCode: -1009039, SQLState: 'QSA39', Severity: 14
  ..

sp_iqcheckdb (DBCC) reported 'Errors Detected'.

    ..
    ** DBCC Status    Errors Detected  
    ..
    ** DBCC Inconsistent Disk Block Headers     
    ..
    ** Inconsistent Index Count          8        
    ** Non-Completed Index Count     8 
    ...


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

"s_trycatch.cxx:3033" , "s_blockmap.cxx" , "s_buf::Read" , , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.