GNU bug report logs - #25415
MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default

Previous Next

Full log

Message #14 received at 25415 <at> debbugs.gnu.org (full text, mbox):

From: ludo <at> gnu.org (Ludovic Courtès)
To: Ben Sturmfels <ben <at> stumbles.id.au>
Cc: 25415 <at> debbugs.gnu.org
Subject: Re: bug#25415: MySQL "server has gone away" when reloading database
 dump due to "max_allowed_packet" default
Date: Fri, 13 Jan 2017 09:03:41 +0100

Ben Sturmfels <ben <at> stumbles.id.au> skribis:

> 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?

I’m not famliar with MySQL/MariaDB, but any setting that sounds useful
to you is welcome.

Thanks,
Ludo’.

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.