Can you provide more details?
network layout, type of client/app used, connectors,etc,etc?
Thanks
Claudio
2009/9/9 stutiredboy stutired...@gmail.com
hi,all:
we met a problem that:
* Lost connection to MySQL server during query
SHOW TABLE STATUS WHERE ENGINE='MyISAM'
*sometimes it works
Since it is very unlikely that you lose connection on the socket file,
I guess you are using a PHP app, that uses the mysql driver and the problem
must be in the driver.
I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the
later one.
Try different PHP (and driver) versions.
the application program and mysql server are in the same host
and i have add skip-name-resolv to the my.cnf and
extend the max_allowed_packet from 16M to 32M
our application connected to mysql server from mysql.sock
before the query which cause lost connection to MySQLserver..
we only ran some
In my experiences, there're three reasons below.
1. Your network is not stable.
2. Your mysqld's parameter called max_allowed_packet is adjusted too small,
trying to increase it.
3. Your mysqld's parameter called connect_timeout is adjusted too small,
trying to increase it.
On Thu, Oct 30, 2008
I've never had a lot of luck tracking down this sort of problem. One
thing I've found to be a good first step is to add each server
involved to the other server's /etc/hosts file (and restart MySQL so
it notices).
Don't have much more to offer other than the usual suspects: recent
versions,
At 10:21 PM 10/29/2008, you wrote:
I've never had a lot of luck tracking down this sort of problem. One
thing I've found to be a good first step is to add each server
involved to the other server's /etc/hosts file (and restart MySQL so
it notices).
Don't have much more to offer other than the
to MySQL server during query
Thanks for the reply. I'm not using persistend connections though. It
appears that it looses the connection in the middle of the query or in
other words, before the procedure returns. So that means I not getting
the data I need. So for debug purposes
David,
Are you using persistent connections? Sounds like perhaps a persistent
connection is timing out.
Maybe a quick work around would be to call a check status routine (ie
- do a show status), just to see if the connection is still there. If
this fails, just do a mysql_connect... Before
Thanks for the reply. I'm not using persistend connections though. It
appears that it looses the connection in the middle of the query or in
other words, before the procedure returns. So that means I not getting
the data I need. So for debug purposes, are you saying to do a check
status from
PM
Subject: RE: Lost connection to MySQL server during query
Thanks for the reply. I'm not using persistend connections though. It
appears that it looses the connection in the middle of the query or in
other words, before the procedure returns. So that means I not getting
the data I need
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote:
Thing is, even though I get that error, the server keeps running and
accepting other connections and responding to queries fine.
Probably because the mysqld_safe wrapper script has restarted it
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
...
Sometimes when I execute this stored procedure ... I get the error
Lost connection to MySQL server during query.
I am using MySQL
Greg 'groggy' Lehey wrote:
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
Jasper Bryant-Greene wrote:
Sometimes when I execute this stored procedure ... I get the error
Lost connection to MySQL server during query.
I am using MySQL 5.0.12-beta-log on Gentoo
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
CALL
Martijn Tonies wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
Hi,
2005/9/21, Jasper Bryant-Greene [EMAIL PROTECTED]:
Martijn Tonies wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
-Daniel
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM
Daniel wrote:
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
PHP MySQLi
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for
Hi,
Can you send some more output from the MySQL error log (normally located
at /var/lib/mysq/[hostname].err) . Have you tried myisamchk to check the
tables that are giving the errors? Also you might want to take a look at
http://dev.mysql.com/doc/mysql/en/gone-away.html
On Wednesday 01 June
Hello.
You should solve the issue with server crashes. I'm not familiar with JDBC,
and if changing the values of parameters with SET statement doesn't work
with JDBC, probably somebody clever on the list could help you. You may
forward your message to:
http://lists.mysql.com/java
Hi,
Yes the server dies during the queries from JDBC.
Regarding the client parameters, what if the client doesn't have mySQL
installed?
Amir
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC (check the
error log)? Sometimes you should increase interactive_timeout as well. A lot of
variables usually could be changed using SET statement. See:
On May 19, 2005, at 12:51 AM, Dan Rossi wrote:
Hi there, I am having issues with this funny error message. I am
trying to do a sub query and then a group by clause on a date.
However i keep getting this annoying message for some reason.
Happens via terminal aswell as my sql gui. Here is the
Marten Lehmann [EMAIL PROTECTED] wrote:
Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
OKay, here's the problem - a self-built MySQL. Unfortunately, due to
some glibc bugs it's not really possible to build a stable MySQL
under linux using stock glibc...
And the
Hello,
Tell us the OS, the MySQL server and client version and the build information
(custom or binary downloaded from MySQL.com).
Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
This *might* be a problem of resolver in glibc.
I don't see a reason why it should be a
Marten Lehmann [EMAIL PROTECTED] wrote:
I'm experiencing a strange thing: When bind is running without
bind-address everything works fine. But when I'm doing a bind-address
= ... the clients get Lost connection to MySQL server during query. I
don't understand this, because ot worked once
Hi Vanessa,
I don't think I saw a reply to this...
You can just reconnect to MySQL if you get this error. :-) Trying to
send the query a second or third time may also make the client try to
reconnect again.
Hope that helps.
Matt
- Original Message -
From: Kiky
Sent: Friday,
]
Sent: Saturday, December 06, 2003 12:56 AM
Subject: RE: Lost connection to MySQL server during query - pls help
At 10:44 -0600 12/5/03, Jay Blanchard wrote:
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15
At 14:14 5/12/2003 +0800, Kiky wrote:
Hi Guys,
I have a problem with
Error 2013 - Lost connection to MySQL server during query
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They turn out to have the same error.
Please upgrade you MySQL Windows client to 4.0.16
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
--
MySQL General Mailing List
For list
Kiky [EMAIL PROTECTED] wrote:
I have a problem with
Error 2013 - Lost connection to MySQL server during query
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
They turn out to have the same error.
My problem is:
I have a Java program which is actually a
At 10:44 -0600 12/5/03, Jay Blanchard wrote:
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
See
Hi Donald,
Is the script possibly sending a query larger than max_allowed_packet
(1MB default)? Have you read http://www.mysql.com/doc/en/Gone_away.html
?
Matt
- Original Message -
From: Donald Tyler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, September
---Original Message-
--From: Alec Smith [mailto:[EMAIL PROTECTED] On Behalf Of Alec
--Smith
--Sent: Friday, June 06, 2003 11:24 AM
--To: [EMAIL PROTECTED]
--Subject: Lost connection to MySQL server during query
--
--Hi -
--
--[Perhaps not exactly the right list, but [EMAIL PROTECTED]
Assume the ip address of your remote machine is 192.168.0.88
You should perform a
nslookup 192.168.0.88
on your LOCAL machine that hold the mysqld
If it cannot resolve into a symbolic name then you will get into trouble.
Add an entry to /etc/hosts or your DNS will solve the problem.
Regards,
On Thursday 16 January 2003 00:32, Gustavo A. Baratto wrote:
This old bug reappeared after the upgrading mysql from version 3.23.54a
(rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by
mysql.com as well).
Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this
You can use --skip-name-resolve when starting mysqld, but this is not a real
solution.
Even doing that,'I'm still having some odd problems I never had before, like
table corruption (I'm on 4.0.8 though)
- Original Message -
From: Patrick de Kievit [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Mark,
Tuesday, November 26, 2002, 7:32:15 AM, you wrote:
M Yes, again. :( Although reluctantly, I finally decided to upgrade to
M 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors.
M Alas, 6 out of 10 times when I start a MySQL application, I get an error
M like this:
M
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 4:44 PM
Subject: re: Lost connection to MySQL server during query
Mark,
Tuesday, November 26, 2002, 7:32:15 AM, you wrote:
M Yes, again. :( Although reluctantly, I
Frederic,
Tuesday, October 29, 2002, 11:49:19 PM, you wrote:
FT What are the possible causes for this error message ?
The possible source of error is the glibc provided by RedHat. Do you use
RedHat? If so, check the mailing list archives, there were a lot of
possible error descriptions during
Hello Graham,
Tuesday, October 15, 2002, 12:03:34 PM, you wrote:
1. replace Red Hat's rpms with MySQL binary release, download it from
http://www.mysql.com/
2. run myisamchk on all files.
3. run MySQL and enjoy the reliability since then :-)
GM Why do Linux distributions ship broken MySQL
Egor Egorov [EMAIL PROTECTED] writes:
1. replace Red Hat's rpms with MySQL binary release, download it from
http://www.mysql.com/
2. run myisamchk on all files.
3. run MySQL and enjoy the reliability since then :-)
Why do Linux distributions ship broken MySQL packages? The newly
released
Hello Me-Selfe,
Saturday, October 12, 2002, 2:25:23 AM, you wrote:
MS After a reboot, the database server running Redhat 7.2 and mySQL
MS 3.23.41-1 started acting funny. When I try to telnet to port 3306 of the
MS server, nothing happens and when i check in the log file for mysql, i
MS get
Gerald R. Jensen wrote:
Network problems ... something is breaking TCP/IP.
Gerald, I can view the webpages on the server, though. Doesn't it use
the same TCP/IP?
- Original Message -
From: Yanglong Zhu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, October 12, 2002 4:57 AM
]
Sent: Saturday, October 12, 2002 2:54 PM
Subject: Re: Lost connection to MySQL server during query
Gerald R. Jensen wrote:
Network problems ... something is breaking TCP/IP.
Gerald, I can view the webpages on the server, though. Doesn't it use
the same TCP/IP?
- Original Message
, but I'm a bit vague on this.
- Original Message -
From: Yanglong Zhu [EMAIL PROTECTED]
To: Gerald R. Jensen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, October 12, 2002 2:54 PM
Subject: Re: Lost connection to MySQL server during query
Gerald R. Jensen wrote:
Network
Network problems ... something is breaking TCP/IP.
- Original Message -
From: Yanglong Zhu [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, October 12, 2002 4:57 AM
Subject: Lost connection to MySQL server during query
Hi there,
This is an error message from MySQL when I try
Sorry all!
I have resolved the issue.
-- Forwarded Message ---
From: Vernon Webb [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sun, 13 Oct 2002 17:18:16 -0500
Subject: Lost connection to MySQL server during query
After spending the entire day trying to figure out
At 17:29 -0500 10/13/02, Vernon Webb wrote:
Sorry all!
I have resolved the issue.
Don't leave us hanging. How?
-- Forwarded Message ---
From: Vernon Webb [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sun, 13 Oct 2002 17:18:16 -0500
Subject: Lost connection to MySQL
Somehow MySQL got broke and by removing MySQL and reinstalling it, removing
the /var/lib/mysql folder and restaring MySQL put me back at the where it
was once I first configured MySQL.
Then I copied the database folders back to the folder, but I had changed the
password and forgot to change
Hi,
How did you solve the problem, Lost connection to
MySQL server during query, please let me know this i
am facing the same problem.
thanks,
swati
--- Vernon Webb [EMAIL PROTECTED] wrote:
Sorry all!
I have resolved the issue.
-- Forwarded Message ---
From: Vernon Webb
Graphfixz,
Tuesday, October 01, 2002, 5:14:13 PM, you wrote:
G I am getting the following error:
G [TCX][MyODBC] Lost Connection to MySQL Server During Query
G My code is simply dumping an IP Address to the database... at the most 10
G lines of code. Any ideas what is causing this error? I
, July 09, 2002 4:31 PM
Subject: Re: Lost connection to MySQL server during query
Hi,
My opinion:
This can be a very good reason to kill the socket(is a file too) which is
open during query.
This error show you that you have too many open files in the system.I
tested
something like this(Linux
Is there anything in the error log?
See mysql/data/hostname.err
-M
On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
I keep getting Lost connection to MySQL server during query
marcos:mysql-3.23.51 {117} mysqladmin version
mysqladmin: connect to server at 'localhost' failed
- Original Message -
From: Michael Bacarella [EMAIL PROTECTED]
To: Steve Mertz [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, July 09, 2002 3:43 PM
Subject: Re: Lost connection to MySQL server during query
Is there anything in the error log?
See mysql/data/hostname.err
-M
PROTECTED]
Sent: Tuesday, July 09, 2002 11:49 PM
Subject: Re: Lost connection to MySQL server during query
No, nothing other than the startup and shutdown messages.
And every once and a while:
020708 21:00:46 Error in accept: Bad file descriptor
But this doesn't happen all the time after
PROTECTED]
Sent: Saturday, June 29, 2002 9:04 AM
Subject: Re: Lost Connection to mysql server during query
Pada Thu, 27 Jun 2002 10:59:48 -0400
Anil Garg [EMAIL PROTECTED] menulis :
Now when i try to insert by using the following query:
INSERT INTO 1_polls VALUES (1,'This web site
I just tried to do this on my MySQL server (version 3.23.51-max-log). It
works fine.
Mikhail.
- Original Message -
From: Anil Garg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 27, 2002 4:59 PM
Subject: Lost Connection to mysql server during query
Hi,
Here is a
59 matches
Mail list logo