SAP Knowledge Base Article - Preview

2968918 - Error 14612, Level 23, State 2: Inconsistent usage anchor - SAP ASE

Symptom

  • Power issues caused corruptions in the master database. 
  • ASE was started with the '-w master' and '-f' switches forcing initialization of the master database, and the master database was then restored from a backup.
  • After restore, the sysusages table shows a row with segmap=-1:

1> select * from sysusages where dbid=1
2> go
dbid segmap lstart size vstart location unreservedpgs crdate vdevno
------ ----------- ---------- ---------- ----------- -------- ------------- ------------------------------- -----------
1 7 0 6656 4 0 3946 May 12 2020 8:47AM 0
1 7 6656 44544 22532 0 44370 May 12 2020 8:47AM 0
1 -1 51200 148736 111620 0 148155 May 12 2020 8:47AM 0

  • After the last row with segmap=-1 was manually deleted from sysusages, DBCC CHECKDB and DBCC CHECKALLOC run clean, but DBCC CHECKCATALOG raises Error 14612:

1> dbcc checkcatalog
2> go
Checking current database: Logical pagesize is 4096 bytes
The following segments have been defined for database 1 (database name master).
virtual device number virtual start addr size (logical pages) segments
--------------------- -------------------- ---------------------- --------------------
0 22532 44544 0, 1, 2
0 4 6656 0, 1, 2
Msg 14612, Level 23, State 2:
Server 'myASE', Line 1:
Inconsistent usage anchor: Dbid '1' Lstart '51200'.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role

  • DBCC ANCHORS still reports a row with lstart 51200:

1> dbcc anchors(master)
2> go

anchor 0x14f0aa158 ( 344): 28 bytes [usage info] dbid 1, segmap 7, lstart 6656, lsize 44544 vdevno 0, vstart 22532 datalen 28 spare 0
anchor 0x14f0aa180 ( 384): 28 bytes [usage info] dbid 1, segmap 4294967295, lstart 51200, lsize 147200 vdevno 0, vstart 114692 datalen 28 spare 0
anchor 0x14f0aa1a8 ( 424): 0 bytes [end of page]


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR821761, CR#821761, 821761, anchor, sysanchors, DBREPAIR, fix_anchor_usg , 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 for Me (Login required).

Search for additional results

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