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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.