[mythtv-users] recordedseek table crashing regularly, still

[Michael T. Dean]

On 02/20/2008 05:17 PM, David Brodbeck wrote:
> On Feb 20, 2008, at 1:59 AM, Hamish Moffatt wrote:
>
>   
>> I have MythTV 0.20.2 and MySQL 5.0.51. The recordedseek table is  
>> getting
>> corrupted regularly, at least twice a week.
>>
>> I used to have a combined backend/frontend/MySQL server running 32-bit
>> linux single core. This worked fine. Then I moved the frontend to a
>> separate 64-bit dual core machine and all was fine.
>>
>> Then I moved the backend/SQL server to a different machine, 64-bit  
>> dual
>> core, and the problems started.
>>
>> Clearly it's a MySQL bug rather than a MythTV bug, but I'd welcome any
>> advice. The system is otherwise stable.
>>     
> Even though the system is otherwise stable, I'd start by checking for  
> memory problems with something like MEMTEST-86+.  Sometimes they only  
> crop up in programs that have particular access patterns -- for  
> example, I had one machine that seemed stable except kernel compiles  
> would consistently fail.  It turned out to have bad cache RAM.

Also could be I/O issues (including I/O wait or hardware-related I/O
issues)...

Mike