View unanswered posts    View active topics

Board index Linux MythTV

All times are UTC - 6 hours





Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
ScottBla
PostPosted: Sun Mar 04, 2007 1:37 pm 
Offline
Joined: Sun Mar 20, 2005 11:50 pm
Posts: 8
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
Top
 Profile  
 
ScottBla
 Post subject:
PostPosted: Thu Mar 08, 2007 10:08 pm 
Offline
Joined: Sun Mar 20, 2005 11:50 pm
Posts: 8
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
Top
 Profile  
 
ScottBla
 Post subject:
PostPosted: Fri Mar 16, 2007 7:07 pm 
Offline
Joined: Sun Mar 20, 2005 11:50 pm
Posts: 8
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
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 1 of 1
  [ 3 posts ] 


Board index Linux MythTV

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 10 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu