What's normal: I have listings data and these are updating; I can watch live TV and recordings; all recording rules are still present and even list instances that would normally be recorded, though these are all listed as "not recording".
What's not working: upcoming recordings are blank. Setting recordings from e.g. program guide results in nothing. Trying to call up "Previously Recorded" results in infinite delay. (I'm not sure if regularly scheduled programs will record -- the next thing I know I had scheduled is tomorrow at 4:30. I know something recorded today, but this issue arose since 2 days ago - it was normal then.)
I'm running: Ubuntu 20.04 (kernel 5.11.0-342109090909).
MythTV 32 from the Mythbuntu PPA (v32.0~master.202110241541.0374b68ac8~ubuntu20.04.1)
MySQL latest from repo (8.0.27-0ubuntu0.20.04.1).
I noticed in /var/log/mythtvmythbackend.log, I have this error that began showing up about the same time as the problem:
This seems pretty likely to be related, but where it came from and how to fix it, I don't know.Oct 26 19:57:04 Dangerous mythbackend: mythbackend[1239]: E Scheduler mythdb.cpp
:202 (DBError) DB Error (AddNewRecords):#012Query was:#012SELECT c.chanid,
c.sourceid, p.starttime, p.endtime, p.title,
p.subtitle, p.description, c.channum, c.cal
lsign, c.name, oldrecduplicate, p.category, sched_temp_record.recpriority, sched_temp_record.dupin, recduplicate, findduplicate, sched_temp_record.type, sched_temp_record.recordid, p.starttime - INTERVAL sched_temp_record.startoffset minute AS recstartts, p.endtime + INTERVAL sched_temp_record.endoffset minute AS recendts, p.previouslyshown, sched_temp_record.recgroup, sched_temp_record.dupmethod, c.commmethod, capturecard.cardid, 0, p.seriesid, p.programid, sched_temp_record.inetref, p.category_type, p.airdate, p.stars, p.originalairdate, sched_temp_record.inactive, sched_temp_record.parentid, recordmatch.findid, sched_temp_record.playgroup, oldrecstatus.recstatus, oldrecstatus.reactivate, p.videoprop+0, p.subtitletypes+0, p.audioprop+0, sched_temp_record.storagegroup, capturecard.hostname, recordmatch.oldrecstatus, NULL, oldrecstatus.future, capturecard.schedorder, p.syndicatedepisodenumber, p.partnumber, p.parttotal, c.mplexid, capturecard.displayname, p.season, p.episode, p.totalepisodes, c.recpriority + capturecard.recpriority + (capturecard.cardid = sched_temp_record.prefinput) * 2 + (FIND_IN_SET('SIGNED', p.subtitletypes) > 0) * -1 + (FIND_IN_SET('ONSCREEN', p.subtitletypes) > 0) * -1 AS powerpriority FROM recordmatch INNER JOIN sched_temp_record ON (recordmatch.recordid = sched_temp_record.recordid) INNER JOIN program AS p ON ( recordmatch.chanid = p.chanid AND recordmatch.starttime = p.starttime AND recordmatch.manualid = p.manualid ) INNER JOIN channel AS c ON ( c.chanid = p.chanid ) INNER JOIN capturecard ON ( c.sourceid = capturecard.sourceid AND ( capturecard.schedorder <> 0 OR capturecard.parentid = 0 ) ) LEFT JOIN oldrecorded as oldrecstatus ON ( oldrecstatus.station = c.callsign AND oldrecstatus.starttime = p.starttime AND oldrecstatus.title = p.title ) WHERE p.endtime > (NOW() - INTERVAL 480 MINUTE) ORDER BY sched_temp_record.recordid DESC, p.starttime, p.title, c.callsign, c.channum #012Driver error was [2/1690]:#012QMYSQL3: Unable to store statement results#012Database error was:#012BIGINT UNSIGNED value is out of range in '((`mythconverg`.`c`.`recpriority` + `mythconverg`.`capturecard`.`recpriority`) + ((`mythconverg`.`capturecard`.`cardid` = `mythconverg`.`sched_temp_record`.`prefinput`) * 2))'
I've tried:
Restarting mythbackend
Restarting mysql
Rebooting.