[mythtv] Trunk - attempting to insert recordings into the DB multiple times?

[Nate Carlson]

Hey all,

I upgraded to trunk (r26320) last night; for the most part it's been 
clean, but I'm noticing some duplicate SQL queries that seem kind of odd. 
Figured I'd ask here before posting a ticket, in case it's a known issue 
and/or I'm acting like a noob.  ;)

Here's my basic backend setup, just fyi..:

mythbackend1  (Master backend, no tuners. Also running MySQL.)
mythrecord1   (Slave backend, tuners below)
   Tuner 1 - PVR-500 1; first tuner, analog cable
   Tuner 2 - PVR-500 1; second tuner, analog cable
   Tuner 3 - PVR-500 2, first tuner, analog cable
   Tuner 4 - PVR-500 2, second tuner, analog cable
   Tuner 5 - HD-PVR connected to cable box; FireWire channel changing
fs            (Slave backend, tuners below)
   Tuner 1 - HDHR 1 tuner 1, antenna
   Tuner 2 - HDHR 1 tuner 2, antenna
   Tuner 3 - HDHR 2 tuner 1, antenna
   Tuner 4 - HDHR 2 tuner 2, antenna

This morning, a recording started on one of the PVR-500 tuners.. it is the 
only recording scheduled at this time. When the recording started, the 
backend logs (normal log level) showed three duplicate insert errors for 
the recording.. could just be a coincidence, but that does match up to the 
number of analog tuners that are mapped to the same channel group.

There haven't been any other analog recordings since I made the switch to 
trunk, but I will watch and see if this repeats itself.. the logs are 
below; this is from monkey tail, the 'RECORD1:' in front of each line is 
just identifying which box the message is coming from.  ;)

Appreciate any thoughts!

-n

[log:]
RECORD1:2010-09-16 11:28:27.795 TVRec(4): ASK_RECORDING 4 29 0 0
RECORD1:2010-09-16 11:28:59.489 TVRec(4): Changing from None to RecordingOnly
RECORD1:2010-09-16 11:28:59.491 TVRec(4): HW Tuner: 4->4
RECORD1:2010-09-16 11:28:59.666 TVRec(4): rec->GetPathname(): '/export/MythTV_TV_3/1032_20100916112900.mpg'
RECORD1:2010-09-16 11:29:00.565 FindPSKeyFrames: frame rate = 29970
RECORD1:2010-09-16 11:29:26.902 MainServer::ANN Playback
RECORD1:2010-09-16 11:29:26.903 adding: fs as a client (events: 0)
RECORD1:2010-09-16 11:29:26.904 RecBase(4:/dev/video-ivtv1): GetKeyframePositions(706,9223372036854775807,#5) out of 53
RECORD1:2010-09-16 11:32:19.729 FindPSKeyFrames: frame rate = 23796
RECORD1:2010-09-16 11:32:19.772 DB Error (Resolution insert):
RECORD1:Query was:
RECORD1:INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
RECORD1:Bindings were:
RECORD1::CHANID=1032, :DATA=720, :MARK=5973, :STARTTIME=2010-09-16T11:29:00, :TYPE=30
RECORD1:Driver error was [2/1062]:
RECORD1:QMYSQL3: Unable to execute statement
RECORD1:Database error was:
RECORD1:Duplicate entry '1032-2010-09-16 11:29:00-30-5973' for key 'PRIMARY'
RECORD1:
RECORD1:2010-09-16 11:32:19.774 DB Error (Resolution insert):
RECORD1:Query was:
RECORD1:INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
RECORD1:Bindings were:
RECORD1::CHANID=1032, :DATA=480, :MARK=5973, :STARTTIME=2010-09-16T11:29:00, :TYPE=31
RECORD1:Driver error was [2/1062]:
RECORD1:QMYSQL3: Unable to execute statement
RECORD1:Database error was:
RECORD1:Duplicate entry '1032-2010-09-16 11:29:00-31-5973' for key 'PRIMARY'
RECORD1:
RECORD1:2010-09-16 11:32:19.774 FindPSKeyFrames: frame rate = 29970
RECORD1:2010-09-16 11:32:19.775 DB Error (Frame rate insert):
RECORD1:Query was:
RECORD1:INSERT INTO recordedmarkup    (chanid, starttime, mark, type, data)    VALUES ( ?, ?, ?, ?, ?);
RECORD1:Bindings were:
RECORD1::CHANID=1032, :DATA=29970, :MARK=5973, :STARTTIME=2010-09-16T11:29:00, :TYPE=32
RECORD1:Driver error was [2/1062]:
RECORD1:QMYSQL3: Unable to execute statement
RECORD1:Database error was:
RECORD1:Duplicate entry '1032-2010-09-16 11:29:00-32-5973' for key 'PRIMARY'