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
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.
SAP Knowledge Base Article - Preview