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

[Kenneth Marshall]

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: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>