[mythtv-users] Database error

[R KANNAN]

>
> From: Nick Rout <nick.rout at gmail.com>
> To: Discussion about MythTV <mythtv-users at mythtv.org>
> Subject: Re: [mythtv-users] Database error
> Message-ID:
>         <
> CALmzFLZt5mj0vG3LZZRn7tyfW_YCnZ3BE8mLPLQqzgKiktfU8g at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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?
>

Because I get only a digest of myth-users not individual postings. I got
both Bill Meek's and your posting together. I wanted to every one on what I
found later. Anyway, here is the link to the mythbackend logs with  the
database errors

http://paste.ubuntu.com/1406203/

You can see the errors at 17:31 and at 18:23

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121202/9677d9dc/attachment.html>