MariaDB MariaDB 10.5.7, 10.4.16, 10.3.26, 10.2.35 and 10.1.48 now available

The MariaDB Foundation is pleased to announce the availability of MariaDB 10.5.7, MariaDB 10.4.16, MariaDB 10.3.26, MariaDB 10.2.35 and MariaDB 10.1.48, the latest stable releases in their respective series. […]

---

The post MariaDB 10.5.7, 10.4.16, 10.3.26, 10.2.35 and 10.1.48 now available appeared first on MariaDB.org.

Continue reading...

 

apparently issue is with <=7.2 mysqlnd which doesn't have fixes 7.3+ have [MDEV-24121] Recent MariaDB update appears to have introduced a DB connection issue for PHP < 7.3 (or anything using PDO) - Jira

I am testing Centmin Mod PHP backported mysqlnd fixes from 7.3 to 5.6.40, 7.0.33, 7.1.33 and 7.2.x

patched 7.0.33, 7.1.33 and 7.2.x seem to work with Wordpress on MariaDB 10.3.26 no 500 errors so far

7.0.33



7.1.33



7.2.34



Just tested 5.6.40

 

Good to know. With your Wordpress 500 issues were they happening everywhere or just specific url/parts of Wordpress ?

 

patched PHP 7.2.34 outlined here seems to be working on Xenforo 2.1 test forums



without the backported mysqlnd PHP 7.3 patch to PHP 7.2.x, you will get the errors for "Exception: MySQL query error [1835]: Malformed communication packet" like in Centmin Mod PHP-FPM error log and on frontend will get Internal 500 errors

Code (Text):

[05-Nov-2020 17:32:58 UTC] PHP Fatal error:  Uncaught XF\Db\Exception: MySQL query error [1835]: Malformed communication packet in /home/nginx/domains/domain.com/public/src/XF/Db/AbstractStatement.php:228
Stack trace:
#0 /home/nginx/domains/domain.com/public/src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1835, 'HY000')
#1 /home/nginx/domains/domain.com/public/src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1835, 'HY000')
#2 /home/nginx/domains/domain.com/public/src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 /home/nginx/domains/domain.com/public/src/XF/Db/AbstractAdapter.php(175): XF\Db\AbstractAdapter->query('\n\t\t\tSELECT data...', Array)
#4 /home/nginx/domains/domain.com/public/src/XF/DataRegistry.php(138): XF\Db\AbstractAdapter->fetchPairs('\n\t\t\tSELECT data...')

 

Folks can try testing my backported patches via Centmin Mod 123.09beta01 using commands below

Patch centminmod 123.09beta01 and then run centmin.sh menu option 5 to recompile PHP 7.2.34 to see if you get Malformed communication packet errors

Code (Text):

cmupdate
cmdir
wget -4 -O php-mysqlnd-fix.patch https://gist.github.com/centminmod/fd058bb2631bcbd7679917285e85c745/raw/php-mysqlnd-fix.patch
patch -p1 < php-mysqlnd-fix.patch
./centmin.sh

to reverse patch and then run centmin.sh menu option 5 to recompile PHP 7.2.34

Code (Text):

cmupdate
cmdir
rm -f patches/php/php*-mysqlnd-fix.patch
./centmin.sh

eventually once the patches confirm to work, then I'll do official commit to 123.09beta01 branch and you can update via the below commands removing first the patches added so that official commit can re-add them via cmupdate

Code (Text):

cmdir
rm -f patches/php/php*-mysqlnd-fix.patch
cmupdate
./centmin.sh

No longer need above patch method as I updated Centmin Mod 123.09beta01 with the new backported patches and added a variable to control whether the backported patches are applied or not. Details outlined at Beta Branch - add PHP 7.0.33, 7.1.33 & 7.2 mysqlnd fix patch for MariaDB in 123.09beta01

 

maybe a specific plugin?

 

I see. So have you tried my backported PHP mysqlnd patch fixes in Centmin Mod yet ?

Particularly interested in anyone using the patched PHP 5.6.40 to see if it fixes their issues. I don't have any web apps which run on PHP 5.6.40 that have this issue so harder to check if the backported PHP 5.6.40 patch is working.

 

No longer need above patch method as I updated Centmin Mod 123.09beta01 with the new backported patches for mysqlnd fix in PHP <= 7.2 related to MariaDB malformed communication packet errors and added a variable to control whether the backported patches are applied or not. Details outlined at Beta Branch - add PHP 7.0.33, 7.1.33 & 7.2 mysqlnd fix patch for MariaDB in 123.09beta01

 

Thanks for the confirmation which was for patched PHP 7.2 I assumed ?

Yeah PHP 5.6 is becoming the black sheep for testing