[rt-users] MySQL server has gone away

[Schultz, Eric]

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com 
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf 
> Of Jesse Vincent
> Sent: Thursday, January 26, 2006 7:00 AM
> To: Goddard Lee
> Cc: rt-users
> Subject: Re: [rt-users] MySQL server has gone away
> 
> 
> 
> 
> On Thu, Jan 26, 2006 at 03:58:47PM +0100, Goddard Lee wrote:
> > > On Thu, Jan 26, 2006 at 03:29:06PM +0100, Goddard Lee wrote:
> > > > FWIW, if anyone has the time, here is the log of posting an 
> > > e-mail to 
> > > > RT 3.4.5, which worked in RT 3.4.4. I took a few days 
> off work, and 
> > > > assume that nothing else in the config has changed in that time:
> > > 
> > > What's in your mysql error log? Are you maybe submitting 
> > > something big enough to overflow mysql's max_packet?
> > 
> > Thanks for reading. As far as I can see, it's just:
> > 
> > Version: '4.1.9-standard'  socket: 
> '/var/lib/mysql/mysql.sock'  port:
> > 3306  Official MySQL RPM
> > 060126 10:55:55 [ERROR] /usr/sbin/mysqld: Got error 127 
> from storage engine
> > 060126 10:55:55 [ERROR] /usr/sbin/mysqld: Sort aborted (END)
> 
> 
> That does seem pretty finger-pointing. Do you perhaps have mysql
> corruption? But I'd try to dig into that error 127.

>From a box with mysql client/server on it:

bl-devel: ~ % perror 127
Error code 127:  Unknown error 127
127 = Record-file is crashed

Looks like you need to do some table repair.