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

Previous Next

Package: guix;

Reported by: Ben Sturmfels <ben <at> stumbles.id.au>

Date: Wed, 11 Jan 2017 00:31:01 UTC

Severity: normal

Done: zimoun <zimon.toutoune <at> gmail.com>

Bug is archived. No further changes may be made.

Full log

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

From: Ben Sturmfels <ben <at> stumbles.id.au>
To: Ludovic Courtès <ludo <at> gnu.org>
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 10:29:20 +1100

[Message part 1 (text/plain, inline)]
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?

Ben


[signature.asc (application/pgp-signature, attachment)]
This bug report was last modified 2 years and 333 days ago.

Previous Next

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