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
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.
Can you provide more details?
network layout, type of client/app used, connectors,etc,etc?
Thanks
Claudio
2009/9/9 stutiredboy
> hi,all:
>
> we met a problem that:
>
> * Lost connection to MySQL server during query
> SHOW TABLE STATUS WHERE ENGINE='MyISAM'
>
> *sometimes it works well, sometim
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 at
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 us
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, persis
t; Sent: Tuesday, January 24, 2006 4:43 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
> > o
ary 24, 2006 4:43 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
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
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 c
-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 i
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
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
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 examp
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 INVOKE
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 user
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
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:
> 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:
>
> C
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 20
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 (ch
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 pro
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 resolver
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 wo
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, Decemb
; <[EMAIL PROTECTED]>; "Kiky" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
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]
> >Ple
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 t
"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
[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 archives:
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
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, Sept
-->-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 PROTE
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 p
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 PROTECT
- 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:
&g
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:
Hi,
Isn't it time to add a manual section like this one
http://www.mysql.com/doc/en/Communication_errors.html on the Lost
Connection to MySQL Server during query? These emails come in at a regualr
rate, they seem to vary in cause somewhat, and I still have not solved my
own problem with this erro
AuctionWare Admin wrote:
Hello all,
I have came across a pretty peculiar problem and am hoping someone can
help me out.
Each time I try to connect to a MySQL server on my network, I receive
the following error:
Lost Connection to MySQL Server during query
It isn't just one server that is givi
From: "Egor Egorov" <[EMAIL PROTECTED]>
FT> To: <[EMAIL PROTECTED]>
FT> Sent: Wednesday, October 30, 2002 5:09 AM
FT> Subject: re: Lost connection to MySQL server during query
>> Frederic,
>> Tuesday, October 29, 2002, 11:49:19 PM, you wrote:
>&g
ROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 5:09 AM
Subject: re: Lost connection to MySQL server during query
> Frederic,
> Tuesday, October 29, 2002, 11:49:19 PM, you wrote:
>
> FT> What are the possible causes for this error message ?
>
> The pos
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 la
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 broke
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
releas
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 s
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: "Ver
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
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 con
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 figur
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
don't think I'm using ODBC, 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,
<[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 problems ... something is breaking TCP/IP.
>
Gerald, I can view the webpages on the server, though. D
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, 2
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
D]>; <[EMAIL PROTECTED]>
Sent: Tuesday, 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 hav
>
To: <[EMAIL 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
>
&
!
-- Steve
- 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
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' faile
ot;Anil Garg" <[EMAIL 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 f
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
63 matches
Mail list logo