[mythtv-users] MySQL related BE deadlocks - collective wisdom needed
warpme
warpme at o2.pl
Fri Jul 29 09:41:40 UTC 2011
Hi *
Having this thread as kind of "mysql and myth" I'm seizing an opportunity to clarify following mysql-myth related issue:
I have occasionally following error in myth log:
2011-07-29 03:00:02.713306 I EITScanner (5): Started passive scan.
2011-07-29 03:00:02.725219 I TVRec(5): rec->GetPathname(): '/myth/tv/15315_20110729030000.mpg'
2011-07-29 03:00:21.058767 E DB Error (change_program):
Query was:
UPDATE program SET starttime = ?, endtime = ? WHERE chanid = ? AND starttime = ?
Bindings were:
:CHANID=21023, :NEWEND=2011-07-29T06:00:00, :NEWSTART=2011-07-29T05:00:00,
:OLDSTART=2011-07-29T04:00:00
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '21023-2011-07-29 05:00:00-0' for key 'PRIMARY'
2011-07-29 03:01:57.645007 I EITScanner (5): Added 869 EIT Events
It is not destructive nor I can notice any negative side effects but I want be 100% sure that above issue isn't connected with mysql deadlocks.
br
More information about the mythtv-users
mailing list