Bug #60825 "ERROR 2006 (HY000) at line 78: MySQL server has gone away"

• Submitted: 10 Apr 2011 19:27
• Modified: 11 Jun 2011 23:17
• Reporter: André verwijs
• Status: No Feedback
• Category: MySQL Server: Backup
• Severity: S2 (Serious)
• Version: mysql-5.5.11
• OS: Windows (6.0.6002 Service Pack 2 Build 6002)
• CPU Architecture: Any

[10 Apr 2011 19:27] André verwijs

Description:
"ERROR 2006 (HY000) at line 78: MySQL server has gone away" 

this is still a problem with mysql. 

André

How to repeat:
try to restore a large mysql backup...

Suggested fix:
Update default settings to prevent this..

[10 Apr 2011 19:29] André verwijs

large backup is 100MB or more..

[10 Apr 2011 20:34] Valeriy Kravchuk

Please, check in the error log if the server crashed. Please, send the output of:

show variables like '%pack%';

[11 Apr 2011 9:30] Peter Laursen

I think this could be the problem:
http://www.webyog.com/blog/2009/08/10/mysql-server-has-gone-away-part-1-max_allowed_packet...

[11 Apr 2011 10:56] MySQL Verification Team

See prior questions.

[11 Apr 2011 17:26] André verwijs

Mr. Laursen, the blog is very interesting, thanks for that. 
mr. Kravchuk, i will try to reproduce the error and check the log files...

[11 May 2011 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[12 Jun 2011 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".