[AMBARI-10098] RU - Unable to begin RU due to MySQL "Error preallocating sequence numbers"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: ambari-server
• Labels: rolling_upgrade
• Assignee: Alejandro Fernandez
• Reporter: Alejandro Fernandez
• Created: 17/Mar/15 01:29
• Updated: 18/Mar/15 00:37
• Resolved: 17/Mar/15 17:59

Description

Tried to make an RU,

• Deployed clustered, enabled Namenode HA, distributed bits
• Attempt to begin an RU (through both UI and curl call)

  curl -X POST -u admin:admin -H 'X-Requested-By:1' http://server:8080/api/v1/clusters/cl1/upgrades -d '{"Upgrade": {"repository_version": "2.2.3.0-2610"}}'
  {
    "status": 500,
    "message": "\nException Description: Error preallocating sequence numbers.  The sequence table information is not complete."
  }
  

Exception Description: Error preallocating sequence numbers.  The sequence table information is not complete.

Saw this on two clusters (Ubuntu and SP3) with MySQL Ambari DB that I deployed to EC2.
Ambari version, 2.0.0-137
Database: MySQL

mysql> select * from ambari_sequences;
+--------------------------+----------------+
| sequence_name            | sequence_value |
+--------------------------+----------------+
| alert_current_id_seq     |            132 |
| alert_definition_id_seq  |             64 |
| alert_group_id_seq       |             20 |
| alert_history_id_seq     |            456 |
| alert_notice_id_seq      |              0 |
| alert_target_id_seq      |              0 |
| cluster_id_seq           |              2 |
| cluster_version_id_seq   |              2 |
| configgroup_id_seq       |              1 |
| config_id_seq            |             95 |
| group_id_seq             |              1 |
| host_role_command_id_seq |           1001 |
| host_version_id_seq      |             12 |
| member_id_seq            |              1 |
| operation_level_id_seq   |              5 |
| permission_id_seq        |              5 |
| principal_id_seq         |              2 |
| principal_type_id_seq    |              3 |
| privilege_id_seq         |              1 |
| repo_version_id_seq      |              2 |
| requestschedule_id_seq   |              1 |
| resourcefilter_id_seq    |             20 |
| resource_id_seq          |              4 |
| resource_type_id_seq     |              8 |
| service_config_id_seq    |             31 |
| upgrade_id_seq           |              2 |
| upgrade_item_id_seq      |              0 |
| user_id_seq              |              2 |
| viewentity_id_seq        |              0 |
| view_instance_id_seq     |              2 |
+--------------------------+----------------+
30 rows in set (0.00 sec)

Issue Links

• links to: Code Review patch