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

Samet Chan

February 21, 2019 10:07

I've just upgraded MariaDB 10.2 to 10.3 after completed and error there. A warning occurred while processing this directive.


(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

Comments

7 comments

RadWebHosting

February 21, 2019 18:18
Noticed this error on a DNSonly node this morning as well. Commenting for updates.
0
cPanelLauren

February 21, 2019 21:34
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: root@server etc]# mysql --version mysql Ver 15.1 Distrib 10.3.13-MariaDB, for Linux (x86_64) using readline 5.1 [root@server 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.
0
cPanelLauren

February 27, 2019 15:55
Hello, I just wanted to let you know that this issue has been marked as resolved in v78.0.13 of cPanel/WHM per the change logs here: 78 Change Log - Change Logs - cPanel Documentation. Please let us know if you experience any further issues with this. Thanks!
0
Samet Chan

February 27, 2019 16:29
Hello, I just wanted to let you know that this issue has been marked as resolved in v78.0.13 of cPanel/WHM per the change logs here:
0
brianktx

March 23, 2019 20:08
Hello, I too ran into some issues when upgrading from 2.0 to 3.0 using whm upgrade. (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.
0
brianktx

March 23, 2019 20:23
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
0
brianktx

March 23, 2019 23:24
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.
0

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?