[mythtv-users] Problem with certain db queries failing in mythbackend causing loss of all requested recordings

[Robin Hill]

On Wed Oct 11, 2006 at 06:27:30PM -0500, Neulinger, Nathan wrote:

> 
> Everything else works fine, but I get a few errors immediately on
> startup that fail, and nothing in the future recordings or scheduled
> recordings screen.
> 
> This goes away if I run with -v database.  This did NOT occur in
> 0.19.20060631-1 - the last version I could run on my backend before this
> problem started. Needed to upgrade recently for other reasons. The DB
> backend has been 5.0.2x for a while. There is most definately not a DB
> "timeout" occurring here as this is a metter of a couple seconds after
> startup... 
> 
> As adding -v database resolves the issue temporarily as a hack, it's not
> an emergency anymore, but it's a kindof sucky way to deal with the
> problem... Is myth not retrying failed queries, and even so, why is it
> losing the db connection in the first place?
> 
> -- Nathan
> 
Have you run optimize_mythdb.pl (in the contrib directory) to
check & repair your database?

Cheers,
        Robin
-- 
     ___        
    ( ' }     |       Robin Hill        <myth at robinhill.me.uk>  |
   / / )      | Little Jim says ....                            |
  // !!       |      "He fallen in de water !!"                 |
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20061012/aa619f8a/attachment.pgp