-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/32142/
-----------------------------------------------------------
(Updated March 17, 2015, 5:58 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 (updated)
-------
Ran the SQL INSERT statement, and was then able to POST to the /upgrade
endpoint.
[INFO] Rat check: Summary of files. Unapproved: 0 unknown: 0 generated: 0
approved: 41 licence.
[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Ambari Main ....................................... SUCCESS [5.511s]
[INFO] Apache Ambari Project POM ......................... SUCCESS [0.030s]
[INFO] Ambari Web ........................................ SUCCESS [39.472s]
[INFO] Ambari Views ...................................... SUCCESS [2.007s]
[INFO] Ambari Admin View ................................. SUCCESS [9.275s]
[INFO] Ambari Metrics Common ............................. SUCCESS [1.203s]
[INFO] Ambari Server ..................................... SUCCESS [32:10.014s]
[INFO] Ambari Agent ...................................... SUCCESS [16.305s]
[INFO] Ambari Client ..................................... SUCCESS [0.055s]
[INFO] Ambari Python Client .............................. SUCCESS [0.353s]
[INFO] Ambari Groovy Client .............................. SUCCESS [9.579s]
[INFO] Ambari Shell ...................................... SUCCESS [0.035s]
[INFO] Ambari Python Shell ............................... SUCCESS [0.053s]
[INFO] Ambari Groovy Shell ............................... SUCCESS [6.630s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 33:41.166s
[INFO] Finished at: Tue Mar 17 10:55:01 PDT 2015
[INFO] Final Memory: 63M/449M
[INFO] ------------------------------------------------------------------------
Thanks,
Alejandro Fernandez
