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

Implement new DB checks for Postgres to prevent cross-schema confusion

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.5.0
    • 3.0.0, 2.5.0
    • ambari-server
    • None

    Description

      Postgres allows multiple schemas on a database user's search path, that is users can query from tables in different schemas without the need of prefixing the tables in the query.

      This can lead to confusion when after an unsuccessful upgrade DBA's restore the tables into a different schema (e.g. public) to Ambari's configured one. As a result, Ambari server may see corrupt data.

      New consistency checks on server startup should warn the user in such situations.

      Attachments

        1. AMBARI-19957-DB-checks_trunk_v4.patch
          46 kB
          Balázs Bence Sári
        2. AMBARI-19957-DB-checks_25_v4_rebase1.patch
          46 kB
          Balázs Bence Sári

        Issue Links

          Activity

            People

              bsari Balázs Bence Sári
              bsari Balázs Bence Sári
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: