[rt-users] sessions table is lost after a system crash

[Tim Cutts]

On 12 Apr 2009, at 11:51 am, Asif Iqbal wrote:

> mysqlcheck says this btw,
>
> [..all OK..]
> rt3.Users                                          OK
> rt3.sessions
> warning  : Table is marked as crashed and last repair failed
> warning  : 9 clients are using or haven't closed the table properly
> warning  : Size of indexfile is: 12666880      Should be: 1024
> error    : Found too long record at 82812800
> error    : Corrupt
>

This happened to me the other day when the VM running our RT fell  
over.  I shut down the web interface, shut down mysql, and then used  
myisamchk to repair the table:

myisamchk --max-record-length=1000000 --safe-recover /var/lib/mysql/ 
rtdb/sessions.MYI

I then restarted the database and apache, and all was well.

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.