List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:September 9 2009 9:29am
Subject:Re: Lost connection to MySQL server during query
View as plain text  
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.


Claudio


2009/9/9 stutiredboy <stutiredboy@stripped>

> 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 sql that create table(s)
>
> i have read this article
> http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
> and can get rid of the problems this article referred
>
> it seems that our problem is similar to this bug:
> http://lists.mysql.com/commits/9447
> http://bugs.mysql.com/bug.php?id=15752
>
> but, this bug has been fixed in 5.0.25
>
> are there any suggestions ? or any other informaion (s) should i post here?
>
> thanks!
>
> stutiredboy
>
>
> Claudio Nanni wrote:
>
>> Can you provide more details?
>> network layout, type of client/app used, connectors,etc,etc?
>> Thanks
>>
>> Claudio
>>
>>
>> 2009/9/9 stutiredboy <stutiredboy@stripped <mailto:stutiredboy@stripped
>> >>
>>
>>    hi,all:
>>
>>    we met a problem that:
>>
>>    * Lost connection to MySQL server during query
>>    SHOW TABLE STATUS WHERE ENGINE='MyISAM'
>>
>>    *sometimes it works well, sometimes not
>>
>>    our mysql version is 5.0.84
>>
>>    our system is FreeBSD 6.2
>>
>>    thanks
>>
>>    --
>>    MySQL General Mailing List
>>    For list archives: http://lists.mysql.com/mysql
>>    To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=1
>>
>>
>>
>>
>> --
>> Claudio
>>
>
>


-- 
Claudio

Thread
Lost connection to MySQL server during querystutiredboy9 Sep
  • Re: Lost connection to MySQL server during queryClaudio Nanni9 Sep
    • Re: Lost connection to MySQL server during querystutiredboy9 Sep
Re: Lost connection to MySQL server during queryClaudio Nanni9 Sep