ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Myroslav Papirkovskyy (JIRA)" <>
Subject [jira] [Created] (AMBARI-5211) Cleanup foreign key contraints after upgrade
Date Tue, 25 Mar 2014 18:02:15 GMT
Myroslav Papirkovskyy created AMBARI-5211:

             Summary: Cleanup foreign key contraints after upgrade
                 Key: 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

- 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)
2. Exceptions in the logs saying cannot add a constraint. (Oracle)

- 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

View raw message