[mythtv-users] Recordings not working

[Peter Bennett]

On 5/22/21 7:39 AM, Stephen Worthington wrote:
> On Sat, 22 May 2021 17:58:43 +0800, you wrote:
>
>> Hi,
>>
>>>> Interesting. Take a look at the forum posts here:
>>>>
>>>>   https://forum.mythtv.org/viewtopic.php?f=36&t=4453&p=21893#p21895
>>> I also had an incident just like that on the 16th - MythTV v31-fixes
>>> failed to record all day until I noticed in the evening.  The log
>>> showed lots of SQL errors.  There was a new version of MythTV waiting
>>> to be updated to, so when I noticed the problem, I installed the
>>> update and rebooted.  Looking at mythbackend.log now, I can see that
>>> there were three more short periods where there were some more SQL
>>> errors logged, but it seems to have continued working properly after
>>> those incidents.  I think there were two more updates installed since
>>> the day it failed to record.  My guess was that there was a bug that
>>> caused the problem which was fixed by the update I installed when I
>>> found the problem.
>>> I am using MariaDB, so if my problem is the same one, it is unlikely
>>> that both MySQL and MariaDB would be causing problems at the same
>>> time, so the problem is likely in MythTV rather than the database
>>> servers.
>> Thanks for your responses. The issue described in the forum post link
>> you sent sounds like the same as mine.
>>
>> It happened again yesterday, but today all was fine. So I'm still not
>> sure what's going on.
> My mother's MythTV box had it yesterday, but mine has been fine since
> I rebooted it.  I am keeping an eye on them to see if it will happen
> again.  As best I can tell from the logs, the problem happens when the
> scheduler runs, and after that the scheduler never works again, so
> there are no scheduled recordings.  This feels like a new MythTV bug,
> so someone should create a bug report for the developers to have a
> look at it.
> _______________________________________________

This is possibly related to a new version of mysql, see
https://forum.mythtv.org/viewtopic.php?f=36&t=4453#p21895

Perhaps a reboot after the database upgrade would fix it?

Here are the changes to fixes/31 since April 1st. There does not seem to 
be anything database or scheduler related:

* f8c59ee69d 2021/05/17 Stuart Auchterlonie : Revert "V4LChannel: Remove 
unneeded definitions" - Broke debian-stretch and centos7builds
* fe5a6243ce 2021/05/17 Stuart Auchterlonie : Revert "Use system 
videodev2.h" - Broke debian-stretch and centos7 builds
* 9b74773e3c 2021/05/17 Gary Buhrmaster : Use system videodev2.h
* bcc01811ca 2021/05/17 Gary Buhrmaster : V4LChannel: Remove unneeded 
definitions
* 200e3f4757 2021/05/17 Klaas de Waal : Update changed streams on PMT 
update
* f7de8cea58 2021/05/06 Peter Bennett : tmdb3 lookup: Prevent exception 
when there are no posters.
* b2ed400037 2021/05/01 Klaas de Waal : Update file size before skip 
forward
* 05c16580e1 2021/04/19 Peter Bennett : tmdb3tv: Prevent exception when 
non-existent season is requested.
* c02c6fc0b3 2021/04/18 kmdewaal : Merge pull request #356 from 
kt--/fix_ssa_subs_karaoke_broken
|\
| * d4997f4629 2021/04/18 kingsley : Increase cut-off for subtitle 
buffer clear, too small for SSA karaoke subs
|/
* 563a05b7a8 2021/04/01 Klaas de Waal : Show "Use FFmpeg's original 
MPEG-TS demuxer" option