[AMBARI-19957] Implement new DB checks for Postgres to prevent cross-schema confusion

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.5.0
• Fix Version/s: 3.0.0, 2.5.0
• Component/s: ambari-server
• Assignee: Balázs Bence Sári
• Reporter: Balázs Bence Sári
• Created: 10/Feb/17 10:20
• Updated: 16/Mar/17 09:37
• Resolved: 16/Mar/17 09:37

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.

Issue Links

• links to: review board