[mythtv] Re: [mythtv-commits] Re: Ticket #821: autoexpire doesn't delete

[Adam Egger]

On 12/30/05, Chris Pinkham <cpinkham at bc2va.org> wrote:
> > 12/30/05 03:33:33: Modified by ghaushe
> >
> > * status changed from closed to reopened.
> > * resolution deleted.
> >
> > I am still seeing this issue pretty frequently as of 8391. Is there
> > some data I can provide that'll help track it down?
>
> Do these recordings have the correct endtime on them or is the endtime
> set to the actual program endtime?  If so, the "short" calculation fails
> since endtime - starttime is greater than one minute.
>
> I thought I saw someone mention that they still were seeing some
> LiveTV recordings that didn't have endtime properly set when they
> switched channels.

I mentioned last week that all my LiveTV recordings don't expire (in
.http://www.gossamer-threads.com/lists/mythtv/dev/169249?search_string=DVB-r8369%3A%20Can%27t%20switch%20channels%20occasionally;#169249)
All endtimes are still set to the actual program endtimes.

Used revision:
2005-12-30 11:33:49.496 mythfrontend version: 8427M, 0.19.20051208-1
www.mythtv.org (by the way I really like the svn version patch from
#885).


Here is some mysql output:
mysql> SELECT starttime,endtime  FROM recorded WHERE recgroup =
'LiveTV' order by starttime desc;
+---------------------+---------------------+
| starttime           | endtime             |
+---------------------+---------------------+
| 2005-12-30 11:16:50 | 2005-12-30 11:35:00 |
| 2005-12-30 11:15:51 | 2005-12-30 11:35:00 |
| 2005-12-30 11:14:17 | 2005-12-30 11:20:00 |
| 2005-12-30 11:14:15 | 2005-12-30 11:14:00 |
| 2005-12-30 11:10:23 | 2005-12-30 11:58:00 |
| 2005-12-30 11:09:08 | 2005-12-30 11:58:00 |
| 2005-12-30 10:52:48 | 2005-12-30 11:03:00 |
| 2005-12-30 10:51:33 | 2005-12-30 11:00:00 |
| 2005-12-30 10:43:38 | 2005-12-30 11:00:00 |
....
mysql> select chanid, progstart, progend, starttime, endtime, title,
autoexpire    from recorded where recgroup = "LiveTV" order by
progstart desc, starttime;
+--------+---------------------+---------------------+---------------------+---------------------+----------------------------------------------------+------------+
| chanid | progstart           | progend             | starttime      
    | endtime             | title                                     
        | autoexpire |
+--------+---------------------+---------------------+---------------------+---------------------+----------------------------------------------------+------------+
|      7 | 2005-12-30 11:03:00 | 2005-12-30 11:58:00 | 2005-12-30
11:10:23 | 2005-12-30 11:58:00 | talk talk talk                       
             |      10000 |
|      6 | 2005-12-30 11:00:00 | 2005-12-30 11:58:00 | 2005-12-30
11:09:08 | 2005-12-30 11:58:00 | Stefanie - Eine Frau startet durch   
             |      10000 |
|   1033 | 2005-12-30 10:55:00 | 2005-12-30 11:20:00 | 2005-12-30
11:14:15 | 2005-12-30 11:14:00 | Die verwegenen Vier                  
             |      10000 |
|   1033 | 2005-12-30 10:55:00 | 2005-12-30 11:20:00 | 2005-12-30
11:14:17 | 2005-12-30 11:20:00 | Die verwegenen Vier                  
             |      10000 |
|      6 | 2005-12-30 10:30:00 | 2005-12-30 11:00:00 | 2005-12-30
10:43:38 | 2005-12-30 11:00:00 | Verliebt in Berlin                   
             |      10000 |
|   1005 | 2005-12-30 10:30:00 | 2005-12-30 11:35:00 | 2005-12-30
11:15:51 | 2005-12-30 11:35:00 | Gioacchino Rossini: Stabat Mater     
             |      10000 |
|   1005 | 2005-12-30 10:30:00 | 2005-12-30 11:35:00 | 2005-12-30
11:16:50 | 2005-12-30 11:35:00 | Gioacchino Rossini: Stabat Mater     
             |      10000 |
|      7 | 2005-12-30 10:03:00 | 2005-12-30 11:03:00 | 2005-12-30
10:52:48 | 2005-12-30 11:03:00 | Eure letzte Chance                   
             |      10000 |
|      8 | 2005-12-30 10:00:00 | 2005-12-30 11:00:00 | 2005-12-30
10:51:33 | 2005-12-30 11:00:00 | FOCUS TV EXKLUSIV                    
             |      10000 |

I can't really switch channels here because of the problem described
in the thread "DVB-r8369: Can't switch channels occasionally". It
always gets stuck on one channel after two or three channel changes.

Adam