[mythtv-users] Database error

[Bill Meek]

On 12/02/2012 07:04 PM, R KANNAN wrote:
...
>>>>>> I have a persistent database error from mythtv backend the recent occurence
>>>>>> of which says...
>>>>>>
>>>>>> DB Error (change_program): Query was: UPDATE program SET starttime = ?,
>>>>>> endtime = ? WHERE chanid = ? AND starttime = ? Bindings were:
>>>>> :CHANID=1202,
>>>>>> :NEWEND=2012-12-02T08:30:00, :NEWSTART=2012-12-02T07:30:00,
>>>>>> :OLDSTART=2012-12-02T07:00:00 Driver error was [2/1062]: QMYSQL3:
>>>>> Unable to  execute statement Database error was: Duplicate entry
>> '1202-2012-12-02
>>>>>> 07:30:00-0' for key 'PRIMARY'
...
 > http://paste.ubuntu.com/1406203/
 >
> You can see the errors at 17:31 and at 18:23           [and 16:39]

Hi;

Well, I was hoping the log would give more clues, but you can
see from:

     E EIT mythdb.cpp:192 (DBError) DB Error (change_program):#012Query was:#012UPDATE program SET starttime...

that EIT is involved. So, for starters, are you using EIT and or
SchedulesDirect?

The 3 timestamps are about 52 minutes and 20 seconds apart, which
means nothing to me. The log doesn't have the MythTV version or
verbose settings, so I'm <assuming> that you did add -v eit to
your backend command line and restart it before pasting it.
If not you can change the verbose options on a running backend
with: mythbackend --setverbose eit and paste another log.

-- 
Bill