From debbugs-submit-bounces@debbugs.gnu.org Tue Jan 10 19:30:41 2017 Received: (at submit) by debbugs.gnu.org; 11 Jan 2017 00:30:41 +0000 Received: from localhost ([127.0.0.1]:49231 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cR6oK-0004ed-Pt for submit@debbugs.gnu.org; Tue, 10 Jan 2017 19:30:41 -0500 Received: from eggs.gnu.org ([208.118.235.92]:50518) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cR6Uh-00049D-FH for submit@debbugs.gnu.org; Tue, 10 Jan 2017 19:10:23 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cR6Ub-0005xR-E0 for submit@debbugs.gnu.org; Tue, 10 Jan 2017 19:10:18 -0500 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=0.8 required=5.0 tests=BAYES_50,T_DKIM_INVALID autolearn=disabled version=3.3.2 Received: from lists.gnu.org ([2001:4830:134:3::11]:41518) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1cR6Ub-0005xL-Ap for submit@debbugs.gnu.org; Tue, 10 Jan 2017 19:10:17 -0500 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 frontend2 ([10.202.2.161]) by compute3.internal (MEProxy); Tue, 10 Jan 2017 19:10:10 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=stumbles.id.au; h= content-transfer-encoding:content-type:date:from:message-id :mime-version:subject:to:x-me-sender:x-me-sender:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=dihMJmTZGZG8+6Z21JQ5ob+HHE0=; b=R9NpCc uPbYzPGFMpVmhoIzmP8zvkX15lZfN1nBMdyUT0AWT5CiA1ssK7vINxatgwRksWsB qzF5plcnGM6TvU2yA2O6qPTLK+k8gA/B4PW9JDIIzmPZoaUn081tebtFCvW5Xbye wbNE7WkE8BvSjwudpSR30pLLAhPNIpGFTh1ms= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:message-id:mime-version:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=smtpout; bh=dihMJmTZGZG8+6 Z21JQ5ob+HHE0=; b=kM6NmuUMRToUUAhObS1mJbpHuEFaVBk2uj+PNAO9L1vfVb dee8Yle3SjZWy0p30mJWXH7da0/t+gaFHYWjjwAxdyWlioesJilOYg/KdBSfa3Fm 26EO6cPilRFw6xK0lenOjrLNTwbLcKu0urxX1ELinEH3yuWbkV1q30COyUwLA= X-ME-Sender: X-Sasl-enc: t5huiLzs4gnWiK7NiD0wDkxbh49IxeqqK9bZDzx/71rX 1484093410 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) Date: Wed, 11 Jan 2017 11:10:03 +1100 From: Ben Sturmfels To: bug-guix@gnu.org Subject: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Message-ID: <20170111111003.5e8ae2c8@stumbles.id.au> X-Mailer: Claws Mail 3.13.2 (GTK+ 2.24.30; x86_64-unknown-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] [fuzzy] X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x X-Received-From: 2001:4830:134:3::11 X-Spam-Score: -4.1 (----) X-Debbugs-Envelope-To: submit X-Mailman-Approved-At: Tue, 10 Jan 2017 19:30:39 -0500 X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -4.1 (----) 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