<br><br>
<div><span class="gmail_quote">On 05/02/2008, <b class="gmail_sendername">georgemason</b> <<a href="mailto:george@porthall.net">george@porthall.net</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br>Thanks for that Mike. Unfortunately when I try to delete them from the UI,<br>they appear to have been deleted, but on reboot they reappear. This makes me<br>
think that I will need to do something more to remove them from the DB.<br><br>Furthermore, I need to try and understand why this is happening in the first<br>place. This is the entry from mythbackend.log for a recording for which the<br>
file is unavailable:<br><br>2008-02-05 09:00:02.159 TVRec(5): Changing from None to RecordingOnly<br>2008-02-05 09:00:02.164 TVRec(5): HW Tuner: 5->5<br>2008-02-05 09:00:02.475 Started recording: Top Gear: channel 1019 on cardid<br>
5, sourceid 1<br>2008-02-05 10:00:00.554 TVRec(5): Changing from RecordingOnly to None<br>2008-02-05 10:00:00.612 Finished recording Top Gear: channel 1019<br><br>(looks ok to me)<br><br>Here's the same log for one that worked:<br>
<br>2008-02-03 17:10:54.964 TVRec(5): Changing from None to RecordingOnly<br>2008-02-03 17:10:54.970 TVRec(5): HW Tuner: 5->5<br>2008-02-03 17:10:54.980 Started recording: Top Gear: channel 1019 on cardid<br>5, sourceid 1<br>
2008-02-03 17:11:20.731 MainServer::HandleAnnounce Monitor<br>2008-02-03 17:11:20.738 adding: longepc as a client (events: 0)<br>2008-02-03 17:11:20.739 MainServer::HandleAnnounce Monitor<br>2008-02-03 17:11:20.740 adding: longepc as a client (events: 1)<br>
2008-02-03 17:11:20.752 Reloading backend settings<br>2008-02-03 17:12:01.000 EITScanner: Added 27 EIT Events<br>2008-02-03 17:12:01.003 Reschedule requested for id -1.<br>2008-02-03 17:12:01.369 Scheduled 62 items in 0.4 = 0.03 match + 0.33 place<br>
2008-02-03 17:12:50.887 EITScanner: Now looking for EIT data on multiplex of<br>channel 108<br>2008-02-03 17:13:57.535 EITScanner: Added 27 EIT Events<br>2008-02-03 17:17:05.299 EITScanner: Added 2 EIT Events<br>2008-02-03 17:17:05.304 Reschedule requested for id -1.<br>
2008-02-03 17:17:05.724 Scheduled 62 items in 0.4 = 0.03 match + 0.39 place<br>2008-02-03 17:17:05.724 EITScanner: Added 2 EIT Events<br>2008-02-03 17:17:06.591 MainServer::HandleAnnounce Playback<br>2008-02-03 17:17:06.596 adding: longepc as a client (events: 0)<br>
2008-02-03 17:17:06.608 TVRec(4): Changing from None to WatchingLiveTV<br>2008-02-03 17:17:06.613 TVRec(4): HW Tuner: 4->4<br>2008-02-03 17:17:08.389 Finished recording An Otter in the Family: channel<br>1002<br>2008-02-03 17:17:08.442 Finished recording An Otter in the Family: channel<br>
1002<br>2008-02-03 17:17:08.534 Preview Error: Previewer file<br>'/var/lib/mythtv/recordings/1002_20080203171706.mpg' is $<br>2008-02-03 17:17:15.991 TVRec(4): Changing from WatchingLiveTV to None<br>2008-02-03 17:17:16.101 Finished recording An Otter in the Family: channel<br>
1002<br>2008-02-03 17:18:03.059 MainServer::HandleAnnounce Playback<br>2008-02-03 17:18:03.069 adding: longepc as a client (events: 0)<br>2008-02-03 17:18:12.525 Expiring An Otter in the Family from Sun Feb 3<br>16:55:00 2008, 0 MBytes, forced expire $<br>
2008-02-03 17:18:12.529 Expiring An Otter in the Family from Sun Feb 3<br>16:55:00 2008, 3 MBytes, forced expire $<br>2008-02-03 17:18:12.766 EITScanner: Added 8 EIT Events<br>2008-02-03 17:19:12.540 EITScanner: Now looking for EIT data on multiplex of<br>
channel 108<br>2008-02-03 17:19:33.293 match[0]: 0 'The Alan Brazil Sports Breakfast with<br>Alan Brazil and Mike Parry' vs. 'Th$<br>2008-02-03 17:19:36.539 match[0]: 0 'Adrian Durham and Ian Wright' vs. 'Ian<br>
Wright and Adrian Durham'<br>2008-02-03 17:20:33.512 EITScanner: Added 1 EIT Events<br>2008-02-03 17:20:33.518 Reschedule requested for id -1.<br>2008-02-03 17:20:33.876 Scheduled 62 items in 0.4 = 0.04 match + 0.32 place<br>
2008-02-03 17:20:41.077 EITScanner: Added 57 EIT Events<br>2008-02-03 17:24:38.177 EITScanner: Now looking for EIT data on multiplex of<br>channel 12<br>2008-02-03 17:25:42.376 EITScanner: Added 16 EIT Events<br>2008-02-03 17:25:42.379 Reschedule requested for id -1.<br>
2008-02-03 17:25:42.728 Scheduled 62 items in 0.3 = 0.03 match + 0.32 place<br>2008-02-03 17:30:03.222 EITScanner: Added 1 EIT Events<br>2008-02-03 17:30:03.230 Reschedule requested for id -1.<br>2008-02-03 17:30:03.631 Scheduled 62 items in 0.4 = 0.07 match + 0.33 place<br>
2008-02-03 17:30:03.670 EITScanner: Now looking for EIT data on multiplex of<br>channel 1<br>2008-02-03 17:31:21.399 EITScanner: Added 6 EIT Events<br>2008-02-03 17:31:45.257 EITScanner: Added 4 EIT Events<br>2008-02-03 17:35:29.161 EITScanner: Now looking for EIT data on multiplex of<br>
channel 700<br>2008-02-03 17:35:53.178<br>EITCache::statistics: Accesses: 50000, Hits: 30862, Table Upgrades 33, New<br>Versions: 88, Entries: 6967 Pruned $<br>2008-02-03 17:36:35.269 EITScanner: Added 6 EIT Events<br>2008-02-03 17:36:35.278 Reschedule requested for id -1.<br>
2008-02-03 17:36:35.628 Scheduled 62 items in 0.3 = 0.03 match + 0.32 place<br>2008-02-03 17:39:46.067 Reschedule requested for id 0.<br>2008-02-03 17:39:46.430 Scheduled 62 items in 0.4 = 0.00 match + 0.36 place<br>2008-02-03 17:39:49.029 Error deleting<br>
'/var/lib/mythtv/recordings/1019_20080129234000.mpg': No such file or d$<br>2008-02-03 17:39:49.430 Reschedule requested for id 0.<br>2008-02-03 17:39:49.794 Scheduled 62 items in 0.4 = 0.03 match + 0.32 place<br>
2008-02-03 17:39:55.070 Reschedule requested for id 0.<br>2008-02-03 17:39:55.093 Error deleting<br>'/var/lib/mythtv/recordings/1007_20080129210000.mpg': No such file or d$<br>2008-02-03 17:39:55.434 Scheduled 62 items in 0.4 = 0.03 match + 0.32 place<br>
2008-02-03 17:40:01.115 Reschedule requested for id 0.<br>2008-02-03 17:40:01.118 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080129200000.mpg': No such file or d$<br>2008-02-03 17:40:01.441 Scheduled 62 items in 0.3 = 0.01 match + 0.32 place<br>
2008-02-03 17:40:07.389 Reschedule requested for id 0.<br>2008-02-03 17:40:07.392 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080129160000.mpg': No such file or d$<br>2008-02-03 17:40:07.760 Scheduled 62 items in 0.4 = 0.01 match + 0.36 place<br>
2008-02-03 17:40:13.712 Reschedule requested for id 0.<br>2008-02-03 17:40:13.714 Error deleting<br>'/var/lib/mythtv/recordings/1002_20080129141500.mpg': No such file or d$<br>2008-02-03 17:40:14.037 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>
2008-02-03 17:40:20.048 Reschedule requested for id 0.<br>2008-02-03 17:40:20.051 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080129110000.mpg': No such file or d$<br>2008-02-03 17:40:20.371 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>
2008-02-03 17:40:26.315 Reschedule requested for id 0.<br>2008-02-03 17:40:26.324 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080128200000.mpg': No such file or d$<br>2008-02-03 17:40:26.643 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>
2008-02-03 17:40:27.536 Reschedule requested for id 0.<br>2008-02-03 17:40:27.916 Scheduled 62 items in 0.4 = 0.01 match + 0.36 place<br>2008-02-03 17:40:32.795 Reschedule requested for id 0.<br>2008-02-03 17:40:32.798 Error deleting<br>
'/var/lib/mythtv/recordings/1019_20080128160000.mpg': No such file or d$<br>2008-02-03 17:40:33.119 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>2008-02-03 17:40:39.065 Reschedule requested for id 0.<br>
2008-02-03 17:40:39.067 Error deleting<br>'/var/lib/mythtv/recordings/1002_20080128141500.mpg': No such file or d$<br>2008-02-03 17:40:39.559 Scheduled 62 items in 0.5 = 0.01 match + 0.49 place<br>2008-02-03 17:40:45.290 Reschedule requested for id 0.<br>
2008-02-03 17:40:45.292 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080128110000.mpg': No such file or d$<br>2008-02-03 17:40:45.837 Scheduled 62 items in 0.5 = 0.00 match + 0.54 place<br>2008-02-03 17:40:51.351 Reschedule requested for id 0.<br>
2008-02-03 17:40:51.354 Error deleting<br>'/var/lib/mythtv/recordings/1713_20080128010000.mpg': No such file or d$<br>2008-02-03 17:40:51.674 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>2008-02-03 17:40:54.476 EITScanner: Added 1 EIT Events<br>
2008-02-03 17:40:54.484 Reschedule requested for id -1.<br>2008-02-03 17:40:54.848 New DB connection, total: 4<br>2008-02-03 17:40:54.947 Connected to database 'mythconverg' at host:<br>localhost<br>2008-02-03 17:40:55.065 Scheduled 62 items in 0.6 = 0.08 match + 0.50 place<br>
2008-02-03 17:40:55.065 EITScanner: Now looking for EIT data on multiplex of<br>channel 108<br>2008-02-03 17:40:57.661 Reschedule requested for id 0.<br>2008-02-03 17:40:57.664 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080127170000.mpg': No such file or d$<br>
2008-02-03 17:40:57.829 Scheduled 62 items in 0.2 = 0.00 match + 0.16 place<br>2008-02-03 17:41:03.675 Reschedule requested for id 0.<br>2008-02-03 17:41:03.678 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080127160000.mpg': No such file or d$<br>
2008-02-03 17:41:04.000 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>2008-02-03 17:41:09.949 Reschedule requested for id 0.<br>2008-02-03 17:41:09.952 Error deleting<br>'/var/lib/mythtv/recordings/1002_20080127130000.mpg': No such file or d$<br>
2008-02-03 17:41:10.274 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>2008-02-03 17:41:16.225 Reschedule requested for id 0.<br>2008-02-03 17:41:16.227 Error deleting<br>'/var/lib/mythtv/recordings/1007_20080126203000.mpg': No such file or d$<br>
2008-02-03 17:41:16.549 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>2008-02-03 17:41:22.498 Reschedule requested for id 0.<br>2008-02-03 17:41:22.500 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080126180000.mpg': No such file or d$<br>
2008-02-03 17:41:22.815 Scheduled 62 items in 0.3 = 0.00 match + 0.31 place<br>2008-02-03 17:41:28.774 Reschedule requested for id 0.<br>2008-02-03 17:41:28.777 Error deleting<br>'/var/lib/mythtv/recordings/1011_20080126170000.mpg': No such file or d$<br>
2008-02-03 17:41:29.117 Scheduled 62 items in 0.3 = 0.01 match + 0.33 place<br>2008-02-03 17:41:34.811 Reschedule requested for id 0.<br>2008-02-03 17:41:34.814 Error deleting<br>'/var/lib/mythtv/recordings/1019_20080126150000.mpg': No such file or d$<br>
2008-02-03 17:41:41.075 Reschedule requested for id 0.<br>2008-02-03 17:41:41.395 Scheduled 62 items in 0.3 = 0.01 match + 0.31 place<br>2008-02-03 17:42:00.996 EITScanner: Added 5 EIT Events<br>2008-02-03 17:45:19.014 EITScanner: Added 2 EIT Events<br>
2008-02-03 17:45:19.021 Reschedule requested for id -1.<br>2008-02-03 17:45:19.361 Scheduled 62 items in 0.3 = 0.03 match + 0.31 place<br>2008-02-03 17:46:20.532 EITScanner: Now looking for EIT data on multiplex of<br>channel 12<br>
2008-02-03 17:47:26.206 EITScanner: Added 4 EIT Events<br>2008-02-03 17:51:46.177 EITScanner: Now looking for EIT data on multiplex of<br>channel 1<br>2008-02-03 17:52:50.645 EITScanner: Added 4 EIT Events<br>2008-02-03 17:52:50.647 Reschedule requested for id -1.<br>
2008-02-03 17:52:50.991 Scheduled 62 items in 0.3 = 0.03 match + 0.31 place<br>2008-02-03 17:55:02.657 EITScanner: Added 1 EIT Events<br>2008-02-03 17:55:03.001 EITScanner: Added 1 EIT Events<br>2008-02-03 17:56:23.412 EITScanner: Added 1 EIT Events<br>
2008-02-03 17:56:23.419 Reschedule requested for id -1.<br>2008-02-03 17:56:23.761 Scheduled 62 items in 0.3 = 0.03 match + 0.31 place<br>2008-02-03 17:56:23.761 EITScanner: Added 1 EIT Events<br>2008-02-03 17:57:11.373 EITScanner: Added 1 EIT Events<br>
2008-02-03 17:57:11.649 EITScanner: Now looking for EIT data on multiplex of<br>channel 700<br>2008-02-03 17:58:16.149 EITScanner: Added 6 EIT Events<br>2008-02-03 17:58:33.042 EITScanner: Added 3 EIT Events<br>2008-02-03 18:00:00.001 TVRec(5): Changing from RecordingOnly to None<br>
2008-02-03 18:00:00.009 Finished recording Top Gear: channel 1019<br>2008-02-03 18:00:00.143 Finished recording Top Gear: channel 1019<br><br>In this second log you can see the errors generated when trying to delete<br>the recordings with no files from the UI.<br>
<br>I must admit I'm completely stumped by this one, hope someone can shed some<br>light on the problem!<br><br>Thanks.<br><br>George<br><br><br>Michael T. Dean wrote:<br>><br>> On 02/05/2008 04:06 AM, georgemason wrote:<br>
>> I have two problems with my Mythbuntu box (it's the master backend etc).<br>>><br>>> 1. Quite often the machine stops recording shows but still adds the<br>>> records<br>>> to the DB, giving a "the file for this recording cannot be found" error<br>
>> if I<br>>> try to watch these recordings.<br>>><br>>> 2. I can't remove these records from the UI - they are there when I<br>>> restart<br>>> the machine despite me having deleted them. I don't know the DB structure<br>
>> well enough to start deleting the records manually.<br>>><br>>> Any help would be appreciated. Thanks.<br>><br>> Use the mythfrontend UI to delete them... Either Watch Recordings or<br>> Delete Recordings. To do that, hit 'D' when the recording is selected<br>
> or use INFO ('I') to get the Action menu and select Delete.<br>><br>> There is no need to edit the DB manually (and if you do, you'll almost<br>> definitely leave information that should be deleted).<br>
><br>> Mike<br>> _______________________________________________<br>> mythtv-users mailing list<br>> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>> <a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
><br>><br><br>--<br>View this message in context: <a href="http://www.nabble.com/Shows-not-recording---how-can-I-delete-DB-entries-manually--tp15258267s15552p15288008.html">http://www.nabble.com/Shows-not-recording---how-can-I-delete-DB-entries-manually--tp15258267s15552p15288008.html</a><br>
Sent from the mythtv-users mailing list archive at <a href="http://Nabble.com">Nabble.com</a>.<br><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br></blockquote></div>
<div> </div>
<div>George,</div>
<div> </div>
<div>I had this one myself when an mp3 export script I was using deleted the original file.</div>
<div> </div>
<div>You can either delete the records from the "recorded" table directly or create a file for the mythui to delete (find the filename using Mythweb) or even better...</div>
<div> </div>
<div>Create a user job that creates the file (using touch <filename>) run this from the mythui then delete the program using the front end....</div>
<div> </div>
<div>A script like this would work for the user job:</div>
<div> </div>
<div>#!/bin/sh</div>
<div>touch $1</div>
<div> </div>
<div>You call this as a userjob (see the wiki) with touch_filename.sh %FILENAME%</div>
<div> </div>
<div>The frontend fails to delete a program if it can't find the file to delete. A bug? Probably not, just an irritation.</div>
<div> </div>
<div>Cheers</div>
<div> </div>
<div>Steve</div>
<div><br> </div>