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

upgrading to 4.3.1 on oracle gives contraint error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Medium Medium
    • None
    • 4.3.1
    • None

    • upgrade from 4.2.11 to 4.3.1 on Oracle 11G

      When upgrading to 4.3.1 to following SQL query fails on Oracle 11G:

      create index attch_data_idx on ATTACHMENTDATA (ATTACHMENTID)

      This happens because there is already an constraint and index generated by oracle on this field. The create fails because the same index already exists.

      Solution is to remove the constraint and index manually. Then the SQL query works, and the upgrade process will continue.

          Form Name

            [CONFSERVER-26715] upgrading to 4.3.1 on oracle gives contraint error

              shaffenden Steve Haffenden (Inactive)
              24386343cf32 Christoph Kempen
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: