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

The AO_54C900_C_TEMPLATE_REF table does not have an index on the UUID column

XMLWordPrintable

      Issue Summary

      The AO_54C900_C_TEMPLATE_REF table can grow quite large, and can cause startup to take a long time. A query is run during startup that may need to be run more than a thousand times, and the lack of an index on the UUID column causes the queries to run slowly if there are hundreds of thousands of rows in the table. Here's the query: 

      SELECT "NAME","PLUGIN_CLONE","TEMPLATE_ID","ID","UUID","PLUGIN_MODULE_KEY" FROM "AO_54C900_C_TEMPLATE_REF" WHERE "UUID" = ?

      Environment

      Issue does not seem to be specific to a version of Confluence or database

      Steps to Reproduce

      1. On an instance of Confluence with several hundred thousands of rows in the AO_54C900_C_TEMPLATE_REF table, time how long startup takes.
      2. Add an index to the UUID column in the AO_54C900_C_TEMPLATE_REF table, and then time to see how long startup takes.

      Expected Results

      Confluence should already have an index on this column

      Actual Results

      There is no index on the column.

      Notes

      After adding the index to the UUID column on an instance with over 500,000 rows, startup time went from about 20 minutes to about 3 minutes.

      Workaround

      You can add a column to this table with the following SQL statement, for Oracle: 

      CREATE INDEX uuid_idx ON AO_54C900_C_TEMPLATE_REF (UUID);

          Form Name

            [CONFSERVER-58513] The AO_54C900_C_TEMPLATE_REF table does not have an index on the UUID column

            Quan Pham added a comment -

            A fix for this issue is available to Server and Data Center customers in Confluence 7.0.1
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            Quan Pham added a comment - A fix for this issue is available to Server and Data Center customers in Confluence 7.0.1 Upgrade now or check out the Release Notes to see what other issues are resolved.

              mbereznitsky Mark Bereznitsky
              jkennemer Jonathon
              Affected customers:
              1 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: