U4-7253 - Error Upgrading 7.2.5 to 7.3 (Duplicate key in umbracoNode)

Created by DOOR3 14 Oct 2015, 18:20:39 Updated by Sebastiaan Janssen 14 Oct 2015, 21:38:39

Duplicates: U4-7222

Attempting to upgrade from 7.2.5 to 7.3. Get the error message:

The database failed to upgrade. ERROR: The database configuration failed with the following message: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.umbracoNode' and the index name 'IX_umbracoNode_uniqueID'. The duplicate key value is (ddf63cd9-aa97-4e8f-a1e9-376de7b09d3d). The statement has been terminated.

In umbracoNode table I found 4 images (rows) that have 2 duplicate instances (duplicate rows). The unique keys were the same but the IDs were not.

When attempting to delete the duplicates from the table I receive an error message saying that rows in cmsPropertyData were referring to them.

MSSQL2014 DB backup can be downloaded at https://drive.google.com/a/door3.com/file/d/0B3W-jMEW3g_FRnFObWZySDdpcWc/view?usp=sharing

3 Attachments

Comments

Priority: Normal

Type: Bug

State: Duplicate

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version:

Sprint:

Story Points:

Cycle: