XF 2.1 Server problem with 10.3.26-MariaDB and PHP: 7.3.6

[antonino]

Before two days my site went down all day when my host provider make some updates.
I know for sure that went from 7.1.33 to 7.3.6 and 10.3.26-MariaDB.
After that I can not do any updates without problem.
It begin like that

503 Service Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
And with the following errors.

An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in src/XF/Db/AbstractStatement.php on line 228

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
XF\Session\Session->save() in src/XF/Install/App.php at line 190
XF\Install\App->complete() in src/XF/App.php at line 2194
XF\App->run() in src/XF.php at line 391
XF::runApp() in install/index.php at line 14

And the next



Any ideas, please?
First answer from my host is...
The solution to the problem you are facing is to ask the xenforo community for a patch for the problem with upgrading MariaDB to your php version.

I am very confused, any help is welcome

 

[rdn]

XF 2.0 - 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...

xenforo.com

Still having problem even using PHP 7.3.x?

I also got similar issue:

MySQL statement prepare error [2006]: MySQL server has gone away during new Install

Server Software: CentOS 7.8 Nginx 1.19.4 PHP 7.4.12 w/ zend opcache MariaDB 10.4.16 Redis 6.0.9 CLI Install error Web Install error

xenforo.com

 

[Tom McIntyre]

Sounds surprisingly close to the problems I am having after upgrade to MariaDB and PHP7.3

Is there anyone available to help with this problem on a private server? We will need PHP configured properly and ImageMagick installed since it was removed when PHP was upgraded to 7.3.

Willing to pay.

 

[Mike]

Current thinking is that this may be a regression in MariaDB. I’m tracking this here:

https://xenforo.com/community/threads/upgrade-to-2-1-12-taking-many-hours.187523/

 

[antonino]

Current thinking is that this may be a regression in MariaDB. I’m tracking this here:

https://xenforo.com/community/threads/upgrade-to-2-1-12-taking-many-hours.187523/

I fully trust that you will find a solution.
Unfortunately I do not have access to my server environment, so i dont know how can i help you with this. I can provide informations only.