Subject: Re: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default

From: zimoun <[email-masked]>
Date: Tue, 14 Sep 2021 13:51:18 +0200

Hi,

Sorry for the delay about this old bug#25415 [1].

1: <http://issues.guix.gnu.org/issue/25415>

On Fri, 13 Jan 2017 at 10:29, Ben Sturmfels <[email-masked]> wrote:
> On 13/01/17 01:22, Ludovic Courtès wrote:
>
>>> 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?
>
> Sure, I'll give it a shot!
>
> It looks as though the MariaDB source comes with a settings file for
> Debian that includes max-allowed-packet=16M:
>
>   mariadb-XX.XX.XX/debian/additions/my.cnf
>
> Would you recommend adding just max-allowed-packet, or would it be worth
> applying all these settings in this file?

Well, anything that suits you. :-)  Could you send a patch if it is
relevant?

All the best,
simon