Using SQL Server 2022 RTM (16.0.1000.6) on a Windows Server 2022 (10.0.20348) with a single replica with the same build.
After creating a contained availability group called CONTAINED_AG, running DBCC CHECKDB([CONTAINED_AG_master]) will usually raise error 8906:
Msg 8906, Level 16, State 1, Line 2
Page (1:10) in database ID 16375 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
The error logs also show this after the DBCC completes:
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 99)' (object ID 99).
CHECKDB found 1 allocation errors and 0 consistency errors in database 'CONTAINED_AG_master'.
DBCC CHECKDB (CONTAINED_AG_master) executed by sa found 1 errors and repaired 0 errors. Elapsed time: 0 hours 0 minutes 0 seconds. Internal database snapshot has split point LSN = 000000df:00000110:0001 and first LSN = 000000df:00000100:0001.
RBPEX::NotifyFileShutdown: Called for database ID: [9], file Id [0]
The DBCC checks occasionally complete without any errors.
Usually these errors are resolved by taking the database out of the availability group and restoring from the last known good backup or by repairing with data loss. This database can't be removed from the availability group so neither of these are an option.
Taking a backup and restoring as a new database results in both allocation and consistency errors.
This happened on a different server with RC1 (16.0.950.9), so I created a new environment with the RTM version to rule out any beta issues.
Can anyone else reproduce this?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 1%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
