[mythtv-users] Scheduler mythdb.cpp:192 (DBError) - DB Error (AddNewRecords)

[Chris Porter]

On Tue, Sep 6, 2011 at 7:20 AM, Brian J. Murrell <brian at interlinx.bc.ca>wrote:

> I'm getting the following on master (7768ebc):
>
> 2011-09-06 08:27:42.960333 E [27892/27915] Scheduler mythdb.cpp:192
> (DBError) - DB Error (AddNewRecords):
> Query was:
> SELECT     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,   rec
> duplicate,          findduplicate,    sched_temp_record.type,
> sched_temp_record.recordid,     p.start
> time - 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, cardinp
> ut.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(da
> te_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.fin
> dday   WHEN 7    THEN sched_temp_record.findid   ELSE 0  END) ,
> sched_temp_record.playgroup, oldrecstat
> us.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,
> c.recpriority + cardinput.recpriority + (
> cardinput.cardinputid = sched_temp_record.prefinput) *
> 2011-09-06 08:27:43.415639 I [27892/27915] Scheduler scheduler.cpp:2066
> (HandleReschedule) - Scheduled 0 items in 10.0 = 1.66 match + 8.33 place
>
> Any ideas?
>
> Cheers,
> b.
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
>
Have you tried repairing or optimizing the database?  Are their any other
errors showing up in your backend logs?

-- 
Working on World Domination since 2001
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110906/a6cec9bf/attachment.html