From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 0GG6HW+vQGG/TgEAgWs5BA (envelope-from ) for ; Tue, 14 Sep 2021 16:19:27 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id MD9tGW+vQGHIfQAAbx9fmQ (envelope-from ) for ; Tue, 14 Sep 2021 14:19:27 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 77D27160F6 for ; Tue, 14 Sep 2021 16:19:26 +0200 (CEST) Received: from localhost ([::1]:36354 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1mQ9HR-0005y0-Dh for larch@yhetil.org; Tue, 14 Sep 2021 10:19:25 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:33166) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1mQ9H5-0005Qq-N3 for bug-guix@gnu.org; Tue, 14 Sep 2021 10:19:03 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:38196) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1mQ9H5-0001by-F6 for bug-guix@gnu.org; Tue, 14 Sep 2021 10:19:03 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1mQ9H4-00073S-AY for bug-guix@gnu.org; Tue, 14 Sep 2021 10:19:02 -0400 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 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-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-guix@gnu.org List-Id: Bug reports for GNU Guix List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: 25415@debbugs.gnu.org Errors-To: bug-guix-bounces+larch=yhetil.org@gnu.org Sender: "bug-Guix" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1631629167; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding:resent-cc: resent-from:resent-sender:resent-message-id:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=V1cKnlXzCGTXzslMMYmRAvmaZ+0cRR7SZbtSSUP4AXE=; b=AX3QZHDI8PfG72INbkjplHAU8JGAqSbM0dV25RVLVbW6bOv1+SMFiv4JP/Jvmt4pJZL0um AnJ3HiaSLIOKJKuQvnxjYFub250yUSc8JMx6YobPG1yl1wlXZqA9whomrsyuTVyn+xT9DH JIgOOjXSawzM5iupdP3QNMn4UbKA9cGioI2xNmM8AqgnIlN7gp5OG4+eD2vn7WVcn6XVQV Aq3mC1Rkus055QvQLjdT7B/vUm7UlJx72sYwdqFMTADSPpmULwegxNRhgnHJdaJErejAp8 5FWLTZ0ehj3eib840ciZWbZDKMSyD1sEV2wf8ypvc0MWya5A7s2Rli/xBh4Sjw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1631629167; a=rsa-sha256; cv=none; b=bunWPVhxNJU905zijK5lGQBhpLlmt8sCP6Q6/3YydowDyE+e42I47bhRQKxd7iOoeGrziH UkAVOqBiUFMvZvOHsJZISvlkSkTS0TBW+72WJo/7UWxUQi0S/XTNNnzJCgBjSewBxfweNp Sqlut5RGmz7E8Kvre34P7H3Fh/4lFy6rlSQ8tqiQo2Ow1pyV7uGP8RPOP9LaP1h5No9Cqa bhKZH1QnA+HtQ9DZVmuFnT6kcWxFYA2TgVp5tZ5TrHpw3EV0Xz94w0DdSdO3botw2HK75g 1NS57G7IhCigRzw3d5/zpS4uR3T9grdiQ3SOPEi1k0HzuaURG6ym6laqxWeWNg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=DaEBCXO0; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Migadu-Spam-Score: -1.30 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20210112 header.b=DaEBCXO0; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of bug-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=bug-guix-bounces@gnu.org X-Migadu-Queue-Id: 77D27160F6 X-Spam-Score: -1.30 X-Migadu-Scanner: scn0.migadu.com X-TUID: D2qQSZYoOX+Y 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