Howdy!
It isn’t uncommon for us to receive autocleanup or manual cleanup issues regarding Change Tracking in CSS. If you have very busy tables that results in a lot of data being written to the side tables, it isn’t uncommon to see error 22122 in the SQL Server error log indicating there was a failure in running cleanup and we will retry later.
2022-04-07 17:30:29.13 spid42s Error: 22122, Severity: 16, State: 1.
2022-04-07 17:30:29.13 spid42s Change Tracking autocleanup failed on side table of « SourceTableName ». If the failure persists, use sp_flush_CT_internal_table_on_demand to clean up expired records