I have a problem. When I split my MariaDB from main server to another server (my database server is running MariaDB docker from latest tag) I got an error:

Got an error writing communication packets

i have 2 server the one is a webserver (no db) the other is a ubuntu 20.04 with 4gig ram and 4 core(2gh per core)

The port is open and my PING is less than 1ms.

I tried with a basic WP site DB and the connection is OK, there was no problem, but my database is about 1GB and I guess this made this problem.

I also try to connect over private network (192.168.100.25) instead of public IP, but the problem is same.

Here is my MariaDB log

Aborted connection 3 to db: ‘wpdb’ user: 'root’ host: 'myip’ (Got an error reading communication packets)

Aborted connection 5 to db: 'wpdb’ user: 'root’ host: 'myip’ (Got an error writing communication packets)

I also edited MariaDB config:

  • increased maxallowedpacket to 1GB
  • increased netbufferlength to 1000000

but nothing changes!

here is mariadb variable :
https://pastebin.ubuntu.com/p/yHFRh7CnVC/

Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!