[MySQL]Lost connection to MySQL server during query

https://dev.mysql.com/doc/refman/8.0/ja/packet-too-large.html

ERROR 2013 (HY000) at line 111: Lost connection to MySQL server during query

  • max_allowed_packetを確認

  • my.cnf/RDS パラメーターグループの変更

再起動必須。

今回はrestore時に起こるもの。以下はdump時の場合だが、対応方法は同じ。

[MySQL]ERROR 1153 (08S01) at line 1000: Got a packet bigger than ‘max_allowed_packet’ bytes

Was this helpful?

0 / 0

コメントを残す