[mythtv-users] Duplicate entry for key PRIMARY in recordedmarkup

[Khanh Tran]

I upgraded to .24-fixes a few weeks ago and I'm starting to see the
following database errors after some recordings.  It's seemingly
random, in that it only happens once or twice a day and it's not
consistent on the channels or shows it has this problem with.

Any help is appreciated!

2011-03-04 08:12:59.607 AutoExpire: CalcParams(): Max required Free
Space: 6.0 GB w/freq: 5 min
2011-03-04 08:15:47.032 DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2030, :DATA=720, :MARK=28215, :STARTTIME=2011-03-04T08:00:00, :TYPE=30
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '2030-2011-03-04 08:00:00-30-28215' for key 'PRIMARY'

2011-03-04 08:15:47.051 DB Error (Resolution insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2030, :DATA=480, :MARK=28215, :STARTTIME=2011-03-04T08:00:00, :TYPE=31
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '2030-2011-03-04 08:00:00-31-28215' for key 'PRIMARY'

2011-03-04 08:15:47.060 DB Error (Frame rate insert):
Query was:
INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)
VALUES ( ?, ?, ?, ?, ?);
Bindings were:
:CHANID=2030, :DATA=29970, :MARK=28215, :STARTTIME=2011-03-04T08:00:00, :TYPE=32
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '2030-2011-03-04 08:00:00-32-28215' for key 'PRIMARY'

2011-03-04 08:18:00.279 AutoExpire: CalcParams(): Max required Free
Space: 6.0 GB w/freq: 5 min