[mythtv] EIT scanner crashes mythbackend

Matt Jarvis matt at mattandkirsty.org.uk
Mon Jan 22 14:24:20 UTC 2007


Will try the patch and report to the list.

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. I have checked the aerial, it doesn't look
like it has shifted but I will double check.

> On Monday 22 January 2007 12:12, Matt Jarvis wrote:
>> Hi
>>
>> I upgraded to 20-fixes about a month ago, and everything has been
>> working perfectly, my server had 40 days uptime and no problems
>> whatsoever. In the last few days, as anyone in the UK knows, we have
>> had extremely bad weather, and since then the EIT scanner has now
>> started crashing my backend about 4 times a day, always after getting
>> a 'pes packet but !payload start' in the logs.
>
> Please rebuild with foolowing patch:
> http://svn.mythtv.org/trac/attachment/ticket/2664/r12480_backported.diff
>
>> I was also
>> experiencing some problems with the QMYSQL driver reporting errors
>> due to duplicate entries.
>
> Have you more than one DVB card? The exact error message would be
> useful.
>
>> but I'm still seeing the crashes after PES packets. I've looked back
>> through both lists and not seeing anyone reporting similar problems
>> in the UK in the last few days. Does anyone have any ideas why this
>> might have started happening ?
>
> Bad reception, Your arial was maybe swiveled by the storm.
>
> Janne
>
> ______________________________________________
> This email has been scanned by Netintelligence
> http://www.netintelligence.com/email
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



More information about the mythtv-dev mailing list