Duplicate indexes on the database

XMLWordPrintable

    • 2
    • Severity 3 - Minor
    • 0

      Issue Summary

      Bamboo database contains duplicate indexes.

      Steps to Reproduce

      1. Install Bamboo and connect to any database (Oracle, PostgreSQL, MySQL or SQL Server)
      2. Restart Bamboo

      Expected Results

      The database should not contain any duplicate indexes.

      Actual Results

      You can find duplicate indexes after restarting Bamboo. The duplicate indexes are:

      Table Indexes names
      AO_A0B856_WEBHOOK_EVENT index_ao_a0b856_web110787824, fkix_a0b856_webhook_event_webhookid
      AO_7A45FB_AOTRACKING_RESULT index_ao_7a45fb_aot1332136998, fkix_7a45fb_aotracking_result_linked_tracking_entry_id
      AO_A0B856_WEBHOOK_CONFIG index_ao_a0b856_web1050270930, fkix_a0b856_webhook_config_webhookid
      AO_7A45FB_AOTRACKING_USER index_ao_7a45fb_aot1861572280, fkix_7a45fb_aotracking_user_linked_tracking_entry_id

      Workaround

      1. Stop Bamboo server
      2. Backup Bamboo database for rollback pourposes
      3. Run the SQL commands below against Bamboo database: 
        DROP INDEX fkix_a0b856_webhook_event_webhookid;
DROP INDEX fkix_7a45fb_aotracking_result_linked_tracking_entry_id;
DROP INDEX fkix_a0b856_webhook_config_webhookid;
DROP INDEX fkix_7a45fb_aotracking_user_linked_tracking_entry_id;
      4. Start Bamboo server

              Assignee:
              Marcin Gardias
              Reporter:
              Karel Miranda
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: