[mythtv-users] tv playback woes

[Michael T. Dean]

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