Uploaded image for project: 'Ambari'
  1. Ambari
  2. AMBARI-18676

Fix constraint violations in adminprincipal table when installing database schema

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • 2.4.2
    • 2.4.2
    • ambari-server
    • None

    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.

      Attachments

        1. AMBARI-18676_trunk_01.patch
          4 kB
          Robert Levas
        2. AMBARI-18676_branch-2.5_01.patch
          4 kB
          Robert Levas
        3. AMBARI-18676_branch-2.4_01.patch
          4 kB
          Robert Levas

        Issue Links

          Activity

            People

              rlevas Robert Levas
              rlevas Robert Levas
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: