Re: Possible regression, need some assistance debugging

If you know your application is going to sit for long periods of time 
between interactions with the database it should call mysql_ping() prior 
to running queries
or be prepared to reconnect and retry in the event of a lost connection. 
I don't believe increasing the wait_timout is the correct solution.

Greg Meyer wrote:

>On Thursday 19 January 2006 7:34 am, Sergei Golubchik wrote:
>  
>
>>On Jan 18, Greg Meyer wrote:
>>    
>>
>>>So the question is, what changed from 5.0.17 to 5.0.18 and is this
>>>intentional or a regression?  perhaps there is some test that must be
>>>performed in amaroK so that a new connection can be opened when the
>>>wait_timeout period is exceeded.
>>>      
>>>
>>A quick look in changeset comments didn't reveal anything that woud
>>explain that. Please submit a bugreport at bugs.mysql.com (and try to
>>provide a repeatable test case :).
>>    
>>
>
>Okay, thanks for the info.  I guess the thing to do then is to see if I can 
>find some other amarok user that also uses mysql to see if it can be 
>reproduced, or perhaps I can try to reproduce it myself on another machine 
>with a different Linux distro.
>
>Extending the wait_timeout to 16 hours seems to have provided a workaround for 
>the problem, since when I woke up this morning, database access is working 
>fine.  
>  
>


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]