[mythtv-users] mysql errors Duplicate entry *************** for key ''PRIMARY'

Kevin Johnson dabears_rule at yahoo.com
Tue Jul 6 23:30:11 UTC 2010


Hi all.

Using mythbuntu .23 latest fixes
Separate frontend backend.
I am getting random brief locks with my frontends.
When I check the backend logs at this time I see the following

2010-07-06 15:34:07.484 Reschedule requested for id -1.
2010-07-06 15:34:09.679 Scheduled 195 items in 2.2 = 0.02 match + 2.16 place
2010-07-06 15:36:00.303 DB Error (change_program):
Query was:
UPDATE program SET starttime = ?,     endtime   = ? WHERE chanid    = ? AND    $
Bindings were:
:CHANID=1112, :NEWEND=2010-07-07T02:00:00, :NEWSTART=2010-07-06T20:29:46,
:OLDSTART=2010-07-06T20:00:00
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1112-2010-07-06 20:29:46-0' for key 'PRIMARY'



More information about the mythtv-users mailing list