MariaDB upgrade

Here's the issue we face when we try to upgrade MySQL to MariaDB on a freshly installed server with Centos 7.x 64bit

(XID ygb62w) "/usr/sbin/mysqld" reported error code "2" when it ended: exec(/usr/sbin/mysqld) failed:  at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 241.
    Whostmgr::Mysql::Upgrade::__ANON__(Cpanel::Exception::ProcessFailed::Error=HASH(0x3f87798)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 120
    Try::Tiny::try(CODE(0x37c4b78), Try::Tiny::Catch=REF(0x3f878b8)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 242
    Whostmgr::Mysql::Upgrade::upgrade_mysql_with_status(HASH(0x32c01e8)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 484
    Whostmgr::Mysql::Upgrade::_run_unattended_upgrade(HASH(0x32c01e8)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 50
    Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90
    Try::Tiny::try(CODE(0x39d20a0), Try::Tiny::Catch=REF(0x3a7eda0)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 58
    Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 67
    eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 67
    Cpanel::ForkAsync::do_in_child(CODE(0x25e2260)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 66
    Cpanel::ForkSync::new("Cpanel::ForkSync", CODE(0x37db9e8), HASH(0x32c01e8)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 390
    Whostmgr::Mysql::Upgrade::unattended_upgrade(HASH(0x32c01e8)) called at whostmgr/bin/whostmgr.pl line 6528
    main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90
    Try::Tiny::try(CODE(0x3aad160), Try::Tiny::Catch=REF(0x2320858)) called at whostmgr/bin/whostmgr.pl line 6532
    main::__ANON__(HASH(0x32c01e8)) 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(0x397c938)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 354
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x397c938), "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(0x397c938)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 163
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 161
    Template::Document::process(Template::Document=HASH(0x3a09c28), Template::Context=HASH(0x397c938)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 357
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x397c938), "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(0x397c938)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 163
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 161
    Template::Document::process(Template::Document=HASH(0x39e78d0), Template::Context=HASH(0x397c938)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 357
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 327
    Template::Context::process(Template::Context=HASH(0x397c938), Template::Document=HASH(0x39e78d0)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 94
    eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 91
    Template::Service::process(Template::Service=HASH(0x395cee0), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x38e2f18)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 64
    Template::process(Template=HASH(0x395c538), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x38e2f18)) called at /usr/local/cpanel/Cpanel/Template.pm line 491
    Cpanel::Template::process_template("whostmgr", HASH(0x38e2f18), HASH(0x37ac170)) called at /usr/local/cpanel/Cpanel/Template/Interactive.pm line 54
    Cpanel::Template::Interactive::process_template("whostmgr", HASH(0x38e2f18)) called at whostmgr/bin/whostmgr.pl line 6574
    main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 230
    Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x32c15c8), HASH(0x32c0128)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 144
    Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x32c16e8)) called at whostmgr/bin/whostmgr.pl line 579

GoZen

October 19, 2018 15:22

The answer is ...make sure you change the MySQL root password before the upgrade.

GOT

October 19, 2018 17:49

Error code 2 references not being able to find a file. I suspect something is not right with your current mysql isntallation. Can you verify its ever running? What happens when you enter the command 'mysql' on a command line?

cPanelLauren

October 23, 2018 15:46

Looking through our cases I'm not seeing anything referencing the behavior you experienced though I am glad to see that you were able to identify the solution. Thanks!

MariaDB upgrade

Comments

Didn't find what you were looking for?