3126129 - Indexes of sysusages were corrupted after shrink database failure - SAP ASE

• Shrink database hanging 
  
  • Tried killing the process (did not work)
  • Killed the process with force option - (did not work)
  • Rebooted ASE
  • Then alter database again showed 'sysusages' index corruption.
• dbcc checktable(sysusages)’ returned two errors for unique clustered index after shrink database failure:
  Msg 2510,  “Key mismatch between index page 225, …at offline 44; and data page 209 (row ID 34), …”
  Msg 7928, “Index csysusages is not consistent; found 24 leaf rows but 35 data rows. Drop and recreate the index.”
  
  
• select * from master.dbo.sysusages where dbid=db_id("dbname")
       --  returns duplicate rows
  dbid   segmap         lstart              size     vstart     location    unreservedpgs                               crdate    vdevno
  ------   ----------- ----------      ---------- -----------      --------        ------------- -------------------------------   -----------     
       4           3  265420800   16384000           0                0          16320000     Nov 13 2021 12:22AM          30
       4           3  265420800   16384000           0                0          16320000     Nov 13 2021 12:22AM          30
• sp_helpdb "dbname" - shows the same duplicates.

SAP Adaptive Server Enterprise (ASE) 16.0

sp_fixindex, CR#825824, CR825824, CR 825824, 825824 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error