[mythtv-users] Shows not recording - how can I delete DB entries manually?

Tue Feb 5 11:19:22 UTC 2008

Thanks for that Mike. Unfortunately when I try to delete them from the UI,
they appear to have been deleted, but on reboot they reappear. This makes me
think that I will need to do something more to remove them from the DB.

Furthermore, I need to try and understand why this is happening in the first
place. This is the entry from mythbackend.log for a recording for which the
file is unavailable:

2008-02-05 09:00:02.159 TVRec(5): Changing from None to RecordingOnly
2008-02-05 09:00:02.164 TVRec(5): HW Tuner: 5->5
2008-02-05 09:00:02.475 Started recording: Top Gear: channel 1019 on cardid
5, sourceid 1
2008-02-05 10:00:00.554 TVRec(5): Changing from RecordingOnly to None
2008-02-05 10:00:00.612 Finished recording Top Gear: channel 1019

(looks ok to me)

Here's the same log for one that worked:

2008-02-03 17:10:54.964 TVRec(5): Changing from None to RecordingOnly
2008-02-03 17:10:54.970 TVRec(5): HW Tuner: 5->5
2008-02-03 17:10:54.980 Started recording: Top Gear: channel 1019 on cardid
5, sourceid 1
2008-02-03 17:11:20.731 MainServer::HandleAnnounce Monitor
2008-02-03 17:11:20.738 adding: longepc as a client (events: 0)
2008-02-03 17:11:20.739 MainServer::HandleAnnounce Monitor
2008-02-03 17:11:20.740 adding: longepc as a client (events: 1)
2008-02-03 17:11:20.752 Reloading backend settings
2008-02-03 17:12:01.000 EITScanner: Added 27 EIT Events
2008-02-03 17:12:01.003 Reschedule requested for id -1.
2008-02-03 17:12:01.369 Scheduled 62 items in 0.4 = 0.03 match + 0.33 place
2008-02-03 17:12:50.887 EITScanner: Now looking for EIT data on multiplex of
channel 108
2008-02-03 17:13:57.535 EITScanner: Added 27 EIT Events
2008-02-03 17:17:05.299 EITScanner: Added 2 EIT Events
2008-02-03 17:17:05.304 Reschedule requested for id -1.
2008-02-03 17:17:05.724 Scheduled 62 items in 0.4 = 0.03 match + 0.39 place
2008-02-03 17:17:05.724 EITScanner: Added 2 EIT Events
2008-02-03 17:17:06.591 MainServer::HandleAnnounce Playback
2008-02-03 17:17:06.596 adding: longepc as a client (events: 0)
2008-02-03 17:17:06.608 TVRec(4): Changing from None to WatchingLiveTV
2008-02-03 17:17:06.613 TVRec(4): HW Tuner: 4->4
2008-02-03 17:17:08.389 Finished recording An Otter in the Family: channel
1002
2008-02-03 17:17:08.442 Finished recording An Otter in the Family: channel
1002
2008-02-03 17:17:08.534 Preview Error: Previewer file
'/var/lib/mythtv/recordings/1002_20080203171706.mpg' is $
2008-02-03 17:17:15.991 TVRec(4): Changing from WatchingLiveTV to None
2008-02-03 17:17:16.101 Finished recording An Otter in the Family: channel
1002
2008-02-03 17:18:03.059 MainServer::HandleAnnounce Playback
2008-02-03 17:18:03.069 adding: longepc as a client (events: 0)
2008-02-03 17:18:12.525 Expiring An Otter in the Family from Sun Feb 3
16:55:00 2008, 0 MBytes, forced expire $
2008-02-03 17:18:12.529 Expiring An Otter in the Family from Sun Feb 3
16:55:00 2008, 3 MBytes, forced expire $
2008-02-03 17:18:12.766 EITScanner: Added 8 EIT Events
2008-02-03 17:19:12.540 EITScanner: Now looking for EIT data on multiplex of
channel 108
2008-02-03 17:19:33.293 match[0]: 0 'The Alan Brazil Sports Breakfast with
Alan Brazil and Mike Parry' vs. 'Th$
2008-02-03 17:19:36.539 match[0]: 0 'Adrian Durham and Ian Wright' vs. 'Ian
Wright and Adrian Durham'
2008-02-03 17:20:33.512 EITScanner: Added 1 EIT Events
2008-02-03 17:20:33.518 Reschedule requested for id -1.
2008-02-03 17:20:33.876 Scheduled 62 items in 0.4 = 0.04 match + 0.32 place
2008-02-03 17:20:41.077 EITScanner: Added 57 EIT Events
2008-02-03 17:24:38.177 EITScanner: Now looking for EIT data on multiplex of
channel 12
2008-02-03 17:25:42.376 EITScanner: Added 16 EIT Events
2008-02-03 17:25:42.379 Reschedule requested for id -1.
2008-02-03 17:25:42.728 Scheduled 62 items in 0.3 = 0.03 match + 0.32 place
2008-02-03 17:30:03.222 EITScanner: Added 1 EIT Events
2008-02-03 17:30:03.230 Reschedule requested for id -1.
2008-02-03 17:30:03.631 Scheduled 62 items in 0.4 = 0.07 match + 0.33 place
2008-02-03 17:30:03.670 EITScanner: Now looking for EIT data on multiplex of
channel 1
2008-02-03 17:31:21.399 EITScanner: Added 6 EIT Events
2008-02-03 17:31:45.257 EITScanner: Added 4 EIT Events
2008-02-03 17:35:29.161 EITScanner: Now looking for EIT data on multiplex of
channel 700
2008-02-03 17:35:53.178
EITCache::statistics: Accesses: 50000, Hits: 30862, Table Upgrades 33, New
Versions: 88, Entries: 6967 Pruned $
2008-02-03 17:36:35.269 EITScanner: Added 6 EIT Events
2008-02-03 17:36:35.278 Reschedule requested for id -1.
2008-02-03 17:36:35.628 Scheduled 62 items in 0.3 = 0.03 match + 0.32 place
2008-02-03 17:39:46.067 Reschedule requested for id 0.
2008-02-03 17:39:46.430 Scheduled 62 items in 0.4 = 0.00 match + 0.36 place
2008-02-03 17:39:49.029 Error deleting
'/var/lib/mythtv/recordings/1019_20080129234000.mpg': No such file or d$
2008-02-03 17:39:49.430 Reschedule requested for id 0.
2008-02-03 17:39:49.794 Scheduled 62 items in 0.4 = 0.03 match + 0.32 place
2008-02-03 17:39:55.070 Reschedule requested for id 0.
2008-02-03 17:39:55.093 Error deleting
'/var/lib/mythtv/recordings/1007_20080129210000.mpg': No such file or d$
2008-02-03 17:39:55.434 Scheduled 62 items in 0.4 = 0.03 match + 0.32 place
2008-02-03 17:40:01.115 Reschedule requested for id 0.
2008-02-03 17:40:01.118 Error deleting
'/var/lib/mythtv/recordings/1019_20080129200000.mpg': No such file or d$
2008-02-03 17:40:01.441 Scheduled 62 items in 0.3 = 0.01 match + 0.32 place
2008-02-03 17:40:07.389 Reschedule requested for id 0.
2008-02-03 17:40:07.392 Error deleting
'/var/lib/mythtv/recordings/1019_20080129160000.mpg': No such file or d$
2008-02-03 17:40:07.760 Scheduled 62 items in 0.4 = 0.01 match + 0.36 place
2008-02-03 17:40:13.712 Reschedule requested for id 0.
2008-02-03 17:40:13.714 Error deleting
'/var/lib/mythtv/recordings/1002_20080129141500.mpg': No such file or d$
2008-02-03 17:40:14.037 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:40:20.048 Reschedule requested for id 0.
2008-02-03 17:40:20.051 Error deleting
'/var/lib/mythtv/recordings/1019_20080129110000.mpg': No such file or d$
2008-02-03 17:40:20.371 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:40:26.315 Reschedule requested for id 0.
2008-02-03 17:40:26.324 Error deleting
'/var/lib/mythtv/recordings/1019_20080128200000.mpg': No such file or d$
2008-02-03 17:40:26.643 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:40:27.536 Reschedule requested for id 0.
2008-02-03 17:40:27.916 Scheduled 62 items in 0.4 = 0.01 match + 0.36 place
2008-02-03 17:40:32.795 Reschedule requested for id 0.
2008-02-03 17:40:32.798 Error deleting
'/var/lib/mythtv/recordings/1019_20080128160000.mpg': No such file or d$
2008-02-03 17:40:33.119 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:40:39.065 Reschedule requested for id 0.
2008-02-03 17:40:39.067 Error deleting
'/var/lib/mythtv/recordings/1002_20080128141500.mpg': No such file or d$
2008-02-03 17:40:39.559 Scheduled 62 items in 0.5 = 0.01 match + 0.49 place
2008-02-03 17:40:45.290 Reschedule requested for id 0.
2008-02-03 17:40:45.292 Error deleting
'/var/lib/mythtv/recordings/1019_20080128110000.mpg': No such file or d$
2008-02-03 17:40:45.837 Scheduled 62 items in 0.5 = 0.00 match + 0.54 place
2008-02-03 17:40:51.351 Reschedule requested for id 0.
2008-02-03 17:40:51.354 Error deleting
'/var/lib/mythtv/recordings/1713_20080128010000.mpg': No such file or d$
2008-02-03 17:40:51.674 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:40:54.476 EITScanner: Added 1 EIT Events
2008-02-03 17:40:54.484 Reschedule requested for id -1.
2008-02-03 17:40:54.848 New DB connection, total: 4
2008-02-03 17:40:54.947 Connected to database 'mythconverg' at host:
localhost
2008-02-03 17:40:55.065 Scheduled 62 items in 0.6 = 0.08 match + 0.50 place
2008-02-03 17:40:55.065 EITScanner: Now looking for EIT data on multiplex of
channel 108
2008-02-03 17:40:57.661 Reschedule requested for id 0.
2008-02-03 17:40:57.664 Error deleting
'/var/lib/mythtv/recordings/1019_20080127170000.mpg': No such file or d$
2008-02-03 17:40:57.829 Scheduled 62 items in 0.2 = 0.00 match + 0.16 place
2008-02-03 17:41:03.675 Reschedule requested for id 0.
2008-02-03 17:41:03.678 Error deleting
'/var/lib/mythtv/recordings/1019_20080127160000.mpg': No such file or d$
2008-02-03 17:41:04.000 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:41:09.949 Reschedule requested for id 0.
2008-02-03 17:41:09.952 Error deleting
'/var/lib/mythtv/recordings/1002_20080127130000.mpg': No such file or d$
2008-02-03 17:41:10.274 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:41:16.225 Reschedule requested for id 0.
2008-02-03 17:41:16.227 Error deleting
'/var/lib/mythtv/recordings/1007_20080126203000.mpg': No such file or d$
2008-02-03 17:41:16.549 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:41:22.498 Reschedule requested for id 0.
2008-02-03 17:41:22.500 Error deleting
'/var/lib/mythtv/recordings/1019_20080126180000.mpg': No such file or d$
2008-02-03 17:41:22.815 Scheduled 62 items in 0.3 = 0.00 match + 0.31 place
2008-02-03 17:41:28.774 Reschedule requested for id 0.
2008-02-03 17:41:28.777 Error deleting
'/var/lib/mythtv/recordings/1011_20080126170000.mpg': No such file or d$
2008-02-03 17:41:29.117 Scheduled 62 items in 0.3 = 0.01 match + 0.33 place
2008-02-03 17:41:34.811 Reschedule requested for id 0.
2008-02-03 17:41:34.814 Error deleting
'/var/lib/mythtv/recordings/1019_20080126150000.mpg': No such file or d$
2008-02-03 17:41:41.075 Reschedule requested for id 0.
2008-02-03 17:41:41.395 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place
2008-02-03 17:42:00.996 EITScanner: Added 5 EIT Events
2008-02-03 17:45:19.014 EITScanner: Added 2 EIT Events
2008-02-03 17:45:19.021 Reschedule requested for id -1.
2008-02-03 17:45:19.361 Scheduled 62 items in 0.3 = 0.03 match + 0.31 place
2008-02-03 17:46:20.532 EITScanner: Now looking for EIT data on multiplex of
channel 12
2008-02-03 17:47:26.206 EITScanner: Added 4 EIT Events
2008-02-03 17:51:46.177 EITScanner: Now looking for EIT data on multiplex of
channel 1
2008-02-03 17:52:50.645 EITScanner: Added 4 EIT Events
2008-02-03 17:52:50.647 Reschedule requested for id -1.
2008-02-03 17:52:50.991 Scheduled 62 items in 0.3 = 0.03 match + 0.31 place
2008-02-03 17:55:02.657 EITScanner: Added 1 EIT Events
2008-02-03 17:55:03.001 EITScanner: Added 1 EIT Events
2008-02-03 17:56:23.412 EITScanner: Added 1 EIT Events
2008-02-03 17:56:23.419 Reschedule requested for id -1.
2008-02-03 17:56:23.761 Scheduled 62 items in 0.3 = 0.03 match + 0.31 place
2008-02-03 17:56:23.761 EITScanner: Added 1 EIT Events
2008-02-03 17:57:11.373 EITScanner: Added 1 EIT Events
2008-02-03 17:57:11.649 EITScanner: Now looking for EIT data on multiplex of
channel 700
2008-02-03 17:58:16.149 EITScanner: Added 6 EIT Events
2008-02-03 17:58:33.042 EITScanner: Added 3 EIT Events
2008-02-03 18:00:00.001 TVRec(5): Changing from RecordingOnly to None
2008-02-03 18:00:00.009 Finished recording Top Gear: channel 1019
2008-02-03 18:00:00.143 Finished recording Top Gear: channel 1019

In this second log you can see the errors generated when trying to delete
the recordings with no files from the UI.

I must admit I'm completely stumped by this one, hope someone can shed some
light on the problem!

Thanks.

George

Michael T. Dean wrote:
> 
> On 02/05/2008 04:06 AM, georgemason wrote:
>> I have two problems with my Mythbuntu box (it's the master backend etc). 
>>
>> 1. Quite often the machine stops recording shows but still adds the
>> records
>> to the DB, giving a "the file for this recording cannot be found" error
>> if I
>> try to watch these recordings.
>>
>> 2. I can't remove these records from the UI - they are there when I
>> restart
>> the machine despite me having deleted them. I don't know the DB structure
>> well enough to start deleting the records manually.
>>
>> Any help would be appreciated. Thanks.
> 
> Use the mythfrontend UI to delete them...  Either Watch Recordings or 
> Delete Recordings.  To do that, hit 'D' when the recording is selected 
> or use INFO ('I') to get the Action menu and select Delete.
> 
> There is no need to edit the DB manually (and if you do, you'll almost 
> definitely leave information that should be deleted).
> 
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Shows-not-recording---how-can-I-delete-DB-entries-manually--tp15258267s15552p15288008.html
Sent from the mythtv-users mailing list archive at Nabble.com.