Bug #7475 ERROR 2013 (HY000): Lost connection to MySQL server during query
Submitted: 22 Dec 2004 10:44 Modified: 22 Dec 2004 13:13
Reporter: Igor Radchenko Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S1 (Critical)
Version:5.0.2 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[22 Dec 2004 10:44] Igor Radchenko
Description:
mySQL ver 5.0.2 on Windows XP.
I tried to make a database table accodnibg to MySQL documentation. That's what 
I have:

Enter password: xxxxxx
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.2-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer-mysql> 
show databases;
+----------+ 
! Database !
+----------+
! mysql    ! 
! test      !
+----------+
2 rows in set (0.11 sec)
mysql> use test 
Database changed 
mysql> show tables; 
Empty set <0.01 sec>
mysql> create table photos (&#1087;&#1072;m&#1077; varchar(20), path varchar(256),
    -> persones varchar(256), shot date);
Query OK, 0 rows affected, 2 warnings (0.15 sec)
mysql> show tables;
+----------------+
! Tables_in_test !
+----------------+
! photos         !
+----------------+	
1 row in set (0.00 sec)
mysql> describe photos;
ERROR 2013 (HY000): Lost connection to MySQL server during query 
mysql>

I also tried to use PremiunSoft Navicat 2004 and failed to open the database. Server crashes.

That's what I have in the appcompat.txt file.

<?xml version="1.0" encoding="UTF-16"?>
<DATABASE>
<EXE NAME="mysqld-nt.exe" FILTER="GRABMI_FILTER_PRIVACY">
    <MATCHING_FILE NAME="comp-err.exe" SIZE="954368" CHECKSUM="0x53D9AA8C" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 07:58:33" UPTO_LINK_DATE="12/01/2004 07:58:33" />
    <MATCHING_FILE NAME="cygwinb19.dll" SIZE="669150" CHECKSUM="0x64393755" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x10000" LINK_DATE="07/15/1998 17:51:01" UPTO_LINK_DATE="07/15/1998 17:51:01" />
    <MATCHING_FILE NAME="isamchk.exe" SIZE="1073152" CHECKSUM="0x5C86E5FC" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:06:19" UPTO_LINK_DATE="12/01/2004 08:06:19" />
    <MATCHING_FILE NAME="libmySQL.dll" SIZE="1069056" CHECKSUM="0x448E9548" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x60000" LINK_DATE="12/01/2004 09:37:34" UPTO_LINK_DATE="12/01/2004 09:37:34" />
    <MATCHING_FILE NAME="myisamchk.exe" SIZE="1196032" CHECKSUM="0xE573386" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:20" UPTO_LINK_DATE="12/01/2004 09:38:20" />
    <MATCHING_FILE NAME="myisamlog.exe" SIZE="1114112" CHECKSUM="0x3A16A72C" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:22" UPTO_LINK_DATE="12/01/2004 09:38:22" />
    <MATCHING_FILE NAME="myisampack.exe" SIZE="1118208" CHECKSUM="0x9AA00BB1" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:23" UPTO_LINK_DATE="12/01/2004 09:38:23" />
    <MATCHING_FILE NAME="myisam_ftdump.exe" SIZE="1093632" CHECKSUM="0x900D94E9" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:25:26" UPTO_LINK_DATE="12/01/2004 08:25:26" />
    <MATCHING_FILE NAME="mysql.exe" SIZE="1110123" CHECKSUM="0x99159742" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:24" UPTO_LINK_DATE="12/01/2004 09:38:24" />
    <MATCHING_FILE NAME="mysqladmin.exe" SIZE="1048576" CHECKSUM="0x486BF79C" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:26" UPTO_LINK_DATE="12/01/2004 09:38:26" />
    <MATCHING_FILE NAME="mysqlbinlog.exe" SIZE="1069056" CHECKSUM="0xABD78034" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:27" UPTO_LINK_DATE="12/01/2004 09:38:27" />
    <MATCHING_FILE NAME="mysqlc.exe" SIZE="334712" CHECKSUM="0xBC927342" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x10000" LINK_DATE="10/29/1998 19:27:56" UPTO_LINK_DATE="10/29/1998 19:27:56" />
    <MATCHING_FILE NAME="mysqlcheck.exe" SIZE="1044480" CHECKSUM="0x1418D430" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:28" UPTO_LINK_DATE="12/01/2004 09:38:28" />
    <MATCHING_FILE NAME="mysqld-debug.exe" SIZE="5779559" CHECKSUM="0x6371BDDF" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:56:00" UPTO_LINK_DATE="12/01/2004 08:56:00" />
    <MATCHING_FILE NAME="mysqld-max-nt.exe" SIZE="4120576" CHECKSUM="0xC74B69B" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:50:13" UPTO_LINK_DATE="12/01/2004 08:50:13" />
    <MATCHING_FILE NAME="mysqld-max.exe" SIZE="4116480" CHECKSUM="0x10EB13C2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:47:11" UPTO_LINK_DATE="12/01/2004 08:47:11" />
    <MATCHING_FILE NAME="mysqld-nt.exe" SIZE="3649536" CHECKSUM="0x4AF3B33A" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:53:11" UPTO_LINK_DATE="12/01/2004 08:53:11" />
    <MATCHING_FILE NAME="mysqld.exe" SIZE="3645440" CHECKSUM="0xBE6615B" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:40:11" UPTO_LINK_DATE="12/01/2004 08:40:11" />
    <MATCHING_FILE NAME="mysqldump.exe" SIZE="1064960" CHECKSUM="0xAABD0F6E" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:30" UPTO_LINK_DATE="12/01/2004 09:38:30" />
    <MATCHING_FILE NAME="mysqlimport.exe" SIZE="1044480" CHECKSUM="0xD5081825" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:31" UPTO_LINK_DATE="12/01/2004 09:38:31" />
    <MATCHING_FILE NAME="MySQLInstanceConfig.exe" SIZE="1496576" CHECKSUM="0x8295B586" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="06/19/1992 22:22:17" UPTO_LINK_DATE="06/19/1992 22:22:17" />
    <MATCHING_FILE NAME="mysqlshow.exe" SIZE="1040384" CHECKSUM="0x7DDCD597" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:38:32" UPTO_LINK_DATE="12/01/2004 09:38:32" />
    <MATCHING_FILE NAME="mysqlshutdown.exe" SIZE="40960" CHECKSUM="0x39044159" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:05:33" UPTO_LINK_DATE="12/01/2004 09:05:33" />
    <MATCHING_FILE NAME="mysqlwatch.exe" SIZE="45056" CHECKSUM="0x38ECF10E" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:05:34" UPTO_LINK_DATE="12/01/2004 09:05:34" />
    <MATCHING_FILE NAME="my_print_defaults.exe" SIZE="122880" CHECKSUM="0x6B5AF9EA" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:24:40" UPTO_LINK_DATE="12/01/2004 08:24:40" />
    <MATCHING_FILE NAME="pack_isam.exe" SIZE="1024000" CHECKSUM="0x42260FAF" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:07:43" UPTO_LINK_DATE="12/01/2004 09:07:43" />
    <MATCHING_FILE NAME="perror.exe" SIZE="110592" CHECKSUM="0x8396569F" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 09:07:48" UPTO_LINK_DATE="12/01/2004 09:07:48" />
    <MATCHING_FILE NAME="replace.exe" SIZE="122880" CHECKSUM="0xD6A451F2" MODULE_TYPE="WIN32" PE_CHECKSUM="0x0" LINKER_VERSION="0x0" LINK_DATE="12/01/2004 08:28:00" UPTO_LINK_DATE="12/01/2004 08:28:00" />
</EXE>
<EXE NAME="kernel32.dll" FILTER="GRABMI_FILTER_THISFILEONLY">
    <MATCHING_FILE NAME="kernel32.dll" SIZE="932864" CHECKSUM="0x8CEAD581" BIN_FILE_VERSION="5.1.2600.0" BIN_PRODUCT_VERSION="5.1.2600.0" PRODUCT_VERSION="5.1.2600.0" FILE_DESCRIPTION="&#1041;&#1080;&#1073;&#1083;&#1080;&#1086;&#1090;&#1077;&#1082;&#1072; &#1082;&#1083;&#1080;&#1077;&#1085;&#1090;&#1072; Windows NT BASE API" COMPANY_NAME="&#1050;&#1086;&#1088;&#1087;&#1086;&#1088;&#1072;&#1094;&#1080;&#1103; &#1052;&#1072;&#1081;&#1082;&#1088;&#1086;&#1089;&#1086;&#1092;&#1090;" PRODUCT_NAME="&#1054;&#1087;&#1077;&#1088;&#1072;&#1094;&#1080;&#1086;&#1085;&#1085;&#1072;&#1103; &#1089;&#1080;&#1089;&#1090;&#1077;&#1084;&#1072; Microsoft® Windows®" FILE_VERSION="5.1.2600.0 (xpclient.010817-1148)" ORIGINAL_FILENAME="kernel32" INTERNAL_NAME="kernel32" LEGAL_COPYRIGHT="© &#1050;&#1086;&#1088;&#1087;&#1086;&#1088;&#1072;&#1094;&#1080;&#1103; &#1052;&#1072;&#1081;&#1082;&#1088;&#1086;&#1089;&#1086;&#1092;&#1090;. &#1042;&#1089;&#1077; &#1087;&#1088;&#1072;&#1074;&#1072; &#1079;&#1072;&#1097;&#1080;&#1097;&#1077;&#1085;&#1099;." VERFILEDATEHI="0x0" VERFILEDATELO="0x0" VERFILEOS="0x40004" VERFILETYPE="0x2" MODULE_TYPE="WIN32" PE_CHECKSUM="0xEA66C" LINKER_VERSION="0x50001" UPTO_BIN_FILE_VERSION="5.1.2600.0" UPTO_BIN_PRODUCT_VERSION="5.1.2600.0" LINK_DATE="08/18/2001 05:33:02" UPTO_LINK_DATE="08/18/2001 05:33:02" VER_LANGUAGE="&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081; [0x419]" />
</EXE>
</DATABASE>

What is the problem ?

How to repeat:
Enter password: xxxxxx
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.2-alpha-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer-mysql> 
show databases;
+----------+ 
! Database !
+----------+
! mysql    ! 
! test      !
+----------+
2 rows in set (0.11 sec)
mysql> use test 
Database changed 
mysql> show tables; 
Empty set <0.01 sec>
mysql> create table photos (&#1087;&#1072;m&#1077; varchar(20), path varchar(256),
    -> persones varchar(256), shot date);
Query OK, 0 rows affected, 2 warnings (0.15 sec)
mysql> show tables;
+----------------+
! Tables_in_test !
+----------------+
! photos         !
+----------------+	
1 row in set (0.00 sec)
mysql> describe photos;
ERROR 2013 (HY000): Lost connection to MySQL server during query 
mysql>
[22 Dec 2004 13:13] MySQL Verification Team
Duplicate for #6950
[6 Jan 2005 14:29] Sushil Kumar
I get the same error on a Windows 2000 Server SP3 machine for MySql 5.0.2-alpha.

Describing any table gives the "ERROR 2013 (HY000): Lost connection to MySQL server during query" error.

I want to use 5.0.2 to use stored procedures.
[10 Feb 2005 1:01] Sam Nanda
I would like to join the club ....
Any solution to this problem.

Thanks in advance.

Regards,
Sam
[10 Feb 2005 19:26] Amit
I'm using MySQL4.1.9-nt on a Windows Server 2003. Whenever I try to create/drop databases it gives me the same error.
[19 Jan 2006 16:08] bruno rovagnati
same problem but when trying to get SP status, Mysql 5.0.16
mysql> use ISP
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show procedure status;
ERROR 2013 (HY000): Lost connection to MySQL server during quer