[mythtv-users] Mythtv-backend hangs after upgrade to 0.22

[jrauti at iki.fi]

Hi

I recently upgrade my mythbuntu to 9.10 and sametime it upgraded mythtv 
from 0.21 -> 0.22. Now I get consistently hangs on backend. Backend 
is running but doesn't respond to frontend or mythweb. It seems that mysql  
connections start hanging. Can anyone give hints where I should 
start looking for possible errors? Usually these are last things I see in 
mythbackend.log:
2009-11-17 13:21:53.007 Connected to database 'mythconverg' at host: 
localhost
2009-11-17 13:21:53.058 New DB connection, total: 8
2009-11-17 13:21:53.107 Connected to database 'mythconverg' at host: 
localhost
2009-11-17 14:53:16.243 mythbackend version: branches/release-0-22-fixes 
[22840] www.mythtv.org
2009-11-17 14:53:16.295 Using runtime prefix = /usr
2009-11-17 14:53:16.345 Using configuration directory = 
/home/mythtv/.mythtv

As you can see I trying latest fixes from mythbuntu repository but they 
haven't helped so far.

I also found these with one hang but they haven't happened since:
Query was:
SELECT chanid, useonairguide FROM channel, dtv_multiplex WHERE serviceid        
= ?   AND       networkid        = ?   AND       transportid      = ? AND       
channel.mplexid  = dtv_multiplex.mplexid AND channel.sourceid = ?
Bindings were:
:NETWORKID=15, :SERVICEID=4369, :SOURCEID=2, :TRANSPORTID=3
Driver error was [2/2006]:
QMYSQL3: Unable to execute statement
Database error was:
MySQL server has gone away

MySQL was running and errors disappeared when I restarted backend.

TIA,
Juhani
-- 
Juhani Rautiainen				jrauti at iki.fi