-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/27207/
-----------------------------------------------------------
Review request for Ambari, Andrew Onischuk and Dmitro Lisnichenko.
Bugs: AMBARI-7975
https://issues.apache.org/jira/browse/AMBARI-7975
Repository: ambari
Description
-------
Schema upgrade failed
15:33:04,218 WARN [main] DBAccessorImpl:535 - Error executing query: ALTER
TABLE clusterconfig MODIFY config_data CLOB
java.sql.SQLException: ORA-22859: invalid modification of columns
Solution:
Upgrade fails because column datatype altering from CLOB to CLOB fails. Since
it's CLOB in 1.6.0 and 1.6.1 DB initial scripts, this altering can be skipped
for Oracle DB.
Alter statements for config_data were added in order to set same data type for
config_data in different tables for Postgres and MySQL
Diffs
-----
ambari-server/src/main/java/org/apache/ambari/server/upgrade/UpgradeCatalog170.java
c756a29
Diff: https://reviews.apache.org/r/27207/diff/
Testing
-------
[INFO] Ambari Server ..................................... SUCCESS [22:39.687s]
[INFO] Ambari Agent ...................................... SUCCESS [9.434s]
[INFO] Ambari Client ..................................... SUCCESS [0.277s]
[INFO] Ambari Python Client .............................. SUCCESS [0.568s]
[INFO] Ambari Groovy Client .............................. SUCCESS [14.351s]
[INFO] Ambari Shell ...................................... SUCCESS [0.040s]
[INFO] Ambari Python Shell ............................... SUCCESS [0.041s]
[INFO] Ambari Groovy Shell ............................... SUCCESS [10.764s]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
+
[root@c6401 ~]# ambari-server upgrade
Using python /usr/bin/python2.6
Upgrading ambari-server
Updating properties in ambari.properties ...
Adjusting ambari-server permissions and ownership...
Ambari Server 'upgrade' completed successfully.
[root@c6401 ~]# ambari-server start
Using python /usr/bin/python2.6
Starting ambari-server
Ambari Server running with 'root' privileges.
Organizing resource files at /var/lib/ambari-server/resources...
Server PID at: /var/run/ambari-server/ambari-server.pid
Server out at: /var/log/ambari-server/ambari-server.out
Server log at: /var/log/ambari-server/ambari-server.log
Waiting for server start....a................
Ambari Server 'start' completed successfully.
Thanks,
Dmytro Sen
