Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

Change Tracking auto cleanup error 22123

Just upgraded to 2016 SP2 (13.0.5026.0) and receiving frequent error messages logged from change tracking auto cleanup: Error 22123, severity 16, state 1 Change Tracking autocleanup is blocked on side table of "<***>". If the failure persists, check if the table "<***>" is blocked by any process . Routinely for different tables, not repeatedly from the same table.

I suspect this was added as part of the changes to auto cleanup released in SP2, and is raised when a table is blocked and marked for retry. Can anyone please confirm this?

Additionally, this seems to me like more of an informational status than a user correctable error, doesn't it? I would not think this would be an issue requiring intervention unless it was happening repeatedly and often on the same table.

Finally, according to sys.messages 22123 is NOT set to be event_logged... but it IS logging to the even log each time.

42 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Timothy Batts shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

18 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base