Applicable to:
- Plesk for Linux
Symptoms
-
Websites configured with PHP 7.2 or lower version are unavailable when establishing a database connection and the following error message is shown:
CONFIG_TEXT: SQLSTATE[HY000]: General error: 1835 Malformed communication packet
-
MariaDB server has been updated to
v10.2.35orv10.3.26versions:# mysql -V
mysql Ver 15.1 Distrib 10.2.35-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 - Error in Domains > example.com > Logs:
CONFIG_TEXT: AH01071: Got error 'PHP message: PHP Warning: mysqli_query(): MySQL server has gone away in /var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php on line 2033\nPHP message: PHP Warning: mysqli_query(): Error reading result set's header in /var/www/vhosts/example.com/httpdocs/wp-includes/wp-db.php
Error in /var/log/messages:
CONFIG_TEXT: kernel: Out of memory: Kill process 196397 (mysqld) score 586 or sacrifice child
Cause
This issue is caused by the MariaDB bug with ID #MDEV-24121. Which was fixed by MariaDB on versions 10.2.36, 10.3.27, 10.4.17, and 10.5.8.
Resolution
The next packages update is already available, so if the server has been affected, install the lastest MariaDB updates:
-
Log into Plesk
-
Go to Tools & Settings > System Updates
-
Search for "MariaDB"
-
Choose all the packages and click Update
Alternatively, updates can be installed via CLI:
-
Connect to the server via SSH
-
Update MariaDB packages:
# yum -y update MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
-
Connect to the server via SSH.
-
Update MariaDB packages:
# apt-get upgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Comments
3 comments
I ran this command below on 18.04.5 LTS Plesk Obsidian 18.0.31 update #1
using Mariadb 10.3.25
upgraded from here https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux-
# apt-get update MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
returns error:
root@server1:~# apt-get update MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
E: The update command takes no arguments
what can be the issue ?
Thanks
Spiro
Not working
Hello Spirogg and Milan Patel
Looks like there was a typo, should be:
apt-get upgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Fixed the article.
Please sign in to leave a comment.