-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/53135/
-----------------------------------------------------------

Review request for Ambari, Jonathan Hurley, Laszlo Puskas, Nate Cole, and 
Oliver Szabo.


Bugs: AMBARI-18676
    https://issues.apache.org/jira/browse/AMBARI-18676


Repository: ambari


Description
-------

Fix constraint violations in adminprincipal table when installing database 
schema

```
psql:/var/lib/ambari-server/resources/Ambari-DDL-Postgres-CREATE.sql:1132: 
ERROR:  insert or update on table "adminprincipal" violates foreign key 
constraint "fk_principal_principal_type_id"
DETAIL:  Key (principal_type_id)=(3) is not present in table 
"adminprincipaltype".
```


Diffs
-----

  ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql 7ab1dc7 
  ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 5556e82 
  ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql fb3ada5 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql 137a243 
  ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql 4922378 
  ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql f72b0ab 

Diff: https://reviews.apache.org/r/53135/diff/


Testing
-------

Manually created MySQL and PosgreSQL databases.


Thanks,

Robert Levas

Reply via email to