No subject

Mon May 17 17:55:34 UTC 2010

the above error.
Is there an easier way to repair this?

Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi all.<br><br>Using mythbuntu .23 latest fixes<br>Separate frontend backend.<br>I am getting random brief locks with my frontends.<br>When I check the backend logs at this time I see the following<br><br>2010-07-06 15:34:07.484 Reschedule requested for id -1.<br>2010-07-06 15:34:09.679 Scheduled 195 items in 2.2 = 0.02 match + 2.16 place<br>2010-07-06 15:36:00.303 DB Error (change_program):<br>Query was:<br>UPDATE program SET starttime = ?,&nbsp;&nbsp;&nbsp;&nbsp; endtime&nbsp;&nbsp; = ? WHERE chanid&nbsp;&nbsp;&nbsp; = ? AND&nbsp;&nbsp;&nbsp; $<br>Bindings were:<br>:CHANID=1112, :NEWEND=2010-07-07T02:00:00, :NEWSTART=2010-07-06T20:29:46,<br>:OLDSTART=2010-07-06T20:00:00<br>Driver error was [2/1062]:<br>QMYSQL3: Unable to execute statement<br>Database error was:<br>Duplicate entry
 '1112-2010-07-06 20:29:46-0' for key 'PRIMARY'<br><br>From what I have read I need to dump the database and do a clean restore to fix the above error.<br>Is there an easier way to repair this?<br></div>


More information about the mythtv-users mailing list