Tim, I am curious. Are you using InnoDB tables or MyISAM tables? I thought that RT needed InnoDB. Does it have a problem with system crashes and recovery with InnoDB?
Just wondering. Ken On Thu, Apr 23, 2009 at 06:31:10PM +0100, Tim Cutts wrote: > > 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 > _______________________________________________ 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
