[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