Remove stale drafts

Question

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?

Shannon S · Answer

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

Brant Schroeder · Answer

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

Daniel_296onp · Answer

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