[AMBARI-22881] Missing user_authentication_id_seq in ambari_sequences table upon upgrade

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.7.0
• Fix Version/s: 2.7.0
• Component/s: ambari-server
• Labels: pull-request-available
• Assignee: Sandor Molnar
• Reporter: Sandor Molnar
• Created: 30/Jan/18 17:44
• Updated: 01/Feb/18 11:48
• Resolved: 01/Feb/18 11:48

Description

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:

insert into ambari_sequences (sequence_name, sequence_value) 
  select 'user_authentication_id_seq', max(user_authentication_id) + 1 from user_authentication;

Issue Links

• links to: GitHub Pull Request #233