Join the community today
Register Now

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

Discussion in 'MariaDB & General MySQL news & discussions' started by eva2000, Nov 4, 2020.

  1. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  2. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    All my servers start throwing 500 errors after the upgrade :(

    Invision, Wordpress and Opencart...

    After downgrading to the previous version all working again :)

    It seems that there is a bug about all these new versions as i got it on 10.3 and 10.2 for sure....

    Not sure for 10.1

    A day earlier i did the system updates and when i try to update MariaDB was the only software to update so i am 100% sure that it has a problem...
     
    Last edited: Nov 5, 2020
  3. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
  4. rdan

    rdan Well-Known Member

    5,003
    1,201
    113
    May 25, 2014
    Ratings:
    +1,827
    Local Time:
    8:08 PM
    Mainline
    10.2
    What PHP version you're using?
     
  5. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    As described on the issue anything less than 7.3 or anything using PDO has the issue.
     
  6. rdan

    rdan Well-Known Member

    5,003
    1,201
    113
    May 25, 2014
    Ratings:
    +1,827
    Local Time:
    8:08 PM
    Mainline
    10.2
    That's why I ask what's your PHP version, I thought you are already using 7.4.x.
     
  7. Revenge

    Revenge Active Member

    459
    93
    28
    Feb 21, 2016
    Portugal
    Ratings:
    +350
    Local Time:
    12:08 PM
    1.9.x
    10.1.x
    Im using PGP 7.4. But i will wait a bit before upgrading.
     
  8. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    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

    wordpress-php7033-mariadb-10.3.26-01.png

    7.1.33

    wordpress-php7133-mariadb-10.3.26-01.png

    7.2.34

    wordpress-php7234-mariadb-10.3.26-01.png

    Just tested 5.6.40

    wordpress-php5640-mariadb-10.3.26-01.png
     
    Last edited: Nov 6, 2020
  9. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Oleksandr Byelkin added a comment:

     
  10. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Good to know. With your Wordpress 500 issues were they happening everywhere or just specific url/parts of Wordpress ?
     
  11. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    patched PHP 7.2.34 outlined here seems to be working on Xenforo 2.1 test forums

    xf21-php7234-mariadb-10.3.26-01.png

    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...')
    
     
  12. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    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
     
    Last edited: Nov 6, 2020
  13. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Not 100% sure that it was for Wordpress also but for Invision it was 100% a problem.

    The issue was everywhere and not on specific links.
     
  14. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    maybe a specific plugin?
     
  15. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    I don't think so as i got the same error on another server also with none common plugins....
     
  16. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    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.
     
    Last edited: Nov 6, 2020
  17. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
  18. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
  19. eva2000

    eva2000 Administrator Staff Member

    45,633
    10,356
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +16,070
    Local Time:
    10:08 PM
    Nginx 1.19.x
    MariaDB 5.5/10.x
    Thanks for the confirmation which was for patched PHP 7.2 I assumed ?

    Yeah PHP 5.6 is becoming the black sheep for testing :D
     
  20. pamamolf

    pamamolf Premium Member Premium Member

    3,883
    381
    83
    May 31, 2014
    Ratings:
    +741
    Local Time:
    2:08 PM
    Nginx-1.17.x
    MariaDB 10.3.x
    Yes