Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-23008

Refreshing browser while jira sync underway loads status message on an incorrect state.

    XMLWordPrintable

Details

    Description

      • Fill up JIRA server data with a server that has high number of group memberships
      • Click "Next" to start the sync.
      • While the sync is happening, refresh the browser two times (leave a 5 second interval between refreshes)

      Expected: Sync page to load and continue to sync. Next button to be disabled until the sync finishes, status message to change to state that synchronization has finished.

      Actual: Sync page loads, status message no longer updates and the Next button is enabled (even though the sync is still occurring in the background). Confluence start with the admin user logged in but the screen states that it does not have permissions to access Confluence. This is due to the fact that the sync is not finished.

      Notes:

      • When the page is reloaded, there is an exception that is thrown in the log.
      • After the sync finishes, admin user is able to load Confluence normally.
      • The same thing happens if browser is closed and reopened.
      • Screen recording: http://screencast.com/t/Cedb0W7E5
      2011-08-01 10:35:06,067 INFO [Long running task: Synchronising JIRA Directory] [atlassian.crowd.directory.DbCachingRemoteChangeOperations] addUserMembershipsForG
      roup added [ 9 ] user members to [ group224 ] in [ 53ms ]
      2011-08-01 10:35:06,168 ERROR [Long running task: Unmigrated wiki markup migration Task] [sf.hibernate.util.JDBCExceptionReporter] logExceptions integrity constr
      aint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
       -- referer: http://localhost:8089/confluence5/setup/connecttojirasyncdirectory-start.action | url: /confluence5/setup/finishsetup.action | userName: anonymous |
       action: finishsetup
      2011-08-01 10:35:06,178 ERROR [Long running task: Unmigrated wiki markup migration Task] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database s
      tate with session
       -- referer: http://localhost:8089/confluence5/setup/connecttojirasyncdirectory-start.action | url: /confluence5/setup/finishsetup.action | userName: anonymous |
       action: finishsetup
      2011-08-01 10:35:06,179 ERROR [Long running task: Unmigrated wiki markup migration Task] [xhtml.migration.macro.RemigrationLongRunningTask] runInternal An error
      occurred during the long running macro migration task
       -- referer: http://localhost:8089/confluence5/setup/connecttojirasyncdirectory-start.action | url: /confluence5/setup/finishsetup.action | userName: anonymous |
       action: finishsetup
      org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.setup.bandana.ConfluenceBandanaRecord#3
      60475]; SQL []; integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA; nested exception is java.sql.SQLExceptio
      n: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
              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)
              at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
              at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
              at $Proxy24.store(Unknown Source)
              at com.atlassian.confluence.setup.bandana.ConfluenceCachingBandanaPersister.store(ConfluenceCachingBandanaPersister.java:130)
              at com.atlassian.bandana.DefaultBandanaManager.setValue(DefaultBandanaManager.java:48)
              at com.atlassian.confluence.content.render.xhtml.migration.macro.MacroMigrationService.setMigrationRequired(MacroMigrationService.java:201)
              at com.atlassian.confluence.content.render.xhtml.migration.macro.RemigrationLongRunningTask.runInternal(RemigrationLongRunningTask.java:79)
              at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:21)
              at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
              at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
              at java.util.concurrent.FutureTask.run(FutureTask.java:138)
              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
              at java.lang.Thread.run(Thread.java:662)
      Caused by: java.sql.SQLException: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
              at org.hsqldb.jdbc.Util.sqlException(Util.java:215)
              at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4613)
              at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(JDBCPreparedStatement.java:308)
              at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
              at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
              at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
              at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
              at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
              at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2447)
              at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2433)
              at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2390)
              at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2259)
              at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
              at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:510)
              ... 19 more
      Caused by: org.hsqldb.HsqlException: integrity constraint violation: unique constraint or index violation; BANDANA_UNIQUE_KEY table: BANDANA
              at org.hsqldb.error.Error.error(Error.java:131)
              at org.hsqldb.Constraint.getException(Constraint.java:913)
              at org.hsqldb.index.IndexAVLMemory.insert(IndexAVLMemory.java:236)
              at org.hsqldb.persist.RowStoreAVL.indexRow(RowStoreAVL.java:171)
              at org.hsqldb.TransactionManagerMVCC.addInsertAction(TransactionManagerMVCC.java:402)
              at org.hsqldb.Session.addInsertAction(Session.java:433)
              at org.hsqldb.Table.insertSingleRow(Table.java:2500)
              at org.hsqldb.StatementDML.insertSingleRow(StatementDML.java:820)
              at org.hsqldb.StatementInsert.getResult(StatementInsert.java:131)
              at org.hsqldb.StatementDMQL.execute(StatementDMQL.java:190)
              at org.hsqldb.Session.executeCompiledStatement(Session.java:1300)
              at org.hsqldb.Session.execute(Session.java:960)
              at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(JDBCPreparedStatement.java:4605)
              ... 31 more
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              psongsiritat Piyawoot Songsiritat [Atlassian]
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: