Upgrade Ambari Server

Follow the below steps to upgrade the Ambari version.

Stop Infra-solr Service

Stop the Infra-solr Service from Ambari-UI.

Stop Ambari Server and Agents

Stop Ambari Server

Take the backup of ambari-server configs.

/etc/ambari-server/conf/

Bash
    
 
ambari-server stop
Copy

Stop Agents

Stop Ambari-agent on every cluster node.

Bash
    
 
ambari-agent stop
Copy

Back up Ambari Database

Take the ambari-server backend database backup from the server host.

DB Backup Commands

Bash
    
 
mkdir /tmp/ambari-server_db_bckpmysqldump --databases ambari > /tmp/ambari-server_db_bckp/ambari_mysql_bckp.sql
Copy

The upgraded version Ambari-2.7.8.2-3 supports only Python 3.11. Ensure that Python 3.11 is installed and configured on all the cluster nodes before proceeding with the upgrade.

Add Ambari Repo on Cluster Nodes

Back up the Old Ambari Repository

Run the following command:

Bash
    
 
mv /etc/yum.repos.d/ambari.repo /tmp/
Copy

Retrieve the latest Ambari repository details from Accessing Acceldata Repositories and add it to all cluster nodes.

List the existing Ambari packages

On RHEL:

Bash
    
 
rpm -qa | grep ambari
Copy

On Ubuntu:

Bash
    
 
apt list ambari-*
Copy

Example Output (if the current Ambari version is 3.0.0.0-1):

Bash
    
 
ambari-infra-solr-3.0.0.0-1.noarchambari-agent-3.0.0.0-1.x86_64ambari-server-3.0.0.0-1.x86_64ambari-infra-solr-client-3.0.0.0-1.noarch
Copy

Remove existing Ambari rpm’s

From the Ambari Server node, remove the installed packages before upgrading:

On RHEL:

Bash
    
 
yum remove ambari-server
Copy

On Ubuntu:

Bash
    
 
apt remove ambari-server
Copy

Note

Adjust the package names based on the installed versions on each node.
You can verify the installed packages before removing them using:

On RHEL:

Bash
    
 
rpm -qa | grep ambari
Copy

On Ubuntu:

Bash
    
 
apt list ambari-*
Copy

Make sure the Amabri packages are not installed.

If you are upgrading from any Python 2 based ODP version, make sure to perform the below additional steps to install Python 3.11 and its dependencies on all the hosts before proceeding with the next step.

For Ubuntu 20/22:

Bash
    
 
apt install software-properties-commonadd-apt-repository ppa:deadsnakes/ppaapt updateapt-get install python3.11 curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py/usr/bin/python3.11 get-pip.pypip3.11 install distro lxml rpm
Copy

For RHEL 8:

Bash
    
 
yum install python3.11 python3.11-pip pip3.11 install distro lxml rpm
Copy

Install the latest Ambari-server only on ambari-server node.

Server Node

On RHEL:

Bash
    
 
yum clean allyum install ambari-server -y
Copy

On Ubuntu:

Bash
    
 
apt cleanapt updateapt install ambari-server -y
Copy

Set up Java 17

Make sure to install and update the default Java version as 17 on all the cluster nodes.

For RHEL:

Bash
    
 
yum install java-17-openjdk.x86_64yum install java-17-openjdk-devel.x86_64
Copy

For Ubuntu:

Bash
    
 
apt-get install openjdk-17-jdk openjdk-17-jdk-headless
Copy

Ensure not to remove the jdk8 packages at this state.

Bash
    
​x
 
update-alternatives --config java​There are 2 choices for the alternative java (providing /usr/bin/java).​  Selection    Path                                            Priority   Status------------------------------------------------------------* 0            /usr/lib/jvm/java-17-openjdk-amd64/bin/java      1111      auto mode  1            /usr/lib/jvm/java-11-openjdk-amd64/bin/java      1111      manual mode  2            /usr/lib/jvm/java-8-openjdk-amd64/jre/bin/java   1081      manual mode​Press <enter> to keep the current choice[*], or type selection number: 1
Copy

Set up Python 3.11

Bash
    
 
yum install python3.11
Copy

Make sure to install and update the default Python version as 3.11 on all the cluster nodes.

Bash
    
 
update-alternatives --config python​There are 4 programs which provide 'python'.  Selection    Command-----------------------------------------------*  1           /usr/libexec/no-python   2           /usr/bin/python3   3           /usr/bin/python2 + 4           /usr/bin/python3.11Enter to keep the current selection[+], or type selection number: 4
Copy

Update JSVC

Make sure to Instal the latest version of the bigtop-jsvc-1.2.4 on all the cluster nodes.

For RHEL:

Bash
    
 
yum install bigtop-jsvc* -y
Copy

For Ubuntu:

Bash
    
 
apt install bigtop-jsvc
Copy

Restore Config Files

Restore the ambari.properties and password.dat files, which are backed up at this step: Configuration Backup on this page.

Restore the ambari.properties file

Bash
    
 
cp /etc/ambari-server/conf_bkp/ambari.properties /etc/ambari-server/conf/
Copy

Please override the file by prompting 'y'.

Restore the password.dat file

Bash
    
 
cp /etc/ambari-server/conf_bkp/password.dat /etc/ambari-server/conf/
Copy

Update the java.home and stack.java.home

In this case, set JAVA_HOME to /usr/lib/jvm/java-17-openjdk

File path - /etc/ambari-server/conf/ambari.properties | grep -i java.home

Bash
    
 
java.home=/usr/lib/jvm/java-17-openjdkstack.java.home=/usr/lib/jvm/java-17-openjdkambari.java.home=/usr/lib/jvm/java-17-openjdkmpacks-v2.staging.path=/var/lib/ambari-server/resources/mpacks-v2
Copy

Update the Ambari Database with New Tables and Columns

MySQL

Bash
    
 
mysql -u ambari -pambari​USE ambari;​CREATE TABLE IF NOT EXISTS registries(id BIGINT NOT NULL,registy_name VARCHAR(255) NOT NULL,registry_type VARCHAR(255) NOT NULL,registry_uri VARCHAR(255) NOT NULL,CONSTRAINT PK_registries PRIMARY KEY (id));​CREATE TABLE IF NOT EXISTS mpacks(id BIGINT NOT NULL,mpack_name VARCHAR(255) NOT NULL,mpack_version VARCHAR(255) NOT NULL,mpack_uri VARCHAR(255),registry_id BIGINT,CONSTRAINT PK_mpacks PRIMARY KEY (id),CONSTRAINT uni_mpack_name_version UNIQUE(mpack_name, mpack_version),CONSTRAINT FK_registries FOREIGN KEY (registry_id) REFERENCES registries(id));​ALTER TABLE stack ADD COLUMN mpack_id BIGINT NULL;ALTER TABLE stack ADD CONSTRAINT FK_mpacks FOREIGN KEY (mpack_id) REFERENCES mpacks(id);​ALTER TABLE upgrade ADD COLUMN upgrade_package_stack VARCHAR(255) NOT NULL;
Copy

MariaDB

Bash
    
 
mysql -u ambari -pambari​USE ambari;​CREATE TABLE IF NOT EXISTS registries(id BIGINT NOT NULL,registy_name VARCHAR(255) NOT NULL,registry_type VARCHAR(255) NOT NULL,registry_uri VARCHAR(255) NOT NULL,CONSTRAINT PK_registries PRIMARY KEY (id));​CREATE TABLE IF NOT EXISTS mpacks(id BIGINT NOT NULL,mpack_name VARCHAR(255) NOT NULL,mpack_version VARCHAR(255) NOT NULL,mpack_uri VARCHAR(255),registry_id BIGINT,CONSTRAINT PK_mpacks PRIMARY KEY (id),CONSTRAINT uni_mpack_name_version UNIQUE(mpack_name, mpack_version),CONSTRAINT FK_registries FOREIGN KEY (registry_id) REFERENCES registries(id));​ALTER TABLE stack ADD COLUMN mpack_id BIGINT NULL;ALTER TABLE stack ADD CONSTRAINT FK_mpacks FOREIGN KEY (mpack_id) REFERENCES mpacks(id);​ALTER TABLE upgrade ADD COLUMN upgrade_package_stack VARCHAR(255) NOT NULL;
Copy

Bash
    
 
-- 0) Use Ambari schemaUSE ambari;​-- 1) (Optional) Confirm current FK names on affected tablesSELECT TABLE_NAME, CONSTRAINT_NAMEFROM information_schema.TABLE_CONSTRAINTSWHERE CONSTRAINT_SCHEMA = DATABASE()  AND CONSTRAINT_TYPE = 'FOREIGN KEY'  AND TABLE_NAME IN ('servicecomponentdesiredstate', 'hostcomponentdesiredstate', 'hostcomponentstate')ORDER BY TABLE_NAME, CONSTRAINT_NAME;​-- 2) Drop child FKs first, then parent FKALTER TABLE hostcomponentdesiredstate DROP FOREIGN KEY hstcmpnntdesiredstatecmpnntnme;ALTER TABLE hostcomponentstate DROP FOREIGN KEY hstcomponentstatecomponentname;ALTER TABLE servicecomponentdesiredstate DROP FOREIGN KEY srvccmponentdesiredstatesrvcnm;​-- 3) Alter service_name columns to VARCHAR(255)ALTER TABLE servicecomponentdesiredstate MODIFY COLUMN service_name VARCHAR(255) NOT NULL;ALTER TABLE hostcomponentdesiredstate  MODIFY COLUMN service_name VARCHAR(255) NOT NULL;ALTER TABLE hostcomponentstate         MODIFY COLUMN service_name VARCHAR(255) NOT NULL;​-- 4) Recreate FKsALTER TABLE servicecomponentdesiredstate  ADD CONSTRAINT srvccmponentdesiredstatesrvcnm  FOREIGN KEY (service_name, cluster_id)  REFERENCES clusterservices (service_name, cluster_id);​ALTER TABLE hostcomponentdesiredstate  ADD CONSTRAINT hstcmpnntdesiredstatecmpnntnme  FOREIGN KEY (component_name, service_name, cluster_id)  REFERENCES servicecomponentdesiredstate (component_name, service_name, cluster_id);​ALTER TABLE hostcomponentstate  ADD CONSTRAINT hstcomponentstatecomponentname  FOREIGN KEY (component_name, service_name, cluster_id)  REFERENCES servicecomponentdesiredstate (component_name, service_name, cluster_id);​-- 5) Verify column definitionsSHOW COLUMNS FROM servicecomponentdesiredstate LIKE 'service_name';SHOW COLUMNS FROM hostcomponentdesiredstate  LIKE 'service_name';SHOW COLUMNS FROM hostcomponentstate         LIKE 'service_name';
Copy

Oracle 19C

Bash
    
 
sqlplus / as sysdba ​ALTER SESSION SET CONTAINER=<DB Name>; ALTER SESSION SET CURRENT_SCHEMA = <UserName>;​CREATE TABLE registries(    id NUMBER(19) NOT NULL,    registy_name VARCHAR2(255) NOT NULL,    registry_type VARCHAR2(255) NOT NULL,    registry_uri VARCHAR2(255) NOT NULL,    CONSTRAINT PK_registries PRIMARY KEY (id));​CREATE TABLE mpacks(    id NUMBER(19) NOT NULL,    mpack_name VARCHAR2(255) NOT NULL,    mpack_version VARCHAR2(255) NOT NULL,    mpack_uri VARCHAR2(255),    registry_id NUMBER(19),    CONSTRAINT PK_mpacks PRIMARY KEY (id),    CONSTRAINT uni_mpack_name_version UNIQUE(mpack_name, mpack_version),    CONSTRAINT FK_registries FOREIGN KEY (registry_id) REFERENCES registries(id));​ALTER TABLE stack ADD mpack_id NUMBER(19) NULL;ALTER TABLE stack ADD CONSTRAINT FK_mpacks FOREIGN KEY (mpack_id) REFERENCES mpacks(id);
Copy

Bash
    
 
​
Copy

Ambari Server Schema Upgrade

Before upgrading, ensure a database backup has been taken (as mentioned in Step 6).

Run the Ambari Server upgrade command:

Bash
    
 
ambari-server upgrade -v
Copy

If you encounter the following error:

Bash
    
 
python version after sym links /usr/bin/python3.11Using python  /usr/bin/python3.11Upgrading ambari-serverTraceback (most recent call last):  File "/usr/sbin/ambari-server.py", line 28, in <module>    from ambari_commons.exceptions import FatalException, NonFatalException  File "/usr/lib/ambari-server/lib/ambari_commons/__init__.py", line 21, in <module>    from ambari_commons.os_check import OSCheck, OSConst  File "/usr/lib/ambari-server/lib/ambari_commons/os_check.py", line 25, in <module>    import distroModuleNotFoundError: No module named 'distro'
Copy

Set up the Distro Module

Install the required dependencies on the ambari-server and ambari-agent nodes.

On RHEL:

Bash
    
 
yum install python3.11-pip -y
Copy

Bash
    
 
pip3.11 install distro lxml
Copy

On Ubuntu:

Bash
    
 
apt-get updateapt-get install python3-pippip3 install distro
Copy

Retry the Upgrade again

Bash
    
 
ambari-server upgrade -v
Copy

Response when prompted:

Bash
    
 
Ambari Server configured for MySQL. Confirm you have made a backup of the Ambari Server database [y/n] (n)? y​Enter 'y' to confirm.
Copy

After the successful completion, you must see the following message.

Bash
    
 
Ambari Server 'upgrade' completed successfully.
Copy

Start Ambari-server

Bash
    
 
ambari-server start
Copy

Once started, verify that the Ambari UI is accessible using the same URL as before.

Verify Ambari Version

Verify the upgraded Ambari version in admin->about on top right corner in Ambari UI.

The Ambari version is upgraded successfully.

Upgrade Known Issues

During the migration, the existing GROUPS table in the Ambari database might cause conflicts due to its name. As a result, the Ambari UI might fail to start and throw the following error when attempting to log in.

Bash
    
 
Internal Exception: java.sql.SQLSyntaxErrorException: Table 'ambari.groups_info' doesn't exist​Error Code: 1146Call: SELECT group_id, group_name, group_type, ldap_group, principal_id FROM groups_info WHERE (group_id = ?)  bind => [1 parameter bound]Query: ReadObjectQuery(name="group" referenceClass=GroupEntity )
Copy

To resolve this issue, rename the GROUPS table to groups_info in the Ambari backend database.

For MySQL

Bash
    
 
mysql>  use ambari;
Copy

Bash
    
 
mysql>  show tables lIKE 'groups';
Copy

The response is as follows.

Bash
    
 
+---------------------------+| Tables_in_ambari (groups) |+---------------------------+| groups                    |+---------------------------+
Copy

Verify the data.

Bash
    
 
mysql>  select * from `groups`;
Copy

Rename the table groups to groups_info using the following command.

Bash
    
 
mysql>  RENAME TABLE `groups` TO groups_info;
Copy

Verify the same data as it was in groups table earlier. It must have the same data as it was earlier in groups table.

Bash
    
 
mysql>  select * from groups_info;
Copy

For Oracle

Log into the Oracle server hosting the Ambari database.
Verify the existing GROUPS table.

Bash
    
 
SELECT table_nameFROM user_tablesWHERE table_name LIKE '%GROUPS%';
Copy

The response is as follows.

Bash
    
TABLE_NAME--------------------------------------------------------------------------------------------------------------------------------GROUPS
Copy

Rename the table groups to groups_info using the following command.

Bash
    
 
SQL> RENAME GROUPS TO GROUPS_INFO ;
Copy

The successful rename operation results the output as TABLE Renamed.

Verify the data once renaming is completed.

For Postgres

Log in to the Postgres server hosting the Ambari database.
Verify the existing GROUPS table.

Bash
    
 
ambari=> \dt+
Copy

The response is as follows.

Bash
    
 
.. public | extensionlink                 | table | ambari | 0 bytes    | public | groups                  | table | ambari | 16 kB      | ..
Copy

Rename the table groups to groups_info using the following command.

Bash
    
 
ambari=> ALTER TABLE groups RENAME TO groups_info;
Copy

Last updated on Mar 10, 2026

Was this page helpful?