/usr/bin/mysqld, Version: 10.4.7-MariaDB-log (Source distribution). started with: Tcp port: 16603 Unix socket: /run/mysql/socket Time Id Command Argument 190805 14:43:00 8 Connect root@localhost as anonymous on 8 Query SHOW DATABASES 8 Init DB mediatomb 8 Query SHOW /*!50002 FULL*/ TABLES 8 Query CHECK TABLE `mt_autoscan` EXTENDED 8 Query CHECK TABLE `mt_cds_active_item` EXTENDED 8 Query CHECK TABLE `mt_cds_object` EXTENDED ... 190805 15:18:07 14 Connect mythtv@mythtv as anonymous on mythconverg 14 Init DB mythconverg 14 Query SET NAMES utf8mb4 14 Query SET @@session.time_zone='+00:00' 14 Query SET @@session.sql_mode='' 14 Prepare SELECT sourceid FROM capturecard WHERE cardid = ? 14 Reset stmt 14 Execute SELECT sourceid FROM capturecard WHERE cardid = 2 14 Close stmt 14 Prepare SELECT SUM(useeit) FROM videosource, capturecard WHERE videosource.sourceid = capturecard.sourceid AND capturecard.cardid = ? 14 Reset stmt 14 Execute SELECT SUM(useeit) FROM videosource, capturecard WHERE videosource.sourceid = capturecard.sourceid AND capturecard.cardid = 2 14 Close stmt 14 Prepare SELECT COUNT(cardid) FROM capturecard 14 Reset stmt 14 Execute SELECT COUNT(cardid) FROM capturecard 14 Close stmt ... 14 Prepare SELECT channel.videofilters FROM channel WHERE channum = ? AND sourceid = ? 14 Reset stmt 14 Execute SELECT channel.videofilters FROM channel WHERE channum = '2_1' AND sourceid = 1 14 Close stmt 14 Prepare SELECT filesize FROM recorded WHERE chanid = ? AND starttime = ? 14 Reset stmt 14 Execute SELECT filesize FROM recorded WHERE chanid = 16802 AND starttime = TIMESTAMP'2019-08-05 19:18:40' 14 Close stmt 14 Prepare SELECT channel.chanid FROM channel, capturecard WHERE channel.channum = ? AND channel.sourceid = capturecard.sourceid AND capturecard.cardid = ? AND capturecard.hostname = ? 14 Reset stmt 14 Execute SELECT channel.chanid FROM channel, capturecard WHERE channel.channum = '2_1' AND channel.sourceid = capturecard.sourceid AND capturecard.cardid = 2 AND capturecard.hostname = 'Oakdale' 14 Close stmt 14 Prepare SELECT channel.chanid FROM channel WHERE channum = ? AND sourceid = ? 14 Reset stmt 14 Execute SELECT channel.chanid FROM channel WHERE channum = '2_1' AND sourceid = 1 14 Close stmt 14 Prepare SELECT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid, program.videoprop+0, program.audioprop+0, program.subtitletypes+0, program.syndicatedepisodenumber, program.partnumber, program.parttotal, program.season, program.episode, program.totalepisodes FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON oldrecstatus.future = 0 AND program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = ? AND program.starttime < ? AND program.endtime > ? GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 20000 14 Reset stmt 14 Execute SELECT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid, program.videoprop+0, program.audioprop+0, program.subtitletypes+0, program.syndicatedepisodenumber, program.partnumber, program.parttotal, program.season, program.episode, program.totalepisodes FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON oldrecstatus.future = 0 AND program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = '10201' AND program.starttime < TIMESTAMP'2019-08-05 19:18:50' AND program.endtime > TIMESTAMP'2019-08-05 19:18:50' GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 20000 14 Close stmt 14 Prepare SELECT chanid, channum, callsign, name, commmethod, outputfilters FROM channel WHERE chanid = ? 14 Reset stmt 14 Execute SELECT chanid, channum, callsign, name, commmethod, outputfilters FROM channel WHERE chanid = 10201 14 Prepare SELECT data FROM settings WHERE value = ? AND hostname = ? 14 Reset stmt 14 Execute SELECT data FROM settings WHERE value = 'unknowntitle' AND hostname = 'oakdale' 14 Close stmt 14 Prepare SELECT data FROM settings WHERE value = ? AND hostname IS NULL 14 Reset stmt 14 Execute SELECT data FROM settings WHERE value = 'unknowntitle' AND hostname IS NULL 14 Close stmt 14 Prepare SELECT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid, program.videoprop+0, program.audioprop+0, program.subtitletypes+0, program.syndicatedepisodenumber, program.partnumber, program.parttotal, program.season, program.episode, program.totalepisodes FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON oldrecstatus.future = 0 AND program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = ? AND program.starttime > ? GROUP BY program.starttime ORDER BY program.starttime LIMIT 1 14 Reset stmt 14 Execute SELECT program.chanid, program.starttime, program.endtime, program.title, program.subtitle, program.description, program.category, channel.channum, channel.callsign, channel.name, program.previouslyshown, channel.commmethod, channel.outputfilters, program.seriesid, program.programid, program.airdate, program.stars, program.originalairdate, program.category_type, oldrecstatus.recordid, oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid, program.videoprop+0, program.audioprop+0, program.subtitletypes+0, program.syndicatedepisodenumber, program.partnumber, program.parttotal, program.season, program.episode, program.totalepisodes FROM program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus ON oldrecstatus.future = 0 AND program.title = oldrecstatus.title AND channel.callsign = oldrecstatus.station AND program.starttime = oldrecstatus.starttime WHERE program.chanid = '10201' AND program.starttime > TIMESTAMP'2019-08-05 19:18:50' GROUP BY program.starttime ORDER BY program.starttime LIMIT 1 14 Close stmt 14 Close stmt 14 Prepare SELECT recordid, category, (category = ?) AS catmatch, (category = ?) AS typematch FROM record WHERE type = ? AND (category = ? OR category = ? OR category = 'Default') ORDER BY catmatch DESC, typematch DESC 14 Reset stmt