Remove stale drafts

[Daniel]

I recognized that my confluence instance has some hundreds of stale drafts and I tried to remove them following this knowledge base articel:

https://confluence.atlassian.com/confkb/how-to-manually-remove-stale-drafts-from-confluence-database-951392345.html

Unfortunately the DELETE FROM CONTENT raises the following error:

Msg 547, Level 16, State 0, Line 1
The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FKwjyn6091q3l1gl7bh143ma2a". The conflict occurred in database "confluence", table "dbo.CONTENT", column 'PAGEID'.
The statement has been terminated.

Completion time: 2022-01-30T16:17:40.9020249+01:00

 Anybody who came over this issue?

[Brant Schroeder]

@Daniel Per the article "Other references not predicted on this guide may exist on the database that can prevent the DELETE FROM CONTENT query from running. If that is the case, please contact our support team and supply the error returned by that query.".  You should contact support and they will help you update the query so you can remove the drafts. https://support.atlassian.com/contact/

[Daniel]

@Brant Schroeder Thanks for pointing this out. I fact I did try it, but that option isn't available for Starter Licenses anymore.

[Brant Schroeder]

@Daniel Let me see if I can get someone from Atlassian to take a look at this post.

[Shannon S]

Hi @Daniel,

I saw a similar case on another support ticket, so I raised a ticket with Confluence support on your behalf. Our team can help you in the support ticket. You can update here when we solve the issue with the solution.

In the meantime, can you reply to the support ticket with a copy of your Support Zip and let them know your Confluence server and database versions?

Thanks to @Brant Schroeder for tagging this!

Take care,

Shannon | Atlassian Community Support

[Daniel]

Did anybody try to resolve this with an approach like the one described here:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c3add717-60c5-420a-9357-151095ac6b36/sql-error-msg-the-delete-statement-conflicted-with-the-same-table-reference-constraint?forum=sqlservermigration