From mboxrd@z Thu Jan 1 00:00:00 1970 From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) Subject: 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 Message-ID: <87shonl736.fsf@gnu.org> References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40007) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cRwqA-0008RI-Vv for bug-guix@gnu.org; Fri, 13 Jan 2017 03:04:06 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cRwqA-0004Xo-2e for bug-guix@gnu.org; Fri, 13 Jan 2017 03:04:03 -0500 Received: from debbugs.gnu.org ([208.118.235.43]:36632) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cRwq9-0004Xi-WE for bug-guix@gnu.org; Fri, 13 Jan 2017 03:04:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1cRwq9-0000LS-OE for bug-guix@gnu.org; Fri, 13 Jan 2017 03:04:01 -0500 Sender: "Debbugs-submit" Resent-Message-ID: In-Reply-To: <58781150.3060202@stumbles.id.au> (Ben Sturmfels's message of "Fri, 13 Jan 2017 10:29:20 +1100") List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-guix-bounces+gcggb-bug-guix=m.gmane.org@gnu.org Sender: "bug-Guix" To: Ben Sturmfels Cc: 25415@debbugs.gnu.org Ben Sturmfels skribis: > On 13/01/17 01:22, Ludovic Court=C3=A8s wrote: > >>> Could it be worth setting max_allowed_packet to 16M in Guix's >>> `mysql-configuration-file` function for consistency with Debian? >>=20 >> Definitely. I would add a =E2=80=98max-allowed-packet=E2=80=99 field in >> in (gnu services databases) and make sure it=E2=80= =99s >> honored. >>=20 >> 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=3D16M: > > 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=E2=80=99m not famliar with MySQL/MariaDB, but any setting that sounds use= ful to you is welcome. Thanks, Ludo=E2=80=99.