[mythtv-users] tv playback woes

[Chris Rouch]

On 18 August 2011 18:28, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> On 08/18/2011 11:32 AM, Chris Porter wrote:
>> On Thu, Aug 18, 2011 at 7:25 AM, Chris Rouch wrote:
>>> The backend isn't entirely normal. There are lots of entries like this
>>> (also when there are no playback problems):
>>>
>>>
>>> 2011-08-17 23:02:49.685 DB Error (delta position map insert):
>>> Query was:
>>> INSERT INTO recordedseek (chanid, starttime, mark, type, offset)
>>> VALUES ( ? , ? , ? , ? , ? )
>>> Bindings were:
>>> :CHANID=105, :MARK=114024, :OFFSET=2028720862,
>>> :STARTTIME=2011-08-17T21:30:00,
>>> :TYPE=9
>>> Driver error was [2/1062]:
>>> QMYSQL3: Unable to execute statement
>>> Database error was:
>>> Duplicate entry '105-2011-08-17 21:30:00-9-114024' for key 1
>> For the backend errors I suggest you look at the wiki and perform a database
>> repair and optimization daily.
>> http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance#Optimize_the_Database
>
> And make sure you're running the most-current 0.24-fixes.  This was
> fixed, recently.
>
> Mike
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>

Thanks for the replies. I have a daily cron job running

/usr/share/doc/mythtv-docs-0.24.1/contrib/maintenance/optimize_mythdb.pl.

I'll make sure I have the latest fixes and see what happens. When it
happened last night, I logged onto the backend and saw the load
average was at 3, though this soon reduced to 0.5 or so, while the
front end started again. Without watching the load instead of watching
tv I'm not sure how to find out what is making it busy.

Regards,

Chris