----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/32142/#review76728 -----------------------------------------------------------
Ship it! Ship It! - Nate Cole 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 > >
