Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL 5.7 upgrade process failed

Discussion in 'Database Discussions' started by Nirjonadda, Feb 6, 2018.

  1. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    524
    Likes Received:
    14
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    I am getting error MySQL 5.7 upgrade. Please let me know this fix.

    Code:
    (XID kb2ypk) 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 234.
        Whostmgr::Mysql::Upgrade::__ANON__(Cpanel::Exception::Database::ConnectError=HASH(0x40184e8)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 120
        Try::Tiny::try(CODE(0x3aba8e8), Try::Tiny::Catch=REF(0x37d2e10)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 235
        Whostmgr::Mysql::Upgrade::upgrade_mysql_with_status(HASH(0x3602698)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 469
        Whostmgr::Mysql::Upgrade::_run_unattended_upgrade(HASH(0x3602698)) 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(0x3d2a3f8), Try::Tiny::Catch=REF(0x3cb82d0)) 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(0x29a3098)) called at /usr/local/cpanel/Cpanel/ForkSync.pm line 66
        Cpanel::ForkSync::new("Cpanel::ForkSync", CODE(0x3b02c80), HASH(0x3602698)) called at /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 383
        Whostmgr::Mysql::Upgrade::unattended_upgrade(HASH(0x3602698)) called at whostmgr/bin/whostmgr.pl line 6585
        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(0x3d2a500), Try::Tiny::Catch=REF(0x3ca4268)) called at whostmgr/bin/whostmgr.pl line 6589
        main::__ANON__(HASH(0x3602698)) 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(0x3c36868)) 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(0x3c36868), "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(0x3c36868)) 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(0x3d31490), Template::Context=HASH(0x3c36868)) 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(0x3c36868), "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(0x3c36868)) 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(0x3ca1080), Template::Context=HASH(0x3c36868)) 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(0x3c36868), Template::Document=HASH(0x3ca1080)) 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(0x3c16c50), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x3a68d50)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Template.pm line 64
        Template::process(Template=HASH(0x3c162a8), "mysqlupgrade/mysqlupgrade-unattended.tmpl", HASH(0x3a68d50)) called at /usr/local/cpanel/Cpanel/Template.pm line 512
        Cpanel::Template::process_template("whostmgr", HASH(0x3a68d50), HASH(0x3ad3b58)) called at /usr/local/cpanel/Cpanel/Template/Interactive.pm line 54
        Cpanel::Template::Interactive::process_template("whostmgr", HASH(0x3a68d50)) called at whostmgr/bin/whostmgr.pl line 6631
        main::mysqlupgrade("mysqlupgrade") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 216
        Whostmgr::Dispatch::_do_call("mysqlupgrade", HASH(0x35feb50), HASH(0x36025c0)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 125
        Whostmgr::Dispatch::dispatch("mysqlupgrade", ARRAY(0x3601978)) called at whostmgr/bin/whostmgr.pl line 582
    
    ScreenShot00083.png
     
  2. Nirjonadda

    Nirjonadda Well-Known Member

    Joined:
    May 8, 2013
    Messages:
    524
    Likes Received:
    14
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Now I do hit retry button then get The upgrade process completed successfully.

    Code:
    Log Messages
    2018-02-06T10:05:13.055718Z 0 [Note] /usr/sbin/mysqld: ready for connections.
    2018-02-06T10:05:12.659400Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
    2018-02-06T10:05:11.048142Z 0 [Note] /usr/sbin/mysqld: ready for connections.
    
    mysqld restarted successfully.
    Obtained version information from system.
    Proceeding with MySQL/MariaDB upgrade despite the following:
    Normal: The selected MySQL version (5.7) is the same as the currently installed MySQL version (5.7). No upgrade will be performed at this time, though the normal upgrade steps will still be executed. This is only useful if a previous upgrade failed while partially completed.
    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 availablehere.
    MySQL upgrade completed successfully
    ------------------------------------
    Checking for Ruby update...
    No Ruby update required.
    ------------------------------------
    
    The upgrade process completed successfully.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    41,484
    Likes Received:
    1,612
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    We'd need access to the affected system to take a closer look to determine what may have happened. Feel free to open a support ticket if you'd like us to investigate this further.

    Thank you.
     
Loading...

Share This Page