to be honest: no idea, to less informations. Basicly it sounds like you’re mysql server has gone, which has a reason that would be detectable inside your logs.
No, only hestacp back up users db.
I have a server for the cs 1.6 game and it often crashes with this error.
L 12/29/2019 - 03:33:08: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 03:33:08: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 15:04:31: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 15:04:31: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 17:25:12: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 17:25:13: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 17:25:14: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 17:25:14: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:09:33: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:09:33: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:09:33: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:12:00: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:12:00: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:12:00: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:12:02: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:12:02: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:12:02: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:13:15: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:13:15: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:13:15: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:24:57: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 19:24:57: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 20:37:30: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 20:37:30: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 21:35:37: SQL Query Error. [2006] MySQL server has gone away
L 12/29/2019 - 21:35:37: SQL Query Error. [2006] MySQL server has gone away
Sometimes queries are done correctly but sometimes there is such an error.
The problem also occurred with php scripts connecting to the database remotely/local
probably whatever query is running there takes too long and simply runs into that timeout.
seems you already increased the wait_timeout, try raising the interactive_timeout as well. if that helps use long-query logging to check which request takes that long and think about optimizing the query or table structure or use of indexes etc.
I just wanted to add that I just ran into some similar errors in my logs today. I accidentally copied some large files to my system drive (which is very small) causing it to be 100% full. I didn’t realize it and ended up spending the last couple hours trying to troubleshoot the ‘mysql has gone away’ error only to find out that my system partition was full and it broke mariadb. So in my case the error was misleading.
Not saying this is the solution, but just something to consider.
Here is an excerpt from my notes when building a new server: # MySQL - Increase MySQL packet size [solves the "MySQL Server gone" error] sed -ri 's/#?max_allowed_packet\s+.*/max_allowed_packet = 512M/' /etc/mysql/my.cnf
The above command will raise the limit of the max_allowed_packet to 512MB.
Quite some time ago I run into this problem (MySQL server has gone away) and by googling around I found out that by changing this value, my problem was solved.
Of course, it all depends on the use case. Some people might not face that problem if their SQL queries are not big.