Page MenuHomePhabricator
Create Task
Maniphest T7812

"MySQL server has gone away" when restoring a backup, needed larger packet size, undocumented
Closed, DuplicatePublic
Actions

Description

I was restoring a backup that had been created using the instructions here: https://secure.phabricator.com/book/phabricator/article/configuring_backups/ My backup file was 84M in size.

When I ran

cat mybackup.sql | mysql -u root

I got the following error:

ERROR 2006 (HY000) at line 586: MySQL server has gone away

It turns out that increasing max_allowed_packet to 128M fixed this error. (It was 1M by default on my Arch system.) If this is an expected problem, can we make a reference to it in the documentation?

Related Objects

Event Timeline

oconnor663 created this task.Apr 13 2015, 4:55 PM
oconnor663 raised the priority of this task from to Needs Triage.
oconnor663 updated the task description. (Show Details)
oconnor663 added a project: Documentation.
oconnor663 updated the task description. (Show Details)
oconnor663 added a subscriber: oconnor663.
chad added a subscriber: chad.Apr 13 2015, 5:00 PM

A setup check is raised if you have max_allowed_packet below 32M already, did you ignore the issue?

epriestley added a subscriber: epriestley.Apr 13 2015, 5:27 PM

Users might encounter this before we have a chance to run any setup checks. Probably worth adding a note to the backup/restore docs.

• sshannin mentioned this in T7813: max_allowed_packet error with bin/storage dump.Apr 13 2015, 5:46 PM
oconnor663 added a comment.EditedApr 13 2015, 5:49 PM

Like @epriestley suggested, I probably got the helpful message when I set up my install the first time, but now doing a restore (on a new machine) I didn't have a chance to see it.

oconnor663 updated the task description. (Show Details)Apr 13 2015, 6:16 PM
chad closed this task as a duplicate of Restricted Maniphest Task.Apr 13 2015, 8:54 PM
Phabricator · Built by Phacility