SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
Closed this issue · 0 comments
programarivm commented
Every few days, the chess_data_mysql container stops working properly, apparently because of an XA crash recovery, and the Chess Server needs to be restarted manually.
[2024-09-18T09:13:50.220453+00:00] data.ERROR: Occurred an error {"message":"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away","file":"/usr/share/chess-server/src/Db.php","line":43,"trace":"#0 /usr/share/chess-server/src/Db.php(43): PDOStatement->execute()\n#1 /usr/share/chess-server/src/Command/Data/RankingCommand.php(28): ChessServer\\Db->query()\n#2 /usr/share/chess-server/src/Socket/Workerman/AbstractWebSocket.php(60): ChessServer\\Command\\Data\\RankingCommand->run()\n#3 /usr/share/chess-server/vendor/workerman/workerman/Connection/TcpConnection.php(646): ChessServer\\Socket\\Workerman\\AbstractWebSocket->ChessServer\\Socket\\Workerman\\{closure}()\n#4 /usr/share/chess-server/vendor/workerman/workerman/Events/Select.php(311): Workerman\\Connection\\TcpConnection->baseRead()\n#5 /usr/share/chess-server/vendor/workerman/workerman/Worker.php(1638): Workerman\\Events\\Select->loop()\n#6 /usr/share/chess-server/vendor/workerman/workerman/Worker.php(1429): Workerman\\Worker::forkOneWorkerForLinux()\n#7 /usr/share/chess-server/vendor/workerman/workerman/Worker.php(1403): Workerman\\Worker::forkWorkersForLinux()\n#8 /usr/share/chess-server/vendor/workerman/workerman/Worker.php(1788): Workerman\\Worker::forkWorkers()\n#9 /usr/share/chess-server/vendor/workerman/workerman/Worker.php(1724): Workerman\\Worker::monitorWorkersForLinux()\n#10 /usr/share/chess-server/vendor/workerman/workerman/Worker.php(562): Workerman\\Worker::monitorWorkers()\n#11 /usr/share/chess-server/cli/workerman/data.php(46): Workerman\\Worker::runAll()\n#12 {main}"} []
See: