-
Bug
-
Resolution: Fixed
-
High
-
4.0
-
None
-
SQL Server, Oracle
After attempting to apply multiple user view restrictions to a page the attached error message is thrown.
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.security.ContentPermission#1409029]; SQL []; Violation of UNIQUE KEY constraint 'cp_unique_group'. Cannot insert duplicate key in object 'dbo.CONTENT_PERM'.; nested exception is java.sql.SQLException: Violation of UNIQUE KEY constraint 'cp_unique_group'. Cannot insert duplicate key in object 'dbo.CONTENT_PERM'. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.hibernate.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:619) at org.springframework.orm.hibernate.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:605) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:518) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) ...
The instance was running with SQL Server 2005, started with 4.0.5 and upgraded to 4.2
- relates to
-
CONFSERVER-23193 Upgrade from CONF 3.5.2 to 3.5.13 or higher with Microsoft SQL Server, PostgreSQL, MySQL fails (ContentPermissionConstraintsUpgradeTask)
- Closed
-
CONFSERVER-23058 Constraint violation failure when importing on SQL Server due to content permission nulls
- Closed
-
CONFSERVER-24031 Bad constraints on SQL Server
- Closed
- mentioned in
-
Page Loading...