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 ONE Support launchpad (Login required).

Search for additional results

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