U4-2165 - Can't Empty Recycle Bin - Version 6.0.4

Created by Mark Mars 29 Apr 2013, 08:55:39 Updated by wtct 20 Sep 2016, 11:23:15

We have over 3,000 items in the recycle bin that cannot be deleted. Most of these items are tea commerce nodes.

When trying to empty the recycle bin the task never completes. Below is what we see in the log file after we have cancelled the empty operation:

2013-04-29 09:38:59,608 [14] INFO umbraco.BusinessLogic.Log - [Thread 12] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (ExternalIndexer)Index is being optimized 2013-04-29 09:38:59,685 [14] INFO umbraco.BusinessLogic.Log - [Thread 26] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (InternalIndexer)Index is being optimized 2013-04-29 09:38:59,685 [14] INFO umbraco.BusinessLogic.Log - [Thread 16] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (InternalMemberIndexer)Index is being optimized 2013-04-29 09:39:00,466 [14] INFO umbraco.BusinessLogic.Log - [Thread 12] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (InternalIndexer)Index is being optimized 2013-04-29 09:39:29,451 [14] INFO umbraco.BusinessLogic.Log - [Thread 28] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (ExternalIndexer)Index is being optimized 2013-04-29 09:39:29,451 [14] INFO umbraco.BusinessLogic.Log - [Thread 16] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (InternalIndexer)Index is being optimized

************** Many more lines logged the same as above - Remove for brevity ******************

2013-04-29 09:39:30,091 [14] INFO Umbraco.Core.Persistence.UmbracoDatabase - [Thread 20] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)

We attempt to run this script to manually empty the recycle bin:

-- Delete all 'related' nodes and table contents... DELETE FROM cmsPreviewXml WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM cmsContentVersion WHERE contentId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM cmsDocument WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM cmsContentXML WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM cmsContent WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM cmsPropertyData WHERE contentNodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM umbracoDomains WHERE domainRootStructureID IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM umbracoUser2NodePermission WHERE nodeId IN (SELECT id FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) DELETE FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20

When trying to execute the last delete statement (DELETE FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20) we get the following:

Msg 547, Level 16, State 0, Line 3 The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "db-name", table "dbo.umbracoNode", column 'parentID'.

1 Attachments

Download Take Out The Trash.sql

Comments

Sebastiaan Janssen 29 Apr 2013, 15:24:59

Try to change the last one to :

DELETE FROM umbracoNode WHERE id IN (SELECT TOP 100 PERCENT id FROM umbracoNode AS umbracoNode_1 WHERE path LIKE '%-20%' ORDER BY level DESC)

This is very similar to what the updated code should have done for you. If this works then I am not sure your upgrade succeeded (but I could be wrong).


Mark Mars 29 Apr 2013, 15:38:06

Hi Sebastiaan,

When trying to execute that query we get the same error:

Msg 547, Level 16, State 0, Line 1 The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "table-name", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated.

Thanks, Mark


Sebastiaan Janssen 29 Apr 2013, 15:56:38

Okay, last resort, try this one (and PLEASE make backups):

ALTER TABLE [dbo].[umbracoNode] DROP CONSTRAINT [FK_umbracoNode_umbracoNode] GO

DELETE FROM umbracoNode WHERE path LIKE '%-20%' AND id != -20

GO ALTER TABLE [dbo].[umbracoNode] WITH CHECK ADD CONSTRAINT [FK_umbracoNode_umbracoNode] FOREIGN KEY([parentID]) REFERENCES [dbo].[umbracoNode] ([id]) GO

ALTER TABLE [dbo].[umbracoNode] CHECK CONSTRAINT [FK_umbracoNode_umbracoNode] GO

Somehow something must have gotten mixed up. This will temporarily remove the foreign key, then delete and then re-enable the foreign key constraint.


Mark Mars 29 Apr 2013, 16:03:16

Thanks. Seems that 'FK_umbracoNode_umbracoNode' is not a constraint.

Msg 3728, Level 16, State 1, Line 1 'FK_umbracoNode_umbracoNode' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Msg 547, Level 16, State 0, Line 2 The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "classic-time", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated.


Sebastiaan Janssen 29 Apr 2013, 16:10:38

How many foreign key constraints (and which ones) do you have on umbracoNode please?


Mark Mars 29 Apr 2013, 16:23:35

I ran this:

SELECT f.name AS foreign_key_name ,OBJECT_NAME(f.parent_object_id) AS table_name ,COL_NAME(fc.parent_object_id, fc.parent_column_id) AS constraint_column_name ,OBJECT_NAME (f.referenced_object_id) AS referenced_object ,COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS referenced_column_name ,is_disabled ,delete_referential_action_desc ,update_referential_action_desc FROM sys.foreign_keys AS f INNER JOIN sys.foreign_key_columns AS fc ON f.object_id = fc.constraint_object_id WHERE f.parent_object_id = OBJECT_ID('dbo.umbracoNode');

which returned:

foreign_key_name table_name constraint_column_name referenced_object referenced_column_name is_disabled delete_referential_action_desc update_referential_action_desc FK_umbracoNode_umbracoNode umbracoNode parentID umbracoNode id 0 NO_ACTION NO_ACTION FK_umbracoNode_umbracoNode_id umbracoNode parentID umbracoNode id 0 NO_ACTION NO_ACTION


Sebastiaan Janssen 29 Apr 2013, 16:30:12

Right, I would drop both of them and run the delete query. Finally add the correct constraint, which would be this guy:

ALTER TABLE [dbo].[umbracoNode] WITH CHECK ADD CONSTRAINT [umbracoNode_FK_umbracoNode_umbracoNode_id] FOREIGN KEY([parentID]) REFERENCES [dbo].[umbracoNode] ([id]) GO

ALTER TABLE [dbo].[umbracoNode] CHECK CONSTRAINT [umbracoNode_FK_umbracoNode_umbracoNode_id] GO


Mark Mars 30 Apr 2013, 07:42:39

Well, this managed to empty the recycle bin but I am unable to add the constraint back in now with the following error:

Msg 547, Level 16, State 0, Line 1 The ALTER TABLE statement conflicted with the FOREIGN KEY SAME TABLE constraint "umbracoNode_FK_umbracoNode_umbracoNode_id". The conflict occurred in database "table-name", table "dbo.umbracoNode", column 'id'. Msg 4917, Level 16, State 0, Line 2 Constraint 'umbracoNode_FK_umbracoNode_umbracoNode_id' does not exist. Msg 4916, Level 16, State 0, Line 2 Could not enable or disable the constraint. See previous errors.

I did not change any constraints myself so how could this have happened in any case? Should I just try adding the 2 constraints I already had or was this definitely wrong?

Thanks.


Sebastiaan Janssen 30 Apr 2013, 07:45:38

@Mark Hmm, I'm using sql2012, syntax might be slightly different if you're on 2010? Try adding back just the one called umbracoNode_FK_umbracoNode_umbracoNode_id the other one was not correct.


Mark Mars 30 Apr 2013, 07:55:29

I too am on 2012.

I ran this:

ALTER TABLE [dbo].[umbracoNode] WITH CHECK ADD CONSTRAINT [umbracoNode_FK_umbracoNode_umbracoNode_id] FOREIGN KEY([parentID])REFERENCES [dbo].[umbracoNode] ([id]) GO

ALTER TABLE [dbo].[umbracoNode] CHECK CONSTRAINT [umbracoNode_FK_umbracoNode_umbracoNode_id] GO

and got this:

Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'umbracoNode_FK_umbracoNode_umbracoNode_id'.

What did I do wrong? :-) -- I'm not a big SQL person...


Mark Mars 01 May 2013, 08:01:47

Any thoughts Sebastiaan? Many Thanks.


Robert Bullock 02 May 2013, 15:08:41

I am experiencing the same exact issue with similar log entries. Any solution?


Robert Bullock 02 May 2013, 15:15:43

Oh, same issue applies to Media Recycle Bin... can't empty it. UI just hangs there doing nothing.


Sebastiaan Janssen 06 May 2013, 11:27:17

@Mark and @Robert Is it possible for you guys to send me your databases? You can attach it to this issue and set the "Visible for group" dropdown to HQ so it's shared privately.


phil wigglesworth 07 May 2013, 22:24:09

I have a similar issue in 6.02, although I don't have the logs. If you delete each item from the recycle bin one by one then they can be deleted that way, otherwise "empty recycle bin" just hangs.


Mark Mars 08 May 2013, 03:33:38

Hi Phil. Yes, that's the same issue as we see and deleting 4,000 items 1 by 1 is not fun! I've sent Sebastian my DB yesterday so we'll see what he can dig up!


Sebastiaan Janssen 08 May 2013, 08:39:38

@Phil that issue was fixed in 6.0.4, you should really upgrade to 6.0.5 by this point if only to mitigate the security issue discovered last week.


Sebastiaan Janssen 08 May 2013, 08:40:02

@Mark: Is this before or after deleting the stuff in the recycle bin?


Mark Mars 08 May 2013, 08:43:51

Hi Sebastiaan. This is with items left in the recycle bin. I am unable to delete them...

Phil's issue has the same characteristics as mine and this was not fixed in 6.0.4.

Thanks.


phil wigglesworth 08 May 2013, 08:47:00

Sorry - I should have been clearer. I had a similar issue in 6.0.2 as described. As soon as I was informed of the security issue of course I upgraded all live systems to 6.0.5, having done a trial upgrade of each on my staging servers. I did not repeat the test on 6.0.5 as I did not actually need to empty my bin.

I just tried it on a 6.0.5 install which went live yesterday, with the security fix, and it's still broken.

The install/ upgrade thing definitely ran. It still hangs as stated. If you cancel the operation the JS throws an unknown object error in an alert box.


Sebastiaan Janssen 08 May 2013, 08:50:37

@Phil would it be possible to attach your site + database to this issue or send a link as to where to download those two so I can have a look? When attaching or replying you can change the visibility to "HQ" so that it's not public information.


phil wigglesworth 08 May 2013, 08:55:01

Give me a minute. I'll use a test (not yet live) site. I assume any membership information is either encrypted already or you'll treat that as confidential. Just need to back one up 1st(I have a pre-upgrade 6.0.2 backup, but we're trying to fix it on 6.0.5, so I need the current backup).


Sebastiaan Janssen 08 May 2013, 09:02:41

@phil Of course, all information is to be kept confidential. :) @Mark Looking at your database soon, thanks.


phil wigglesworth 08 May 2013, 09:19:13

Ok, one small backup uploaded, should be visible to "HQ" only. Please delete/ remove it when you're done, as it does contain membership data I assume.


Sebastiaan Janssen 08 May 2013, 10:19:26

@phil Don't see it? :)


phil wigglesworth 08 May 2013, 10:21:11

Hmm, it's there below where I'm typing - says "visible to HQ"? Otherwise do you have an email address and I can mail it... (maybe it's there now - perhaps I have to post as well as add the attatchment?)


Sebastiaan Janssen 08 May 2013, 10:29:34

@phil Got it now, thanks! :)


Sebastiaan Janssen 08 May 2013, 15:27:54

@Mark this is just the schema, I really needed the data as well. Can you zip it up and email me? sebastiaan@umbraco.com - if it's over 10 megabytes then gmail will reject it so then a wetransfer or dropbox link would be appreciated.


Sebastiaan Janssen 08 May 2013, 15:36:30

@phil I just restored your database and updated my connection string in a 6.0.5 install to point to this database. I emptied the recycle bin without doing anything else so I can't reproduce the issue?


Sebastiaan Janssen 08 May 2013, 15:38:01

@phil Using Chrome by the way. In order to reproduce I'd probably also need the site in which it's not working. Same as I just asked Mark, either attach or send me a link to the email address above.


Mark Mars 08 May 2013, 15:46:24

Hi Sebastiaan,

Database sent.

Thanks, Mark


phil wigglesworth 08 May 2013, 15:47:24

Yes, also on Chrome here.. which made me think I should look at the console. I'd assumed it was a badly handled SQL error, but here's what we have in my console, when I try to empty the bin on that same databasae in the live install (I used that one as it's small):

Failed to load resource: the server responded with a status of 500 (Internal Server Error) http://www.health-analytics.co.uk/umbraco/webservices/trashcan.asmx/EmptyTrashcan

In fact there are multiple "getTrashStatus" Ajax calls running along there, not sure what that's about. So the "EmptyTrashcan" web service is crashing in ASP - do you log that stuff anywhere?

I can probably reverse engineer the db and write T-SQL to get rid of the stuff, but that's not really the point of course.


Sayron 20 May 2013, 14:10:36

Was this issue ever resolved? Having the same problem on a 4.8.11 website.


Mark Mars 26 May 2013, 07:47:19

Hi Sebastian, Any update on this. We've gone live with our site now but I am conscious that we've a database filling up with deleted nodes which may cause us performance issues down the line. Thanks.


phil wigglesworth 26 May 2013, 12:21:42

I installed a couple more sites with the latest Umbraco download and they both have the same server error on empty of recycle bin, so it's still out there. I'm using stock standard SQL server 2012.


Jon Dunfee 22 Jun 2013, 19:43:48

I ran into this issue with v6.1.1. I used the manual script above to delete the baggage, I went into the admin and the trash bin doesn't display any nodes. I still ran the empty bin in the context (which displayed an orphan count of the original nodes still in umbracoNode table) and it cleared it right up almost instantly. This is still an issue.

Edit: I was mistaken, I did not clear it up. I had to perform the following:

ALTER TABLE umbracoNode NOCHECK CONSTRAINT FK_umbracoNode_umbracoNode_id delete umbracoNode where id in (select id from umbracoNode where path like '%-20%' and id!=-20) ALTER TABLE umbracoNode CHECK CONSTRAINT FK_umbracoNode_umbracoNode_id


Jon Dunfee 15 Jul 2013, 17:29:31

Just letting folks know it is still an issue with version 6.1.2.


Mark Mars 15 Jul 2013, 17:31:50

Thanks Jon.

Sebastiaan - Did you get anywhere withe the database I sent over?

Thanks, Mark


Brian Powell 09 Sep 2013, 14:46:52

This issue still looks to be there in Umbraco 6.1.4.


Mark Mars 09 Sep 2013, 17:10:02

Every day my customers recycle bin gets bigger and bigger. I do fear the consequences long term not deleting these nodes. Sebastiaan - Is there likely to be a fix for this?


Jon Dunfee 10 Sep 2013, 02:45:29

I've attached my sql file whenever I need to empty the trash.


Eric Schrepel 03 Sep 2014, 17:47:16

Also still an issue in 6.1.6, have 968 items in Recycle Bin, hangs when trying to empty.


Ken McCormack 10 Jan 2015, 01:59:59

In 6.1.6 I'm seeing a SQL Exception due to cost, so the Recycle bin isn't shown

2015-01-10 11:48:47,879 [140] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 65] An unhandled exception occurred System.Data.SqlClient.SqlException (0x80131904): The query has been canceled because the estimated cost of this query (42924) exceeds the configured threshold of 900. Contact the system administrator. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at Umbraco.Core.Persistence.Database.d__1c1.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Umbraco.Core.Persistence.Database.Fetch[T1,T2,TRet](Func3 cb, Sql sql) at Umbraco.Core.Persistence.Repositories.EntityRepository.GetByQuery(IQuery1 query, Guid objectTypeId) at Umbraco.Core.Services.EntityService.GetChildren(Int32 parentId, UmbracoObjectTypes umbracoObjectType) at umbraco.cms.presentation.Trees.BaseMediaTree.Render(XmlTree& tree) at umbraco.presentation.webservices.TreeDataService.LoadTree(TreeRequestParams treeParams) at umbraco.presentation.webservices.TreeDataService.GetXmlTree() at umbraco.presentation.webservices.TreeDataService.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ClientConnectionId:cb97498f-0d3b-45d7-b290-953eca5bc039


svanleusden 02 Jun 2015, 09:25:34

Hi @sebastiaan, any updates about this issue? Running UMB v6.1.6. UI keeps hanging, by deleting 1 node. Total nodes ca. 200. Thanks in advance.


Brian Powell 02 Jun 2015, 11:55:13

The best suggestion I can offer is to use the SQL scripts and manually delete the records from the database. This helps get things to a valid state from which the Recycle Bin will generally work OK.

If you have upgraded from old versions, I found that the upgraded database schema didn't always align with the new database schema. For me, I was able to solve a lot of issues by creating a new site database then migrating my old data into it. My database them had all of the correct field types/name and foreign keys so that deletions would work consistently.


wtct 20 Sep 2016, 11:23:03

I have similar problem. I can't empty recycle bin but I can remove each node in recycle by node's context menu.

When I try to empty recycle bin then in Trace Log:

2016-09-20 13:08:58,898 [7] ERROR Umbraco.Core.Persistence.Repositories.RecycleBinRepository - [Thread 49] An error occurred while emptying the Recycle Bin: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode". The conflict occurred in database "kpi_KomputerSwiat", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated. System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode". The conflict occurred in database "kpi_KomputerSwiat", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClass1.b__0() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy cmdRetryPolicy, RetryPolicy conRetryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command, RetryPolicy retryPolicy) at Umbraco.Core.Persistence.PetaPocoCommandExtensions.ExecuteNonQueryWithRetry(IDbCommand command) at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args) at Umbraco.Core.Persistence.Repositories.RecycleBinRepository.EmptyRecycleBin(Guid nodeObjectType) ClientConnectionId:5fff4eb2-adbd-46a6-8d75-a940d08b63b9

Probably Umbraco is traying to delete folder first instead containing nodes.

My version is 6.2.6


Priority: Normal

Type: Bug

State: Submitted

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.0.4, 6.1.6, 6.2.6

Due in version:

Sprint:

Story Points:

Cycle: