[mythtv] EIT scanner crashes mythbackend

[Janne Grunau]

On Monday 22 January 2007 15:24, Matt Jarvis wrote:
> Will try the patch and report to the list.

Thanks.

> Here is the exact sql error ( there have been many of them so this is
> just an example )
>
> 2007-01-22 14:02:37.262 DB Error (change_program):
> Query was:
> UPDATE program SET starttime = '2007-01-27T00:00:00',     endtime   =
> '2007-01-30T02:55:00' WHERE chanid    = 1702 AND       starttime =
> '2007-01-26T22:55:00'
> Driver error was [2/1062]:
> QMYSQL3: Unable to execute query
> Database error was:
> Duplicate entry '1702-2007-01-27 00:00:00-0' for key 1
>
> Yes, I have three DVB cards.

Then it's no real problem and deleting the program table has solved it 
only by pure luck (and a backend restart). This error can occur then 
more than one card scans the same program. It will be fixed as soon as 
the eit scanner gets smarter.

> I have checked the aerial, it doesn't 
> look like it has shifted but I will double check.

Do you have a free line of sight to the transmitter? Air humidity and 
rain have also influence on the reception but I doubt that the effect 
is large enough to cause your problems.

Janne