GNU bug report logs - #25415
MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default

Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.

Package: guix; Reported by: Ben Sturmfels <ben@HIDDEN>; dated Wed, 11 Jan 2017 00:31:01 UTC; Maintainer for guix is bug-guix@HIDDEN.

Message received at 25415 <at> debbugs.gnu.org:


Received: (at 25415) by debbugs.gnu.org; 13 Jan 2017 08:03:59 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Fri Jan 13 03:03:59 2017
Received: from localhost ([127.0.0.1]:52031 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1cRwq6-0000LB-QX
	for submit <at> 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 <ludo@HIDDEN>) id 1cRwq4-0000Ky-SS
 for 25415 <at> 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 <ludo@HIDDEN>) id 1cRwpu-0004QH-9U
 for 25415 <at> 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 <ludo@HIDDEN>)
 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 <ludo@HIDDEN>)
 id 1cRwps-0005TN-47; Fri, 13 Jan 2017 03:03:44 -0500
From: ludo@HIDDEN (Ludovic =?utf-8?Q?Court=C3=A8s?=)
To: Ben Sturmfels <ben@HIDDEN>
Subject: Re: bug#25415: MySQL "server has gone away" when reloading database
 dump due to "max_allowed_packet" default
References: <20170111111003.5e8ae2c8@HIDDEN> <87wpe02w9c.fsf@HIDDEN>
 <58781150.3060202@HIDDEN>
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?=
 =?utf-8?Q?=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@HIDDEN> (Ben Sturmfels's message of
 "Fri, 13 Jan 2017 10:29:20 +1100")
Message-ID: <87shonl736.fsf@HIDDEN>
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-Debbugs-Envelope-To: 25415
Cc: 25415 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -8.2 (--------)

Ben Sturmfels <ben@HIDDEN> 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
>> <mysql-configuration> 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.




Information forwarded to bug-guix@HIDDEN:
bug#25415; Package guix. Full text available.

Message received at 25415 <at> debbugs.gnu.org:


Received: (at 25415) by debbugs.gnu.org; 12 Jan 2017 23:32:55 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Thu Jan 12 18:32:55 2017
Received: from localhost ([127.0.0.1]:51867 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1cRorX-0007sO-6H
	for submit <at> 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 <ben@HIDDEN>) id 1cRoo9-0007m9-GP
 for 25415 <at> 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: <xms:UxF4WES4hsj_p9ZA0p1BWFqUrrS1V5eqP7-CQrDXhIrFCzPjtjLULA>
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)
Subject: Re: bug#25415: MySQL "server has gone away" when reloading database
 dump due to "max_allowed_packet" default
To: =?UTF-8?Q?Ludovic_Court=c3=a8s?= <ludo@HIDDEN>
References: <20170111111003.5e8ae2c8@HIDDEN> <87wpe02w9c.fsf@HIDDEN>
From: Ben Sturmfels <ben@HIDDEN>
X-Enigmail-Draft-Status: N1110
Message-ID: <58781150.3060202@HIDDEN>
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@HIDDEN>
Content-Type: multipart/signed; micalg=pgp-sha512;
 protocol="application/pgp-signature";
 boundary="UlePjgg7wGUda5d5icBEoAPXQQe4wJXMp"
X-Spam-Score: -0.7 (/)
X-Debbugs-Envelope-To: 25415
X-Mailman-Approved-At: Thu, 12 Jan 2017 18:32:54 -0500
Cc: 25415 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
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
> <mysql-configuration> 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--




Information forwarded to bug-guix@HIDDEN:
bug#25415; Package guix. Full text available.

Message received at 25415 <at> debbugs.gnu.org:


Received: (at 25415) by debbugs.gnu.org; 12 Jan 2017 14:22:56 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Thu Jan 12 09:22:56 2017
Received: from localhost ([127.0.0.1]:50719 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1cRgHH-0005Bv-Q5
	for submit <at> 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 <ludo@HIDDEN>) id 1cRgHG-0005Bi-7N
 for 25415 <at> 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 <ludo@HIDDEN>) id 1cRgH3-0003r9-LL
 for 25415 <at> 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 <ludo@HIDDEN>)
 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 <ludo@HIDDEN>)
 id 1cRgH2-0000Kn-QX; Thu, 12 Jan 2017 09:22:41 -0500
From: ludo@HIDDEN (Ludovic =?utf-8?Q?Court=C3=A8s?=)
To: Ben Sturmfels <ben@HIDDEN>
Subject: Re: bug#25415: MySQL "server has gone away" when reloading database
 dump due to "max_allowed_packet" default
References: <20170111111003.5e8ae2c8@HIDDEN>
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?=
 =?utf-8?Q?=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@HIDDEN> (Ben Sturmfels's message
 of "Wed, 11 Jan 2017 11:10:03 +1100")
Message-ID: <87wpe02w9c.fsf@HIDDEN>
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-Debbugs-Envelope-To: 25415
Cc: 25415 <at> debbugs.gnu.org
X-BeenThere: debbugs-submit <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
X-Spam-Score: -8.2 (--------)

Hi Ben,

Ben Sturmfels <ben@HIDDEN> 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
<mysql-configuration> 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.




Information forwarded to bug-guix@HIDDEN:
bug#25415; Package guix. Full text available.

Message received at submit <at> debbugs.gnu.org:


Received: (at submit) by debbugs.gnu.org; 11 Jan 2017 00:30:41 +0000
From debbugs-submit-bounces <at> debbugs.gnu.org Tue Jan 10 19:30:41 2017
Received: from localhost ([127.0.0.1]:49231 helo=debbugs.gnu.org)
	by debbugs.gnu.org with esmtp (Exim 4.84_2)
	(envelope-from <debbugs-submit-bounces <at> debbugs.gnu.org>)
	id 1cR6oK-0004ed-Pt
	for submit <at> 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 <ben@HIDDEN>) id 1cR6Uh-00049D-FH
 for submit <at> 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 <ben@HIDDEN>) id 1cR6Ub-0005xR-E0
 for submit <at> 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 <ben@HIDDEN>) id 1cR6Ub-0005xL-Ap
 for submit <at> 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 <ben@HIDDEN>) id 1cR6Ua-00005Q-9A
 for bug-guix@HIDDEN; Tue, 10 Jan 2017 19:10:17 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <ben@HIDDEN>) id 1cR6UX-0005vi-3A
 for bug-guix@HIDDEN; 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 <ben@HIDDEN>) id 1cR6UW-0005v5-TJ
 for bug-guix@HIDDEN; 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 <bug-guix@HIDDEN>; 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: <xms:4nd1WKc6qqn43o-aaFXn_kIflT93gipqFDXibyOv7lwNES88RiCXMQ>
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 <bug-guix@HIDDEN>; Tue, 10 Jan 2017 19:10:09 -0500 (EST)
Date: Wed, 11 Jan 2017 11:10:03 +1100
From: Ben Sturmfels <ben@HIDDEN>
To: bug-guix@HIDDEN
Subject: MySQL "server has gone away" when reloading database dump due to
 "max_allowed_packet" default
Message-ID: <20170111111003.5e8ae2c8@HIDDEN>
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 <at> debbugs.gnu.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: <debbugs-submit.debbugs.gnu.org>
List-Unsubscribe: <https://debbugs.gnu.org/cgi-bin/mailman/options/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=unsubscribe>
List-Archive: <https://debbugs.gnu.org/cgi-bin/mailman/private/debbugs-submit/>
List-Post: <mailto:debbugs-submit <at> debbugs.gnu.org>
List-Help: <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=help>
List-Subscribe: <https://debbugs.gnu.org/cgi-bin/mailman/listinfo/debbugs-submit>, 
 <mailto:debbugs-submit-request <at> debbugs.gnu.org?subject=subscribe>
Errors-To: debbugs-submit-bounces <at> debbugs.gnu.org
Sender: "Debbugs-submit" <debbugs-submit-bounces <at> debbugs.gnu.org>
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




Acknowledgement sent to Ben Sturmfels <ben@HIDDEN>:
New bug report received and forwarded. Copy sent to bug-guix@HIDDEN. Full text available.
Report forwarded to bug-guix@HIDDEN:
bug#25415; Package guix. Full text available.
Please note: This is a static page, with minimal formatting, updated once a day.
Click here to see this page with the latest information and nicer formatting.
Last modified: Mon, 25 Nov 2019 12:00:02 UTC

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997 nCipher Corporation Ltd, 1994-97 Ian Jackson.