Possible regression, need some assistance debugging

Greg Meyer <[email protected]> Wed, 18 Jan 2006 23:16:57 -0500
Newsgroups gmane.comp.kde.amarok.devel,gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
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.

The amarok bug in the KDE database is here for further information.  
http://bugs.kde.org/show_bug.cgi?id=120198

-- 
Greg


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642