From mboxrd@z Thu Jan 1 00:00:00 1970 From: Ben Sturmfels Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Date: Wed, 11 Jan 2017 11:10:03 +1100 Message-ID: <20170111111003.5e8ae2c8@stumbles.id.au> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:49594) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cR6ol-0004jJ-Cv for bug-guix@gnu.org; Tue, 10 Jan 2017 19:31:08 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cR6og-0002QC-H5 for bug-guix@gnu.org; Tue, 10 Jan 2017 19:31:07 -0500 Received: from debbugs.gnu.org ([208.118.235.43]:33832) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cR6og-0002Pz-90 for bug-guix@gnu.org; Tue, 10 Jan 2017 19:31:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1cR6og-0004fK-0p for bug-guix@gnu.org; Tue, 10 Jan 2017 19:31:02 -0500 Sender: "Debbugs-submit" Resent-Message-ID: Received: from eggs.gnu.org ([2001:4830:134:3::10]:41474) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cR6Ua-00005Q-9A for bug-guix@gnu.org; Tue, 10 Jan 2017 19:10:17 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cR6UX-0005vi-3A for bug-guix@gnu.org; Tue, 10 Jan 2017 19:10:16 -0500 Received: from out1-smtp.messagingengine.com ([66.111.4.25]:46074) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1cR6UW-0005v5-TJ for bug-guix@gnu.org; Tue, 10 Jan 2017 19:10:13 -0500 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id C0F7B208C0 for ; Tue, 10 Jan 2017 19:10:10 -0500 (EST) Received: from localhost (ppp118-209-10-115.lns20.mel4.internode.on.net [118.209.10.115]) by mail.messagingengine.com (Postfix) with ESMTPA id D4C3D24717 for ; Tue, 10 Jan 2017 19:10:09 -0500 (EST) 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: 25415@debbugs.gnu.org Hi there! I'm using GuixSD 0.12.0 and ran `guix package --install=mysql` (which I gather gave me MariaDB 10.1.19), then created a database and tried to reload a database dump of a decent sized existing database: zcat dump.sql.gz | mysql DBNAME which failed with: ERROR 2006 (HY000) at line 2266: MySQL server has gone away 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=16M 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? Regards, Ben