2019-08-05 15:18:03.031740 C mythbackend version: [v30.0] www.mythtv.org 2019-08-05 15:18:03.031780 C Qt version: compile: 5.12.4, runtime: 5.12.4 2019-08-05 15:18:03.031784 N Enabled verbose msgs: general database 2019-08-05 15:18:03.031798 N Setting Log Level to LOG_DEBUG 2019-08-05 15:18:03.042298 I Added logging to the console ... 2019-08-05 15:18:46.354268 I Database object created: DBManager17 2019-08-05 15:18:46.354292 I New DB connection, total: 15 2019-08-05 15:18:46.354303 D PortChecker::checkPort(): host Oakdale port 16603 timeLimit 30000 linkLocalOnly 1 2019-08-05 15:18:46.355114 I [DBManager17] Connected to database 'mythconverg' at host: Oakdale 2019-08-05 15:18:46.357194 I MSqlQuery::exec(DBManager17) SELECT r.title, r.subtitle, r.description, r.season, r.episode, r.category, r.chanid, c.channum, c.callsign, c.name, c.outputfilters,r.recgroup, r.playgroup, r.storagegroup, r.basename, r.hostname, r.recpriority, r.seriesid, r.programid, r.inetref, r.filesize, r.progstart, r.progend, r.stars, r.starttime, r.endtime, p.airdate+0, r.originalairdate, r.lastmodified, r.recordid, c.commmethod, r.commflagged, r.previouslyshown, r.transcoder, r.transcoded, r.deletepending, r.preserve, r.cutlist, r.autoexpire, r.editing, r.bookmark, r.watched, p.audioprop+0, p.videoprop+0, p.subtitletypes+0, r.findid, rec.dupin, rec.dupmethod, p.syndicatedepisodenumber, p.partnumber, p.parttotal, p.season, p.episode, p.totalepisodes, p.category_type, r.recordedid, r.inputname, r.bookmarkupdate FROM recorded AS r LEFT JOIN channel AS c ON (r.chanid = c.chanid) LEFT JOIN recordedprogram AS p ON (r.chanid = p.chanid AND r.progstart = p.starttime) LEFT JOIN record AS rec ON (r.recordid = rec.recordid) WHERE r.chanid = '16802' AND r.starttime = '2019-08-05T18:23:17.000Z' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.357431 D MSqlQuery::next(DBManager17) Result: "title = Monkey See, Monkey Do, subtitle = , description = Accomplished professionals and experts provide careful how-to instructions, as well as practical tips, on a variety of functions and topics for children, which, season = 0, episode = 0, category = , chanid = 16802, channum = 68_2, callsign = qubo, name = qubo, outputfilters = , recgroup = LiveTV, playgroup = Default, storagegroup = LiveTV, basename = 16802_20190805182317.ts, hostname = Oakdale, recpriority = 0, seriesid = , programid = , inetref = , filesize = 0, progstart = 2019-08-05T18:15:00.000, progend = 2019-08-05T18:30:00.000, stars = 0, starttime = 2019-08-05T18:23:17.000, endtime = 2019-08-05T18:23:18.000, p.airdate+0 = 0, originalairdate = , lastmodified = 2019-08-05T19:18:31.000, recordid = 0, commmethod = -1, commflagged = 0, previouslyshown = 0, transcoder = 0, transcoded = 0, deletepending = 1, preserve = 0, cutlist = 0, autoexpire = 10000, editing = 0, bookmark = 0, watched = 0, p.audioprop+0 = 0, p.videoprop+0 = 0, p.subtitletypes+0 = 1, findid = 0, dupin = 0, dupmethod = 0, syndicatedepisodenumber = , partnumber = 0, parttotal = 0, season = 0, episode = 0, totalepisodes = 0, category_type = , recordedid = 3683, inputname = , bookmarkupdate = " 2019-08-05 15:18:46.358319 I MSqlQuery::exec(DBManager17) UPDATE jobqueue SET status = '320' WHERE chanid = '16802' AND starttime = '2019-08-05T18:23:17.000Z' AND status = '1'; <<<< Took 0ms 2019-08-05 15:18:46.359153 I MSqlQuery::exec(DBManager17) UPDATE jobqueue SET cmds = '4' WHERE chanid = '16802' AND starttime = '2019-08-05T18:23:17.000Z' AND status <> '320'; <<<< Took 0ms 2019-08-05 15:18:46.361132 I MSqlQuery::exec(DBManager17) SELECT id FROM jobqueue WHERE chanid = '16802' and starttime = '2019-08-05T18:23:17.000Z' AND status NOT IN ('272','288','304','320'); <<<< Took 0ms, Returned 0 row(s) 2019-08-05 15:18:46.361948 I MSqlQuery::exec(DBManager17) DELETE FROM jobqueue WHERE chanid = '16802' AND starttime = '2019-08-05T18:23:17.000Z'; <<<< Took 0ms 2019-08-05 15:18:46.468443 I MSqlQuery::exec(DBManager3) SELECT channel.videofilters FROM channel WHERE channum = '2_1' AND sourceid = '1' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.468473 D MSqlQuery::next(DBManager3) Result: "videofilters = " 2019-08-05 15:18:46.469306 I MSqlQuery::exec(DBManager3) SELECT filesize FROM recorded WHERE chanid = '16802' AND starttime = '2019-08-05T19:18:40.000Z' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.469333 D MSqlQuery::next(DBManager3) Result: "filesize = 886232" 2019-08-05 15:18:46.470284 I MSqlQuery::exec(DBManager3) SELECT channel.chanid FROM channel, capturecard WHERE channel.channum = '2_1' AND channel.sourceid = capturecard.sourceid AND capturecard.cardid = '2' AND capturecard.hostname = 'Oakdale' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.471364 I MSqlQuery::exec(DBManager3) SELECT channel.chanid FROM channel WHERE channum = '2_1' AND sourceid = '1' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.471394 D MSqlQuery::next(DBManager3) Result: "chanid = 10201" 2019-08-05 15:18:46.471529 I MSqlQuery::exec(DBManager1) SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'LiveTV' AND hostname = 'Oakdale' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.471561 D MSqlQuery::next(DBManager1) Result: "dirname = /mm/Storage/LiveTV/" 2019-08-05 15:18:46.472706 I MSqlQuery::exec(DBManager1) SELECT MIN(id),dirname FROM storagegroup WHERE hostname = 'Oakdale' AND groupname NOT IN ( 'DB Backups', 'Videos', 'Trailers', 'Coverart', 'Fanart', 'Screenshots', 'Banners', 'Photographs', 'Music', 'MusicArt' ) GROUP BY dirname; <<<< Took 0ms, Returned 2 row(s) 2019-08-05 15:18:46.472746 D MSqlQuery::next(DBManager1) Result: "MIN(id) = 1, dirname = /mm" 2019-08-05 15:18:46.472784 D MSqlQuery::next(DBManager1) Result: "MIN(id) = 14, dirname = /mm/Storage/LiveTV/" 2019-08-05 15:18:46.473778 I MSqlQuery::exec(DBManager1) SELECT chanid,visible FROM channel, capturecard WHERE capturecard.sourceid = channel.sourceid AND channel.channum = '2_1' AND capturecard.cardid = '2' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.473813 D MSqlQuery::next(DBManager1) Result: "chanid = 10201, visible = 1" 2019-08-05 15:18:46.474679 I MSqlQuery::exec(DBManager1) SELECT inputname, sourceid, livetvorder, schedorder, displayname, recpriority, quicktune FROM capturecard WHERE cardid = '2' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.474724 D MSqlQuery::next(DBManager1) Result: "inputname = DVBInput, sourceid = 1, livetvorder = 3, schedorder = 2, displayname = , recpriority = 0, quicktune = 0" 2019-08-05 15:18:46.475494 I MSqlQuery::exec(DBManager1) SELECT mplexid FROM channel WHERE chanid = '10201' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.475524 D MSqlQuery::next(DBManager1) Result: "mplexid = 2" 2019-08-05 15:18:46.476329 I MSqlQuery::exec(DBManager1) SELECT chanid,visible FROM channel, capturecard WHERE capturecard.sourceid = channel.sourceid AND channel.channum = '2_1' AND capturecard.cardid = '2' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.476362 D MSqlQuery::next(DBManager1) Result: "chanid = 10201, visible = 1" 2019-08-05 15:18:46.477165 I MSqlQuery::exec(DBManager1) SELECT inputname, sourceid, livetvorder, schedorder, displayname, recpriority, quicktune FROM capturecard WHERE cardid = '2' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.477209 D MSqlQuery::next(DBManager1) Result: "inputname = DVBInput, sourceid = 1, livetvorder = 3, schedorder = 2, displayname = , recpriority = 0, quicktune = 0" 2019-08-05 15:18:46.477996 I MSqlQuery::exec(DBManager1) SELECT mplexid FROM channel WHERE chanid = '10201' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.478023 D MSqlQuery::next(DBManager1) Result: "mplexid = 2" 2019-08-05 15:18:46.478104 N AutoExpire: CalcParams(): Max required Free Space: 3.0 GB w/freq: 14 min 2019-08-05 15:18:46.480036 I MSqlQuery::exec(DBManager3) 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 < '2019-08-05T19:18:50.000Z' AND program.endtime > '2019-08-05T19:18:50.000Z' GROUP BY program.starttime, channel.channum, channel.callsign, program.title ORDER BY program.starttime, atsc_major_chan,atsc_minor_chan,channum,callsign LIMIT 20000 <<<< Took 1ms, Returned 0 row(s) 2019-08-05 15:18:46.480866 I MSqlQuery::exec(DBManager3) SELECT chanid, channum, callsign, name, commmethod, outputfilters FROM channel WHERE chanid = '10201' <<<< Took 0ms, Returned 1 row(s) 2019-08-05 15:18:46.480911 D MSqlQuery::next(DBManager3) Result: "chanid = 10201, channum = 2_1, callsign = WGBH-HD, name = WGBH-HD, commmethod = -1, outputfilters = " 2019-08-05 15:18:46.481671 I MSqlQuery::exec(DBManager3) SELECT data FROM settings WHERE value = 'unknowntitle' AND hostname = 'oakdale' <<<< Took 0ms, Returned 0 row(s) 2019-08-05 15:18:46.482595 I MSqlQuery::exec(DBManager3) SELECT data FROM settings WHERE value = 'unknowntitle' AND hostname IS NULL <<<< Took 0ms, Returned 0 row(s) 2019-08-05 15:18:46.482756 W LoadFromProgram(): SQL contains LIMIT clause, caller should be updated to use limit parameter instead 2019-08-05 15:18:46.485374 I MSqlQuery::exec(DBManager3) 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 > '2019-08-05T19:18:50.000Z' GROUP BY program.starttime ORDER BY program.starttime LIMIT 1 <<<< Took 0ms, Returned 0 row(s) QMYSQLResult::cleanup: unable to free statement handle 2019-08-05 15:18:46.676684 I MSqlQuery::exec(DBManager3) SELECT recordid, category, (category = '') AS catmatch, (category = '') AS typematch FROM record WHERE type = '11' AND (category = '' OR category = '' OR category = 'Default') ORDER BY catmatch DESC, typematch DESC <<<< Took 0ms, Returned -1 row(s) 2019-08-05 15:18:46.676712 E DB Error (LoadByTemplate): Query was: 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 Bindings were: :CAT1="", :CAT2="", :CATTYPE1="", :CATTYPE2="", :TEMPLATE=11 Driver error was [2/2006]: QMYSQL3: Unable to execute statement Database error was: MySQL server has gone away