[AMBARI-18676] Fix constraint violations in adminprincipal table when installing database schema

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 2.4.2
• Fix Version/s: 2.4.2
• Component/s: ambari-server
• Assignee: Robert Levas
• Reporter: Robert Levas
• Due: 25/Oct/16
• Created: 24/Oct/16 13:43
• Updated: 24/Oct/16 22:33
• Resolved: 24/Oct/16 14:44

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".

This was caused by the patch from AMBARI-18635.

Issue Links

• is related to: AMBARI-18635 Authorizations given to roles, should use generic role-based principals rather than hard-coded pseudo-role-based principals
• links to: ReviewBoard