[mythtv-users] No Scheduled Recordings [v0.25.2-15-g46cab93]

[Chris Watson]

I upgraded my backend yetserday and noticed that there were no
recordings yesterday.

Having rebooted the system and found the same issue today, I checked the log.

I noticed there is an entry in the log as follows: E Scheduler
mythdb.cpp:192 (DBError)

Can anybody recommend a fix please?

Aug 23 14:27:00 ford mythbackend[1725]: C thread_unknown
mythcommandlineparser.cpp:2534 (ConfigureLogging) mythbackend version:
fixes/0.25 [v0.25.2-15-g46cab93] www.mythtv.org
Aug 23 14:27:00 ford mythbackend[1725]: C thread_unknown
mythcommandlineparser.cpp:2536 (ConfigureLogging) Qt version: compile:
4.8.1, runtime: 4.8.1
Aug 23 14:27:00 ford mythbackend[1725]: N thread_unknown
mythcommandlineparser.cpp:2538 (ConfigureLogging) Enabled verbose
msgs: general
Aug 23 14:27:00 ford mythbackend[1725]: N thread_unknown
logging.cpp:1176 (logStart) Setting Log Level to LOG_INFO
Aug 23 14:27:00 ford mythbackend[1725]: I thread_unknown
logging.cpp:229 (FileLogger) Added logging to the console
Aug 23 14:27:00 ford mythbackend[1725]: I thread_unknown
logging.cpp:369 (SyslogLogger) Added syslogging to facility local7
Aug 23 14:27:00 ford mythbackend[1725]: I thread_unknown
logging.cpp:425 (DatabaseLogger) Added database logging to table
logging
Aug 23 14:27:00 ford mythbackend[1725]: N thread_unknown
logging.cpp:1215 (logStart) Setting up SIGHUP handler
Aug 23 14:27:00 ford mythbackend[1725]: N thread_unknown
mythdirs.cpp:51 (InitializeMythDirs) Using runtime prefix = /usr
Aug 23 14:27:00 ford mythbackend[1725]: N thread_unknown
mythdirs.cpp:64 (InitializeMythDirs) Using configuration directory =
/home/mythtv/.mythtv
Aug 23 14:27:00 ford mythbackend[1725]: I CoreContext
mythcorecontext.cpp:227 (Init) Assumed character encoding: en_GB.UTF-8
Aug 23 14:27:00 ford mythbackend[1725]: E CoreContext
configuration.cpp:64 (Load) Error parsing:
/home/mythtv/.mythtv/config.xml at line: 1 column: 1
Aug 23 14:27:00 ford mythbackend[1725]: E CoreContext
configuration.cpp:66 (Load) Error Msg: unexpected end of file
Aug 23 14:27:00 ford mythbackend[1725]: N CoreContext
mythcontext.cpp:477 (LoadDatabaseSettings) Empty LocalHostName.
Aug 23 14:27:00 ford mythbackend[1725]: I CoreContext
mythcontext.cpp:481 (LoadDatabaseSettings) Using localhost value of
ford
Aug 23 14:27:00 ford mythbackend[1725]: E CoreContext
configuration.cpp:64 (Load) Error parsing:
/home/mythtv/.mythtv/config.xml at line: 1 column: 1
Aug 23 14:27:00 ford mythbackend[1725]: E CoreContext
configuration.cpp:66 (Load) Error Msg: unexpected end of file
Aug 23 14:27:02 ford mythbackend[1725]: N CoreContext
mythcorecontext.cpp:1270 (InitLocale) Setting QT default locale to
en_GB
Aug 23 14:27:02 ford mythbackend[1725]: I CoreContext
mythcorecontext.cpp:1303 (SaveLocaleDefaults) Current locale en_GB
Aug 23 14:27:02 ford mythbackend[1725]: N CoreContext
mythlocale.cpp:121 (LoadDefaultsFromXML) Reading locale defaults from
/usr/share/mythtv//locales/en_gb.xml
Aug 23 14:27:02 ford mythbackend[1725]: I CoreContext
schemawizard.cpp:117 (Compare) Current MythTV Schema Version
(DBSchemaVer): 1299
Aug 23 14:27:02 ford mythbackend[1725]: E CoreContext
mythtranslation.cpp:74 (load) Error Loading en_gb translation for
module mythfrontend
Aug 23 14:27:02 ford mythbackend[1725]: N CoreContext
main_helpers.cpp:556 (run_backend) MythBackend: Starting up as the
master server.
Aug 23 14:27:21 ford mythbackend[1725]: I CoreContext
programinfo.cpp:2052 (CheckProgramIDAuthorities) Found 2 distinct
programid authorities
Aug 23 14:27:21 ford mythbackend[1725]: I Scheduler mythdbcon.cpp:422
(getStaticCon) New static DB connectionSchedCon
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6544
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP 192.168.0.12:6544
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP [::1]:6544
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP
[fe80::20c:29ff:fe76:6040%eth0]:6544
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
main_helpers.cpp:626 (run_backend) Main::Registering HttpStatus
Extension
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP 127.0.0.1:6543
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP 192.168.0.12:6543
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP [::1]:6543
Aug 23 14:27:22 ford mythbackend[1725]: I CoreContext
serverpool.cpp:395 (listen) Listening on TCP
[fe80::20c:29ff:fe76:6040%eth0]:6543
Aug 23 14:27:23 ford mythbackend[1725]: N CoreContext
autoexpire.cpp:263 (CalcParams) AutoExpire: CalcParams(): Max required
Free Space: 1.0 GB w/freq: 15 min
Aug 23 14:27:23 ford mythbackend[1725]: I CoreContext
bonjourregister.cpp:103 (BonjourCallback) Bonjour: Service
registration complete: name 'Mythbackend on ford' type
'_mythbackend-master._tcp.' domain: 'local.'
Aug 23 14:27:25 ford mythbackend[1725]: I Scheduler scheduler.cpp:2033
(HandleReschedule) Reschedule requested for id -1.
Aug 23 14:27:32 ford mythbackend[1725]: I HouseKeeping
housekeeper.cpp:225 (RunHouseKeeping) Running housekeeping thread
Aug 23 14:27:46 ford mythbackend[1725]: E Scheduler mythdb.cpp:192
(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, 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,
cardinput.cardinputid,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,(CASE sched_temp_record.type WHEN 6 THEN
sched_temp_record.findid WHEN 9 THEN to_days(date_sub(p.starttime,
interval time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) WHEN 10 THEN floor((to_days(date_sub(p.starttime,
interval time_format(sched_temp_record.findtime, '%H:%i')
hour_minute)) - sched_temp_record.findday)/7) * 7 +
sched_temp_record.findday WHEN 7 THEN sched_temp_record.findid ELSE 0
END) , 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, sched_temp_record.avg_delay,
oldrecstatus.future, cardinput.schedorder, c.recpriority +
cardinput.recpriority + (cardinput.cardinputid = sched_te
Aug 23 14:27:46 ford mythbackend[1725]: I Scheduler scheduler.cpp:2093
(HandleReschedule) Scheduled 1 items in 20.7 = 19.60 match + 1.12
place
Aug 23 14:27:46 ford mythbackend[1725]: I Scheduler scheduler.cpp:2160
(HandleRunSchedulerStartup) Scheduler: Seem to be woken up by USER
Aug 23 14:28:41 ford mythbackend[1725]: N Expire autoexpire.cpp:263
(CalcParams) AutoExpire: CalcParams(): Max required Free Space: 1.0 GB
w/freq: 15 min
Aug 23 14:29:54 ford mythbackend[1725]: I SystemIOHandlerW
system-unix.cpp:90 (run) Starting IO manager (write)
Aug 23 14:29:54 ford mythbackend[1725]: I SystemIOHandlerR
system-unix.cpp:90 (run) Starting IO manager (read)
Aug 23 14:29:54 ford mythbackend[1725]: I SystemSignalManager
system-unix.cpp:485 (run) Starting process signal handler