[mythtv-users] Backend looses mysql connection [SOLVED]

[Philippe Van Der Gucht]

Philippe Van Der Gucht wrote:
> Hey guys,
> 
> I have a mythbuntu v9 (jaunty) system running here and mythbackend is 
> having trouble connecting to the mysql db.
> 
> This is what I get in the log:
> 2009-03-22 15:36:45.825 Connected to database 'mythconverg' at host: 
> localhost
> 2009-03-22 15:36:47.992 DB Error (Error clearing channel locks):
> Query was:
> DELETE FROM eit_cache WHERE status  = 1
> Driver error was [2/2006]:
> QMYSQL3: Unable to execute query
> Database error was:
> MySQL server has gone away
> 
> And it continues for different sql statements with the same result.
> 
> The result is that I'm loosing scheduled programs.

The problem lies with the mysqld_safe script. It kills the mysql server 
after a while because it thinks (wrongly) it hangs. This causes 
mythbackend to deactivate scheduled programs for a tuner device it can't 
find.

The fix involves modifying mysqld_safe:
https://lists.ubuntu.com/archives/ubuntu-server-bugs/2009-February/009799.html 


This works for me.

Secondly, probably due to this annoying bug I had corruped tables. Check 
your /var/log/syslog for error messages.

I followed these instructions to fix this:
http://forums.devshed.com/mysql-help-4/innodb-corruption-must-use-skip-innodb-589178.html

-- 
Your education begins when what is called your education is over.
* TagZilla 0.066 * http://tagzilla.mozdev.org