Stack Overflow
Stack Overflow

Questions tagged [mysql-error-2013]

Error 2013: Lost Connection To Mysql Server During Query

This error

Error 2013: Lost Connection To Mysql Server During Query

could happen when the connection to the server during a query went away. The query might have been killed, or the thread servicing the process has crashed or died.

30 questions
29
votes
13 answers

Getting MYSQL Error: "Error Code: 2006 - MySQL server has gone away"

I am getting following error, when I try to import MYSQL database: Error Code: 2013 - Lost connection to MySQL server during queryQuery: Error Code: 2006 - MySQL server has gone away Can someone let me know what is wrong?
meetpd
  • 9,150
  • 21
  • 71
  • 119
8
votes
6 answers

MySQL Error 2013

I am facing connection failure to MySQL problem when I run my program for more than couple of days.MySQL Error Code is 2013 while connecting to Database. MySQL server and client programs are both on same machine. I am using FC5 as my OS and MySQL…
kova
4
votes
1 answer

Intermittent error connecting to my localhost MySQL instance from PHP: mysqli_connect(): HY000/2013

I have a LAMP website (PHP/MySQL), and I rely heavily on my MySQL database. Recently, the following error started occurring intermittently: [30-Oct-2011 16:11:49] PHP Warning: mysqli_connect() [
Jonathan
  • 63
  • 1
  • 6
3
votes
1 answer

facing "PDO Connection Error" when try to deploy symfony project to Debian

My project works fine on my local. When i put it on Debian, I am facing an error: PDO Connection Error: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 110 I searched it on the…
Erman Taylan
  • 383
  • 1
  • 3
  • 12
2
votes
1 answer

Lost network connection from long running SQL statement in MySQL Docker container

I have a long running SQL statement that times out when I run it against an AWS RDS instance from inside a local Docker container. I have a .env file that defines some environment variables needed to run the command. I get into the Docker container…
CaffeineFueled
  • 561
  • 2
  • 9
2
votes
0 answers

mysql-udf-http http_get function Linux

I want to insert into MYSQL UDF function "http_get". Currently I have a "mysql-udf-http.so" file that I import the function in the program, but to run it I get the error message: ERROR 2013 (HY000): Lost connection to MySQL server During query In…
Alberto
  • 21
  • 4
2
votes
1 answer

MySQL ERROR 2013 (HY000)

I'm trying to import a large database (the .sql file is 300MB) on a local MySQL install, it imports for about two seconds then I get this error message: ERROR 2013 (HY000) at line 457: Lost connection to MySQL server during query Apparently this is…
Sean
  • 6,389
  • 9
  • 45
  • 69
2
votes
1 answer

MySQL crashes on SELECT depending on schema

I am experiencing some strange behaviour with MySQL. I have a table, not large, about 20k rows, with one column that is VARCHAR(512). Performing a SELECT query on this table (that involves joins etc) works, but if I change the schema to…
Asher
  • 21
  • 4
1
vote
1 answer

accelerate very large mysql join

Problem: Query aborts after 10 minutes Query should be faster I created the following query. This one was the fastest of several versions. Unfortunately, with more data, even this one abots after 600 seconds with an error "Error Code: 2013. Lost…
Christian Ruf
  • 13
  • 3
1
vote
2 answers

Error calling procedure in MySQL: Error Code: 2013. Lost connection to MySQL server during query

I need help on MySQL, when I call a specific procedure the Workbench lose connection and the MySQL80 Windows service is arrested! I already tried to set higher parameter (600) on Edit -> Preferences -> SQL Editor -> DBMS connection read time out (in…
Ex.
  • 57
  • 7
1
vote
1 answer

Getting 2013 lost connection error when trying to connect to mysql with Python

I am trying to connect to mysql database to retrieve some id for some users and use those id to retrieve another set of data from another table. It should be easy but I am getting mysql errors. Here's a snippet of what I am trying to do. import…
Cryssie
  • 3,047
  • 10
  • 54
  • 81
1
vote
0 answers

Mysql Error Code: 2013. Lost connection to MySQL server during query 44.515 sec

I have a table called products2 with about 830,000 rows in it. When I had about 500,000 rows, the query runs slow but fine. And now when I try to query something, it almost doesnt return anything in Mysql Workbench. Showing the following…
Zhen Cai
  • 11
  • 2
  • 3
1
vote
1 answer

MySQL Error 2013 after a failed attempt to import

I was importing one table in a MySQL Server when the power went down. After this event I tried to query the table I was importing, but got the error 2013, only when I'm querying this table (the others work just fine). I have physical access to the…
user1207338
  • 11
  • 1
1
vote
1 answer

MySQL Assertion Failure in thread

Why does this Query Fails? SELECT SUB_COMMODITY, `VOL` AS Sales, `VOL_CHANGE` AS Dollar_change, `VOL_SHARE` AS Dollar_share, `VOL_SHARE_CHANGE` AS Dollar_share_change, `U_VOL` AS Unit_sales, `UVOL_CHANGE` AS Unit_change, …
yghanem
  • 86
  • 2
  • 12
0
votes
2 answers

How to reproduce mysql error 2013

I'am using MySQL version 5.5.14-log and we upgraded recently. Now I'am getting 2013 error in MySQL 5.5.14-log version frequently and I'am not able to reproduce the issue manually, from my application (compiled with MySQL version 5.0.41) only it is…
ajay
  • 41
  • 2
  • 2
  • 4
1
2