Bug #54976 ERROR 2006 (HY000) at line 1303128: MySQL server has gone away

• Submitted: 3 Jul 2010 5:42
• Modified: 5 Jul 2010 8:11
• Reporter: Anil Alpati
• Status: Not a Bug
• Category: MySQL Server: Row Based Replication ( RBR )
• Severity: S2 (Serious)
• Version: 5.1.45
• OS: Windows
• CPU Architecture: Any

[3 Jul 2010 5:42] Anil Alpati

Description:
Im facing an issue while restoring
incremental backup file using mysqlbinlog command.

Since - Log file size is around 1.5 GB. After some time Im getting an
message

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

because after some instance its showing the message as mentioned above

I want split log file into some sub files

It would appreciable if you send me suggestions how can i resolve this
problem.

How to repeat:
Im facing an issue while restoring
incremental backup file using mysqlbinlog command.

Since - Log file size is around 1.5 GB. After some time Im getting an
message

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

because after some instance its showing the message as mentioned above

I want split log file into some sub files

It would appreciable if you send me suggestions how can i resolve this
problem.

[3 Jul 2010 7:51] Valeriy Kravchuk

Please, send error log from the server.

[3 Jul 2010 8:44] Anil Alpati

Its not printing any thing in related to this failure in mysql error log file.

[3 Jul 2010 8:47] Anil Alpati

please let me know if u need any other details from my end.

Also Now - I have restricted binary log file size limit to 500 MB. now its logging upto that.

[5 Jul 2010 5:16] Sveta Smirnova

Thank you for the feedback.

> Its not printing any thing in related to this failure in mysql error log file.

Does this mean server is up and running after restore failed?

[5 Jul 2010 6:02] Anil Alpati

YES, server is up and running perfectly.

I guess this issue is might be with log file size.(1.5 GB) not with mysql server connections since its consumes more memory while restoration so its failing after some time.  

Please let me know if any thing else which i can comment on your request

[5 Jul 2010 8:11] Sveta Smirnova

This is not a bug than.

See http://dev.mysql.com/doc/refman/5.1/en/gone-away.html for reasons why you can get such error and how to solve the problem.

[15 Aug 2013 4:51] Kamal Machareka

I'm having the same issue when attempting to restore a database on a MySQL version 5.5.33.

Database is 32 MB in size. I'm getting the "ERROR 2006 (HY000) at line 1553: MySQL server has gone away" error for the "mysql -u root -pMYPASSWORD MYDATABASE < BACKUPFILE.sql" command from a CMD prompt.

Same result when restore is attempted using a third-party tool (phpMyAdmin).

Any suggestions would be highly appreciated.