[mythtv-users] Database error

[Bill Meek]

On 12/02/2012 01:47 PM, R KANNAN wrote:
>> Date: Sun, 02 Dec 2012 16:04:18 +0000
...
>> I'd suspect a database error if this keeps repeating. Have you run
>> optimize_mythdb.pl recently?
>>
>> --
>>
>> Mike Perkins
>>
>>
>>
> Thanks. I just ran optimize_mythdb.pl. It ran through without any errors.
> Hopefully, it gets rid of this error. The recent instance of the DB error
> had different STRAT/END time but the same channel ID.
>
> DB Error (change_program): Query was: UPDATE program SET starttime = ?,
> endtime = ? WHERE chanid = ? AND starttime = ? Bindings were: :CHANID=1202,
> :NEWEND=2012-12-02T23:30:00, :NEWSTART=2012-12-02T23:00:00,
> :OLDSTART=2012-12-02T22:00:00 Driver error was [2/1062]: QMYSQL3: Unable to
> execute statement Database error was: Duplicate entry '1202-2012-12-02
> 23:00:00-0' for key 'PRIMARY'

Hi;

What was going on ahead of the error. change_program is used by MoveOutOfTheWayDB
which is used by UpdateDB etc.

It might be helpful to post the entire log, preferably using the --logpath
option, as opposed to --syslog. Also, I'd add -v eit to your backend's
logging 1st.

See this: http://www.mythtv.org/wiki/Posting_Logs and just put a link
to a pastebin here.

-- 
Bill