[jira] [Created] (AMBARI-5211) Cleanup foreign key contraints after upgrade

["Myroslav Papirkovskyy (JIRA)" <ji...@apache.org>]

Myroslav Papirkovskyy created AMBARI-5211:
---------------------------------------------

             Summary: Cleanup foreign key contraints after upgrade
                 Key: AMBARI-5211
                 URL: https://issues.apache.org/jira/browse/AMBARI-5211
             Project: Ambari
          Issue Type: Task
          Components: controller
    Affects Versions: 1.5.0
            Reporter: Myroslav Papirkovskyy
            Assignee: Myroslav Papirkovskyy
            Priority: Critical
             Fix For: 1.5.0


*Situation*:
- We modified constraint names for foreign keys to fit Oracle restriction
- However, did not make names consistent across all DB types
- Now Upgrade java code has to have smaller length constraint names to work with Oracle
- So after upgrade there could be:
1. More that 1 constraint for same set of columns. (Postgres)
OR
2. Exceptions in the logs saying cannot add a constraint. (Oracle)

*Fix*:
- Drop old constraints before adding new ones. (Only for the ones which are different in both CREATE sql scripts)



--
This message was sent by Atlassian JIRA
(v6.2#6252)