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

[rdn]

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

 

[Chris D]

There won't be anything to us to change here. It will be a server configuration issue.

I'd most likely check wait_timeout first but if you search for that error on this forum you may find other recommendations.

 

[rdn]

I'll try to increase wait_timeout now.
This is a new server in DO 2cpu/2gb ram for testing.

 

[rdn]

Mysql wait_timeout and PHP max execution increase to 180, but still the same error :/

 

[Chris D]

What was the wait_timeout value before you changed it?

The default is typically 28800 so 180 would be far from sufficient.

Also no reason to increase PHP max_execution timeout for this as that isn't a factor in this issue.

 

[rdn]

My current setting now:

wait_timeout = 28800
connect_timeout = 600
innodb_lock_wait_timeout = 600

But still fail with the same error.

 

[Chris D]

You might want to consider increasing max_allowed_packet too.

After making the changes make sure the MySQL server has been restarted.

You can also verify the values are taking effect by querying the server directly after restarting:

show variables like 'wait_timeout';

show variables like 'max_allowed_packet';

etc.

 

[rdn]

Adjusted to
max_allowed_packet = 128M

Trying again now.

 

[rdn]

I even set it to:
max_allowed_packet = 256M

Still the same :|
Not sure what to adjust now, Maybe I'll try with MariaDB 10.3 install.

 

[Xon]

Is there anything in the mysql logs?

 

[eva2000]

Try downgrading MySQL to 10.4.15 and see if it's related to the new updated MariaDB versions which have stricter packet validation https://community.centminmod.com/th...3-26-10-2-35-and-10-1-48-now-available.20632/

 

[rdn]

I already deleted the droplet, but I will try again today with 10.3.x.

 

[eva2000]

MariaDB 10.3.26 would have same 10.4.16 stricter packet validation, only downgrading to MariaDB 10.3.25 or 10.4.15 would have previous packet validation policies which are more relaxed.

 

[rdn]

Is there anything in the mysql logs?

Nothing on /var/log/mysqld.log

but I will try again today with 10.3.x.

Unfortunately same issue.

MariaDB 10.3.26 would have same 10.4.16 stricter packet validation, only downgrading to MariaDB 10.3.25 or 10.4.15 would have previous packet validation policies which are more relaxed.

This is new CMM server install though.
Not possible to install specific version.

 

[eva2000]

This is new CMM server install though.
Not possible to install specific version.

downgrade not working ?

yum downgrade MariaDB-client MariaDB-common MariaDB-compat MariaDB-devel MariaDB-server MariaDB-shared galera

if not then you need to specify specific MariaDB version via MariaDB repo file edits

 

[rdn]

I did the new xf2 install on old server and just imported it on test server.
All done for now.
Thanks Eva.

XenForo 2.2.1 Loader.io Testing on Free plan

DO San Francisco 2 droplet specs: CentminMod Specs: CentOS 7.8 Nginx 1.19.4 PHP 7.4.12 w/ zend opcache MariaDB 10.3.26 Redis 6.0.9 All test are done with 250 clients & duration of 1 minute, each run 3 times. Default & New install XenForo 2.2.1 Stats / No caching Maintain client load...

xenforo.com

 

[eva2000]

so old server had older MariaDB 10.3.25 ? or it worked with 10.3.26 ? and not just with 10.4.16 ?

 

[rdn]

so old server had older MariaDB 10.3.25 ?

Yes.

Doesn't work on both 10.3.26 & 10.4.16.

 

[eva2000]

Yes.

Doesn't work on both 10.3.26 & 10.4.16.

wow so even PHP7.4 isn't immune to new MariaDB versions stricter packet validation requirements

 

[rdn]

I'm not sure of that :|
But I just can't make it install.