<br><br><div class="gmail_quote">On Sun, Dec 2, 2012 at 2:47 PM, R KANNAN <span dir="ltr"><<a href="mailto:rk111810@gmail.com" target="_blank">rk111810@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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 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: :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: 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 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></blockquote><div><br>Thanks. I just ran <a href="http://optimize_mythdb.pl" target="_blank">optimize_mythdb.pl</a>. 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. <br>
</div><div> </div></div>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'
</blockquote></div>Running <a href="http://optimize_mythdb.pl">optimize_mythdb.pl</a> 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.<br>