[mythtv-users] Recordings not working

Justin Smith justin at smithpolglase.com
Thu May 20 13:22:03 UTC 2021


Hi,

I have the following problem: My MythTV is not recording TV shows. When I
go to the Guide and select a show to record and then select the type of
recording rule (e.g. "Record All Showings") nothing happens. The Guide
re-appears and there is no icon showing that the show is going to record,
nor does the recording actually happen.

More symptoms: The Upcoming Recordings list is empty.

The backend logs show all sorts of database errors but MySQL seems to be
working fine so I can't make head nor tail out of it. Sample log for one
failed recording added below.

Note that LiveTV works fine. E.g. select "Watch this Channel" from the
guide.

However when I restart the backend, everything is back to normal! All my
recording rules appear to be working again. Upcoming recordings are listed.
And the guide shows when a show will be recorded. And recordings work.

But the next day, the MythTV is no longer recording again. Restarting the
backend fixes it again. Rinse and repeat. This has happened over the last
few days.

One thing I have done - recently I re-ran mythtv-setup and scanned all
channels again. And used WebFrontend to fix up a bunch of channel icons.
While I didn't check all channels, the ones I watch mostly work fine (with
LiveTV).

I have been running MythTV since around 2006 (yep!). I always upgrade
promptly when a new stable version comes out. Every few years I upgrade the
hardware.

Setup:
* v31+fixes frontend + backend on one box
* Ubuntu Focal (latest LTS).
* HDHR5-4DT network tuner (4 tuners).
* I live in Australia and use Shepherd as my TV guide source.
* Box is nothing fancy - Intel i5, 4GB ram, blah blah blah, circa 2015.

Backend log snippet when I set a show to record (was going to start
shortly):
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: I Scheduler
scheduler.cpp:2310 (HandleReschedule) Reschedule requested for MATCH 146 0
0 - SaveRule Giro d'Italia
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: DELETE recordmatch FROM
recordmatch, channel WHERE recordmatch.chanid = channel.chanid AND
recordmatch.recordid = :RECORDID
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (UpdateMatches1):#012Query was:#012DELETE
recordmatch FROM recordmatch, channel WHERE recordmatch.chanid =
channel.chanid AND recordmatch.recordid = 146#012Bindings
were:#012:RECORDID=146#012Driver error was [2/0]:#012QMYSQL: Unable to
execute query#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: DELETE oldrecorded FROM
oldrecorded LEFT JOIN recordmatch ON     recordmatch.chanid    =
oldrecorded.chanid    AND     recordmatch.starttime = oldrecorded.starttime
    WHERE oldrecorded.future > 0 AND     recordmatch.recordid IS NULL
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (DeleteFuture):#012Query was:#012DELETE
oldrecorded FROM oldrecorded LEFT JOIN recordmatch ON
recordmatch.chanid    = oldrecorded.chanid    AND     recordmatch.starttime
= oldrecorded.starttime     WHERE oldrecorded.future > 0 AND
recordmatch.recordid IS NULL#012Driver error was [2/0]:#012QMYSQL: Unable
to execute query#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: DROP TABLE IF EXISTS
sched_temp_record;
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (Dropping sched_temp_record
table):#012Query was:#012DROP TABLE IF EXISTS sched_temp_record;#012Driver
error was [2/0]:#012QMYSQL: Unable to execute query#012Database error
was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: UPDATE recordmatch
 INNER JOIN sched_temp_record ON (recordmatch.recordid =
sched_temp_record.recordid)  INNER JOIN program p ON (recordmatch.chanid =
p.chanid AND                           recordmatch.starttime = p.starttime
AND                           recordmatch.manualid = p.manualid)  LEFT JOIN
oldrecorded ON   (     sched_temp_record.dupmethod > 1 AND
oldrecorded.duplicate <> 0 AND     p.title = oldrecorded.title AND
p.generic = 0      AND      (       (p.programid <> ''        AND
p.programid = oldrecorded.programid)       OR       (        (p.programid =
'' OR oldrecorded.programid = '')        AND
 (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> ''
AND p.subtitle = oldrecorded.subtitle))        AND
 (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> ''
    AND p.description = oldrecorded.description))        AND
 (((sched_temp_record.dupmethod & 0x08) = 0) OR           (p.subtitle <> ''
AND              (p.subtitle = oldrecorded.subtitle OR
(oldrecorded.subtitle = '' AND                p.subtitle =
oldrecorded.description))) OR           (p.subtitle = '' AND p.description
<> '' AND              (p.description = oldrecorded.subtitle OR
  (oldrecorded.subtitle = '' AND                p.description =
oldrecorded.description))))       )      )   )  LEFT JOIN
sched_temp_recorded recorded ON   (     sched_temp_record.dupmethod > 1 AND
    recorded.duplicate <> 0 AND     p.title = recorded.title AND
p.generic = 0 AND     recorded.recgroup NOT IN ('LiveTV','Deleted')
 AND      (       (p.programid <> ''        AND p.programid =
recorded.programid)       OR       (        (p.programid = '' OR
recorded.programid = '')        AND        (((sched_temp_record.dupmethod &
0x02) = 0) OR (p.subtitle <> ''           AND p.subtitle =
recorded.subtitle))        AND        (((sch
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (UpdateDuplicates):#012Query
was:#012UPDATE recordmatch  INNER JOIN sched_temp_record ON
(recordmatch.recordid = sched_temp_record.recordid)  INNER JOIN program p
ON (recordmatch.chanid = p.chanid AND
recordmatch.starttime = p.starttime AND
recordmatch.manualid = p.manualid)  LEFT JOIN oldrecorded ON   (
sched_temp_record.dupmethod > 1 AND     oldrecorded.duplicate <> 0 AND
p.title = oldrecorded.title AND     p.generic = 0      AND      (
(p.programid <> ''        AND p.programid = oldrecorded.programid)       OR
      (        (p.programid = '' OR oldrecorded.programid = '')        AND
       (((sched_temp_record.dupmethod & 0x02) = 0) OR (p.subtitle <> ''
      AND p.subtitle = oldrecorded.subtitle))        AND
 (((sched_temp_record.dupmethod & 0x04) = 0) OR (p.description <> ''
    AND p.description = oldrecorded.description))        AND
 (((sched_temp_record.dupmethod & 0x08) = 0) OR           (p.subtitle <> ''
AND              (p.subtitle = oldrecorded.subtitle OR
(oldrecorded.subtitle = '' AND                p.subtitle =
oldrecorded.description))) OR           (p.subtitle = '' AND p.description
<> '' AND              (p.description = oldrecorded.subtitle OR
  (oldrecorded.subtitle = '' AND                p.description =
oldrecorded.description))))       )      )   )  LEFT JOIN
sched_temp_recorded recorded ON   (     sched_temp_record.dupmethod > 1 AND
    recorded.duplicate <> 0 AND     p.title = recorded.title AND
p.generic = 0 AND     recorded.recgroup NOT IN ('LiveTV','Deleted')
 AND      (       (p.programid <> ''        AND p.programid =
recorded.programid)       OR       (        (p.programid = '' OR
recorded.programid = '')        AND        (((sched_temp_record.dupmethod &
0x02) = 0) OR (p.subtitle <> ''           AND p.subtitle =
recorded.subtitle))
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: SELECT recordid, title,
maxepisodes, maxnewest FROM sched_temp_record
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (CheckTooMany):#012Query was:#012SELECT
recordid, title, maxepisodes, maxnewest FROM sched_temp_record#012Driver
error was [2/0]:#012QMYSQL: Unable to execute query#012Database error
was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: SELECT record.title,
  record.subtitle,           record.description, record.season,
 record.episode,     record.category,           record.chanid,
 channel.channum,             record.station,     channel.name,
   record.recgroup,    record.playgroup,          record.seriesid,
 record.programid,          record.inetref,     record.recpriority,
 record.startdate,   record.starttime,          record.enddate,
record.endtime,            record.recordid,    record.type,
record.dupin,       record.dupmethod,          record.findid,
                    record.startoffset, record.endoffset,
 channel.commmethod                          FROM record INNER JOIN channel
ON (channel.chanid = record.chanid) LEFT JOIN recordmatch on
record.recordid = recordmatch.recordid WHERE (type = 1 OR type = 7) AND
  recordmatch.chanid IS NULL
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (AddNotListed):#012Query was:#012SELECT
record.title,       record.subtitle,           record.description,
record.season,              record.episode,     record.category,
record.chanid,      channel.channum,             record.station,
channel.name,                record.recgroup,    record.playgroup,
 record.seriesid,    record.programid,          record.inetref,
record.recpriority,        record.startdate,   record.starttime,
 record.enddate,     record.endtime,            record.recordid,
 record.type,               record.dupin,       record.dupmethod,
 record.findid,                                   record.startoffset,
record.endoffset,          channel.commmethod                          FROM
record INNER JOIN channel ON (channel.chanid = record.chanid) LEFT JOIN
recordmatch on record.recordid = recordmatch.recordid WHERE (type = 1 OR
type = 7) AND       recordmatch.chanid IS NULL#012Driver error was
[2/0]:#012QMYSQL: Unable to execute query#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: DROP TABLE IF EXISTS
sched_temp_record;
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (DeleteTempTables
sched_temp_record):#012Query was:#012DROP TABLE IF EXISTS
sched_temp_record;#012Driver error was [2/0]:#012QMYSQL: Unable to execute
query#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: DROP TABLE IF EXISTS
sched_temp_recorded;
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdb.cpp:181 (DBError) DB Error (DeleteTempTables drop table):#012Query
was:#012DROP TABLE IF EXISTS sched_temp_recorded;#012Driver error was
[2/0]:#012QMYSQL: Unable to execute query#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:843 (prepare) Error preparing query: SELECT recordid,
next_record FROM record;
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: E Scheduler
mythdbcon.cpp:845 (prepare) Driver error was [2/0]:#012QMYSQL3: Unable to
prepare statement#012Database error was:#012
May 20 20:53:15 elzo mythbackend: mythbackend[60645]: I Scheduler
scheduler.cpp:2427 (HandleReschedule) Scheduled 0 items in 0.0 = 0.00 match
+ 0.00 check + 0.00 place
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210520/6430c8f4/attachment.htm>


More information about the mythtv-users mailing list