[mythtv-users] Database error

R KANNAN rk111810 at gmail.com
Sun Dec 2 19:47:53 UTC 2012


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


More information about the mythtv-users mailing list