SAP Knowledge Base Article - Preview

2669056 - Corruption on LFB index after reorg 'index' - SAP ASE

Symptom

  • Latch Free B-tree (LFB) index gets corrupt
  • When running reorg on that index : reorg rebuild table_name LFB_index_name
  • Errors reported can include 12314, 820, 872 or 11068, with ASE log entries including:

Beginning REORG REBUILD of index 'LFB_index_name' on table 'table_name' in database 'my_db'.

Error: 12314, Severity: 21, State: 2
Bad child page pointer found on page 1234567 of index with id 4 of table 'table_name' in database 'my_db'. Expected child page pointer to be 0 but found 456789.
Check if the index is consistant using DBCC.

Msg 820, Level 21, State 2:
Attempt to dirty non-log buffer BUF=0x0x0000000303626000, (.....) cid=0 ('default data cache'), Pinned xdes=0x(nil), spid=0 which is in I/O.

Msg 872, Level 20, State 1:
Process 4321 is trying to get a exclusive latch on buffer 0x0x303626000 (dbid: 4, pageno: 1882928) while already holding a exclusive latch on the buffer.
Error while undoing log row in database 'repro'.  Rid pageid = 10563434; row num = 1.

Msg 11068, Level 20, State 1:
Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.
ASE is terminating this process.

  • Database may fail to recover after seeing above error(s), reporting 3478 timestamp :

Error: 3478, Severity: 21, State: 1
During undo the page timestamp value is less than new timestamp from log. Page #=1882928, object id = 407537725, page timestamp=0002 33da7127.
Log new timestamp=0002 33da7167. Log record marker = (10563434, 1).
Error while undoing log row in database 'my_db'.  Rid pageid = 10563434; row num = 1.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 or higher
    • Using LFB index feature
    • And having cache configured with large IO pool

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.