[mythtv] Table for Upcoming Recordings

[R. G. Newbury]

On 10/10/14 12:08 PM, Stuart Morgan wrote:
> On Friday 10 Oct 2014 11:51:12 R. G. Newbury wrote:
>> I cannot find the answer to this question:
>>
>> Which table holds the Upcoming Recordings data?
>>
>> I had a power outage which borked the box on re-boot. I missed some
>> recordings as a result. But they still show up in the 'Upcoming
>> Recordings' listing.
>> And I cannot remove them!  Using Delete pops up the usual 'Delete
>> Recording Rule' but that does nothing to the missed entry. It remains in
>> green as if the recording were still in progress!
>> Listed upcoming programs are deleted.
>>
>> I come up empty spelunking the mysql tables for the correct rows to
>> delete. I cannot find which table holds the data.
>
> It's not held in any table, it's held in memory. <Cue spooky music>

<cue weird horror-themed spooky music with overlay BWA-HA-HA-HA shriek>

Now THAT I would NEVER have guessed. It *does* explain why I cannot find 
it in the tables.
THanks!

So of course, a re-start of the backend should clear it.

Must have been a power flicker. Could not have been a full outage. I 
really do need to get the replacement battery for the UPS and move it 
from the office to home!

Geoff