ambari-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Hurley" <jhur...@hortonworks.com>
Subject Re: Review Request 32142: RU - Unable to begin RU due to MySQL "Error preallocating sequence numbers"
Date Tue, 17 Mar 2015 02:20:33 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32142/#review76698
-----------------------------------------------------------

Ship it!


Ship It!

- Jonathan Hurley


On March 16, 2015, 9:33 p.m., Alejandro Fernandez wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/32142/
> -----------------------------------------------------------
> 
> (Updated March 16, 2015, 9:33 p.m.)
> 
> 
> Review request for Ambari, Dmitro Lisnichenko, Jonathan Hurley, Nate Cole, and Sid Wagle.
> 
> 
> Bugs: AMBARI-10098
>     https://issues.apache.org/jira/browse/AMBARI-10098
> 
> 
> Repository: ambari
> 
> 
> 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)
> ```
> 
> 
> Diffs
> -----
> 
>   ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 3da9bb9 
>   ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql b404b4d 
> 
> Diff: https://reviews.apache.org/r/32142/diff/
> 
> 
> Testing
> -------
> 
> Ran the SQL INSERT statement, and was then able to POST to the /upgrade endpoint.
> 
> 
> Thanks,
> 
> Alejandro Fernandez
> 
>


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message