[mythtv-users] Strange Error Message in Log

[Alan Chandler]

I am tracking down another problem (which I will report separately to 
the list) when I cam across the following in my backend log for today

2012-05-12 19:15:33.915813 N [26047/26071] Expire autoexpire.cpp:263 
(CalcParams) - AutoExpire: CalcParams(): Max required Free Space: 3.0 GB 
w/freq: 14 min
2012-05-12 19:17:04.328460 E [26047/26058] EIT mythdb.cpp:192 (DBError) 
- DB Error (change_program):
Query was:
UPDATE program SET starttime = ?,     endtime   = ? WHERE chanid    = ? 
AND       starttime = ?
Bindings were:
:CHANID=1081, :NEWEND=2012-05-14T13:40:00, :NEWSTART=2012-05-14T13:00:00,
:OLDSTART=2012-05-14T12:00:00
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1081-2012-05-14 13:00:00-0' for key 'PRIMARY'

2012-05-12 19:18:23.779159 I [26047/26069] Scheduler scheduler.cpp:2011 
(HandleReschedule) - Reschedule requested for id -1.
2012-05-12 19:18:24.419806 I [26047/26069] Scheduler scheduler.cpp:2069 
(HandleReschedule) - Scheduled 141 items in 0.6 = 0.31 match + 0.33 place
2012-05-12 19:18:41.203334 I [26047/26070] HouseKeeping 
housekeeper.cpp:225 (RunHouseKeeping) - Running housekeeping thread
2012-05-12 19:19:29.555847 I [26047/26064] TVRecEvent tv_rec.cpp:1518 
(HandlePendingRecordings) - TVRec(21): ASK_RECORDING 21 29 0 0
2012-05-12 19:19:29.564286 I [26047/26068] TVRecEvent tv_rec.cpp:1518 
(HandlePendingRecordings) - TVRec(24): ASK_RECORDING 24 29 0 0
2012-05-12 19:19:29.899042 I [26047/26067] TVRecEvent tv_rec.cpp:1518 
(HandlePendingRecordings) - TVRec(23): ASK_RECORDING 23 29 0 0
2012-05-12 19:19:29.899175 I [26047/26066] TVRecEvent tv_rec.cpp:1518 
(HandlePendingRecordings) - TVRec(22): ASK_RECORDING 22 29 0 0
2012-05-12 19:19:59.759659 I [26047/26064] TVRecEvent tv_rec.cpp:1014 
(HandleStateChange) - TVRec(21): Changing from None to RecordingOnly
2012-05-12 19:19:59.760574 I [26047/26064] TVRecEvent tv_rec.cpp:3456 
(TuningCheckForHWChange) - TVRec(21): HW Tuner: 21->21
2012-05-12 19:20:06.344388 N [26047/26069] Scheduler autoexpire.cpp:263 
(CalcParams) - AutoExpire: CalcParams(): Max required Free Space: 3.0 GB 
w/freq: 7 min
2012-05-12 19:20:06.344451 I [26047/26069] Scheduler scheduler.cpp:2460 
(HandleRecordingStatusChange) - Tuning recording: "Britain's Got 
Talent":"The Final": channel 1003 on ca
rdid 21, sourceid 1
2012-05-12 19:20:36.633274 E [26047/26058] EIT mythdb.cpp:192 (DBError) 
- DB Error (change_program):
Query was:
UPDATE program SET starttime = ?,     endtime   = ? WHERE chanid    = ? 
AND       starttime = ?
Bindings were:
:CHANID=1081, :NEWEND=2012-05-14T13:40:00, :NEWSTART=2012-05-14T13:00:00,
:OLDSTART=2012-05-14T12:00:00
Driver error was [2/1062]:
QMYSQL3: Unable to execute statement
Database error was:
Duplicate entry '1081-2012-05-14 13:00:00-0' for key 'PRIMARY'

2012-05-12 19:21:56.285571 I [26047/26069] Scheduler scheduler.cpp:2011 
(HandleReschedule) - Reschedule requested for id -1.
2012-05-12 19:21:56.823969 I [26047/26069] Scheduler scheduler.cpp:2069 
(HandleReschedule) - Scheduled 141 items in 0.5 = 0.28 match + 0.25 place


It may or may not be related to the other problem. (I have a NOVA-TD-500 
which seems to sometimes lockup the second tuner with a hard lockup - 
requiring a reboot of my server to clear).  The "Britain's Got Talent" 
program its trying to start recording ended up being 0 bytes log (ie it 
didn't record it)

What does database failure mean? (I realise that the primary key already 
exists is what it means, what I mean is what in Mythtv terms does it mean).

-- 
Alan Chandler
http://www.chandlerfamily.org.uk