Re: Possible regression, need some assistance debugging

Hi!

On Jan 18, Greg Meyer wrote:
> I am working with the amaroK team and have run into a little problem
> since upgrading mysql to 5.0.18.  We use mysql as one of the choices
> for the music collection database, and since upgrading mysql to
> 5.0.18, I am getting an error about the server having gone away after
> amaroK sits idle for awhile (overnight).  This is the error
> 
>       "[CollectionDB] MYSQL QUERY FAILED: MySQL server has gone away"
> 
> This error appears and continues until the application is killed and
> restarted.  I am not sure if it is a bug or desired behavior, so I
> thought I would ask here first before posting a bug.
> 
> When I RTFM, I see that there is an explanation about the
> wait_timeout parameter here
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html  I didn't recall
> this behavior in 5.0.17 so I downgraded to test and after attempting
> the same task, the error does appear for a second in the console, but
> eventually the the query is completed successfully.  So, 5.0.17 allows
> a connection to be re-opened after being idle for the wait_timout
> period, but 5.0.18 does not.
> 
> 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 :).
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Kerpen, Germany
       <___/  www.mysql.com

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