[mythtv-users] recordedseek table crashing regularly, still

David Brodbeck gull at gull.us
Wed Feb 20 22:17:46 UTC 2008

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.

If that doesn't work, I'd try a different MySQL version to see if  
maybe the version you're running is particularly buggy.  You could  
also try a different database engine (like InnoDB instead of MYD) and  
see if it makes a difference.  Obviously you'd want to back up your  
database before doing this.

More information about the mythtv-users mailing list