[mythtv-users] Database error

[Nick Rout]

On Mon, Dec 3, 2012 at 11:47 AM, R KANNAN <rk111810 at gmail.com> wrote:

>
>
> On Sun, Dec 2, 2012 at 2:47 PM, R KANNAN <rk111810 at gmail.com> wrote:
>
>>
>> Date: Sun, 02 Dec 2012 16:04:18 +0000
>>> From: Mike Perkins <mikep at randomtraveller.org.uk>
>>> To: Discussion about MythTV <mythtv-users at mythtv.org>
>>> Subject: Re: [mythtv-users] Database error
>>> Message-ID: <50BB7C02.1020103 at randomtraveller.org.uk>
>>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>>
>>> On 02/12/12 15:19, R KANNAN wrote:
>>> > Hello,
>>> >
>>> > 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'
>>> >
>>> >
>>> > The channel ID 1202 is a local channel here and I do not have a
>>> recording
>>> > rule for recording anything on that channel. How can I eleminate this?
>>> >
>>> 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'
>
> Running optimize_mythdb.pl did not help I am still getting these errors
> every 1 hrs to 2 hrs with the only change being in the START & ENDTIME in
> the message.
>

Why don't you follow Bill Meek's suggestion?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121203/76859972/attachment-0001.html>