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: Fri, 13 Jan 2017 10:29:20 +1100 Message-ID: <58781150.3060202@stumbles.id.au> References: <20170111111003.5e8ae2c8@stumbles.id.au> <87wpe02w9c.fsf@gnu.org> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UlePjgg7wGUda5d5icBEoAPXQQe4wJXMp" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:60688) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1cRorj-000657-2J for bug-guix@gnu.org; Thu, 12 Jan 2017 18:33:08 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1cRore-0003vU-6M for bug-guix@gnu.org; Thu, 12 Jan 2017 18:33:07 -0500 Received: from debbugs.gnu.org ([208.118.235.43]:36468) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1cRore-0003vN-2m for bug-guix@gnu.org; Thu, 12 Jan 2017 18:33:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1cRord-0007sm-NT for bug-guix@gnu.org; Thu, 12 Jan 2017 18:33:01 -0500 Sender: "Debbugs-submit" Resent-Message-ID: In-Reply-To: <87wpe02w9c.fsf@gnu.org> 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: Ludovic =?UTF-8?Q?Court=C3=A8s?= Cc: 25415@debbugs.gnu.org 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--