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

      • 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

        1. Bildschirmfoto 2011-09-16 um 10.42.22.png
          80 kB
          Dan Choon
        2. Error.txt
          15 kB
          Ankur Mehrotra

            [CONFSERVER-23008] Refreshing browser while jira sync underway loads status message on an incorrect state.

            Steve Haffenden (Inactive) added a comment -

            Hi there

            Thanks for taking the time to raise this issue. As you're probably aware this has been on our backlog now for sometime with very little progress having been made. Rather than leave this here I'm going to close this issue as won't fix, I believe that this better reflects the status of the issue.

            If the problem is raised again in the future we will readdress it.

            Regards
            Steve Haffenden
            Confluence Bugmaster
            Atlassian

            Steve Haffenden (Inactive) added a comment - Hi there Thanks for taking the time to raise this issue. As you're probably aware this has been on our backlog now for sometime with very little progress having been made. Rather than leave this here I'm going to close this issue as won't fix, I believe that this better reflects the status of the issue. If the problem is raised again in the future we will readdress it. Regards Steve Haffenden Confluence Bugmaster Atlassian

            Fernando Ojeda added a comment -

            Remove the attribute "disabled" from the button "Next" using inspect element (chrome). That's works for me. It's better than uninstall.

            Fernando Ojeda added a comment - Remove the attribute "disabled" from the button "Next" using inspect element (chrome). That's works for me. It's better than uninstall.

            ekynox added a comment -

            Hello,

            I am stuck to installation, same problem here.

            https://answers.atlassian.com/questions/111652/confluence-installation-bug-when-linking-to-jira-stucked

            Thanks for help.

            ekynox added a comment - Hello, I am stuck to installation, same problem here. https://answers.atlassian.com/questions/111652/confluence-installation-bug-when-linking-to-jira-stucked Thanks for help.

            V added a comment -

            I was hung/frozen at "load users and groups from jira". Any access to the server redirected to that page.

            The server was stuck there for a few weeks, because I got side-tracked on a different issue. I restarted apache, confluence, and jira. I deleted the confluence temp files. Nothing worked. Everything redirected to "/setup/connecttojirasyncdirectory-start.action"

            After reading the previous posts I accessed the page from Internet Explorer (Not my normal browser). I refreshed the page until the "Next >>" button was not grayed out. I clicked the "Next >>" button, and it FINALLY finished the load.

            Everything appears to be working now.

            V added a comment - I was hung/frozen at "load users and groups from jira". Any access to the server redirected to that page. The server was stuck there for a few weeks, because I got side-tracked on a different issue. I restarted apache, confluence, and jira. I deleted the confluence temp files. Nothing worked. Everything redirected to "/setup/connecttojirasyncdirectory-start.action" After reading the previous posts I accessed the page from Internet Explorer (Not my normal browser). I refreshed the page until the "Next >>" button was not grayed out. I clicked the "Next >>" button, and it FINALLY finished the load. Everything appears to be working now.

            Jay Sauce added a comment -

            The issue is a javascript problem. The way I got it to work is I tailed the log in /var/atlassian/application-data/confluence/logs/atlassian-confluence.log and made sure my user syncing was done and then with javascript I submitted the form using firebug and jquery. You can do it whatever javascript way you like though. The interface may only work with IE and not with firefox/Chrome. Don't know for sure though.

            Jay Sauce added a comment - The issue is a javascript problem. The way I got it to work is I tailed the log in /var/atlassian/application-data/confluence/logs/atlassian-confluence.log and made sure my user syncing was done and then with javascript I submitted the form using firebug and jquery. You can do it whatever javascript way you like though. The interface may only work with IE and not with firefox/Chrome. Don't know for sure though.

            Mark Hrynczak (Inactive) added a comment -

            Is this issue the cause of CONFDEV-5673 & CONF-23184?

            Mark Hrynczak (Inactive) added a comment - Is this issue the cause of CONFDEV-5673 & CONF-23184 ?

            Ulas Devrim Demiroz added a comment - - edited

            I resolved the problem. My walk through:

            • Uninstalled confluence. Uninstall does not drop db tables
            • Reinstalled confluence. Besides reinstallation, confluence remembers the previous jira syn step
            • Looked into browser history and found the "...:8090/setup/setuplicense.action". Entered a new license.
            • Continued with db installation. Db installation failed as tables already exists. However there is a button to continue with setup.
            • Clicked "Continue with setup" button. An error page come up.
            • Stopped confluence service.
            • Restarted confluence service, accessed 8090 via browser.
            • Voila! "Confluence Setup Successful"

            Ulas Devrim Demiroz added a comment - - edited I resolved the problem. My walk through: Uninstalled confluence. Uninstall does not drop db tables Reinstalled confluence. Besides reinstallation, confluence remembers the previous jira syn step Looked into browser history and found the "...:8090/setup/setuplicense.action". Entered a new license. Continued with db installation. Db installation failed as tables already exists. However there is a button to continue with setup. Clicked "Continue with setup" button. An error page come up. Stopped confluence service. Restarted confluence service, accessed 8090 via browser. Voila! "Confluence Setup Successful"

            Ulas Devrim Demiroz added a comment -

            Piyawoot,

            Thanks for the info, however it is not possible to return the previous steps in confluence setup. Even though i have re installed over existing one. Guess my only workaround left is to uninstall all confluence and start over. I was wondering if there is a possible way to step back...

            Ulas Devrim Demiroz added a comment - Piyawoot, Thanks for the info, however it is not possible to return the previous steps in confluence setup. Even though i have re installed over existing one. Guess my only workaround left is to uninstall all confluence and start over. I was wondering if there is a possible way to step back...

            Piyawoot Songsiritat [Atlassian] added a comment -

            Yes, you can work around by selecting "Manage users and groups within Confluence" in "User Management Setup" step. And then you can configure Jira connectivity after the installation http://confluence.atlassian.com/display/DOC/Connecting+to+Crowd+or+JIRA+for+User+Management.

            Piyawoot Songsiritat [Atlassian] added a comment - Yes, you can work around by selecting "Manage users and groups within Confluence" in "User Management Setup" step. And then you can configure Jira connectivity after the installation http://confluence.atlassian.com/display/DOC/Connecting+to+Crowd+or+JIRA+for+User+Management .

            Ulas Devrim Demiroz added a comment - - edited

            http://localhost:8090/setup/connecttojirasyncdirectory-start.action it stopped/hung. This happened during jira user synchronization and i was unable to observe similar stack traces inside logs.
            Confluence stuck at this point, is there a possible workaround to jump to finished setup phase or restart the process without synchronization?

            Screen capture is same with the attached.

            "Load users and groups from JIRA

            Synchronisation completed successfully.
            Time Elapsed:Less than a second
            Local administrator account created.
            We have created a local administrator with the same username and password as the JIRA system administrator you provided. This will ensure that you can always log into Confluence to update the system configuration."

            Ulas Devrim Demiroz added a comment - - edited http://localhost:8090/setup/connecttojirasyncdirectory-start.action it stopped/hung. This happened during jira user synchronization and i was unable to observe similar stack traces inside logs. Confluence stuck at this point, is there a possible workaround to jump to finished setup phase or restart the process without synchronization? Screen capture is same with the attached. "Load users and groups from JIRA Synchronisation completed successfully. Time Elapsed:Less than a second Local administrator account created. We have created a local administrator with the same username and password as the JIRA system administrator you provided. This will ensure that you can always log into Confluence to update the system configuration."

              Unassigned Unassigned
              psongsiritat Piyawoot Songsiritat [Atlassian]
              Affected customers:
              1 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: