E

MySQL down after failed MariaDB upgrade

Log Messages
Jul 8 19:15:07 r00t mysqld: mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
Jul 8 19:15:07 r00t mysqld: mysqld: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 3.
2022-07-08T19:09:58.668794Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29) MySQL Community Server - GPL.

mysql has failed. Contact your system administrator if the service does not automagically recover.
Mysql did not start up after upgrade; there may be a problem in /etc/my.cnf. at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 859.
Failed to get MySQL version from server: STDERR: mysqld: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 3.
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!


Cpanel::Exception::ProcessFailed::Error/(XID k28ukm) “/usr/sbin/mysqld” reported error code “1” when it ended: mysqld: [ERROR] Found option without preceding group in config file /etc/my.cnf at line 3.
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!

at /usr/local/cpanel/Cpanel/ChildErrorStringifier.pm line 161.
Cpanel::ChildErrorStringifier::to_exception(Cpanel::SafeRun::Object=HASH(0x5d58e20)) called at /usr/local/cpanel/Cpanel/ChildErrorStringifier.pm line 140
Cpanel::ChildErrorStringifier::die_if_error(Cpanel::SafeRun::Object=HASH(0x5d58e20)) called at /usr/local/cpanel/Cpanel/SafeRun/Object.pm line 681
Cpanel::SafeRun::Object::die_if_error(Cpanel::SafeRun::Object=HASH(0x5d58e20)) called at /usr/local/cpanel/Cpanel/SafeRun/Object.pm line 662
Cpanel::SafeRun::Object::new_or_die("Cpanel::SafeRun::Object", "program", "/usr/sbin/mysqld", "args", ARRAY(0x5d58400)) called at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 180
Cpanel::MysqlUtils::Version::current_mysql_version() called at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 90
Cpanel::MysqlUtils::Version::mysqlversion() called at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 98
Cpanel::MysqlUtils::Version::uncached_mysqlversion() called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 972
Whostmgr::Mysql::Upgrade::__ANON__() called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 100
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 91
Try::Tiny::try(CODE(0x5d58508), Try::Tiny::Catch=REF(0x5d58580)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 979
Whostmgr::Mysql::Upgrade::get_current_version(Cpanel::Output::Multi=HASH(0x4f12ca0)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 1029
Whostmgr::Mysql::Upgrade::_update_conf_with_current_version_and_check_for_blockers(HASH(0x3eb1a28)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 509
Whostmgr::Mysql::Upgrade::_validate_conf(HASH(0x3eb1a28), 4) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 476
Whostmgr::Mysql::Upgrade::_write_step(HASH(0x1c25730), HASH(0x3eb1a28)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 496
Whostmgr::Mysql::Upgrade::stop_step(4, 4, HASH(0x3eb1a28)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 275
Whostmgr::Mysql::Upgrade::_mysql_upgrade_error("Mysql did not start up after upgrade; there may be a problem "..., HASH(0x3eb1a28)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 206
Whostmgr::Mysql::Upgrade::__ANON__() called at /usr/local/cpanel/Cpanel/ForkSync.pm line 115
Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 100
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 91
Try::Tiny::try(CODE(0x52085b8), Try::Tiny::Catch=REF(0x516ed88)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 123
Cpanel::ForkSync::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 72
eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 72
Cpanel::ForkAsync::do_in_child(CODE(0x521b3a0)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 144
Cpanel::ForkSync::new_with_parent_callback("Cpanel::ForkSync", undef, CODE(0x4f132e8)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 77
Cpanel::ForkSync::new("Cpanel::ForkSync", CODE(0x4f132e8)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 218
Whostmgr::Mysql::Upgrade::upgrade_mysql_with_status(HASH(0x3eb1a28)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 97
Whostmgr::Mysql::Upgrade::upgrade_mysql(HASH(0x3eb1a28)) called at whostmgr/bin/whostmgr.pl line 6713
main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 100
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 91
Try::Tiny::try(CODE(0x4f14318), Try::Tiny::Catch=REF(0x4b163b0)) called at whostmgr/bin/whostmgr.pl line 6717
main::__ANON__(HASH(0x3eb1a28)) called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade4.tmpl line 9
eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade4.tmpl line 9
eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade4.tmpl line 7
Template::Document::__ANON__(Template::Context=HASH(0x46d6330)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 349
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 322
Template::Context::process(Template::Context=HASH(0x46d6330), "runner") called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/runner.tmpl line 129
eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/runner.tmpl line 7
Template::Document::__ANON__(Template::Context=HASH(0x46d6330)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 165
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 163
Template::Document::process(Template::Document=HASH(0x4f124d8), Template::Context=HASH(0x46d6330)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 352
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 322
Template::Context::process(Template::Context=HASH(0x46d6330), "mysqlupgrade/runner.tmpl", HASH(0x468ab70)) called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade4.tmpl line 11
eval {...} called at /usr/local/cpanel/whostmgr/docroot/templates/mysqlupgrade/mysqlupgrade4.tmpl line 7
Template::Document::__ANON__(Template::Context=HASH(0x46d6330)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 165
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Document.pm line 163
Template::Document::process(Template::Document=HASH(0x46812c8), Template::Context=HASH(0x46d6330)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 352
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Context.pm line 322
Template::Context::process(Template::Context=HASH(0x46d6330), Template::Document=HASH(0x46812c8)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 94
eval {...} called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template/Service.pm line 91
Template::Service::process(Template::Service=HASH(0x457c328), "mysqlupgrade/mysqlupgrade4.tmpl", HASH(0x4526478)) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 66
Template::process(Template=HASH(0x46fdc68), "mysqlupgrade/mysqlupgrade4.tmpl", HASH(0x4526478)) called at /usr/local/cpanel/Cpanel/Template.pm line 471
Cpanel::Template::process_template("whostmgr", HASH(0x4526478), HASH(0x3eb19c8)) called at /usr/local/cpanel/Cpanel/Template/Interactive.pm line 54
Cpanel::Template::Interactive::process_template("whostmgr", HASH(0x4526478)) called at whostmgr/bin/whostmgr.pl line 6764
main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 366
Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x3eb1f80), HASH(0x3eb18f0)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 178
Whostmgr::Dispatch::dispatch("mysqlupgrade", 1, ARRAY(0x3eb1758), HASH(0x3eb18f0)) called at whostmgr/bin/whostmgr.pl line 439
Obtained version information from mysql data files.
Proceeding with MySQL/MariaDB upgrade despite the following:
Critical: MySQL enables "strict mode" by default as of version 5.7. Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MySQL are compatible before upgrading. More information about strict mode is available here.
Author
elyspace
Views
243
First release
Last update
Rating
0.00 star(s) 0 ratings