I am trying to upgrade from Confluence 5.0.3 to 5.8.9 but I face this error:
2015-09-01 10:02:43,127 INFO [localhost-startStop-1] [confluence.upgrade.upgradetask.UserKeyReferenceUpgradeTask] updateUsernameReferences Updating CONTENT_PERM table [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: StatementCallback; SQL [UPDATE CONTENT_PERM SET USERNAME = COALESCE((SELECT um.user_key FROM user_mapping um WHERE CONTENT_PERM.USERNAME = um.lower_username), CONTENT_PERM.USERNAME), CREATOR = COALESCE((SELECT um.user_key FROM user_mapping um WHERE CONTENT_PERM.CREATOR = um.lower_username), CONTENT_PERM.CREATOR), LASTMODIFIER = COALESCE((SELECT um.user_key FROM user_mapping um WHERE CONTENT_PERM.LASTMODIFIER = um.lower_username), CONTENT_PERM.LASTMODIFIER)]; Cannot add or update a child row: a foreign key constraint fails (`confluence`.`content_perm`, CONSTRAINT `FKBD74B31676E33274` FOREIGN KEY (`CPS_ID`) REFERENCES `content_perm_set` (`ID`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`confluence`.`content_perm`, CONSTRAINT `FKBD74B31676E33274` FOREIGN KEY (`CPS_ID`) REFERENCES `content_perm_set` (`ID`))
Hi there,
I found the same symptoms about this issue in the following documentation. You could execute the workaround described in it.
Cheers,
Hi, Thank you for the reply. I know this page and I attempt to follow the steps but from the first line I do not have any duplication. This Query return empty result set. that means no problematic row according to the workaround. SELECT CONTENT_ID, CONT_PERM_TYPE, COUNT(CONTENT_ID) FROM CONTENT_PERM_SET GROUP BY CONTENT_ID, CONT_PERM_TYPE HAVING COUNT(*) > 1;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.