[CONFSERVER-32014] UserIdMigrationUpgradeTask should delete from UserApplicationLink

Type: Bug
Resolution: Unresolved
Priority: Medium
Fix Version/s: None
Affects Version/s: 5.4, 5.3.4, 5.4.4, 5.6.3
Component/s: Core - Workbox
Labels:
- affects-server
- sc
- upgrade
- workbox

Support reference count:
24
Symptom Severity:
Severity 2 - Major
UIS:
2
Bug Fix Policy:
View Atlassian Server bug fix policy

Impact

After an upgrade to Confluence 5.3.x or higher, the Workbox notification tray on the upper right of Confluence shows a stacktrace (foreign key constraint violation) when clicked.

Technical notes

AO does not support cascade deletes. Currently UserIdMigrationUpgradeTask tries to delete all user specific data for users that do not exist in the system, but only deletes rows from the user table. It should also delete the rows from the user_app_link table for users which are not in the user_mapping table, before deleting from the USER table.

This bug is causing:

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`confluence5`.`ao_9412a1_user_app_link`, CONSTRAINT `fk_ao_9412a1_user_app_link_user_id` FOREIGN KEY (`USER_ID`) REFERENCES `ao_9412a1_aouser` (`ID`))

(see line 53 in UserIdMigrationUpgradeTask)

Workaround

Purge the invalid rows manually from the 'AO_9412A1_USER_APP_LINK' table. Example queries are provided below for MySQL and Postgres; you may need to modify the queries slightly to suit your own database management system (change table casing, surround them in quotation marks, etc).

Please back up your database and perform/verify these operations in a test environment before applying to production

Postgres

Ensure Confluence is shut down

Run the following SELECT statement. It should return with a non-empty set to be deleted.

SELECT * FROM "AO_9412A1_USER_APP_LINK" WHERE "USER_ID" not in (select "ID" from "AO_9412A1_AOUSER" aou, user_mapping um where lower(aou."USERNAME") = um.lower_username);

OR

SELECT * FROM "AO_9412A1_USER_APP_LINK" WHERE "USER_ID" not in (select "ID" from "AO_9412A1_AOUSER" aou, user_mapping um where lower(aou."USERNAME") = um.user_key);

Run the following DELETE statement to remove the above rows:

DELETE FROM "AO_9412A1_USER_APP_LINK" WHERE "USER_ID" not in (select "ID" from "AO_9412A1_AOUSER" aou, user_mapping um where lower(aou."USERNAME") = um.lower_username);

OR

DELETE FROM "AO_9412A1_USER_APP_LINK" WHERE "USER_ID" not in (select "ID" from "AO_9412A1_AOUSER" aou, user_mapping um where lower(aou."USERNAME") = um.user_key);

Run the SELECT from Step 2 again to confirm. Now an empty set should be returned.
Start Confluence and see if issue has been resolved

MySQL

Ensure Confluence is shut down

Run the following SELECT statement. It should return with a non-empty set to be deleted.

SELECT * from AO_9412A1_USER_APP_LINK where USER_ID not in (select ID from AO_9412A1_AOUSER aou, user_mapping um where lower(aou.USERNAME) = um.lower_username);

OR

SELECT * from AO_9412A1_USER_APP_LINK where USER_ID not in (select ID from AO_9412A1_AOUSER aou, user_mapping um where lower(aou.USERNAME) = um.user_key);

Run the following DELETE statement to remove the above rows:

DELETE from AO_9412A1_USER_APP_LINK where USER_ID not in (select ID from AO_9412A1_AOUSER aou, user_mapping um where lower(aou.USERNAME) = um.lower_username);

OR

DELETE from AO_9412A1_USER_APP_LINK where USER_ID not in (select ID from AO_9412A1_AOUSER aou, user_mapping um where lower(aou.USERNAME) = um.user_key);

Run the SELECT from Step 2 again to confirm. Now an empty set should be returned.
Start Confluence and see if issue has been resolved

mentioned in: Page No Confluence page found with the given URL.; Page No Confluence page found with the given URL.; Page No Confluence page found with the given URL.; Page No Confluence page found with the given URL.; Page No Confluence page found with the given URL.; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(6 mentioned in)

Tomas Kenis added a comment - 17/Oct/2014 4:09 PM

I got the same problems.
I followed the above steps but no result. I'm on version 5.6.3

StackTrace

com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.mywork.confluence-host-plugin]
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:105)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:92)
at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:42)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:

name:MySQL
version:5.5.35-0ubuntu0.13.10.2
minor version:5
major version:5
Driver:
name:MySQL Connector Java
version:mysql-connector-java-5.1.29 ( Revision: alexander.soklakov@oracle.com-20140120140810-s44574olh90i6i4l )

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a83eae244fdc3870144fdce97bd0030' for key 'U_AO_9412A1_AOUSER_USERNAME'
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:91)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:85)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25)
at com.atlassian.sal.spring.component.SpringHostContextAccessor$1.doInTransaction(SpringHostContextAccessor.java:88)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
at com.atlassian.sal.spring.component.SpringHostContextAccessor.doInTransaction(SpringHostContextAccessor.java:82)
at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129)
at com.sun.proxy.$Proxy238.doInTransaction(Unknown Source)
at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154)
at com.sun.proxy.$Proxy238.doInTransaction(Unknown Source)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21)
at sun.reflect.GeneratedMethodAccessor189.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.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58)
at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56)
at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy1235.execute(Unknown Source)
at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:84)
at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:40)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:99)
... 7 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a83eae244fdc3870144fdce97bd0030' for key 'U_AO_9412A1_AOUSER_USERNAME'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842)
at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2348)
at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2418)
at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2381)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99)
at net.java.ao.EntityManager.migrate(EntityManager.java:128)
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:50)
... 47 more

Tomas Kenis added a comment - 17/Oct/2014 4:09 PM I got the same problems. I followed the above steps but no result. I'm on version 5.6.3 StackTrace com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.atlassian.mywork.confluence-host-plugin] at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:105) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:92) at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:42) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: name:MySQL version:5.5.35-0ubuntu0.13.10.2 minor version:5 major version:5 Driver: name:MySQL Connector Java version:mysql-connector-java-5.1.29 ( Revision: alexander.soklakov@oracle.com-20140120140810-s44574olh90i6i4l ) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a83eae244fdc3870144fdce97bd0030' for key 'U_AO_9412A1_AOUSER_USERNAME' at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:91) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory$1.doInTransaction(AbstractActiveObjectsFactory.java:85) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25) at com.atlassian.sal.spring.component.SpringHostContextAccessor$1.doInTransaction(SpringHostContextAccessor.java:88) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.sal.spring.component.SpringHostContextAccessor.doInTransaction(SpringHostContextAccessor.java:82) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.hostcomponents.impl.DefaultComponentRegistrar$ContextClassLoaderSettingInvocationHandler.invoke(DefaultComponentRegistrar.java:129) at com.sun.proxy.$Proxy238.doInTransaction(Unknown Source) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:154) at com.sun.proxy.$Proxy238.doInTransaction(Unknown Source) at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21) at sun.reflect.GeneratedMethodAccessor189.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.osgi.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:58) at org.springframework.osgi.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:62) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:56) at org.springframework.osgi.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:39) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.osgi.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy1235.execute(Unknown Source) at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:84) at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:40) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:99) ... 7 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a83eae244fdc3870144fdce97bd0030' for key 'U_AO_9412A1_AOUSER_USERNAME' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1842) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1764) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2348) at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2418) at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2381) at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:99) at net.java.ao.EntityManager.migrate(EntityManager.java:128) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:50) ... 47 more

AlexH added a comment - 12/Oct/2014 8:40 AM - edited

I'm getting a similar exception in 5.4.4 which occured immediately after we upgraded JIRA from 4.4.4 to 6.3.7 and rebuilt the application links between Confluence 5.4 and JIRA 6.3.

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
        - name:MySQL
        - version:5.5.34-enterprise-commercial-advanced-log
        - minor version:5
        - major version:5
Driver:
        - name:MySQL Connector Java
        - version:mysql-connector-java-5.1.29 ( Revision: alexander.soklakov@oracle.com-20140120140810-s44574olh90i6i4l )

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a5ef2dc4527892501452d8bb6ac000c' for key 'U_AO_9412A1_AOUSER_USERNAME'

AlexH added a comment - 12/Oct/2014 8:40 AM - edited I'm getting a similar exception in 5.4.4 which occured immediately after we upgraded JIRA from 4.4.4 to 6.3.7 and rebuilt the application links between Confluence 5.4 and JIRA 6.3. Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:5.5.34-enterprise-commercial-advanced-log - minor version:5 - major version:5 Driver: - name:MySQL Connector Java - version:mysql-connector-java-5.1.29 ( Revision: alexander.soklakov@oracle.com-20140120140810-s44574olh90i6i4l ) com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a5ef2dc4527892501452d8bb6ac000c' for key 'U_AO_9412A1_AOUSER_USERNAME'

MarioW added a comment - 04/Jun/2014 8:45 AM

I did successfully fix the problem with the above solution (upgrading from confluence 5.1.5 to 5.4.4).
After restarting confluence, a further problem appeared which seems to be rather equal than the first one. This time the error starts with

2014-06-04 10:33:15,464 ERROR [TP-Processor14] [mywork.host.rest.ExceptionLogger] toResponse Exception thrown from resource
– referer: http://confluence-t.sbb.ch/display/PZSBBP/Startseite | url: /rest/mywork/latest/status/notification/count | userName: u203963
com.atlassian.activeobjects.internal.ActiveObjectsInitException: Active Objects failed to initalize for bundle com.atlassian.mywork.confluence-host-plugin

........
........

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a064d734660c221014660c2d35a4555' for key 'U_AO_9412A1_AOUSER_USERNAME'

i will continue to search in the atlassian forum but until now, i have not find anthing accordingly.
THanks in advance for help

Mario Widmer
Schweizerische Bundesbahnen SBB

MarioW added a comment - 04/Jun/2014 8:45 AM I did successfully fix the problem with the above solution (upgrading from confluence 5.1.5 to 5.4.4). After restarting confluence, a further problem appeared which seems to be rather equal than the first one. This time the error starts with 2014-06-04 10:33:15,464 ERROR [TP-Processor14] [mywork.host.rest.ExceptionLogger] toResponse Exception thrown from resource – referer: http://confluence-t.sbb.ch/display/PZSBBP/Startseite | url: /rest/mywork/latest/status/notification/count | userName: u203963 com.atlassian.activeobjects.internal.ActiveObjectsInitException: Active Objects failed to initalize for bundle com.atlassian.mywork.confluence-host-plugin ........ ........ Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '8a064d734660c221014660c2d35a4555' for key 'U_AO_9412A1_AOUSER_USERNAME' i will continue to search in the atlassian forum but until now, i have not find anthing accordingly. THanks in advance for help Mario Widmer Schweizerische Bundesbahnen SBB

Confluence Data Center

Details

Description

Impact

Technical notes

Workaround

Postgres

MySQL

Attachments

Issue Links

Forms

Activity

Collapse comment: Tomas Kenis added a comment - 17/Oct/2014 4:09 PM

Expand comment: Tomas Kenis added a comment - 17/Oct/2014 4:09 PM

Collapse comment: AlexH added a comment - 12/Oct/2014 8:40 AM, Edited by AlexH - 12/Oct/2014 8:40 AM

Expand comment: AlexH added a comment - 12/Oct/2014 8:40 AM, Edited by AlexH - 12/Oct/2014 8:40 AM

Collapse comment: MarioW added a comment - 04/Jun/2014 8:45 AM

Expand comment: MarioW added a comment - 04/Jun/2014 8:45 AM

People

Dates