[mythtv-users] Database error

R KANNAN rk111810 at gmail.com
Sun Dec 2 22:47:36 UTC 2012


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121202/0e4f3d75/attachment.html>


More information about the mythtv-users mailing list