[mythtv-users] Duplicate entry for key PRIMARY in recordedmarkup
Bill Meek
keemllib at gmail.com
Fri Mar 4 22:00:28 UTC 2011
On Fri, 2011-03-04 at 11:02 -0500, Michael T. Dean wrote:
> On 03/04/2011 08:32 AM, Khanh Tran wrote:
> > I upgraded to .24-fixes a few weeks ago and I'm starting to see the
> > following database errors after some recordings.
...
> > Duplicate entry '2030-2011-03-04 08:00:00-30-28215' for key
> 'PRIMARY'
...
> The only ways I could see this happening is if you have duplicate
> channel IDs, which is only possible if your channel table is broken,
> or if for some reason there are actually 2 recorders writing the same
> file (which shouldn't be possible--and the code to prevent such
> hasn't changed in a /very/ long time.)
Khanh Tran, thanks for bringing this up and Mike for the detail.
I have 136 of these in my logs from 8-25-2010 [trunk at 25815] to today
[v0.25pre-1317-g624c23c].
All of them are on my Hauppauge HVR-1600's analog tuner which is
connected to my STB (Motorola DCT-700.) Channel IDs 2xxx.
The digital side of the HVR-1600 and the 2 halves of an HVR-2250
are used for over the air recording. Channel IDs 1xxx.
Most errors appear in pairs like:
Duplicate entry '2117-2011-01-18 22:01:00-30-46214' for key 'PRIMARY'
Duplicate entry '2117-2011-01-18 22:01:00-31-46214' for key 'PRIMARY'
and all but 2 are type 30 & 31 (MARK_VIDEO_WIDTH & MARK_VIDEO_HEIGHT.)
The 2 odd ones are type 11 (MARK_ASPECT_4_3.)
I only looked at the most recent 3 cases where the recording would still
be on disk, but is isn't. That's because the recordings had no audio and
I deleted them and asked for MythTV to rerecord.
I'd never tied these errors to my missing audio recordings.
Does this look like a valid MythTV case, I'd be happy to collect more
data and open a ticket.
Bill
More information about the mythtv-users
mailing list