Upgrade RTM FAQs

The following are frequently asked questions when upgrading IBM Spectrum LSF RTM.

Why does my Cacti log contain errors after upgrading RTM 10.2 to Fix Pack 15 on RHEL 8?

RTM is sensitive to database performance. If you are upgrading RTM 10.2 on RHEL 8 to Fix Pack 15, and the initial RTM installation included the OPTIMIZE_MYSQL=N configuration in the install.config file, then the database was not optimized. Optimizing the database should be completed prior to upgrading to Fix Pack 15 to ensure the LSF data collectors function properly. Without this optimization, the Cacti log can contains errors as such:
2025/05/21 11:12:25 - ERROR: A database insert failed! Error:'1364', ODBC:S1000, SQL Fragment:'INSERT INTO ...
To workaround this issue:
  1. Copy the sample tuned server.cnf file to your database /etc/my.cnf.d directory; for instance, run:
    cp /opt/IBM/rtm/share/server.cnf.rtm_tuned /etc/my.cnf.d/server-rtm-tuned.cnf
  2. Edit the server.cnf file to match the storage, memory, and threads that the database server supports.
  3. Save the file and restart the database with this command:
    systemctl restart mariadb

During the upgrade process, does RTM handle 300 partition tables correctly?

RTM is changed structurally, but only to grid_jobs, and grid_jobs_finished tables and not to partitioned tables. RTM is designed to work with structural differences in table format between partitioned tables and the two main tables. So, all partitioned tables are untouched and significantly reduces upgrade time.

How long does the upgrade process take for a large RTM environment with several clusters and jobs?

The upgrade process duration depends on:
  1. The RTM version that you are currently using.
  2. The size of grid_jobs and grid_jobs_finished tables. If you are on RTM10.1.0, expect the upgrade to take less than 30 minutes.

The MySQL server is also used by other (non-RTM) services. During the upgrade process, does MySQL become unresponsive for the other services?

Other databases are not disturbed during the upgrade.

How do I move the RTM server from one host to another before upgrading?

It is possible to move RTM from one host to another. Refer to the document called Moving Platform RTM to a New Server on the IBM Spectrum LSF Wiki.

Can I upgrade RTM on a newer version of OS that is not listed in the software requirements?

No, you can only upgrade RTM on the supported OS versions.

How do I reset or recover my password?

If the account is Admin (ID =1), you can do the following:
% mysql cacti
> update user_auth set password=MD5('<enter a password>') where ID=1;
> quit;

If you are unsure of the user ID, then do the following:

Select ID, username from user_auth; and replace ID=1.

How do I reset remote configurations after upgrading?

To reset remote configurations after upgrading your RTM version, download the data poller package, extract the package, and run rpm -Uvh rtm-*.rpm