<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
From: Nick Rout <<a href="mailto:nick.rout@gmail.com" target="_blank">nick.rout@gmail.com</a>><br>
To: Discussion about MythTV <<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>><br>
Subject: Re: [mythtv-users] Database error<br>
Message-ID:<br>
<<a href="mailto:CALmzFLZt5mj0vG3LZZRn7tyfW_YCnZ3BE8mLPLQqzgKiktfU8g@mail.gmail.com" target="_blank">CALmzFLZt5mj0vG3LZZRn7tyfW_YCnZ3BE8mLPLQqzgKiktfU8g@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
On Mon, Dec 3, 2012 at 11:47 AM, R KANNAN <<a href="mailto:rk111810@gmail.com" target="_blank">rk111810@gmail.com</a>> wrote:<br>
<br>
><br>
><br>
> On Sun, Dec 2, 2012 at 2:47 PM, R KANNAN <<a href="mailto:rk111810@gmail.com" target="_blank">rk111810@gmail.com</a>> wrote:<br>
><br>
>><br>
>> Date: Sun, 02 Dec 2012 16:04:18 +0000<br>
>>> From: Mike Perkins <<a href="mailto:mikep@randomtraveller.org.uk" target="_blank">mikep@randomtraveller.org.uk</a>><br>
>>> To: Discussion about MythTV <<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>><br>
>>> Subject: Re: [mythtv-users] Database error<br>
>>> Message-ID: <<a href="mailto:50BB7C02.1020103@randomtraveller.org.uk" target="_blank">50BB7C02.1020103@randomtraveller.org.uk</a>><br>
>>> Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br>
>>><br>
>>> On 02/12/12 15:19, R KANNAN wrote:<br>
>>> > Hello,<br>
>>> ><br>
>>> > I have a persistent database error from mythtv backend the recent<br>
>>> occurence<br>
>>> > of which says...<br>
>>> ><br>
>>> > DB Error (change_program): Query was: UPDATE program SET starttime = ?,<br>
>>> > endtime = ? WHERE chanid = ? AND starttime = ? Bindings were:<br>
>>> :CHANID=1202,<br>
>>> > :NEWEND=2012-12-02T08:30:00, :NEWSTART=2012-12-02T07:30:00,<br>
>>> > :OLDSTART=2012-12-02T07:00:00 Driver error was [2/1062]: QMYSQL3:<br>
>>> Unable to<br>
>>> > execute statement Database error was: Duplicate entry '1202-2012-12-02<br>
>>> > 07:30:00-0' for key 'PRIMARY'<br>
>>> ><br>
>>> ><br>
>>> > The channel ID 1202 is a local channel here and I do not have a<br>
>>> recording<br>
>>> > rule for recording anything on that channel. How can I eleminate this?<br>
>>> ><br>
>>> I'd suspect a database error if this keeps repeating. Have you run<br>
>>> <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> recently?<br>
>>><br>
>>> --<br>
>>><br>
>>> Mike Perkins<br>
>>><br>
>>><br>
>>><br>
>> Thanks. I just ran <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a>. It ran through without any<br>
>> errors. Hopefully, it gets rid of this error. The recent instance of the DB<br>
>> error had different STRAT/END time but the same channel ID.<br>
>><br>
>> DB Error (change_program): Query was: UPDATE program SET starttime = ?,<br>
>> endtime = ? WHERE chanid = ? AND starttime = ? Bindings were: :CHANID=1202,<br>
>> :NEWEND=2012-12-02T23:30:00, :NEWSTART=2012-12-02T23:00:00,<br>
>> :OLDSTART=2012-12-02T22:00:00 Driver error was [2/1062]: QMYSQL3: Unable to<br>
>> execute statement Database error was: Duplicate entry '1202-2012-12-02<br>
>> 23:00:00-0' for key 'PRIMARY'<br>
><br>
> Running <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a> did not help I am still getting these errors<br>
> every 1 hrs to 2 hrs with the only change being in the START & ENDTIME in<br>
> the message.<br>
><br>
<br>
Why don't you follow Bill Meek's suggestion?<br></blockquote><div><br>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<br>
<br><a href="http://paste.ubuntu.com/1406203/">http://paste.ubuntu.com/1406203/</a><br><br>You can see the errors at 17:31 and at 18:23<br><br>Thanks<br>
</div></div>