Question

MariaDB Error Reading Communication Packets

Posted January 4, 2021 3.3k views
MySQLDockerMariaDBUbuntu 20.04

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/

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers