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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
