SOLVED [CPANEL-25629] MariaDB 10.2 upgraded to 10.3 completed/error

Samet Chan

Well-Known Member
Jun 24, 2016
359
32
103
cPanel Access Level
Root Administrator
Twitter
I've just upgraded MariaDB 10.2 to 10.3 after completed and error there.

A warning occurred while processing this directive.
Code:
(XID sqzbcn) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 241.
    Whostmgr::Mysql::Upgrade::__ANON__(Cpanel::Exception::Database::ConnectError=HASH(0x30c3df0)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 118
    Try::Tiny::try(CODE(0x2b85c38), Try::Tiny::Catch=REF(0x31279e0)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 242
    Whostmgr::Mysql::Upgrade::upgrade_mysql_with_status(HASH(0x26c4930)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 493
    Whostmgr::Mysql::Upgrade::_run_unattended_upgrade(HASH(0x26c4930)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 50
    Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
    Try::Tiny::try(CODE(0x3024dd8), Try::Tiny::Catch=REF(0x3024c70)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 58
    Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68
    eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68
    Cpanel::ForkAsync::do_in_child(CODE(0x1e90738)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 66
    Cpanel::ForkSync::new("Cpanel::ForkSync", CODE(0x2b9f2c0), HASH(0x26c4930)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 399
    Whostmgr::Mysql::Upgrade::unattended_upgrade(HASH(0x26c4930)) called at whostmgr/bin/whostmgr.pl line 6619
    main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
    Try::Tiny::try(CODE(0x3024c40), Try::Tiny::Catch=REF(0x1c2eb50)) called at whostmgr/bin/whostmgr.pl line 6623
    main::__ANON__(HASH(0x26c4930)) called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 10
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 10
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 7
    Template::Document::__ANON__(Template::Context=HASH(0x2d30728)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 354
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x2d30728), "runner") called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/runner.tmpl line 30
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/runner.tmpl line 7
    Template::Document::__ANON__(Template::Context=HASH(0x2d30728)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 162
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 160
    Template::Document::process(Template::Document=HASH(0x2db7450), Template::Context=HASH(0x2d30728)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 357
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x2d30728), "mysqlupgrade/runner.tmpl") called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 12
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 7
    Template::Document::__ANON__(Template::Context=HASH(0x2d30728)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 162
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 160
    Template::Document::process(Template::Document=HASH(0x2d98910), Template::Context=HASH(0x2d30728)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 357
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x2d30728), Template::Document=HASH(0x2d98910)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 94
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 91
    Template::Service::process(Template::Service=HASH(0x2cf30a8), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x29718d8)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 64
    Template::process(Template=HASH(0x2ce4188), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x29718d8)) called at /usr/local/cpanel/Cpanel/Template.pm line 465
    Cpanel::Template::process_template("whostmgr", HASH(0x29718d8), HASH(0x2bfdcd0)) called at /usr/local/cpanel/Cpanel/Template/Interactive.pm line 54
    Cpanel::Template::Interactive::process_template("whostmgr", HASH(0x29718d8)) called at whostmgr/bin/whostmgr.pl line 6666
    main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
    Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x26c4a68), HASH(0x26c4840)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
    Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x26c4af8), HASH(0x26c4840)) called at whostmgr/bin/whostmgr.pl line 398
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
7,907
626
263
Houston
cPanel Access Level
DataCenter Provider
I got this error when attempting to update to MariaDB 10.3 as well. I was able to find a case that addresses this: CPANEL-25629 Maria DB 10.3 unknown configuration options cause failures during upgrades. This case is slated to be fixed in v78 of cPanel though it is not in the product as of right now.


I did find that I was able to successfully restart MariaDB 10.3 directly after the upgrade:

Code:
[email protected] etc]# mysql --version
mysql  Ver 15.1 Distrib 10.3.13-MariaDB, for Linux (x86_64) using readline 5.1
[[email protected] etc]# /scripts/restartsrv_mysql
Waiting for “mysql” to restart ……waiting for “mysql” to initialize ………finished.

Service Status
    mysql (/usr/sbin/mysqld) is running as mysql with PID 10140 (systemd+/proc check method).

Startup Log
    Feb 21 16:30:06 server.myhost.us systemd[1]: Starting MariaDB 10.3.13 database server...
    Feb 21 16:30:07 server.myhost.us mysqld[10140]: 2019-02-21 16:30:07 0 [Note] /usr/sbin/mysqld (mysqld 10.3.13-MariaDB) starting as process 10140 ...
    Feb 21 16:30:07 server.myhost.us systemd[1]: Started MariaDB 10.3.13 database server.

Log Messages
    2019-02-21 16:30:07 0 [Note] /usr/sbin/mysqld: ready for connections.
    2019-02-21 16:30:06 0 [Note] /usr/sbin/mysqld: Shutdown complete
    2019-02-21 16:26:37 0 [Note] /usr/sbin/mysqld: ready for connections.
    2019-02-21 16:26:36 0 [Note] /usr/sbin/mysqld: Shutdown complete
    2019-02-21 16:26:35 0 [Note] /usr/sbin/mysqld: ready for connections.
    2019-02-21 16:26:34 0 [Note] /usr/sbin/mysqld: Shutdown complete
    Feb 21 16:30:07 server mysqld: 2019-02-21 16:30:07 0 [Note] /usr/sbin/mysqld (mysqld 10.3.13-MariaDB) starting as process 10140 ...

mysql restarted successfully.
 
  • Like
Reactions: Samet Chan

brianktx

Registered
Mar 23, 2019
3
1
3
Flower Mound, Texas
cPanel Access Level
Root Administrator
Hello, I too ran into some issues when upgrading from 2.0 to 3.0 using whm upgrade.
Code:
(XID g9aavq) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 241.
    Whostmgr::Mysql::Upgrade::__ANON__(Cpanel::Exception::Database::ConnectError=HASH(0x3dea858)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 118
    Try::Tiny::try(CODE(0x34f69d8), Try::Tiny::Catch=REF(0x3deaf30)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 242
    Whostmgr::Mysql::Upgrade::upgrade_mysql_with_status(HASH(0x3034620)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 493
    Whostmgr::Mysql::Upgrade::_run_unattended_upgrade(HASH(0x3034620)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 50
    Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
    Try::Tiny::try(CODE(0x3b5b418), Try::Tiny::Catch=REF(0x3b5b2b0)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 58
    Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68
    eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68
    Cpanel::ForkAsync::do_in_child(CODE(0x1e90668)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 66
    Cpanel::ForkSync::new("Cpanel::ForkSync", CODE(0x350f6d0), HASH(0x3034620)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 399
    Whostmgr::Mysql::Upgrade::unattended_upgrade(HASH(0x3034620)) called at whostmgr/bin/whostmgr.pl line 6669
    main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 97
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 88
    Try::Tiny::try(CODE(0x3b5b280), Try::Tiny::Catch=REF(0x1c3b938)) called at whostmgr/bin/whostmgr.pl line 6673
    main::__ANON__(HASH(0x3034620)) called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 10
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 10
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 7
    Template::Document::__ANON__(Template::Context=HASH(0x36a84b0)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 354
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x36a84b0), "runner") called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/runner.tmpl line 30
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/runner.tmpl line 7
    Template::Document::__ANON__(Template::Context=HASH(0x36a84b0)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 162
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 160
    Template::Document::process(Template::Document=HASH(0x372ef18), Template::Context=HASH(0x36a84b0)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 357
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x36a84b0), "mysqlupgrade/runner.tmpl") called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 12
    eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade-unattended.tmpl line 7
    Template::Document::__ANON__(Template::Context=HASH(0x36a84b0)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 162
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 160
    Template::Document::process(Template::Document=HASH(0x370f988), Template::Context=HASH(0x36a84b0)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 357
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x36a84b0), Template::Document=HASH(0x370f988)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 94
    eval {...} called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 91
    Template::Service::process(Template::Service=HASH(0x365fb48), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x3197e58)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 64
    Template::process(Template=HASH(0x3655910), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x3197e58)) called at /usr/local/cpanel/Cpanel/Template.pm line 465
    Cpanel::Template::process_template("whostmgr", HASH(0x3197e58), HASH(0x32e3628)) called at /usr/local/cpanel/Cpanel/Template/Interactive.pm line 54
    Cpanel::Template::Interactive::process_template("whostmgr", HASH(0x3197e58)) called at whostmgr/bin/whostmgr.pl line 6716
    main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
    Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x3034758), HASH(0x3034530)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
    Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x1e89ae0), HASH(0x3034530)) called at whostmgr/bin/whostmgr.pl line 448


Log Messages
2019-03-23 13:39:40 0 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_support_xa=0'
i've changed the "0" to a "1" and still get the unknown variable message for "1".

I'm still searching to find what I need to do to get this back online. Any help would be greatly appreciated.
 
Last edited by a moderator:

brianktx

Registered
Mar 23, 2019
3
1
3
Flower Mound, Texas
cPanel Access Level
Root Administrator
This is currently what shows in whm for mysql / mariadb upgrade

Warning: The last run of the MySQL upgrade wizard failed. If you have corrected the problems that led to this failure it is highly recommended that you resume your previous upgrade rather than beginning a new one.


Current step number: 4
Starting MySQL/MariaDB version: 10.3
Selected MySQL/MariaDB version: 10.3
Upgrade Type: Unattended Upgrade
 

brianktx

Registered
Mar 23, 2019
3
1
3
Flower Mound, Texas
cPanel Access Level
Root Administrator
Log Messages 2019-03-23 13:39:40 0 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_support_xa=0'
So, I removed the "innodb_support_xa=0" from my /etc/my.cnf file. started upgrade again and now we have an upgraded mariadb!!! yeah. Currently all is well and no assistance needed. a big thanks to all that contribute to these forums, they've helped me on more than one occasion.
 
  • Like
Reactions: cPanelLauren