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), Errors reported both on HG and FP indexes.

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

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 for Me (Login required).

Search for additional results

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