You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ambari.apache.org by "Sandor Molnar (JIRA)" <ji...@apache.org> on 2018/01/30 17:45:00 UTC

[jira] [Created] (AMBARI-22881) Missing user_authentication_id_seq in ambari_sequences table upon upgrade

Sandor Molnar created AMBARI-22881:
--------------------------------------

             Summary: Missing user_authentication_id_seq in ambari_sequences table upon upgrade
                 Key: AMBARI-22881
                 URL: https://issues.apache.org/jira/browse/AMBARI-22881
             Project: Ambari
          Issue Type: Bug
          Components: ambari-server
    Affects Versions: 2.7.0
            Reporter: Sandor Molnar
            Assignee: Sandor Molnar
             Fix For: 2.7.0


Missing user_authentication_id_seq in ambari_sequences table upon upgrade.

The missing sequence should be added using a value greater than the largest {{user_authentication.user_authentication_id}}. For example:
{code:sql}
insert into ambari_sequences (sequence_name, sequence_value) 
  select 'user_authentication_id_seq', max(user_authentication_id) + 1 from user_authentication;{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)