XF 2.2 Malformed communication packet

spk100

spk100

Member
All of a sudden my site started showing a server 500 error since today morning.
I am on a dedicated server so I asked my host to check and they could not figure out what it was. The server was restarted.

Then they shared this log

[04-Nov-2020 08:13:29 UTC] PHP Fatal error: Uncaught XF\Db\Exception: MySQL query error [1835]: Malformed communication packet in /home/tambram/public_html/src/XF/Db/AbstractStatement.php:228
Stack trace:
#0 /home/tambram/public_html/src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1835, 'HY000')
#1 /home/tambram/public_html/src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1835, 'HY000')
#2 /home/tambram/public_html/src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 /home/tambram/public_html/src/XF/Db/AbstractAdapter.php(175): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT data...', Array)
#4 /home/tambram/public_html/src/XF/DataRegistry.php(138): XF\Db\AbstractAdapter->fetchPairs('\n\t\t\tSELECT data...')
#5 /home/tambram/public_html/src/XF/DataRegistry.php(83): XF\DataRegistry->readFromDb(Array, Array)
#6 /home/tambram/public_html/src/XF/DataRegistry.php(226): XF\DataRegistry->get(Array)
#7 /home/tambram/public_html/src/XF/App.php(1753): X in /home/tambram/public_html/src/XF/Db/AbstractStatement.php on line 228
[04-Nov-2020 08:13:29 UTC] PHP Fatal error: Uncaught XF\Db\Exception: MySQL query error [1835]: Malformed communication packet in /home/tambram/public_html/src/XF/Db/AbstractStatement.php:228
Stack trace:
#0 /home/tambram/public_html/src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1835, 'HY000')
#1 /home/tambram/public_html/src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1835, 'HY000')
#2 /home/tambram/public_html/src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 /home/tambram/public_html/src/XF/Db/AbstractAdapter.php(175): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT data...', Array)
#4 /home/tambram/public_html/src/XF/DataRegistry.php(138): XF\Db\AbstractAdapter->fetchPairs('\n\t\t\tSELECT data...')
#5 /home/tambram/public_html/src/XF/DataRegistry.php(83): XF\DataRegistry->readFromDb(Array, Array)
#6 /home/tambram/public_html/src/XF/DataRegistry.php(226): XF\DataRegistry->get(Array)
#7 /home/tambram/public_html/src/XF/App.php(1753): X in /home/tambram/public_html/src/XF/Db/AbstractStatement.php on line 228

They also said the search_index table was corrupted so it was emptied.

I disabled all plugins via config.php

But still the site is showing server 500 error and is not working.

Any idea what could be the problem?
 
Sort by date Sort by votes
I reported it on the cPanel forum as well, and other people are experiencing the same:

forums.cpanel.net

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

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...
forums.cpanel.net forums.cpanel.net
 
Upvote 0 Downvote
I'm using MariaDB 10.3.26. Working fine for all versions of PHP 7.x.

Why not upgrade MariaDB rather than messing around with downgrading or changing PHP?
 
Upvote 0 Downvote
djbaxter said:
I'm using MariaDB 10.3.26. Working fine for all versions of PHP 7.x.

Why not upgrade MariaDB rather than messing around with downgrading or changing PHP?
Click to expand...
Are you using cPanel? On cPanel, it breaks more than just PHP, as it's affecting Perl also and crucially cPanel's own ability to interact with the database:

support.cpanel.net

Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline.

Symptoms Updating MariaDB to v10.2.35 or v10.3.26 may hinder select sites to be inaccessible and the MySQL Database interface within cPanel may populate "The MySQL server is currently offline." ...
support.cpanel.net support.cpanel.net
 
Upvote 0 Downvote
Feanor said:
Official response from cPanel is now to upgrade PHP: https://support.cpanel.net/hc/en-us/articles/360056803454

If it affects more than PHP, they may be missing some information or perhaps it doesn't affect everyone in the same way.
Click to expand...
They have split their response.

support.cpanel.net

Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline.

Symptoms Updating MariaDB to v10.2.35 or v10.3.26 may hinder select sites to be inaccessible and the MySQL Database interface within cPanel may populate "The MySQL server is currently offline." ...
support.cpanel.net support.cpanel.net

The other article lists why it also affects cPanel itself, and the requirement to downgrade MariaDB.
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

B
  • Solved
XF 2.1 Fatal error when clicking on new posts
Replies
8
Views
960
Ozzy47
Ozzy47
MattW
  • Question Question
XF 2.0 MariaDB 10.3.26-1 Breaks PHP < 7.2
2
Replies
33
Views
5K
djbaxter
D
R
  • Question Question
Forum broke
Replies
1
Views
329
kick
K
Devil™
  • Question Question
XF 2.0 Lost connection to MySQL server at 'reading initial communication packet'
Replies
2
Views
1K
Dnyan
Dnyan
SyTry
  • Question Question
XF 2.0 Fatal error: Uncaught XF\Db\Exception: MySQL query error [1615]
Replies
10
Views
3K
SyTry
SyTry
Back
Top Bottom