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

(Updated May 3, 2016, 1:09 p.m.)


Review request for Ambari, Alejandro Fernandez, Ajit Kumar, Jonathan Hurley, 
Jayush Luniya, and Sumit Mohanty.


Changes
-------

Updated build and verification.


Bugs: AMBARI-16029
    https://issues.apache.org/jira/browse/AMBARI-16029


Repository: ambari


Description
-------

AMBARI-16029: Ambari version history - Create DB table, constraints and 
sequence id.

** Issue **
In order to support tracking of ambari version, a DB table is required.

** Fix **
Create ambari_operation_history table to store from version, to version, 
install type, start and stop timestamps.


Diffs
-----

  ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql 
319afa579e6f5090588fb90fe619ee7b6bae6d78 
  ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 
9a20b8c05801f61a91a092afd4424173a94d7f17 
  ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql 
e1da7190d6fb929277c834b29cb537107d857bc3 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql 
ab1eec42fcba467e0bae19674a7877c79eb77b8e 
  ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql 
bd869f454ae7ec1c84a9cbd418875f10c023a0c2 
  ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql 
fdba489f2d0759e9c1282dfad38036f9bce3673d 
  ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql 
a1da8e5c8343ae554b4e95717cda085c7f79bc46 

Diff: https://reviews.apache.org/r/46545/diff/


Testing (updated)
-------

** 1. mvn clean install **

[INFO] ------------------------------------------------------------------------
[INFO] Reactor Summary:
[INFO]
[INFO] Ambari Main ....................................... SUCCESS [11.109s]
[INFO] Apache Ambari Project POM ......................... SUCCESS [0.037s]
[INFO] Ambari Web ........................................ SUCCESS [32.312s]
[INFO] Ambari Views ...................................... SUCCESS [1.275s]
[INFO] Ambari Admin View ................................. SUCCESS [8.752s]
[INFO] ambari-metrics .................................... SUCCESS [0.375s]
[INFO] Ambari Metrics Common ............................. SUCCESS [0.521s]
[INFO] Ambari Metrics Hadoop Sink ........................ SUCCESS [1.184s]
[INFO] Ambari Metrics Flume Sink ......................... SUCCESS [0.616s]
[INFO] Ambari Metrics Kafka Sink ......................... SUCCESS [0.678s]
[INFO] Ambari Metrics Storm Sink ......................... SUCCESS [2.215s]
[INFO] Ambari Metrics Collector .......................... SUCCESS [8.408s]
[INFO] Ambari Metrics Monitor ............................ SUCCESS [2.389s]
[INFO] Ambari Metrics Grafana ............................ SUCCESS [1.170s]
[INFO] Ambari Metrics Assembly ........................... SUCCESS [1:21.702s]
[INFO] Ambari Server ..................................... SUCCESS [3:40.188s]
[INFO] Ambari Functional Tests ........................... SUCCESS [3.530s]
[INFO] Ambari Agent ...................................... SUCCESS [30.377s]
[INFO] Ambari Client ..................................... SUCCESS [0.106s]
[INFO] Ambari Python Client .............................. SUCCESS [1.418s]
[INFO] Ambari Groovy Client .............................. SUCCESS [2.914s]
[INFO] Ambari Shell ...................................... SUCCESS [0.077s]
[INFO] Ambari Python Shell ............................... SUCCESS [1.011s]
[INFO] Ambari Groovy Shell ............................... SUCCESS [1.401s]
[INFO] ambari-logsearch .................................. SUCCESS [0.329s]
[INFO] Ambari Logsearch Appender ......................... SUCCESS [0.377s]
[INFO] Ambari Logsearch Portal ........................... SUCCESS [8.035s]
[INFO] Ambari Logsearch Log Feeder ....................... SUCCESS [2.534s]
[INFO] Ambari Logsearch Solr Client ...................... SUCCESS [0.906s]
[INFO] Ambari Logsearch Assembly ......................... SUCCESS [0.150s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 7:08.197s
[INFO] Finished at: Tue May 03 13:06:54 PDT 2016
[INFO] Final Memory: 281M/1172M
[INFO] ------------------------------------------------------------------------


** 2. Manual testing **
Tested with Ambari-DDL-Postgres-EMBEDDED-CREATE.sql. Copied the SQL script to a 
VM and ran ambari-server reset. Verified the schema:

ambari=> \d+ ambari_operation_history
                   Table "ambari.ambari_operation_history"
     Column     |          Type          | Modifiers | Storage  | Description
----------------+------------------------+-----------+----------+-------------
 id             | bigint                 | not null  | plain    |
 from_version   | character varying(255) | not null  | extended |
 to_version     | character varying(255) | not null  | extended |
 start_time     | bigint                 | not null  | plain    |
 end_time       | bigint                 |           | plain    |
 operation_type | character varying(255) | not null  | extended |
 comments       | text                   |           | extended |
Indexes:
    "pk_ambari_operation_history" PRIMARY KEY, btree (id)
Has OIDs: no


Thanks,

Nahappan Somasundaram

Reply via email to