After upgrading to v1.8.8 I’m getting the following errors in mysqld.log several times a day.
2019-08-02 6:01:10 140106333263616 [Warning] Aborted connection 41 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
2019-08-02 6:01:10 140108947121920 [Warning] Aborted connection 42 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
2019-08-02 6:01:10 140106332034816 [Warning] Aborted connection 43 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
2019-08-02 6:16:09 140106211559168 [Warning] Aborted connection 748 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
2019-08-02 6:36:38 140106210944768 [Warning] Aborted connection 1555 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
2019-08-02 6:36:38 140106331727616 [Warning] Aborted connection 1557 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
2019-08-02 6:36:38 140106199013120 [Warning] Aborted connection 1556 to db: 'cyberpanel' user: 'cyberpanel' host: 'localhost' (Got timeout reading communication packets)
I’m using the Optimized mysql config from platform.cyberpanel.net, have tried increasing the wait_timeout and max-allowed-packet values, as well as upgrading to the latest MariaDB 10.2 but it didn’t help.
It was working fine without any errors for a few months with v1.8.3 and started happening all of a sudden after I upgraded to v1.8.8
BTW no one was trying to access the cyberpanel admin page at :8090 at the times this error is showing up, so I’m not sure what’s generating those queries/connections.
I’m not sure if there’s a difference between Linux OS versions… but, if you’re using MariaDB on CentOS/CloudLinux, the my.cnf entries should have _ and not -.
if you log into mysql via CLI:
$ mysql -uroot -p
and then show your variables (this example is any/all variables w/ the term ‘query’:
show variables like '%query%';
you’ll be able to see/confirm the methodology that your instance of MariaDB is using. if it’s showing _ instead of -, that’s probably why your my.cnf changes aren’t being reflected upon restarting mysqld.