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.

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

            Steve Haffenden (Inactive) added a comment -

            Hi There

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

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

            Regards
            Steve Haffenden
            Confluence Bugmaster

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

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

                Created:
                Updated:
                Resolved: