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: Thu, 12 Jan 2017 15:22:39 +0100 Message-ID: <87wpe02w9c.fsf@gnu.org> References: <20170111111003.5e8ae2c8@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]:42437) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cRgHS-0003Ot-O8 for bug-guix@gnu.org; Thu, 12 Jan 2017 09:23:10 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cRgHO-0003vf-7f for bug-guix@gnu.org; Thu, 12 Jan 2017 09:23:06 -0500 Received: from debbugs.gnu.org ([208.118.235.43]:35320) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cRgHO-0003va-4t for bug-guix@gnu.org; Thu, 12 Jan 2017 09:23:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1cRgHN-0005CV-VG for bug-guix@gnu.org; Thu, 12 Jan 2017 09:23:01 -0500 Sender: "Debbugs-submit" Resent-Message-ID: In-Reply-To: <20170111111003.5e8ae2c8@stumbles.id.au> (Ben Sturmfels's message of "Wed, 11 Jan 2017 11:10:03 +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 Hi Ben, Ben Sturmfels 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=3D16M 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 =E2=80=98max-allowed-packet=E2=80=99 field in in (gnu services databases) and make sure it=E2=80=99s honored. Would you like to give it a try? Thanks for your report! Ludo=E2=80=99.