From: Ben Sturmfels <ben@stumbles.id.au>
To: 25415@debbugs.gnu.org
Subject: bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default
Date: Wed, 11 Jan 2017 11:10:03 +1100 [thread overview]
Message-ID: <20170111111003.5e8ae2c8@stumbles.id.au> (raw)
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
next reply other threads:[~2017-01-11 0:31 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2017-01-11 0:10 Ben Sturmfels [this message]
2017-01-12 14:22 ` bug#25415: MySQL "server has gone away" when reloading database dump due to "max_allowed_packet" default Ludovic Courtès
2017-01-12 23:29 ` Ben Sturmfels
2017-01-13 8:03 ` Ludovic Courtès
2021-09-14 11:51 ` zimoun
2021-10-12 21:42 ` zimoun
2021-11-26 1:51 ` zimoun
2022-01-04 23:00 ` zimoun
2022-06-23 9:54 ` zimoun
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=20170111111003.5e8ae2c8@stumbles.id.au \
--to=ben@stumbles.id.au \
--cc=25415@debbugs.gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/guix.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.