MySQL Bugs: #69011: ERROR 2013 (HY000): Lost connection to MySQL server during query

Bug #69011	ERROR 2013 (HY000): Lost connection to MySQL server during query
Submitted:	19 Apr 2013 16:00	Modified:	23 Apr 2013 8:09
Reporter:	Paolo Pedrazzoli	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.77-log Source distribution	OS:	Linux (Red Hat Enterprise Linux Server release 5.7 (Tikanga))
Assigned to:		CPU Architecture:	Any
Tags:	ERROR 2013 (HY000): Lost connection to MySQL server during query

Description:
Environment description:
mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1
OS Version: Red Hat Enterprise Linux Server release 5.7 (Tikanga)

[root@myserver etgweb]# ls -laF | grep history.
-rw-rw---- 1 mysql mysql       8730 Jun 23  2011 history.frm
-rw-rw---- 1 mysql mysql 1195376640 Apr 19 17:50 history.ibd

when i execute a simple select count(*) on the following table:

CREATE TABLE `history` (
  `counterId` bigint(20) NOT NULL auto_increment,
  `vcId` bigint(20) NOT NULL,
  `day` date NOT NULL,
  `minutes` smallint(6) NOT NULL,
  `value` double default NULL,
  `status` int(11) default '1',
  PRIMARY KEY  (`counterId`),
  UNIQUE KEY `vcId_day_minutesUnique` (`vcId`,`day`,`minutes`)
) ENGINE=InnoDB AUTO_INCREMENT=79969225 DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED

I receive following error messages:

mysql> select count(*) from history;
ERROR 2013 (HY000): Lost connection to MySQL server during query

How to repeat:
Probably it is possible to repeat the problem with big table on the same mysql version and the same os version.

Suggested fix:
Unknow

Hello Paolo,

Please be informed that the MySQL version in which you are hitting this issue is very old one ( MySQL Community Server 5.0.77 relased on 2009-01-28 - http://dev.mysql.com/doc/relnotes/mysql/5.0/en/), could you please try the latest GA version in 5.1/5.5/5.6 and let us know if it is still repeable, if yes then send across complete error log and repeatable test case.

We do not fix bugs that are not repeatable with current versions.

Thanks,
Umesh

Hi Umesh, 

we are going to prepare a new server with os RHEL 6.4 and MySQL 5.1.67-log Source distribution.

Now the problem is related to the data migration because mysqldump does not work on the acutal server because i receive the same error (ERROR 2013 (HY000): Lost connection to MySQL server during query).

How can I migrate the database to the new server?

Thanks, 
Paolo.