MYSQL :: SQL Execution Error # 2013. Response From Database: Lost Connection To MySQL Server

ERROR 2013: Lost Connection To MySQL Server During Query
I have recently installed suse 9.0 linux which has MySQL 4.0.15 as part
of the distribution. After I set up my users I was able to use
mysqldump and pipe it into mysql on my windows machine running 4.0.16 to
dump a database to the linux box. However, now when I try to login to
the linux box from another machine on the network I get a query timed
out error immediately after I enter the command line to start the mysql
client.

mysql -h 192.168.1.2 -u cdw -pxxxxxx
ERROR 2013: Lost connection to MySQL server during query

The error happens with in a small fraction of a second after I type in
the command. I can login from the linux machine just fine though.

Error 2013: Lost Connection To MySQL Server During Query
I have MySQL 4.1.10 running successfully on an office XP machine, but
when I try to set up similar XP box at home I continually get this
error: "Error 2013: Lost connection to MySQL server during query".
The install went fine, and Windows XP is recognizing it as a running
service. But whenever I try to connect via one of my GUI applications
(e.g., MySQLFront), the error appears.

I have scoured this forum and Google looking for this error, but
haven't found anything helpful so far. This post ...
(http://forums.mysql.com/read.php?11,10684,10684) seemed similar, but
my service does not stop when I hit the error.

I've lost a couple days to this problem, and I've uninstalled and
reinstalled the app several times. I don't know where to go next. I
need to have 4.1 running because we need the Unions and Subqueries.

Error 2013: Lost Connection To MySQL Server During Query
I have MySQL 4.1.10 running successfully on an office XP machine, but when I try to set up similar XP box at home I continually get this error: "Error 2013:  Lost connection to MySQL server during query".

The install went fine, and Windows XP says it has started and is running as a service.  But whenever I try to connect via one of my GUI applications (e.g., MySQLFront), the error appears.

I have scoured this forum and Google looking for this error, but haven't found anything helpful so far.  I've lost a couple days to this problem, and I've uninstalled and reinstalled the app several times.  I don't know where to go next.  I need to have 4.1 running because we need the Unions and Subqueries.

Error 2013: Lost Connection To MySQL Server During Query
I get this message instantly (< 1 second) when I try to connect to the MySQL server from a remote host. I am using "mysql" at the remote client. Does not matter where the remote client is: on Solaris, on RH 7.2, on Fedora. Same thing every time.

I am using the the mysqld as it comes out of the box on Red Hat Linux 8.0.

I tried a google search on Error 2013, and there are a lot of responses:

User-defined Function: ERROR 2013 (HY000): Lost Connection To MySQL Server During Query
With mysql-4.1.1-alpha, using any User Defined Function ( UDF) at the
query execution stage, on Linux 2.6, gave me the following error:

"ERROR 2013 (HY000): Lost connection to MySQL server during query"

However, upgrading to mysql-4.1.2-alpha seemed to solve the problem.

Both versions were configured exactly as follows

../configure --with-openssl --enable-thread-safe-client --with-mysqld-ldflags
=-rdynamic

The only way I could solve this was by upgrading to 4.1.2-alpha-log. Then,
recompiling the functions, drop the old UDF functions, then, recreate.
So far so good.

Anyway, if you run into this problem, or just want more detail on the sample
User Defined Functions that come with MySQL ( /sql/udf_example.cc), I've put
my notes in the following link ( TIP 27 )

MySQL Error 2013: Lost Connection To MySQL Server During Query
I'm running sugarcrm on mysql and the following query is returning "MySQL error 2013: Lost connection to MySQL server during query":

Encountering 2013 Error ("Lost Connection To MySQL Server...")
I have a nightly job that performs backups on my MySQL servers. There are three production MySQL instances on different machines. My backups have been running successfully for months (until now).

However, on last night's backups for one instance, a couple of database/schemas (appear to have) backed up successfully, but the larger schemas failed, as follows:

=======================================
Backup of schema dhunt was successful in 0 seconds
Backup of schema mysql was successful in 0 seconds
Backup of schema support_appl was successful in 0 seconds
Error: Backup of schema support_dict was not successful (1115 seconds):
mysqldump: Got error: 2013: Lost connection to MySQL server during query when retrieving data from server
Error: Backup of schema test was not successful (0 seconds):
mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
=======================================

I re-ran the backup cron job with the same results. Does anyone have any troubleshooting suggestions?

Lost Connection To MySQL Server During Query (error_no 2013)
I am using PHP to invoke mysql_query to my database.
In most cases everything works fine and the query executes perfectly.
Sometimes, I will get a burst of errors and the query will fail with the following error:
Lost connection to MySQL server during query (err_no 2013)

UNION Causes Lost Connection ERROR 2013
I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute
the query with a UNION it returns:

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

I am able to run additional queries after I get the error, so the connection is not lost. I have tried running the query with the union on MySQL Query Browser and also on the command prompt and I get the same results.

Here is my query:

Network Problem - ERROR 2013 (HY000): Lost Connection ....
I'm having problems with my MySQL server when I do queries that return a lot of data over the network.

It's fine if I connect via the local UNIX socket

> mysql -u root -p

> SELECT * FROM users limit 100;
returns 100 rows in a few seconds

>SELECT * FROM users limit 1000;
returns 1000 rows in a few seconds

But when I try the same thing but connecting to the network port I get

> mysql -u root -p -h 127.0.0.1 -P 3306

> SELECT * FROM users limit 100;
returns 100 rows in a few seconds

> SELECT * FROM users limit 1000;
sits there for about 15 minutes and then I get the following message
ERROR 2013 (HY000): Lost connection to MySQL server during query

If I watch the traffic with tcpdump it sends a few packets right at the start and then doesn't appear to be sending anything for the next 15 minutes until the error appears.

I'm using 5.0.27-standard-log community edition.

Lost Connection To MySQL Server During Query Socket Error On Read. WSAGetLastError Return 10054($2746)
We just migrated our MySQL database from a NetWare server running version 5.0.21 to a openSUSE box running version 5.0.45.

Everything ran fine for a couple of days, then clients began losing their connections and creating new ones without the old threads being terminated. This behavior is the same for the Delphi client we use to access our database as well as the MySQL Administrator tool.

I've tried adjusting connection_timeout, but overall the settings for this server are the same as the previous one that ran without issues for a year.

Lost Connection To MySQL Server During Query / Server Has Gone Away
All of a sudden the server stopped working. When trying to execute a simple INSERT both from PHP and Query Browser, the server crashes and I get either "Lost connection to MySQL server during query" or "Server has gone away" errors.

The problem started on 5.0.18, and upgrading to 5.0.41 didn't help. I'm using Windows XP SP2.

I've seen quite a few posts on similar problems, but no real solutions though. Is that a bug?

Lost Connection To MySQL Server
I am using PHP to invoke mysql_query to my database.
In most cases everything works fine and the query executes perfectly.
Sometimes, I will get a burst of errors and the query will fail with the following error:
Lost connection to MySQL server during query (err_no 2013)

Does anyone know what could cause this?
Could this be a mysql configuration problem, or maybe some network problem?

Lost Connection To Mysql Server During Query
While working in application VB with MySQL this error occurs,

'lost connection to mysql server during query'

Mostly this error occurs during multiple users working in exe.

How to rectify this error.

Lost Connection To MySQL Server During Query
I recently installed an ubuntu LAMP server for my website and upon trying a script that uses a mysql database (which I set up the tables via phpmyadmin) and I get this error:

Warning: mysql_connect(): Lost connection to MySQL server during query in /home/tanner/Desktop/bot/DoctorWho/db_connect.php on line 4

I've searched the forums and I've gotten no answers. Anyone know the answer?

Lost Connection To MySQL Server During Query
I downloaded the MySQL trail version a few month ago, it worked fine. however after i brought 1 x EMS MySQL Manager Professional (Non-commercial license) and registered but the tool doesn't work anymore... when i try to register a database and try to get it connect, it through me a error message "Lost connection to MySQL server during query". more to it... when i try to create a database at my local host, a error messate says "can't connect to MySQL server on localhost (10061)... PLease help!

Lost Connection To Mysql Server During Query
I have following problem: when I try to connect from Windows XP to mysql
server (linux computer), I get the following error: Lost connection to mysql
server during query. This happens when I test the connection.

I have firewall in linux, so I opened the port 3306. Is there something else
I need to change to make sure that the connection will work properly?

Lost Connection To Mysql Server During Query
I'm running mysql stored procedure using VB as front end. While clicking Ok button in application it calls 3 stored procedures and returns a resultset. First time it works properly. If second time clicked the error 'lost connection to mysql server during query' displayed. Third time works fine. Like this alternatively throws error message.

Lost Connection To MySQL Server During Query
After changing RAM and the ethernet card of my DB server, the problem of getting
frequent:

Database error (error code 102)
Could not connect to database server (Lost connection to MySQL server during query)

Still occurs ;/

I've tried to eliminate all factors (like multiple servers, load-balancers,
replication etc) so I have wrote a php script that only does the following:

- opens db connection
- does a simple select
- closes db connection

If I refresh this page over and over, every 6-7 times I get the above error.
Anyone have any further solutions, ?? I've tried the software (re-installing
mysql, upgrading, etc....) and tried the hardware (RAM, ethernet card). Nothing
seems to help.

The DB server is Linux Redhat 7.3 with the 2.4.18-3smp kernel. I am running
MySQL standard 4.0.13.

Connection Error (2013) Using TCP/IP
When I try to connect to a remote MySQL server with following command:
>mysql -h myhost.com -u mysql -p

I'll occasionally get an error message saying:
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization packet', system error: 104

This is quite often when I using a remote client, but never happens if I use the local client on the MySQL server. Is this a known bug or anyone knows a solution to this problem? Code:

Lost Connection To MySQL Server During Query After Script Takes 60 Secs
I get the error "Lost connection to MySQL server during query" at the mysql_select_db when reaching this part of the code after 60 seconds of script execuation has already passed. Works fine if the script execution time when reaching this is under 60. Tested with Sleep() and I'm 100% sure that the 60 second barrier is causing it. I just don't know what the barrier is.////

CREATE INDEX Crashes Server (Lost Connection...)
I'm having trouble with a table I created quite a while ago and now want to add an index to. Here's what I get if I try to add an index on the host field of my table:

mysql> create index Index_host on uselog(host);
ERROR 2013 (HY000): Lost connection to MySQL server during query

Connection was lost because the server crashed. The Windows event log has an event that says "Faulting application mysqld-nt.exe, version 0.0.0.0, faulting module mysqld-nt.exe, version 0.0.0.0, fault address 0x0017dc06."

I've also tried the allegedly identical "ALTER TABLE uselog ADD INDEX Index_host(host)", as well as trying to index a different column, all with the same outcome (server crash).

Thing is, I had no trouble adding an index to the same table a week or so ago. The table was smaller then (and had only one index), but even now, it's not very big by DB standards, so I can't imagine that's the problem.

(My table had ~900K rows earlier today, which I pruned down to 140K rows after my first failed attempt to add the index. Puny! Only 55MB data length, according to MySQL administrator.)

"Lost Connection To MySQL Server During Query"
Bog standard SuSE 8.2 Linux install.

I have installed mySQL (off the SuSE 8.2 distro CDs). I can connect locally,
e.g:

bealzebub> mysql -u root -p mysql -h localhost

....logs me in just fine. However, this:

bealzebub> mysql -u root -p mysql -h bealzebub

....causes the connection to fail with: "ERROR 2013: Lost connection to MySQL
server during query". Its the same if I try to log in from another machine.

"Lost Connection To MySQL Server During Query"
Hi, I wonder if anyone can help me with this.

Bog standard SuSE 8.2 Linux install.

I have installed mySQL (off the SuSE 8.2 distro CDs). I can connect locally,
e.g:

bealzebub> mysql -u root -p mysql -h localhost

....logs me in just fine. However, this:

bealzebub> mysql -u root -p mysql -h bealzebub

....causes the connection to fail with: "ERROR 2013: Lost connection to MySQL
server during query". Its the same if I try to log in from another machine.

Anyone?

MySQL Error 2013
I set up a PHP/Apache MySql install on a Win XP machine. The server works fine, PHP is donig it's thing. When I try to fire up MySQL (version 5.0), I get the following;

ERROR 2013 (HY000) Lost Connection to MySQL server during query

This happens from both the command line and the admin GUI. I am quite sure of the user name and password.

Lost Connection To Mysql
i have mysql server located in in machine that used Red Hat 8.0 and my mysql server version was 3.23.58. I am trying to connect using my machine..And currently i used Red Hat Fedora...But when i am trying to connect to mysql server i got this error message.....

"ERROR 2013: Lost connection to MySQL server during query"
And i am also trying to killall my mysqld and start the mysql server through mysql kernel....
/usr/libexec/mysql -Sg --user=root&
After that, when i tried to reconnect it, it's hang up !.....nothing to be done and i need to start my machine back to run mysql.

Lost Connection To MySQL
Ok heres a quick background on the situation. I run a large mysql orinated website, and tried splitting the load between 2 servers together connected via lan. On server 2 im running debian 3.0 testing/unstable with MySQL 4.0.24. When i try to execute a php mysql search script from Server 1 I get this error:

Warning: mysql_pconnect(): Lost connection to MySQL server during query ..............
Connection Error

I have searched googled, and found a possible solution, which turned out did not work. I simply added these 2 lines to my /etc/hosts.allow

/etc/hosts.allow
mysqld : ALL : ALLOW
mysqld-max : ALL : ALLOW

Also I edited /etc/mysql/my.cnf and added wait_timeout 16000

Database Server Connection
I am trying to using mysql as back-end for an application(web) running
on the window 2X, one thing I am not sure is that once I establish the
connection between database server and application, should I keep this
connection open while application is running, or only open it when
there is a requet to qury records from database?

Lost Username And Password To MySQL Server....
I have been using the MySQL control center and had my usernames and
passwords for the MySQL server stored in the control center.
I recently lost everything on my PC including the usernames and
passwords.

Does anyone know if there is a way to reset or remove the passwords
from MySQL so that I can make new ones? I do have the root password for the server that MySQL is running on.

Database Error Storing File: MySQL Server Has Gone Away
The following thread shows exact same error I am having but without a resolution. I am going through the same example of the book he refers to in the thread. I guess if I cant store a file that is large in mysql how do you get it do it is stored on the filesystem and a pointer to that file added to mysql?

http://www.sitepoint.com/forums/show...A+MySQL+server

Connection Lost
I have an unusual problem with the error "Lost connection to MySQL sever
during query". I receive this message only when querying one table in a
database. All other tables and queries work fine.

Lost Connection
I am getting this error "ERROR 2013: Lost connection to MySQL server
during query" when i try to connect from one client, on all other
clients i don't have any problems connecting to specific server.
Also from this client i can connect to the other servers without any
problem.

Lost Connection
I send a big INSERT request to the mysql server and I very often get a 'Lost connection to MySQL server during query' error. Though the client and the server are on the same machine.... Is there any way to avoid this problem ?

Connection Lost
I've got the following problem: I've an select wich gets binary Data out of my sql-table.
The type is longblob and i've lauded some files into it previously with the LOAD_FILE function.

The files have a size between 0.5 and 3MB. I'm loading the data out of the tables with a select like: SELECT data FROM files WHERE file_id=1

After executing the command and some seconds waiting (70 seconds) i get the error "connection lost".

The file i'm actually trying to load has a size of 1,5MB.
(Im using mysql with C++ and the execQuery returns with false after that 70 seconds).

The code above worked fine as long as i use my computer as client use the server in my LAN or the remote server (client and server located in Germany).
When my mate tries to use this code from India the above error occures.

The question now is how can i handle that error? What can i do to get the file even if the inet connection might be a little bit unstable or slow?
Im specially interested in the way how the communication between client and server works. Is the "connection lost" because of instability or because of a timeout?
Every other query works fine from india, only this one which needs some bandwidth is failing.

Besides: i've set the following parameters both for server and client:
mysql_opt_timeout = 5;
mysql_opt_max_allowed_packet = 16*1024L*1024L; //16MB

for the mysql_opt_timeout: is this a timeout which is only important for establishing the connection? or does it affects every query?

Lost Connection Problem
I have problems with the connection to the MySql server. The problem only occure
when running the application on the webserver, never on the local machine.
A strange thing is that it not allways happen, just sometimes. I wounder if the problem depends on a closed connection but then it should appear all the time or ..... ? Code:

Connection To Localhost Lost
After installing MySql I telnet localhost 3306 and I receive garbled text ant then it says:
connection to localhost lost.

Error Message: MYSQL RealTime: Failed To Connect Database Server Asterisk
I have installed asterisk version 1.2.14, asterisk-addons 1.2.5 and mysql version 4.1.21. on Red Hat linux version 9.0. I created the database 'asterisk' in mysql so that the asterisk cdr record can be stored in my sql. I has edited the asterisk modules.conf to load cdr_addon_mysql.so and also change the configuration in cdr_mysql.conf. Finally, i do a reset on asterisk.

I got the below error message after i reset my asterisk.

Error [6825]: cdr_addon_mysql.c:231 mysql_log: cdr_mysql:cannot connect to database

ERROR[6969]: res_config_mysql.c: 651 mysql_reconnect: MYSQL RealTime: Failed to connect database server asterisk on (err 1045). Check debug for more info.

Insert Into Select - Connection Lost
my problem - want to write a query - find new records in one table and insert in an ohter to generate new keys... See below the statement - but wenn I execute the select part it works fine - as soon as I add the insert into for the select i loose the connection to the mysql server (Error 2013)

Error Establishing A Database Connection
I'm trying to use MySQL on my computer to design and test a WordPress blog locally, but I keep getting the message, "Error establishing a database connection." This isn't limited to WordPress; if I run a simple MySQL test script I get the same problem.

I'm using MySQL 4.0.21 (I installed this old version after getting the same results with a couple of newer versions, so I don't think this is the problem). I'm on OS X 10.4.8.

Using MySQL Administrator, I'm able to connect to the server as root. I created my wordpress schema and assigned all available connection privileges to root on localhost, [computername].local, and %.

I'm used to creating a database and assigning a user to it using cPanel. I suspect the solution is simple and I'm overlooking something obvious because of my newbie status when it comes to MySQL.

Lost Connection My Wait_timeout Is In Default Setting 28800
PHP/MYSQL) under UBUNTU 6.06. I keep on getting this error message "Lost connection to MySQL server during query" my wait_timeout is in default setting "28800". What else could cause this problem?

Maximum Execution Time Of 300 Seconds Exceeded (was "MYSQL Error")
I have a huge database 400mb+ in size which i have exported into a .sql file. I tried to run this export script into a new database and it runs fine until three quarters into the scripts execution and the following error appears:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<br / >
<b>Fatal error</b>: Maximum execution time of 300 seconds exceeded in <b' at li ne 1
I believe this error may relate to "delayed_insert_timeout = 300". How do I increase this limit in mysql - maybe it may solve the problem but then again it may not .

Any advice is most gratefully appreciated - As you can imagine if the script runs fine for 3/4 of it and then an error appears, stating the error is on line 1, it will take me days to go through the whole script (hundreds of thousands of rows) to find the error as I assume the error does not reside on line 1 as this line would have been executed.

I am running the script on mysql 5, and via source /path/****.sql on linux.

Slow Response From MySQL
I was wondering if any one can help me out, I am literally tearing my
hair out with an availability search I have written.

Previously I was selecting all the records from two databases but
noticed the response time was very slow anything up to 20 secs.

I tried to streamline the search by only selecting the columns I
needed from the tables and created indexes for each of the tables for
the required rows but now the results are executing in around 50 - 60
secs, which is ultimately alot slower.

The SQL query I am using at the moment is this:

SELECT villas.id, villas.resort, villas.beds, villas.owner,
villas.air_con, villas.walk_beach, villas.walk_shop, pricing.id,
pricing.week, pricing.price, pricing.availability FROM villas LEFT
OUTER JOIN pricing ON villas.id = pricing.id WHERE pricing.week =
1073088000 AND pricing.availability = 1 AND villas.beds > 0 AND
pricing.price > 0 AND ( villas.resort = 'cala_dor' OR villas.resort =
'pollenca' ) GROUP BY villas.id ORDER BY villas.owner DESC ,
villas.beds ASC

No Response From MySQL From PHP With WAMP On XP
I am new to PHP/MYSQL and am setting up/running Apache 2 as a development platform on my Win XP pc.

I have succeeded in running php scripts on Apache but when I attempt to connect to mySQL I don't receive any response whatsoever, not even a helpful error message.

I have attempted binding the address in my.ini to 127.0.0.1, and have moved the mysql_connect script various places within my "www" structure.

I understand that certain firewall applications on XP can be problematic. I feel that there is probably a simple fix that I'm overlooking; I'd like to find it before I start tampering with my protection software.

Here's what I'm running into. Running the following script produces only "point 3", which makes me believe that the script is bailing out around the _connect command:

Code:

Delayed Response From MySQL To VB 6.0 Application
I have developed a system using Visual Basic 6.0 connecting to a MySQL database. The system inserts new records, updates existing records and views all records in the database.

When I do an insert record and save the record to the database,I have a Flex Grid that I use to view all records from the table in the database,even the newely added record I just added. However, when i do add a new record, it takes at least half a minute to see the record in my Flex Grid.

This confuses the user and he/she thinks that the record did not save, where in fact it did.I had already put an feature to update the Flex Grid and I don't think that Visual Basic is the problem. I think the problem may be the delay in response from the MySQL database to the VB application.

This is the only problem I am having with MySQL, but it's a lot better to manage and easier to use than Microsoft SQL Server or Oracle.