Search
This page explains how to resume and finalize the ODP stack upgrade.
Resume Upgrade
Resume the ODP Stack Upgrade from its Paused state. Upon upgrade completion, you can see the two options.
**Finalize Later—**Choosing this option preserves the ability to downgrade or roll back to the previous version.
**Finalize—**Once selected, version 3.3.6.4-1 becomes permanent, and rollback is no longer possible.
Navigate to the Ambari UI Home page and perform the Start All services from Actions.
Verify the Upgrade
Mpacks Restore
Perform the following steps to restore Mpacks.
Install Mpacks on the Ambari Server node.
ambari-server install-mpack --mpack=ambari-mpacks-airflow-2.8.3.tar.gz
ambari-server install-mpack --mpack=ambari-mpacks-impala-4.4.1.tar.gz
ambari-server install-mpack --mpack=ambari-mpacks-ozone-1.4.1.tar.gz
ambari-server install-mpack --mpack=ambari-mpacks-spark3-3.5.5.tar.gz
Install the services from Ambari.
Stop the Mpack services from ambari UI.
Restore the config at mysql DB.
Now restore the configuration backups for the mpacks that were taken during the upgrade prerequisites phase. For details, see Backup Ambari Configuration (Mpacks).
mysql> use ambari
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
Restore Airflow Config
Run the following script.
mysql>
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = 'AIRFLOW') and service_name = 'AIRFLOW'),
config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = 'AIRFLOW') and service_name = 'AIRFLOW')
where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'AIRFLOW' and version =
(select max(version) from serviceconfig where service_name = 'AIRFLOW')) );
Response:
Query OK, 3 rows affected (0.06 sec)
Rows matched: 27 Changed: 3 Warnings: 0
Restore Ozone Configs
Run the following script.
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = 'OZONE') and service_name = 'OZONE'),
config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = 'OZONE') and service_name = 'OZONE')
where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'OZONE' and version =
(select max(version) from serviceconfig where service_name = 'OZONE')) );
Response:
Query OK, 16 rows affected (0.06 sec)
Rows matched: 24 Changed: 16 Warnings: 0
Restore Impala Configs
Run the following script.
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = 'IMPALA') and service_name = 'IMPALA'),
config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = 'IMPALA') and service_name = 'IMPALA')
where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'IMPALA' and version =
(select max(version) from serviceconfig where service_name = 'IMPALA')) );
Response:
Query OK, 1 row affected (0.04 sec)
Rows matched: 4 Changed: 1 Warnings: 0
Restore Kudu Configs
Run the following script.
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = 'KUDU') and service_name = 'KUDU'),
config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = 'KUDU') and service_name = 'KUDU')
where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'KUDU' and version =
(select max(version) from serviceconfig where service_name = 'KUDU')) );
Response:
Query OK, 1 row affected (0.03 sec)
Rows matched: 10 Changed: 1 Warnings: 0
Restore Spark3 Configs
Run the following script.
update clusterconfig a set config_data = (select config_data from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM service_conf_bck.configs_prior_patch WHERE service_name = 'SPARK3') and service_name = 'SPARK3'),
config_attributes = (select config_attributes from service_conf_bck.configs_prior_patch b where a.type_name = b.type_name and version = (SELECT MAX(version) FROM serviceconfig WHERE service_name = 'SPARK3') and service_name = 'SPARK3')
where config_id in (select config_id from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'SPARK3' and version =
(select max(version) from serviceconfig where service_name = 'SPARK3')) );
Response:
Query OK, 1 row affected (0.03 sec)
Rows matched: 12 Changed: 1 Warnings: 0
Was this page helpful?