Loading...

Details

Type: Bug
Resolution: Fixed
Priority: Highest
Fix Version/s: 5.3
Affects Version/s: 5.2.3
Component/s: Server - Upgrade Manager
Labels:

Bug Fix Policy:
View Atlassian Server bug fix policy

Description

For various reasons CONTENT_PERM table may contain permission settings for the same content, having different usernames. This is usually caused by having the username changed in an external user directory. This causes no problems during normal operation, only upon XML backup restore or for the newly introduced LowerCaseUsernameReferencesUpgradeTask, that seemingly converts all usernames in the CONTENT_PERM table to lowercase.

In such scenarios, this will cause the upgrade task to fail on unique constraint violation.

Steps to reproduce

Synchronize an external user directory with Confluence 5.1.x with uppercase username, make sure to add a restriction on a page
Change the username in the external directory to all lowercase, add the same restriction on the same page again
Upgrade the instance to 5.2.3

Workaround
Identify the duplicate row by matching the lowercase values of the unique constraint on the CONTENT_PERM table and delete the record that has the uppercase username/groupname.

Sample error message in Oracle

2013-08-22 11:35:14,886 INFO [main] [confluence.upgrade.upgradetask.LoginInfoDuplicateEntryRemovalUpgradeTask] doUpgrade No duplicate logininfo rows found. No action necessary.
2013-08-22 11:35:15,360 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LINKS table
2013-08-22 11:35:16,822 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in TRACKBACKLINKS table
2013-08-22 11:35:16,830 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in FOLLOW_CONNECTIONS table
2013-08-22 11:35:16,872 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in LABEL table
2013-08-22 11:35:16,929 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in SPACES table
2013-08-22 11:35:16,953 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in NOTIFICATIONS table
2013-08-22 11:35:17,328 INFO [main] [atlassian.confluence.upgrade.UpgradeTask] doUpgrade Finding rows with mixed case username references in CONTENT_PERM table
2013-08-22 11:35:17,734 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.LowerCaseUsernameReferencesUpgradeTask@5913b1de failed during the SCHEMA_UPGRADE phase due to: PreparedStatementCallback; SQL [update CONTENT_PERM set USERNAME = ?, CREATOR = ?, LASTMODIFIER = ? where ID = ?]; ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
; nested exception is java.sql.SQLException: ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
com.atlassian.confluence.upgrade.UpgradeException: Upgrade task com.atlassian.confluence.upgrade.upgradetask.LowerCaseUsernameReferencesUpgradeTask@5913b1de failed during the SCHEMA_UPGRADE phase due to: PreparedStatementCallback; SQL [update CONTENT_PERM set USERNAME = ?, CREATOR = ?, LASTMODIFIER = ? where ID = ?]; ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
; nested exception is java.sql.SQLException: ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.executeUpgradeStep(AbstractUpgradeManager.java:268)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.runSchemaUpgradeTasks(AbstractUpgradeManager.java:193)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.upgrade(AbstractUpgradeManager.java:143)
at com.atlassian.confluence.upgrade.UpgradeLauncherServletContextListener.contextInitialized(UpgradeLauncherServletContextListener.java:50)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
at org.apache.catalina.core.StandardService.start(StandardService.java:525)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update CONTENT_PERM set USERNAME = ?, CREATOR = ?, LASTMODIFIER = ? where ID = ?]; ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
; nested exception is java.sql.SQLException: ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:866)
at com.atlassian.confluence.upgrade.upgradetask.LowerCaseUsernameReferencesUpgradeTask.updateRows(LowerCaseUsernameReferencesUpgradeTask.java:85)
at com.atlassian.confluence.upgrade.upgradetask.LowerCaseUsernameReferencesUpgradeTask.doUpgrade(LowerCaseUsernameReferencesUpgradeTask.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy20.doUpgrade(Unknown Source)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager$UpgradeStep$3.execute(AbstractUpgradeManager.java:662)
at com.atlassian.confluence.upgrade.AbstractUpgradeManager.executeUpgradeStep(AbstractUpgradeManager.java:244)
... 18 more
Caused by: java.sql.SQLException: ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1008)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9855)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9959)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:213)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(JdbcTemplate.java:881)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
... 35 more
2013-08-22 11:35:17,744 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade:
2013-08-22 11:35:17,759 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: PreparedStatementCallback; SQL [update CONTENT_PERM set USERNAME = ?, CREATOR = ?, LASTMODIFIER = ? where ID = ?]; ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated
; nested exception is java.sql.SQLException: ORA-00001: unique constraint (WIKI32.CP_UNIQUE_USER_GROUPS) violated

Attachments

Issue Links

causes

CONFSERVER-30749 All user specific page restrictions lost when upgrading to Confluence 5.2.4

Closed

mentioned in: Wiki Page Loading...; Wiki Page Loading...; Wiki Page Loading...

Confluence LowerCaseUsernameReferencesUpgradeTask will fail on mixed-case usernames in CONTENT_PERM

Details

Description

Attachments

Issue Links

Activity

People

Dates