U4-2068 - Empty recyclebin, or deleting from recycle bin with many decendants

Created by Anders Brannmark 08 Apr 2013, 09:53:59 Updated by Sam 15 May 2015, 14:13:06

Is duplicated by: U4-2125

Seams like there is a bug in v6.0.3 that makes the path corrupt when deleteing an item with many decendants.

Have a content tree that looks like this: *Content root ** Catalog *** Product category **** Product ***** Variant

Deletion of the product category results in that the variant gets the wrong path. See attached screenshoot. When the varinat doesnt get -20 in the path empty recyclebin crashes due to constraints as contentservice does this filter:

var query = Query.Builder.Where(x => x.Path.Contains("-20")); var contents = repository.GetByQuery(query).OrderByDescending(x => x.ParentId);

1 Attachments

Comments

Sebastiaan Janssen 08 Apr 2013, 09:59:20

Has this site been upgraded from 4.11.4 or earlier by any chance?


Anders Brannmark 08 Apr 2013, 10:01:50

Its upgraded from a 4.9. Have run fixup path tool. But the nodes above was created after upgrade also.


Anders Brannmark 08 Apr 2013, 10:05:01

Also database was started with a blank 6.0.3 database.


Mads Krohn 12 Apr 2013, 12:36:57

I'm seeing issues here as well. Fresh 6.0.3 install and database. Deleting an item with descendants and trying to empty the recycle bin will cause a 500 Server Error -> "The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "U6", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated.". For now, a workaround is to simply right click the item and delete it. I recorded a quick screen cast to show it -> http://screencast.com/t/wSE5lrDJGWQ


Peter Gregory 19 Apr 2013, 04:46:22

Can confirm I am also getting the following error. This is the error shown in chrome when I try to empty the trash.

Sys.Net.WebServiceFailedException: Sys.Net.WebServiceFailedException: The server method 'EmptyTrashcan' failed with the following error: System.Data.SqlClient.SqlException-- The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "CLIENTNAMEREMOVED", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated. [http://localhost:13893/ScriptResource.axd?d=ELbyFT1WV0dv2AHeEOpC6UfeJkk6to6cYtPcmjCRQRKBtzkER3_fIDnONRAL_nL443uJdjXHauNw3APL9qVRCdxfPT1KUgAqdneL22FLRbeMiX7ZLJRBI2Hp0r2D0TTE9iDXWY29RTeNt4iiBIJsrSuoaSmZedNu8TheNDKI65qZTiqv7ELxChtOIuZrs_tl0&t=6119e399:6965]


Morten Christensen 19 Apr 2013, 08:09:18

Fixed in changeset 84644bda46ba for both Content and Media.


Simon Dingley 03 Apr 2014, 09:40:18

I'm seeing this in 6.1.6 still.


Sam 15 May 2015, 14:13:06

I am seeing this in 7.1.7 as well. https://db.tt/iiuXo0uF


Priority: Normal

Type: Bug

State: Fixed

Assignee: Morten Christensen

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.0.3

Due in version: 6.0.4

Sprint:

Story Points:

Cycle: