[mythtv-users] DB error I just logged

Jerome Yuzyk jerome at supernet.ab.ca
Sat Oct 17 20:15:44 UTC 2015


I have a tail -f on the mythbackend log and it just registered this. I think it's about one of 2 recordings that started about 10 minutes ago on one of my PVR-500 tuners. The backend keeps on recording though.


2015-10-17 14:06:27.367002 E [32247/3904] RecThread mythdb.cpp:183 (DBError) - DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=1020, :DATA=720, :MARK=11581, :STARTTIME=2015-10-17T20:00:00Z, :TYPE=30
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1020-2015-10-17 20:00:00-30-11581' for key 'PRIMARY'

2015-10-17 14:06:27.367372 E [32247/3904] RecThread mythdb.cpp:183 (DBError) - DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=1020, :DATA=480, :MARK=11581, :STARTTIME=2015-10-17T20:00:00Z, :TYPE=31
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1020-2015-10-17 20:00:00-31-11581' for key 'PRIMARY'


-- 
A little of Jerome's MythTV World: http://mythtv.bss.ab.ca


More information about the mythtv-users mailing list