<div dir="ltr"><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Oct 27, 2021 at 4:51 AM John <<a href="mailto:jksjdevelop@gmail.com">jksjdevelop@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<div>On 27/10/2021 04:24, Fred Squires
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>I'm not getting any new recordings today and found that I
have no upcoming recordings listed.</div>
<div>I'm also unable to schedule new recordings. If I try in
MythWeb it simply refreshes the page as if I selected no
settings.<br>
</div>
<div>My current recordings still exist and play back properly. I
have listings, recording schedules and tuners. I can play live
TV. I'm currently running Ubuntu 20.04.3 LTS and MythTV
v31.0+fixes.202108081239.5da2523154~ubuntu20.04.1</div>
<div><br>
</div>
<div>I've restored my database to the backup from the last 2
days which did not help.<br>
</div>
<div><br>
</div>
<div>I noticed that another person posted a similar problem
today. I installed updates today including a "Ubuntu base"
update, so maybe something is wrong there.<br>
</div>
<div><br>
</div>
<div>I see the following error in the mythbackend log:</div>
<div>Oct 26 23:05:08 mainbe mythbackend: mythbackend[9515]: E
Scheduler mythdb.cpp:181 (DBError) DB Error
(AddNewRecords):#012Query was:#012SELECT c.chanid,
c.sourceid, p.starttime, p.endtime,
p.title, p.subtitle, p.description,
c.channum, c.callsign, <a href="http://c.name" target="_blank">c.name</a>,
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 +
(p.hdtv > 0 OR FIND_IN_SET('HDTV', p.videoprop) > 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
O</div>
<div><br>
</div>
<div>Does anyone have any thoughts? <br>
</div>
<div>Thanks!<br>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
mythtv-users mailing list
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p>I see mysql client changed on the 25 th you could try reverting
it libmysqlclient21:amd64 (8.0.26-0ubuntu0.20.04.3,
8.0.27-0ubuntu0.20.04.1),<br>
</p>
</div>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a></blockquote><div> </div><div>Thanks!</div><div>I downgraded that from 8.0.27 to 8.019, but that didn't help. I'm going to try downgrading the rest of the packages that were upgraded yesterday before trying anything more drastic.</div><div>Here are the packages that upgraded yesterday:</div><div><br></div><div>Start-Date: 2021-10-26 06:04:32<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: libmysqlclient21:amd64 (8.0.26-0ubuntu0.20.04.3, 8.0.27-0ubuntu0.20.04.<br>1)<br>End-Date: 2021-10-26 06:04:34<br><br>Start-Date: 2021-10-26 06:04:39<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: binutils:amd64 (2.34-6ubuntu1.1, 2.34-6ubuntu1.3), binutils-x86-64-linu<br>x-gnu:amd64 (2.34-6ubuntu1.1, 2.34-6ubuntu1.3), binutils-common:amd64 (2.34-6ubu<br>ntu1.1, 2.34-6ubuntu1.3), libbinutils:amd64 (2.34-6ubuntu1.1, 2.34-6ubuntu1.3), <br>libctf0:amd64 (2.34-6ubuntu1.1, 2.34-6ubuntu1.3)<br>End-Date: 2021-10-26 06:04:42<br><br>Start-Date: 2021-10-26 06:04:47<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: mysql-client-8.0:amd64 (8.0.26-0ubuntu0.20.04.3, 8.0.27-0ubuntu0.20.04.<br>1), mysql-server-8.0:amd64 (8.0.26-0ubuntu0.20.04.3, 8.0.27-0ubuntu0.20.04.1), m<br>ysql-server-core-8.0:amd64 (8.0.26-0ubuntu0.20.04.3, 8.0.27-0ubuntu0.20.04.1)<br>End-Date: 2021-10-26 06:05:34<br><br>Start-Date: 2021-10-26 06:05:39<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: python3-apport:amd64 (2.20.11-0ubuntu27.20, 2.20.11-0ubuntu27.21)<br>End-Date: 2021-10-26 06:05:41<br><br>Start-Date: 2021-10-26 06:05:46<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: python3-problem-report:amd64 (2.20.11-0ubuntu27.20, 2.20.11-0ubuntu27.2<br>1)<br>End-Date: 2021-10-26 06:05:47<br><br>Start-Date: 2021-10-26 06:05:51<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: apport-gtk:amd64 (2.20.11-0ubuntu27.20, 2.20.11-0ubuntu27.21)<br>End-Date: 2021-10-26 06:05:52<br><br>Start-Date: 2021-10-26 06:05:57<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: mysql-client-core-8.0:amd64 (8.0.26-0ubuntu0.20.04.3, 8.0.27-0ubuntu0.2<br>0.04.1)<br>End-Date: 2021-10-26 06:06:02<br><br>Start-Date: 2021-10-26 06:06:07<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: apport:amd64 (2.20.11-0ubuntu27.20, 2.20.11-0ubuntu27.21)<br>End-Date: 2021-10-26 06:06:13<br><br>Start-Date: 2021-10-26 06:06:18<br>Commandline: /usr/bin/unattended-upgrade<br>Upgrade: libctf-nobfd0:amd64 (2.34-6ubuntu1.1, 2.34-6ubuntu1.3)<br>End-Date: 2021-10-26 06:06:18<br><br>Start-Date: 2021-10-26 21:53:20<br>Commandline: aptdaemon role='role-commit-packages' sender=':1.16976'<br>Upgrade: netplan.io:amd64 (0.103-0ubuntu5~20.04.1, 0.103-0ubuntu5~20.04.2), brave-browser:amd64 (1.30.89, 1.31.87), alsa-ucm-conf:amd64 (1.2.2-1ubuntu0.10, 1.2.2-1ubuntu0.11), libpulsedsp:amd64 (1:13.99.1-1ubuntu3.11, 1:13.99.1-1ubuntu3.12), pulseaudio:amd64 (1:13.99.1-1ubuntu3.11, 1:13.99.1-1ubuntu3.12), libpulse0:amd64 (1:13.99.1-1ubuntu3.11, 1:13.99.1-1ubuntu3.12), libpulse-mainloop-glib0:amd64 (1:13.99.1-1ubuntu3.11, 1:13.99.1-1ubuntu3.12), libnetplan0:amd64 (0.103-0ubuntu5~20.04.1, 0.103-0ubuntu5~20.04.2), pulseaudio-module-bluetooth:amd64 (1:13.99.1-1ubuntu3.11, 1:13.99.1-1ubuntu3.12), pulseaudio-utils:amd64 (1:13.99.1-1ubuntu3.11, 1:13.99.1-1ubuntu3.12)<br>End-Date: 2021-10-26 21:53:42</div></div></div>