[mythtv-users] clock jumping and recording deletion problems

[Scott Blachowicz]

For the record...

It turns out that all of the "undeleteable" programs had records in
the "recorded" table in the mysql db with a starttime or endtime value
that was now invalid...that is, mysql showed a time around 02:30 Sunday
morning. Since the clock skipped forward from 01:59 PST to 03:00 PDT,
02:30 is a bad time. So, ProgramInfo::GetProgramFromRecorded() was
failing somewhere along the line. I manually whacked the times in the db
to be valid, then went to the frontend to delete them and it succeeded.

Scott

Scott Blachowicz <scott.mythtv at sabami.seaslug.org> wrote:

> [I posted this to a forum at mysettopbox.tv, but got no responses...]
> 
> OK...this is kinda weird...:)
> 
> My myth box is a KnoppMyth install (R5D1, I think, with SVN built & install=
> ed on top of it - I see
> "Myth version: 0.20.20070122-1 12631M" in my system status screen).
> 
> Yesterday, I was installing new tzdata files (by downloading the tzdata fil=
> es from elsie and using
> 'zic' to compile them) to handle the upcoming DST transition changes and I =
> did that OK, but in the
> process of testing it out I'd done some 'date' command that apparently chan=
> ged my system time.  So,
> for about 20 hours, I was running with a system time of Mar 11 (even though=
>  it's Mar 4 now) after it
> jumped around a few times yesterday afternoon.
> 
> Now, I've got several recordings that are listed with a date of 3/11 and th=
> ey are 0.00GB in size.  I
> also have some with a date of 4/11 in the same condition.  Anyways, so I go=
>  into the Delete
> Recordings screen and start deleteing them (allowing re-record) and that wo=
> rks fine on a few of
> them, but after that it just leaves them greyed out so that when I try sele=
> cting them for deletion a
> 2nd time, I get a popup that says "This recording is currently being delete=
> d and is unavailable".
> Then when I exit the delete recordings screen and go back in, it's highligh=
> ted normally and I can
> try to delete it again (no effect).
> 
> Checking /var/log/mythtv/mythbackend.log, I see this kind of stuff:
> 
>     2007-03-04 11:32:59.253 RingBuf(/myth/tv2/1059_20070311023000.mpg.png):=
>  Could not open /myth/tv2/1059_20070311023000.mpg.png.
>     2007-03-04 11:32:59.261 MainServer::HandleAnnounce Monitor
>     2007-03-04 11:32:59.264 adding: mythtv.rresearch.com as a client (event=
> s: 0)
>     2007-03-04 11:32:59.265 GetRecordBasename found no entry
>     2007-03-04 11:32:59.266 Preview Error: Previewer file '/myth/tv/' is no=
> t valid.
>     2007-03-04 11:32:59.267 MainServer: Failed to make preview image.
>     2007-03-04 11:32:59.881 GetRecordBasename found no entry
>     2007-03-04 11:32:59.889 MainServer::HandleAnnounce Monitor
>     2007-03-04 11:32:59.892 adding: mythtv.rresearch.com as a client (event=
> s: 0)
>     2007-03-04 11:32:59.893 GetRecordBasename found no entry
>     2007-03-04 11:32:59.894 Preview Error: Previewer file '/myth/tv/' is no=
> t valid.
>     2007-03-04 11:32:59.895 MainServer: Failed to make preview image.
>     2007-03-04 11:33:01.069 GetRecordBasename found no entry
>     2007-03-04 11:33:01.083 MainServer::HandleAnnounce Monitor
>     2007-03-04 11:33:01.085 adding: mythtv.rresearch.com as a client (event=
> s: 0)
>     2007-03-04 11:33:01.086 GetRecordBasename found no entry
>     2007-03-04 11:33:01.088 Preview Error: Previewer file '/myth/tv/' is no=
> t valid.
>     2007-03-04 11:33:01.089 MainServer: Failed to make preview image.
>     2007-03-04 11:33:02.262 GetRecordBasename found no entry
>     2007-03-04 11:33:02.272 MainServer::HandleAnnounce Monitor
>     2007-03-04 11:33:02.274 adding: mythtv.rresearch.com as a client (event=
> s: 0)
>     2007-03-04 11:33:02.275 GetRecordBasename found no entry
>     2007-03-04 11:33:02.276 Preview Error: Previewer file '/myth/tv/' is no=
> t valid.
>     2007-03-04 11:33:02.277 MainServer: Failed to make preview image.
>     2007-03-04 11:33:03.448 GetRecordBasename found no entry
>     2007-03-04 11:33:29.788 GetRecordBasename found no entry
>     2007-03-04 11:33:32.325 GetRecordBasename found no entry
>     2007-03-04 11:33:32.329 Reschedule requested for id 0.
>     2007-03-04 11:33:32.760 Scheduled 215 items in 0.4 =3D 0.00 match + 0.4=
> 3 place
>     2007-03-04 11:33:35.333 ERROR retrieving program info when trying to de=
> lete program for chanid 1059 recorded at Sun Mar 11 03:30:00 2007. Recordin=
> g will NOT be deleted.
>     2007-03-04 11:33:35.338 mythbackend: Delete Recording: Unable to retrie=
> ve program info for chanid 1059 at Sun Mar 11 03:30:00 2007. Program will N=
> OT be deleted.
> 
> Any suggestions on how to clean this mess up?  Or anything else I'm likely =
> to need to clean up after
> this?
> 
> Thanx,
> --
> Scott