ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alejandro Fernandez (JIRA)" <>
Subject [jira] [Created] (AMBARI-10022) RU - DB Schema differs between Postgres internal and external
Date Wed, 11 Mar 2015 01:27:38 GMT
Alejandro Fernandez created AMBARI-10022:

             Summary: RU - DB Schema differs between Postgres internal and external
                 Key: AMBARI-10022
             Project: Ambari
          Issue Type: Bug
          Components: ambari-server
    Affects Versions: 2.0.0
            Reporter: Alejandro Fernandez
            Assignee: Alejandro Fernandez
             Fix For: 2.0.0

The DB schema differs between the internal and external Postgres databases, and this affects

Impact: If not fixed in Ambari 2.0, then a future release will have to absorb the technical
debt and need the Ambari Update to correct the schema in order to keep it consistent in order
to prevent bugs.
CREATE TABLE ambari.repo_version (
  repo_version_id BIGINT,  -- should have NOT NULL modifier


  INSERT INTO ambari_sequences (sequence_name, sequence_value)
  union all
  select 'upgrade_group_id_seq', 0 


CREATE TABLE ambari.repo_version (
  repo_version_id BIGINT NOT NULL,


INSERT INTO ambari_sequences (sequence_name, sequence_value)
-- Doesn't insert upgrade_group_id_seq

This message was sent by Atlassian JIRA

View raw message