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

On certain configurations, the attachments upgrade task very slow or hangs when upgrading to 5.7

XMLWordPrintable

      This is an umbrella issue to investigate why the Confluence upgrade to 5.7 takes a long amount of time with certain database configurations or in some rare cases even hangs.

      Here is an example log message:

      2015-02-05 01:35:26,704 INFO [localhost-startStop-1] [upgrade.upgradetask.attachmentceo.AttachmentIdClashResolver] resolveAttachmentIdClashes No ID collisions were found between the ATTACHMENTS and CONTENT tables.
2015-02-05 01:35:26,717 INFO [localhost-startStop-1] [upgrade.upgradetask.attachmentceo.AttachmentToContentMigrator] doMigration Beginning migration of 6644 attachment entries..

      This appears to be affecting SQL Server and Oracle databases that already have latency issues.

      Workaround for SQL Server

      • SQL Server is known to have this issue when a connection validation query is enabled or when C3P0 (direct JDBC) connection pooling is used.
      • There is a bug (CONF-36484) where the preferredTestQuery passed to C3P0 is ignored causing it to issue a "list tables" query which locks up if run while the upgrade task is running.
      • The solution is to switch to using a datasource connection with "select 1" as the connection test query.

            [CONFSERVER-36430] On certain configurations, the attachments upgrade task very slow or hangs when upgrading to 5.7

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2902364 ] New: CONFSERVER Bug Workflow v4 [ 2996985 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2799663 ] New: JAC Bug Workflow v3 [ 2902364 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2730118 ] New: JAC Bug Workflow v2 [ 2799663 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2380746 ] New: JAC Bug Workflow [ 2730118 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2272252 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2380746 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2222336 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2272252 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2169467 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2222336 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1943973 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2169467 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1722628 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1943973 ]
            Lauretha Rura made changes -
            Labels Original: affects-server business-teams hot-conf-fixed team-muppets warranty New: affects-server business-teams team-muppets warranty

              nbhawnani Niraj Bhawnani
              mreis Mitermayer Reis
              Affected customers:
              9 This affects my team
              Watchers:
              42 Start watching this issue

                Created:
                Updated:
                Resolved: