Skip to main content

CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

matt1206
Just wanting to post this here, as I've spent the last 2 hours fault finding an issue on my servers this morning. cPanel servers, all the latest updates. MariaDB automatically updated to 10.3.26-1 over night as part of the cPanel yum update. As soon as this happened, any XenForo site running on PHP7.2 or below broke! [04-Nov-2020 08:24:41 UTC] PHP Fatal error: Uncaught XF\Db\Exception: MySQL query error [1835]: Malformed communication packet in /home/XXX/public_html/community/src/XF/Db/AbstractStatement.php:212 Stack trace: #0 /home/XXX/public_html/community/src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1835, 'HY000') #1 /home/XXX/public_html/community/src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1835, 'HY000') #2 /home/XXX/public_html/community/src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute() #3 /home/XXX/public_html/community/src/XF/Db/AbstractAdapter.php(116): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT data...', Array) #4 /home/XXX/public_html/community/src/XF/DataRegistry.php(137): XF\Db\AbstractAdapter->fetchPairs('\n\t\t\tSELECT data...') #5 /home/XXX/public_html/community/src/XF/DataRegistry.php(82): XF\DataRegistry->readFromDb(Array, Array) #6 /home/XXX/public_html/community/src/XF/DataRegistry.php(225): XF\DataRegistry- in /home/XXX/public_html/community/src/XF/Db/AbstractStatement.php on line 212
This also prevents any user accessing MySQL via cPanel: Swapping to 7.3 or 7.4 works. I've had to downgrade MariaDB back to the previous version: # yum history info 264 Loaded plugins: fastestmirror, universal-hooks Transaction ID : 264 Begin time : Wed Nov 4 05:35:28 2020 Begin rpmdb : 1964:269d3e2a5fc59faed15b162386618da46afe3e28 End time : 05:36:05 2020 (37 seconds) End rpmdb : 1964:7aac4ca2ee1e5c81b04babc4f774126e1254d10d User : root Return-Code : Success Command Line : --assumeyes --color=never --config /etc/yum.conf update --disablerepo=epel Transaction performed with: Installed rpm-4.11.3-43.el7.x86_64 @base Installed yum-3.4.3-167.el7.centos.noarch @base Installed yum-metadata-parser-1.1.4-10.el7.x86_64 @anaconda Installed yum-plugin-fastestmirror-1.1.31-54.el7_8.noarch @updates Packages Altered: Updated MariaDB-client-10.3.25-1.el7.centos.x86_64 @MariaDB103 Update 10.3.26-1.el7.centos.x86_64 @MariaDB103 Updated MariaDB-common-10.3.25-1.el7.centos.x86_64 @MariaDB103 Update 10.3.26-1.el7.centos.x86_64 @MariaDB103 Updated MariaDB-compat-10.3.25-1.el7.centos.x86_64 @MariaDB103 Update 10.3.26-1.el7.centos.x86_64 @MariaDB103 Updated MariaDB-devel-10.3.25-1.el7.centos.x86_64 @MariaDB103 Update 10.3.26-1.el7.centos.x86_64 @MariaDB103 Updated MariaDB-server-10.3.25-1.el7.centos.x86_64 @MariaDB103 Update 10.3.26-1.el7.centos.x86_64 @MariaDB103 Updated MariaDB-shared-10.3.25-1.el7.centos.x86_64 @MariaDB103 Update 10.3.26-1.el7.centos.x86_64 @MariaDB103 Updated galera-25.3.30-1.el7.centos.x86_64 @MariaDB103 Update 25.3.31-1.el7.centos.x86_64 @MariaDB103 history info
And this fixes the issue. So, I don't know if it's a PHP issue, a MariaDB issue, or something combining everything! I've excluded MariaDB and Galera now from automatic updates on my servers.

Comments

89 comments

Date Votes
  • milstanyu
    I followed @wintech2003 instructions, updated to MariaDB 10.3.27 and everything is working again! Thanks a lot! One question, can I restore the original MariaDB103.repo file now? Thanks again!
    0
  • MindServer
    The problem has been solved, I have not downgraded MariaDB, I have always kept the version 10.3.26-MariaDB, I have waited for the autofixer. I use CLOUDLINUX 7.9 and cPanel v90.0.16 The problem has been solved automatically with the autofixer. Thank you @cPanelSamA

    I did the same thing and have the same problem. WHM/cPanel 90.0.16 CloudLinux 7.9 MariaDB 10.3.26 Anybody can tell me how execute this "autofixer"?.
    @MindServer - for your situation it would be best to stay downgraded to avoid further issues with the system until there is a more official fix.

    Why have here a people that says "the problem is solved" and another people says "the problem still not solved by cPanel"?. The last cPanel version not have the fix, I updated all. Please @cPRex, contact cPanel developers team and get real and reliable information. We need know if this problem is solved in the last cPanel's version or need execute any autofixer and how do this. We cannot update and downgrade 10 times because in this forum have inconsistent information. You can see that with last updates (WHM/cPanel, CloudLinux, MariaDB) have the same problem: img Thank you very much. Have a nice day.
    0
  • cPRex Jurassic Moderator
    @MindServer - the autofixer is only for the cPanel interface problem. You're experiencing the PHP conflict, which isn't officially resolved. You could try the workaround that @wintech2003 posted, that is not something we've tested on our side as we are currently just recommending the downgrade.
    0
  • MindServer
    @MindServer - the autofixer is only for the cPanel interface problem. You're experiencing the PHP conflict, which isn't officially resolved. You could try the workaround that @wintech2003 posted, that is not something we've tested on our side as we are currently just recommending the downgrade.

    But I don't know how can happens this, because we are using PHP 7.4 en all cPanel accounts. We not have any other PHP version enabled. I will disable all updates and wait until cPanel solve him. Please, notify us here when you release a real and 100% reliable fix for all these problems Thank you very much. Have a nice day.
    0
  • cPRex Jurassic Moderator
    If you're still seeing issues with PHP 7.4 it might be best to put in a ticket as there could be something else going on unrelated to these two issues.
    0
  • MindServer
    If you're still seeing issues with PHP 7.4 it might be best to put in a ticket as there could be something else going on unrelated to these two issues.

    Maybe I need execute this script and reboot MySQL service?: Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline. /scripts/autorepair fix_mariadb_show_grants_roles
    Or did this run automatically in yesterday's cPanel updates?
    0
  • cPRex Jurassic Moderator
    Neither of those would be related to issues with PHP 7.4
    0
  • George_Fusioned
    we are using PHP 7.4 en all cPanel accounts. We not have any other PHP version enabled.

    Are your scripts using PDO to connect to MySQL?
    0
  • MindServer
    Are your scripts using PDO to connect to MySQL?
    We only have web sites with WordPress in this servers, we not use any other CMS or script. I not applied this changes:     Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline. Maybe this is the problem?. I waited until cPanel solve him and yesterday I updated all: "yum update" and "/scripts/upcp --force". But still had the problem and I did the MariaDB downgrade again. Have a nice day.
    0
  • George_Fusioned
    MindServer WordPress doesn't use PDO out of the box, so if you're having issues with "Malformed communication packet" errors while using PHP 7.4 on MariaDB v10.3.26 (or 10.2.35) then it might be something else and I would recommend you to open a ticket with cPanel support.
    0
  • filoucp
    In my case ( PDO with PHP7.2 and the Malformed communication packet error ) , It seems the problem only affects the PDO::query function. So rewriting the affected queries with PDO::prepare / PDOStatement::execute do work correctly in my scripts. I know it's not really a good workaround for most, but still better than downgrade or upgrade PHP version in my case.
    0
  • Steini Petur
    This is a temporary fix to upgrade to 10.3.27, until MariaDB pushes 10.3.27 into the 10.3 repo. Use at your own risk. Open file /etc/yum.repos.d/MariaDB103.repo with an editor and change: baseurl = http://yum.mariadb.org/10.3/centos7-amd64
    to baseurl = http://yum.mariadb.org/10.3.27/centos7-amd64
    in order to force yum to update from the v10.3.27 path. Then run yum upgrade to upgrade to 10.3.27 This version fixes both the issue with PHP < 7.2 scripts, as well as the vulnerability reported by Rack911. In some servers I still had to run /scripts/autorepair fix_mariadb_show_grants_roles to fix the MySQL UI error. Finally restart MySQL with /scripts/restartsrv_mysql

    Actually this might be what I can look at, this seems straight forward and so this fixes both the UI and PHP issues, did you run into any issue in any of your nodes (assuming you have many to apply this too)
    0
  • SigmaWeb
    The previous mariadb update (10.3.26) has created problems with some magento installations where mysqld process, produces high CPU load (this doesn't happen with 10.3.25). I was hopping that the new release 10.3.27 will fix this, but unfortunately I see that problem still exists. Does anyone else face this magento - mysqld high CPU load?
    0
  • voip
    MariaDB has released updates to resolve the issue case MDEV-24121:
    0
  • George_Fusioned
    Actually this might be what I can look at, this seems straight forward and so this fixes both the UI and PHP issues, did you run into any issue in any of your nodes (assuming you have many to apply this too)

    Nope, no issues at all with that workaround to install 10.2.36 / 10.3.27 although it might be obsolete now since MariaDB released the packages in their main repos: Emergency Release of MariaDB 10.5.8, 10.4.17, 10.3.27, and 10.2.36 is now available - MariaDB.org
    0
  • George_Fusioned
    The previous mariadb update (10.3.26) has created problems with some magento installations where mysqld process, produces high CPU load (this doesn't happen with 10.3.25). I was hopping that the new release 10.3.27 will fix this, but unfortunately I see that problem still exists. Does anyone else face this magento - mysqld high CPU load?

    We've had a few servers with abnormally high RAM usage after upgrading from 10.3.25 -> 10.3.26, but it's stable again with 10.3.27 I believe it was related to [MDEV-24117] Memory management problem in statistics state for queries that have a large field IN (values) part - Jira
    0
  • Domenico
    When will cPanel update the MariaDB upgrade to the latest and safe version within WHM ?
    0
  • George_Fusioned
    If you run a upcp now, rpmup should get the latest/fixed MariaDB packages.
    0
  • cPRex Jurassic Moderator
    That is correct - cPanel doesn't manage the MariaDB packages as those get pulled directly from the MariaDB repositories.
    0
  • Domenico
    Yeah I know but that was not what I meant. Either way, it is fixed now. Thanks for your reply. :)
    0
  • MindServer
    Hi, I updated MariaDB to version 10.3.27, I updated all with command "yum update" and updated WHM/cPanel with command "/scripts/upcp --force". But this not solved the problem. Finally I executed manually the autofix and now the problem is solved: /scripts/autorepair fix_mariadb_show_grants_roles Why WHM/cPanel not executed automatically the autofix?. Thank you very much.
    0
  • cPRex Jurassic Moderator
    @MindServer - I can't say for sure as there have been many changes to your system that you've outlined in this thread. The autofixer may have run previously, but it was only designed to run once on the system.
    0
  • MindServer
    @MindServer - I can't say for sure as there have been many changes to your system that you've outlined in this thread. The autofixer may have run previously, but it was only designed to run once on the system.

    Thank you very much for your help. Have a nice day.
    0
  • colin12345
    I have the same problem, I couldn't access or create any databases in Cpanel. Just wonder, how do I run the script? I could see the instructions is to run /scripts/autorepair fix_mariadb_show_grants_roles but how do I do this? Is there a step by step instructions on how to do this? Thanks.
    0
  • MindServer
    I have the same problem, I couldn't access or create any databases in Cpanel. Just wonder, how do I run the script? I could see the instructions is to run /scripts/autorepair fix_mariadb_show_grants_roles but how do I do this? Is there a step by step instructions on how to do this? Thanks.

    You only need login with SSH access in your Linux Terminal and execute the command: /scripts/autorepair fix_mariadb_show_grants_roles Copy and paste him in Terminal. Have a nice day.
    0
  • colin12345
    You only need login with SSH access in your Linux Terminal and execute the command: /scripts/autorepair fix_mariadb_show_grants_roles Copy and paste him in Terminal. Have a nice day.

    Thank you for your reply, I'll try this.
    0
  • Kent Brockman
    If you want to solve it with a single chain of commands, you can do this: yum versionlock clear && yum -y upgrade MariaDB-* && /scripts/autorepair fix_mariadb_show_grants_roles && /scripts/upcp
    Worked for us and our servers :)
    0
  • Nurs1927
    If you want to solve it with a single chain of commands, you can do this: yum versionlock clear && yum -y upgrade MariaDB-* && /scripts/autorepair fix_mariadb_show_grants_roles && /scripts/upcp
    Worked for us and our servers :)

    Solved for me whit this command. Thanks.
    0
  • cPRex Jurassic Moderator
    At this point the upstream issues have been resolved. That, in combination with the autofixer means this should no longer be an issue so I'm marking this as resolved.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post