LinHES Forums
http://forum.linhes.org/

clock jumping and recording deletion problems
http://forum.linhes.org/viewtopic.php?f=17&t=14448		 Page 1 of 1
Author:  ScottBla [ Sun Mar 04, 2007 1:37 pm ]
Post subject:  clock jumping and recording deletion problems
OK...this is kinda weird...:)

My myth box is a KnoppMyth install (R5D1, I think, with SVN built & installed 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 files 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 changed 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 they 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 works fine on a few of them, but after that it just leaves them greyed out so that when I try selecting them for deletion a 2nd time, I get a popup that says "This recording is currently being deleted and is unavailable". Then when I exit the delete recordings screen and go back in, it's highlighted normally and I can try to delete it again (no effect).

Checking /var/log/mythtv/mythbackend.log, I see this kind of stuff:

Code:
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 (events: 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 not 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 (events: 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 not 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 (events: 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 not 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 (events: 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 not 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 = 0.00 match + 0.43 place
2007-03-04 11:33:35.333 ERROR retrieving program info when trying to delete program for chanid 1059 recorded at Sun Mar 11 03:30:00 2007. Recording will NOT be deleted.
2007-03-04 11:33:35.338 mythbackend: Delete Recording: Unable to retrieve program info for chanid 1059 at Sun Mar 11 03:30:00 2007. Program will NOT 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
Author:  ScottBla [ Thu Mar 08, 2007 10:08 pm ]
Post subject: 
Or...put another way...

Is there some documentation for the schema that myth uses in mysql?

Or...does anyone have some handy, dandy SQL that will safely remove all traces of a particular listing? I'd love to clean this up before the actual Mar 11 arrives and I have to find out what happens when the recording times for the funny listings comes up...

Thanx!
Scott
Author:  ScottBla [ Fri Mar 16, 2007 7:07 pm ]
Post subject: 
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
Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/