[mythtv] [mythtv-commits] Ticket #2342: EIT Data update fials due to duplicate keys
Janne Grunau
janne-mythtv at grunau.be
Fri Sep 8 10:34:47 UTC 2006
On Friday 08 September 2006 11:04, MythTV wrote:
> #2342: EIT Data update fials due to duplicate keys
>
> 2006-09-07 13:39:09.063 DB Error (change_program):
> Query was:
> UPDATE program SET starttime = '2006-09-10T01:32:00', endtime
> = '2006-09-10T02:00:00' WHERE chanid = 1717 AND starttime =
> '2006- 09-10T01:00:00'
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1717-2006-09-10 01:32:00-0' for key 1
>
> it appears that the database is ok - ran all the checks I could.
>
> I think the issue is that there is a program already in the program
> table for this time and channel, which will need deleting first else
> the primary key constraint is broken on the DB.
>
> Its an easy fix I think,
It's a bug in the current implementation. We search and delete
overlapping programs. I'm not sure if it's an error in the matching and
delete code or if it is caused by multiple eitscanners listening for
the same chanids. Even if it's the second locking the program table is
a bad solution.
The eitscanner changes in my queue will handle this situation in a
better way.
For the grabber-EIT-integration we have find a different solution.
Janne
More information about the mythtv-dev
mailing list