problem with mariadb103 to 105 and mysqlgovernor

dzamanakos

Well-Known Member
Feb 15, 2014
63
4
58
cPanel Access Level
Root Administrator
Hi, i'm using cloudlinux with mysqlgovernor and tried to upgrade mariadb from 103 to 105.
As always i used the instructions from CloudLinux OS Shared components

When i entered the
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb104
i got the message that cpanel does not support 104 and run the
/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb105

After a while the new packages were installed but in the last steps that the script upgrades dbs etc, i got an error :

sys.x$schema_tables_with_full_table_scans OK
sys.x$session OK
sys.x$statement_analysis OK
sys.x$statements_with_errors_or_warnings OK
sys.x$statements_with_full_table_scans OK
sys.x$statements_with_runtimes_in_95th_percentile OK
sys.x$statements_with_sorting OK
sys.x$statements_with_temp_tables OK
sys.x$user_summary OK
sys.x$user_summary_by_file_io OK
sys.x$user_summary_by_file_io_type OK
sys.x$user_summary_by_stages OK
sys.x$user_summary_by_statement_latency OK
sys.x$user_summary_by_statement_type OK
sys.x$wait_classes_global_by_avg_latency OK
sys.x$wait_classes_global_by_latency OK
sys.x$waits_by_host_by_latency OK
sys.x$waits_by_user_by_latency OK
sys.x$waits_global_by_latency OK
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 2013 (HY000) at line 448: Lost connection to MySQL server during query
ERROR 2006 (HY000) at line 458: MySQL server has gone away
FATAL ERROR: Upgrade failed
The installation of MySQL for db_governor completed
---
metadata:
command: configureservice
reason: Enabled monitoring for mysql.
result: 1
version: 1
Give mysql service time to start before service checking(15 sec)
Installation of mysql for db_governor completed

The mariadb105 (and the websites that use databases) is working for some days now but it seems that it didnt complete all the steps.

One thing i noticed is that no mariadb105 repo is in /etc/yum.repos.d
One other that after mariadb upgrade, cpanel is installing a new my.cnf, that didnt happened after my upgrade.
I'm worrying that the mariadb105 is running, but some stuff may be unfinished.

I opened a ticket to cloudlinux and the reply was :

-------------------------------------------------------------------------------------------
I've checked your server and can't find any DB Governor-related issues. Please note, that we can provide support to DB Governor-related issues only, and we aren't MySQL experts.
I've run the following command on the server:
mysql_upgrade

And no issues reported:
Phase 7/7: Running 'FLUSH PRIVILEGES'
OK

I would recommend you contact the MySQL database experts in order to update your databases correctly.
---------------------------------------------------------------------------------------------

and

---------------------------------------------------------------------------------------------
In this situation, I can only recommend remove DB Governor, open the ticket with cPanel in order to upgrade MariaDB from 10.3 to 10.5 safely, and then install DB Governor back.
---------------------------------------------------------------------------------------------

If i uninstall at that time (after the upgrade) mysqlgovernor, the version will be on 105. Is there a way to reinstall cpanel's mariadb105 with all the meta-installation scripts running to be sure that the upgrade will be completed and then reinstall mysqlgovernor?


best,
 
Last edited by a moderator:

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,027
313
cPanel Access Level
Root Administrator
Hey there! I checked a test server using MySQL Governor and found that it does not add an entry to /etc/yum.repos.d, so that in itself is not an issue as it is expected behavior. Here's my test machine showing this:

Code:
[[email protected] yum.repos.d]# ll
total 88
-rw-r--r--  1 root root   329 Aug 23 08:01 centos-extras.repo
-rw-r--r--. 1 root root   406 Jul 21 04:51 clmirror.repo
-rw-r--r--  1 root root   391 Sep 16 13:32 cl-mysql.repo
-rw-r--r--. 1 root root   755 Feb 16  2021 cloudlinux-ea4-experimental.repo
-rw-r--r--. 1 root root   660 Feb 16  2021 cloudlinux-ea4.repo
-rw-r--r--. 1 root root 12737 Feb 16  2021 cloudlinux-ea4-rollout.repo
-rw-r--r--. 1 root root   734 Feb 16  2021 cloudlinux-ea4-testing.repo
-rw-r--r--  1 root root   232 Aug 23 08:01 cloudlinux-imunify360.repo
-rw-r--r--  1 root root  2895 Aug 23 08:01 cloudlinux.repo
-rw-r--r--  1 root root 12467 Aug 23 08:01 cloudlinux-rollout.repo
-rw-r--r--  1 root root   257 Sep  8 22:50 cPAddons.repo
-rw-------  1 root root   241 Sep 20 03:28 cpanel-plugins.repo
-rw-r--r--  1 root root   204 Jun 22 17:25 EA4.repo
-rw-r--r--  1 root root  1050 Oct 31  2020 epel.repo
-rw-r--r--  1 root root  1149 Oct 31  2020 epel-testing.repo
-rw-r--r--  1 root root   771 Sep  8 22:38 Mysql57.repo
[[email protected] yum.repos.d]# mysql --version
mysql  Ver 15.1 Distrib 10.3.31-MariaDB, for Linux (x86_64) using readline 5.1
If everything is currently working well it's hard for me to recommend changing anything. If you'd like to submit a ticket to our team we could at least check the system and make sure everything is in place that we expect to be there.
 

dzamanakos

Well-Known Member
Feb 15, 2014
63
4
58
cPanel Access Level
Root Administrator
Thank you, for now no users reported any problems so i'll not do any changes.

Just in case, if anyone wants to upgrade from 103 to 105 and is using mysqlgovernor, the only way, at that time, to do that (final ticket reply from cloudlinux) is to :

- uninstall mysqlgovernor
- update mariadb through WHM menu
- install mysqlgovernor

best,
 

cPRex

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,027
313
cPanel Access Level
Root Administrator
That's very interesting as they don't mention that in their documentation, and I've been able to switch back and forth without issues. I'm wondering if that is for your specific situation, or if they really mean that to be in general.

 

HostXNow_Chris

Well-Known Member
PartnerNOC
Jan 22, 2016
76
44
68
United Kingdom
cPanel Access Level
DataCenter Provider
Twitter
That's very interesting as they don't mention that in their documentation, and I've been able to switch back and forth without issues. I'm wondering if that is for your specific situation, or if they really mean that to be in general.

Is this still the same issue i.e have to

- uninstall mysqlgovernor
- update mariadb through WHM menu
- install mysqlgovernor

Or does it upgrade properly now without having to uninstall mysqlgovernor first? I think cPanel created a password updater-script in the end?
 

HostXNow_Chris

Well-Known Member
PartnerNOC
Jan 22, 2016
76
44
68
United Kingdom
cPanel Access Level
DataCenter Provider
Twitter
Hello! I have reached out to CloudLinux for confirmation. As long as you are on cPanel version 98 or higher, and have the latest MySQLgovernor packages, you shouldn't need to perform these steps. Please let me know if you run into any issues.
Which are those? How to check?