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!

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

Discussion in 'Database Discussion' started by Samet Chan, Feb 21, 2019.

  1. Samet Chan

    Samet Chan Well-Known Member

    Joined:
    Jun 24, 2016
    Messages:
    358
    Likes Received:
    32
    Trophy Points:
    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
    
    
     
  2. RadWebHosting

    RadWebHosting Active Member

    Joined:
    May 6, 2016
    Messages:
    40
    Likes Received:
    7
    Trophy Points:
    8
    Location:
    Dallas, Texas
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Noticed this error on a DNSonly node this morning as well. Commenting for updates.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Samet Chan likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,715
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    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:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Samet Chan likes this.
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    5,715
    Likes Received:
    436
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Samet Chan likes this.
  5. Samet Chan

    Samet Chan Well-Known Member

    Joined:
    Jun 24, 2016
    Messages:
    358
    Likes Received:
    32
    Trophy Points:
    103
    cPanel Access Level:
    Root Administrator
    Twitter:
    I'm glad to hear that has been fixed. :)
     
    cPanelLauren likes this.
  6. brianktx

    brianktx Registered

    Joined:
    Mar 23, 2019
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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.
     
    #6 brianktx, Mar 23, 2019
    Last edited by a moderator: Mar 23, 2019
  7. brianktx

    brianktx Registered

    Joined:
    Mar 23, 2019
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    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
     
  8. brianktx

    brianktx Registered

    Joined:
    Mar 23, 2019
    Messages:
    3
    Likes Received:
    1
    Trophy Points:
    3
    Location:
    Flower Mound, Texas
    cPanel Access Level:
    Root Administrator
    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.
     
    cPanelLauren likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice