[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
bug#25415: MySQL "server has gone away" when reloading database dump due
From: |
Ludovic Courtès |
Subject: |
bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default |
Date: |
Thu, 12 Jan 2017 15:22:39 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) |
Hi Ben,
Ben Sturmfels <address@hidden> skribis:
> Reloading the same dump works for me on default MySQL in Trisquel 7.
> The database dump was created on Debian with `mysqldump --no-create-db
> DBNAME`.
>
> On Guix, I was able to reload the dump by running mysqld with a custom
> config file with max_allowed_packet=16M under [mysqld].
>
> It appears that the default value for `max_allowed_packet` under
> Debian/Trisquel is "16M", where under Guix it is "4M". The mysqldump
> defaults bunche a whole lot of records into a single insert statement
> for performance, which is why I'm getting a value > 4M.
>
> Could it be worth setting max_allowed_packet to 16M in Guix's
> `mysql-configuration-file` function for consistency with Debian?
Definitely. I would add a ‘max-allowed-packet’ field in
<mysql-configuration> in (gnu services databases) and make sure it’s
honored.
Would you like to give it a try?
Thanks for your report!
Ludo’.