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

[Neulinger, Nathan]

I have done the equivalent by hand directly on the db server to no
effect, not surprising though since there are no mysqld errors occuring
about corrupt tables.

-- Nathan
 
------------------------------------------------------------
Nathan Neulinger                       EMail:  nneul at umr.edu
University of Missouri - Rolla         Phone: (573) 341-6679
UMR Information Technology             Fax: (573) 341-4216
 

> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org 
> [mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Robin Hill
> Sent: Thursday, October 12, 2006 2:49 AM
> To: mythtv-users at mythtv.org
> Subject: Re: [mythtv-users] Problem with certain db queries 
> failing inmythbackend causing loss of all requested recordings
> 
> 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 !!"                 |
>