From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: Ben Sturmfels Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Wed, 11 Jan 2017 00:31:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: 25415@debbugs.gnu.org X-Debbugs-Original-To: bug-guix@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.148409464117901 (code B ref -1); Wed, 11 Jan 2017 00:31:01 +0000 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 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-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 From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Thu, 12 Jan 2017 14:23:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ben Sturmfels Cc: 25415@debbugs.gnu.org Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.148423097619963 (code B ref 25415); Thu, 12 Jan 2017 14:23:01 +0000 Received: (at 25415) by debbugs.gnu.org; 12 Jan 2017 14:22:56 +0000 Received: from localhost ([127.0.0.1]:50719 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRgHH-0005Bv-Q5 for submit@debbugs.gnu.org; Thu, 12 Jan 2017 09:22:55 -0500 Received: from eggs.gnu.org ([208.118.235.92]:51376) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRgHG-0005Bi-7N for 25415@debbugs.gnu.org; Thu, 12 Jan 2017 09:22:54 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cRgH3-0003r9-LL for 25415@debbugs.gnu.org; Thu, 12 Jan 2017 09:22:49 -0500 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-5.1 required=5.0 tests=BAYES_00,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:38352) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cRgH3-0003r5-I3; Thu, 12 Jan 2017 09:22:41 -0500 Received: from [193.50.110.111] (port=60756 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1cRgH2-0000Kn-QX; Thu, 12 Jan 2017 09:22:41 -0500 From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) References: <20170111111003.5e8ae2c8@stumbles.id.au> X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: 23 =?UTF-8?Q?Niv=C3=B4se?= an 225 de la =?UTF-8?Q?R=C3=A9volution?= X-PGP-Key-ID: 0x090B11993D9AEBB5 X-PGP-Key: http://www.fdn.fr/~lcourtes/ludovic.asc X-PGP-Fingerprint: 3CE4 6455 8A84 FDC6 9DB4 0CFB 090B 1199 3D9A EBB5 X-OS: x86_64-unknown-linux-gnu Date: Thu, 12 Jan 2017 15:22:39 +0100 In-Reply-To: <20170111111003.5e8ae2c8@stumbles.id.au> (Ben Sturmfels's message of "Wed, 11 Jan 2017 11:10:03 +1100") Message-ID: <87wpe02w9c.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -8.2 (--------) 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: -8.2 (--------) 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. From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: Ben Sturmfels Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Thu, 12 Jan 2017 23:33:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ludovic =?UTF-8?Q?Court=C3=A8s?= Cc: 25415@debbugs.gnu.org Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.148426397530284 (code B ref 25415); Thu, 12 Jan 2017 23:33:01 +0000 Received: (at 25415) by debbugs.gnu.org; 12 Jan 2017 23:32:55 +0000 Received: from localhost ([127.0.0.1]:51867 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRorX-0007sO-6H for submit@debbugs.gnu.org; Thu, 12 Jan 2017 18:32:55 -0500 Received: from out2-smtp.messagingengine.com ([66.111.4.26]:55755) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRoo9-0007m9-GP for 25415@debbugs.gnu.org; Thu, 12 Jan 2017 18:29:26 -0500 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 467D120D73; Thu, 12 Jan 2017 18:29:23 -0500 (EST) Received: from frontend2 ([10.202.2.161]) by compute3.internal (MEProxy); Thu, 12 Jan 2017 18:29:23 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=stumbles.id.au; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc :x-sasl-enc; s=mesmtp; bh=6X4ZDPGyNKF7YLHa7eqdmEDeYjs=; b=XQAtFg eWsGVQK/Mdva8vph7g1Z2+XVQXhUT4Ddvgr7eIxVE0Du9ULHAqGA1PRCuhKvg+4i DoquMu7VofGEGUZJhcApMaLdpIJAvLs146a8ZpGDdBAy/DWt1A5MKXB/1rjZ+Bg+ pAZZoRdDXG8iRtEu1tqx4MZervGzv1Tq4yd3M= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=smtpout; bh=6X4ZDPGyNKF7YL Ha7eqdmEDeYjs=; b=nd3CUDrTSskKbWYkYA/8aDPhMIjzz37OjjBWsEX2ck/U2C GTOeBCllkXVcC8zW7saLnVoGj6+XP9tpUpNXjAd+XSp8NKZzYiyoD4f8w/K/EjnI O+tPK5LhM3+CcFdYjEDPgk0GUh+TWmbStBnNza35eUv4weomlOoQIzz8jQ9ng= X-ME-Sender: X-Sasl-enc: iCy8DA9AFjnuMPR6ra0B7HwqM8uOWcxt3lD/Hv9HH9ED 1484263762 Received: from [192.168.1.1] (ppp118-209-46-232.lns20.mel4.internode.on.net [118.209.46.232]) by mail.messagingengine.com (Postfix) with ESMTPA id 4B669241E0; Thu, 12 Jan 2017 18:29:22 -0500 (EST) References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> From: Ben Sturmfels X-Enigmail-Draft-Status: N1110 Message-ID: <58781150.3060202@stumbles.id.au> Date: Fri, 13 Jan 2017 10:29:20 +1100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Icedove/38.8.0 MIME-Version: 1.0 In-Reply-To: <87wpe02w9c.fsf@gnu.org> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UlePjgg7wGUda5d5icBEoAPXQQe4wJXMp" X-Spam-Score: -0.7 (/) X-Mailman-Approved-At: Thu, 12 Jan 2017 18:32:54 -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: -0.7 (/) This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --UlePjgg7wGUda5d5icBEoAPXQQe4wJXMp Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 i= n > 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? Ben --UlePjgg7wGUda5d5icBEoAPXQQe4wJXMp Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iQIcBAEBCgAGBQJYeBFQAAoJEAI8BeLJwGjwqgQQAKWebihDS31bKEI0/ZTSlXfi /7zddgTYjwAriplc+ZVaYlsK/xWKQzMGzQK3b71iMp/0cHlNxu7GUXjJcUgAeWNM Yx+/n1LcpFk0+ukEK3qg/Pa2q/qHIK4ufHb+KB0y3j1+WHzk8dg8vigOUpQ9Z+2F 1qN0ClhstvbihjgiQJ0Nq5o7yWGyLyMh3/TD51qhkDwk4T+QGSpTFfcP7b3i1fRE qs3SPDCX+06Uskc4TA7tHfeQ9GbjazBBCf/dc3sSRutnrqKZAtt+h4GWCeA/64JW hsxuKaUWcr1IFy/j9EyWqqk2BkJu1jmsyjBh6zcDqVqog1gtH1q8dB4i07HNLrC5 KMEolrgNA7oDrJaqOSqxP200i6dTOT1PS9lxDOgz4RRqgj5qTFGJPFk32I4GeM8Y +7caLhxBYFkGH2Hy6TnOpykZMkSfym9U2AXVxziZ9dJM3H3W8rQlmblU95MGk46g C1WfGKr0sJob607yukGGBsoP7oQnw+Oe00eQetecFL+JAbcb3Voxdpbrthp6Z5q7 urH3FTeCRQK+V/H7qh5/esZVb6Qm8x3BU5Yjs92pWxRMH0qLR3NgFyGmHvVi9iet 9fRnzX6ZqL24pbWTheW5OsY9jmygr9ol6SSnCNt41TaiD8Iqh1Xf0v287sGNIVDL KdvNQsnr6YzIdIud4Tln =Efux -----END PGP SIGNATURE----- --UlePjgg7wGUda5d5icBEoAPXQQe4wJXMp-- From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Fri, 13 Jan 2017 08:04:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ben Sturmfels Cc: 25415@debbugs.gnu.org Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.14842946391317 (code B ref 25415); Fri, 13 Jan 2017 08:04:01 +0000 Received: (at 25415) by debbugs.gnu.org; 13 Jan 2017 08:03:59 +0000 Received: from localhost ([127.0.0.1]:52031 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRwq6-0000LB-QX for submit@debbugs.gnu.org; Fri, 13 Jan 2017 03:03:58 -0500 Received: from eggs.gnu.org ([208.118.235.92]:48989) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cRwq4-0000Ky-SS for 25415@debbugs.gnu.org; Fri, 13 Jan 2017 03:03:57 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cRwpu-0004QH-9U for 25415@debbugs.gnu.org; Fri, 13 Jan 2017 03:03:51 -0500 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on eggs.gnu.org X-Spam-Level: X-Spam-Status: No, score=-2.4 required=5.0 tests=BAYES_50,RP_MATCHES_RCVD autolearn=disabled version=3.3.2 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:51112) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cRwpu-0004QC-7B; Fri, 13 Jan 2017 03:03:46 -0500 Received: from [193.50.110.111] (port=53108 helo=ribbon) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1cRwps-0005TN-47; Fri, 13 Jan 2017 03:03:44 -0500 From: ludo@gnu.org (Ludovic =?UTF-8?Q?Court=C3=A8s?=) References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> X-URL: http://www.fdn.fr/~lcourtes/ X-Revolutionary-Date: 24 =?UTF-8?Q?Niv=C3=B4se?= an 225 de la =?UTF-8?Q?R=C3=A9volution?= X-PGP-Key-ID: 0x090B11993D9AEBB5 X-PGP-Key: http://www.fdn.fr/~lcourtes/ludovic.asc X-PGP-Fingerprint: 3CE4 6455 8A84 FDC6 9DB4 0CFB 090B 1199 3D9A EBB5 X-OS: x86_64-unknown-linux-gnu Date: Fri, 13 Jan 2017 09:03:41 +0100 In-Reply-To: <58781150.3060202@stumbles.id.au> (Ben Sturmfels's message of "Fri, 13 Jan 2017 10:29:20 +1100") Message-ID: <87shonl736.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.2.x-3.x [generic] X-Received-From: 2001:4830:134:3::e X-Spam-Score: -8.2 (--------) 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: -8.2 (--------) 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. From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: zimoun Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 14 Sep 2021 14:19:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ben Sturmfels Cc: 25415@debbugs.gnu.org, Ludovic =?UTF-8?Q?Court=C3=A8s?= Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.163162913627083 (code B ref 25415); Tue, 14 Sep 2021 14:19:02 +0000 Received: (at 25415) by debbugs.gnu.org; 14 Sep 2021 14:18:56 +0000 Received: from localhost ([127.0.0.1]:49736 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1mQ9Gy-00072h-28 for submit@debbugs.gnu.org; Tue, 14 Sep 2021 10:18:56 -0400 Received: from mail-wm1-f41.google.com ([209.85.128.41]:46676) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1mQ9Gu-00072F-94 for 25415@debbugs.gnu.org; Tue, 14 Sep 2021 10:18:53 -0400 Received: by mail-wm1-f41.google.com with SMTP id d207-20020a1c1dd8000000b00307e2d1ec1aso2683974wmd.5 for <25415@debbugs.gnu.org>; Tue, 14 Sep 2021 07:18:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version:content-transfer-encoding; bh=V1cKnlXzCGTXzslMMYmRAvmaZ+0cRR7SZbtSSUP4AXE=; b=DaEBCXO0xcj0jQQWsoSN2NKe4uLUrVD6T478MiHOGkOlAzb4nYQO7jeezahlpMMfX6 0L580KKOjnhYtPHOTt5Jsu1UPMXrPbjKmA3ZwLjTNvzCnHEE9NJRhFf/nCjrmXPS6/Bl mSw/UUyMwJAdB12GPwjxSuH8kXSz3UqUraYfJFL1/iJDmsmZbzOS4gEHAUq1tZ4XMBDq m0GlgiiPpUORwk3C0r6e52bNqS2Q/fzHEdkX8AuWwIxKHEJ8EmXCPdSmbz+qjn/VdR99 Gi/cTSX5+1Gt4BbjkgbhJiuvMseUeWGt7CaUb5x31VfMIF2q+nUn5g952SicfgY/T00I WM3g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version:content-transfer-encoding; bh=V1cKnlXzCGTXzslMMYmRAvmaZ+0cRR7SZbtSSUP4AXE=; b=gYf2w7pYY5rVRW+JTh3VQYlXeOai2W58jTx+OwJ7zRj3YgObL0lMv9ppT6vHNTVjqO In2jBxCetGqhpyKqzp3I63xHGUtQdXVCgSdPY1sb3OWDZjgHINHjprLd2oNg5eJPNN54 Gc7PoxXzQAn5zUR5aYtArRJRvbs4+SCX23F1U28oDIJgr8nn1GNl9uVgM5R9+y7bEP79 bveb/JebzzC16hjg1L+uOApFgo+vn0plBPEIbzFwcj/+hoBD5fukO07GmiV7kWCSEcML yKo9EkscxC54xktnmkEM68fFs1eQs8ITsaiIHGQ1pkjpierpN7/euCGvwmw3hsZ2gpzU a1mw== X-Gm-Message-State: AOAM530ITewYEg+ygTiAkEd3Fo0gJNZyeefyADUZLMOpcDQ/kb2EKhMW cyzsTy+w5ON+v42OQ7Q1L8KafGL9lPKhBw== X-Google-Smtp-Source: ABdhPJzyswGfNql7cepOD3ZT6sf4CDqNd26zmSArOnyDCmXZyugM8yTHTtkRuGvaTsXtFazo+OlyFA== X-Received: by 2002:a05:600c:19d0:: with SMTP id u16mr2485056wmq.21.1631629126414; Tue, 14 Sep 2021 07:18:46 -0700 (PDT) Received: from lili (roam-nat-fw-prg-194-254-61-40.net.univ-paris-diderot.fr. [194.254.61.40]) by smtp.gmail.com with ESMTPSA id d24sm1280016wmb.35.2021.09.14.07.18.45 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 14 Sep 2021 07:18:45 -0700 (PDT) From: zimoun References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> Date: Tue, 14 Sep 2021 13:51:18 +0200 In-Reply-To: <58781150.3060202@stumbles.id.au> (Ben Sturmfels's message of "Fri, 13 Jan 2017 10:29:20 +1100") Message-ID: <86pmtbtlxl.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) 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: -1.0 (-) Hi, Sorry for the delay about this old bug#25415 [1]. 1: On Fri, 13 Jan 2017 at 10:29, Ben Sturmfels wrote: > 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? >> >> 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? > > 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? Well, anything that suits you. :-) Could you send a patch if it is relevant? All the best, simon From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: zimoun Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 12 Oct 2021 21:43:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ben Sturmfels Cc: 25415@debbugs.gnu.org, Ludovic =?UTF-8?Q?Court=C3=A8s?= Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.163407498112510 (code B ref 25415); Tue, 12 Oct 2021 21:43:01 +0000 Received: (at 25415) by debbugs.gnu.org; 12 Oct 2021 21:43:01 +0000 Received: from localhost ([127.0.0.1]:54917 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1maPY5-0003Fi-4J for submit@debbugs.gnu.org; Tue, 12 Oct 2021 17:43:01 -0400 Received: from mail-wr1-f46.google.com ([209.85.221.46]:35402) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1maPY2-0003FM-S9 for 25415@debbugs.gnu.org; Tue, 12 Oct 2021 17:42:59 -0400 Received: by mail-wr1-f46.google.com with SMTP id g25so1577238wrb.2 for <25415@debbugs.gnu.org>; Tue, 12 Oct 2021 14:42:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version:content-transfer-encoding; bh=oR6Z352VpicZoVNuT7mvjKtZMR//5aYGM994dwpoj58=; b=Ln4iMgBXZPNq7n+/TjrCdS11d+V1JqmdESrrpzGOc8i766vg0Hf5CcmpZQVnPjbExR cQl6bHLcvxNfqABMQXrO3qXV0CxuAwaMuusJdLwGc27yWbhaMP+hdo3/G0GrQz00UUJM hulq1DOtoBCvehyWwEZTTDALPScKUuVZSMwPmM4GW0ta7Zv4T1J9shq2VRvvwPSTRP7H CQf5WphbXXsc1HWr4MsNKwyiGzBW+56UDQT+0lXEZaR8i/vWApdz7tpfejTe5JmxKRoS XTNLdqpBYVG1S5l+nJ0PA/Yo6CACrbUU4MpCFW05J/vhLAQGCqEWQKbHTcbVsQrV3Kf7 654g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version:content-transfer-encoding; bh=oR6Z352VpicZoVNuT7mvjKtZMR//5aYGM994dwpoj58=; b=vEv2TSyTpTBHuTgOt55wnL411pnIuOuGaipQDNHbn59sbTuZzXdbvVkQLDBojCK03S Tf7MzDQvt08u2FyMWwk2yoXFVZAuh2+gIgzkXRObPOtd1kOjUhLvIGN6Toj+fDPy7EMN OU/jsIv7xQyNyBvrM1ZxUtEvIC7SVpRF41ZdHk/ZJKBqd+WvxcOCstxQ913IVkC8MJbu UmyHnqd7GIMJWDAH7068HEAt1txjXlzshPmryeJ1Y/TZGanGTjd2R+USK619bFb+1YGa epMZ1lFFubIMFRmwPK3c1KLeeqVOFxb09smKtOcpQ51j3QwKINKRdWezCUWGfxlGmA2i M0jQ== X-Gm-Message-State: AOAM532Nwqn3v+h478vPHtl+4byv3MUpobiwQPcYpapfBnf7cxhYYlaN llIfklvSJj12GHUw8SYR3tJyXq+VQas8Lw== X-Google-Smtp-Source: ABdhPJwnWQGsKCKlPTYcuLgiaEBabshp5FZlidXGkIhuOjk8CrSt74lsgiRTvtsamQ4Qx59irGpfJw== X-Received: by 2002:a1c:7fd0:: with SMTP id a199mr8685648wmd.96.1634074973190; Tue, 12 Oct 2021 14:42:53 -0700 (PDT) Received: from lili ([2a01:e0a:59b:9120:65d2:2476:f637:db1e]) by smtp.gmail.com with ESMTPSA id u24sm3343012wmj.48.2021.10.12.14.42.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 12 Oct 2021 14:42:52 -0700 (PDT) From: zimoun References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> <86pmtbtlxl.fsf@gmail.com> Date: Tue, 12 Oct 2021 23:42:42 +0200 In-Reply-To: <86pmtbtlxl.fsf@gmail.com> (zimoun's message of "Tue, 14 Sep 2021 13:51:18 +0200") Message-ID: <86sfx5kjhp.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) 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: -1.0 (-) Hi Ben, On Tue, 14 Sep 2021 at 13:51, zimoun wrote: > On Fri, 13 Jan 2017 at 10:29, Ben Sturmfels wrote: >> 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? >>> >>> 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? >> >> 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? > > Well, anything that suits you. :-) Could you send a patch if it is > relevant? Would you like to give a try to fix bug#25415 [1]? :-) 1: Cheers, simon From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: zimoun Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Fri, 26 Nov 2021 01:55:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ben Sturmfels Cc: 25415@debbugs.gnu.org, Ludovic =?UTF-8?Q?Court=C3=A8s?= Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.163789165616881 (code B ref 25415); Fri, 26 Nov 2021 01:55:02 +0000 Received: (at 25415) by debbugs.gnu.org; 26 Nov 2021 01:54:16 +0000 Received: from localhost ([127.0.0.1]:58349 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1mqQRL-0004O1-Ja for submit@debbugs.gnu.org; Thu, 25 Nov 2021 20:54:16 -0500 Received: from mail-wm1-f54.google.com ([209.85.128.54]:53192) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1mqQRJ-0004Nn-FB for 25415@debbugs.gnu.org; Thu, 25 Nov 2021 20:54:13 -0500 Received: by mail-wm1-f54.google.com with SMTP id o29so6902276wms.2 for <25415@debbugs.gnu.org>; Thu, 25 Nov 2021 17:54:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version:content-transfer-encoding; bh=2YdXOXJZWqtxhl4j3FMUN9V4wvNTo0XlFE277nRKRnY=; b=RX3SMthWo78LM0Uxdu6TaFKDPESwQ0LuyXVd/hdUM2lRlu6J3SQ603s8DsgkfbzEup ZzVZaow0Hz2CBXs7SRftqntVEYZh8vGB78zv3S44CVXCoL2ZchbGetyN0wi8WmLUOGEN eOG0w1q27+Al7T9mblemhHImrqqofLUgRZuH+CUfLQyqYEpZtRC5093FwmQ6/hb5Y92I jQtjT6PYxX8oPD2ZT9qguqhUbujLNUmvT6k99rwnZ9QMoZh0lP8Lf64rhvtMBpmBmg2t CNVBs8sMsr1hE1gVbK6iCOtWKgM/rMWOyDByXPCbapjd36vbGCVu2lx04Xjhxf7KhgrK J3FQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version:content-transfer-encoding; bh=2YdXOXJZWqtxhl4j3FMUN9V4wvNTo0XlFE277nRKRnY=; b=VGbp+6qtH8/TLMLKajGRk79MjbLZS8P+INW1bwOXSkHlCaBGPfRHOW6EOYbuQt9vIU euEA7bkbpLDCjR/dTWp2dXOjjseZyYPHFoc374zjVIdGH0odOWqxWP88Gn+o4BjoWTFV ZFdekR/s9PNo+Qtipl3G5aq5fw3d9debsfEbSVnvpn6lHcb5ACY8NCRIVHh5i679NvEA boXYvHkpMMKFfVSO9iZ99DfsblWCG6qjwdBDovzQfp5oEDM+UHigPvI6uBa7ej+8tBzW MhmWxz3+ZnWx7A2yCV/AcPqbZndAzfqgSiBZcJ64rge8Yc63PvgVYAPJvaQ2pyeH2tjp uCvQ== X-Gm-Message-State: AOAM531YVwQRbRKd4mBZnDBs9xYDnxJrzBBGWSekB3WVbddtZD6SfJsq Id6rHKoT/NvaIKnSaprMWz8= X-Google-Smtp-Source: ABdhPJzZb37ne+DoANMNsQhESaecTtC3cRR++2qwwJJIRIYeSl9Sg1szKv5R4g1zk96SNSZFjlJj6Q== X-Received: by 2002:a7b:c7c6:: with SMTP id z6mr12160267wmk.173.1637891647614; Thu, 25 Nov 2021 17:54:07 -0800 (PST) Received: from lili ([2a01:e0a:59b:9120:65d2:2476:f637:db1e]) by smtp.gmail.com with ESMTPSA id f13sm5359965wmq.29.2021.11.25.17.54.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 25 Nov 2021 17:54:07 -0800 (PST) From: zimoun References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> <86pmtbtlxl.fsf@gmail.com> <86sfx5kjhp.fsf@gmail.com> Date: Fri, 26 Nov 2021 02:51:48 +0100 In-Reply-To: <86sfx5kjhp.fsf@gmail.com> (zimoun's message of "Tue, 12 Oct 2021 23:42:42 +0200") Message-ID: <86czmnr8ej.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) 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: -1.0 (-) Hi Ben, I hope you are well. On Tue, 12 Oct 2021 at 23:42, zimoun wrote: > On Tue, 14 Sep 2021 at 13:51, zimoun wrote: >> On Fri, 13 Jan 2017 at 10:29, Ben Sturmfels wrote: >>> 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? >>>> >>>> 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? >>> >>> 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? The bug#25415 [1] is about MySQL and a patch seems required. Would you like give a try? 1: Cheers, simon From unknown Mon Aug 11 18:16:31 2025 X-Loop: help-debbugs@gnu.org Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Resent-From: zimoun Original-Sender: "Debbugs-submit" Resent-CC: bug-guix@gnu.org Resent-Date: Tue, 04 Jan 2022 23:09:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 25415 X-GNU-PR-Package: guix X-GNU-PR-Keywords: To: Ben Sturmfels Cc: 25415@debbugs.gnu.org, Ludovic =?UTF-8?Q?Court=C3=A8s?= Received: via spool by 25415-submit@debbugs.gnu.org id=B25415.164133772116757 (code B ref 25415); Tue, 04 Jan 2022 23:09:02 +0000 Received: (at 25415) by debbugs.gnu.org; 4 Jan 2022 23:08:41 +0000 Received: from localhost ([127.0.0.1]:39087 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1n4sv2-0004M7-Rr for submit@debbugs.gnu.org; Tue, 04 Jan 2022 18:08:41 -0500 Received: from mail-wm1-f52.google.com ([209.85.128.52]:38761) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1n4suy-0004Lq-Fn for 25415@debbugs.gnu.org; Tue, 04 Jan 2022 18:08:40 -0500 Received: by mail-wm1-f52.google.com with SMTP id p1-20020a1c7401000000b00345c2d068bdso638494wmc.3 for <25415@debbugs.gnu.org>; Tue, 04 Jan 2022 15:08:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:cc:subject:references:date:in-reply-to:message-id :user-agent:mime-version:content-transfer-encoding; bh=Atw19wtfxu0UOVJXFfnDxS0EeqGcoaLlzo0FU2Dzt0Q=; b=OrQ8mvCQKxakq9UwjS/1U73VKZtIl+J8Jp+mWIeNjthKhynOhdox3beBzsz9NuLMTg 4NGqHZpU0p/PuUnDJxOwAy5/0xAoFjOUvIaDVloNkc4R3k+nO42QQaAIkHz3QJD9Ac5n A8hlQAuunf4MZ2yrto8nYwT+IqS+QdgXadLQAYRP5df34pEqq3Eh6vRju4gf3alwdx0d yJXIuF1C1Z8LSiijB/SwtnKNUSl78q1g7Bx++cH0WninRRszEvYXCJZvxJhIBQICmAd+ PlPaP3jxhDuGzPa2qhjDrCHW5XFuzs+lNMGPzwFTD4S8JP37jE0jj+BvDAwLsDvFyzeI PMXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:cc:subject:references:date:in-reply-to :message-id:user-agent:mime-version:content-transfer-encoding; bh=Atw19wtfxu0UOVJXFfnDxS0EeqGcoaLlzo0FU2Dzt0Q=; b=k/CA+HiYoAdP8K/X96wJyO8PhlYbTM9a85ztbMOytpuixE1xLSWX6yzebfn5vISKpa G2LuX016rtM8mbEV9B0yuhvzTsjI2Mtk57cpFwE2B8cgcsyjHmjyJVB0Da5FwyCr719y E4FYgXHSCIjv2eBb5Ato3vm/C3wFC8tt3fe/wQMbQ42BrfxjMNaDLpwO0j8Ti3ZH+8yP 56fxIRM4lYdk7luBu/7AmNqab6/BYRr+LBlnsrhDndvJC2hunOtuK/8lBJbMvQBegsf5 XSIiTFQ4C9vP4Yy6PZWvOE8Yy8MX+qTlHFB2/hpOBIb0We07uH92jMzabuMlSDSgkTGQ 9yVw== X-Gm-Message-State: AOAM5311eUPkrHIPoDeQ4h6urxGWF9eZOOMNWTlkkadum+f3AlTHe4cY IK4sUWC7+0EmpWG3R+UZZWU5FRCVdEA= X-Google-Smtp-Source: ABdhPJziv0suPXE15AtXh4lHLXdW/KFEK7QzbOQIeJXd/Mm6zVldK4qZtQ14sLIqJgM3AJQQSOJnJQ== X-Received: by 2002:a05:600c:4f48:: with SMTP id m8mr475546wmq.158.1641337710732; Tue, 04 Jan 2022 15:08:30 -0800 (PST) Received: from lili ([88.126.110.68]) by smtp.gmail.com with ESMTPSA id o3sm776430wmr.15.2022.01.04.15.08.29 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 04 Jan 2022 15:08:30 -0800 (PST) From: zimoun References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> <86pmtbtlxl.fsf@gmail.com> <86sfx5kjhp.fsf@gmail.com> <86czmnr8ej.fsf@gmail.com> Date: Wed, 05 Jan 2022 00:00:11 +0100 In-Reply-To: <86czmnr8ej.fsf@gmail.com> (zimoun's message of "Fri, 26 Nov 2021 02:51:48 +0100") Message-ID: <86wnjfayys.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: 0.0 (/) 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: -1.0 (-) Hi, On Fri, 26 Nov 2021 at 02:51, zimoun wrote: > On Tue, 12 Oct 2021 at 23:42, zimoun wrote: >> On Tue, 14 Sep 2021 at 13:51, zimoun wrote: >>> On Fri, 13 Jan 2017 at 10:29, Ben Sturmfels wrote: >>>> 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? >>>>> >>>>> 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? >>>> >>>> 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 wor= th >>>> applying all these settings in this file? > > The bug#25415 [1] is about MySQL and a patch seems required. > > Would you like give a try? > > 1: The bug is open since 2017 without any inputs despite my 3 questions. Therefore, I will close it in one month from now if there is no more interest in. The backlog is already enough long. :-) Cheers, simon From unknown Mon Aug 11 18:16:31 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: Ben Sturmfels Subject: bug#25415: closed (Re: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default) Message-ID: References: <86wnd77lj1.fsf@gmail.com> <20170111111003.5e8ae2c8@stumbles.id.au> X-Gnu-PR-Message: they-closed 25415 X-Gnu-PR-Package: guix Reply-To: 25415@debbugs.gnu.org Date: Thu, 23 Jun 2022 10:03:05 +0000 Content-Type: multipart/mixed; boundary="----------=_1655978585-13793-1" This is a multi-part message in MIME format... ------------=_1655978585-13793-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #25415: MySQL "server has gone away" when reloading database dump due to "m= ax_allowed_packet" default which was filed against the guix package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 25415@debbugs.gnu.org. --=20 25415: https://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D25415 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1655978585-13793-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 25415-done) by debbugs.gnu.org; 23 Jun 2022 10:02:47 +0000 Received: from localhost ([127.0.0.1]:37476 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1o4Jfh-0003Y6-Ks for submit@debbugs.gnu.org; Thu, 23 Jun 2022 06:02:47 -0400 Received: from mail-wr1-f41.google.com ([209.85.221.41]:38757) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1o4Jff-0003Xo-Dm for 25415-done@debbugs.gnu.org; Thu, 23 Jun 2022 06:02:44 -0400 Received: by mail-wr1-f41.google.com with SMTP id v14so27186062wra.5 for <25415-done@debbugs.gnu.org>; Thu, 23 Jun 2022 03:02:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:subject:references:date:in-reply-to:message-id:user-agent :mime-version:content-transfer-encoding; bh=hRwtQBYg+uc0Ril6ccvwaVXokKybYsSxjMKocT6iRbw=; b=EwWR3J6zVZ2YOctmJR1XYLutX1OeVoE79jYm5BWC69qRi6C7hYgtL/vABICVlLBSK8 CSi+YH502G3NHjvdGYoNIaCcbhKU6qvv49THCAtEYkCJ3XLG+qyrz7z8h8j6UBlo0T0p 49cTwd/AqXAM2GzwYecJvC6dnfh2qymFN6E4dz04ubLlkz/6d87Jj9cMfzFn/CPuFIeA 8cuHwcfVdFsC1imaZQPR0PfjxFuOLtjHD/28DEhv6377ce7J+0B8WD7UbM/SfrB9D6r+ TIJYQhK9LOT5HJfW/l1seihFMapyP1jvqfeyjQo6LBOG4sJw1gXQo/lEYus1L07xlo4d x+pQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:subject:references:date:in-reply-to :message-id:user-agent:mime-version:content-transfer-encoding; bh=hRwtQBYg+uc0Ril6ccvwaVXokKybYsSxjMKocT6iRbw=; b=UPu7TsOdGmeqsdbYArPZYOnOWq36yWK5FdZ+2zNZItC0Rp4idnF6ZhumKzpJfjQTFW 9R544E1tSRloiAvoU/vxf2PMpTKuNEuBfLg+woOsCOjvNaLlBPKPb86j7uUDAAJxcp8h mkKN8Rq8thy9hojv0kW2snn4/knP0O07mrSen6U2xikkfkeJ+VH46Snr61SgYZ5SAlwZ 18/Gqk7EYfap7gJfcRk3qANFhzmPTQ/297Ufdpm2aqviaWhnBx8anemZph+pmqY/6zFg FAHt1dDK2+HpjMp+0fkaCiEIGDiRfuct5giM+qVrWJZAN5HTajPLa5uK390swyW5tqzg 8XYg== X-Gm-Message-State: AJIora+euQQN05E3DIMbrFSFrvLw7ny5sVOjVSw2vVQ4HLUV0yOynlRP iD/bsSmeebBTKadifL7RnFe7ZXCRwm4= X-Google-Smtp-Source: AGRyM1tfe37LdYVK6SXr4dw2MQkQac4k9PCH3fdCYIf4SzrV2yOB408NjVziFr0i/ZmbOoeLlQMyhw== X-Received: by 2002:adf:e710:0:b0:21b:8af6:d5bc with SMTP id c16-20020adfe710000000b0021b8af6d5bcmr7244668wrm.278.1655978557505; Thu, 23 Jun 2022 03:02:37 -0700 (PDT) Received: from lili ([147.99.27.198]) by smtp.gmail.com with ESMTPSA id p18-20020a05600c431200b003a0332760c0sm892900wme.16.2022.06.23.03.02.36 for <25415-done@debbugs.gnu.org> (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 23 Jun 2022 03:02:37 -0700 (PDT) From: zimoun To: 25415-done@debbugs.gnu.org Subject: Re: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> <58781150.3060202@stumbles.id.au> <86pmtbtlxl.fsf@gmail.com> <86sfx5kjhp.fsf@gmail.com> <86czmnr8ej.fsf@gmail.com> <86wnjfayys.fsf@gmail.com> Date: Thu, 23 Jun 2022 11:54:10 +0200 In-Reply-To: <86wnjfayys.fsf@gmail.com> (zimoun's message of "Wed, 05 Jan 2022 00:00:11 +0100") Message-ID: <86wnd77lj1.fsf@gmail.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: 25415-done 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: -1.0 (-) On Wed, 05 Jan 2022 at 00:00, zimoun wrote: > On Fri, 26 Nov 2021 at 02:51, zimoun wrote: >> On Tue, 12 Oct 2021 at 23:42, zimoun wrote: >>> On Tue, 14 Sep 2021 at 13:51, zimoun wrote: >>>> On Fri, 13 Jan 2017 at 10:29, Ben Sturmfels wrote: >>>>> On 13/01/17 01:22, Ludovic Court=C3=A8s wrote: > The bug is open since 2017 without any inputs despite my 3 questions. > Therefore, I will close it in one month from now if there is no more > interest in. The backlog is already enough long. :-) Done. Cheers, simon ------------=_1655978585-13793-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit 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 ------------=_1655978585-13793-1--