MySQL - MyISAM to InnoDB? MySQL server has gone away ]

From: Schultz, Eric [mailto:ESchultz@corp.untd.com]

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Jesse Vincent

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.

Do the db-upgrade scripts switch the RT tables to InnoDB, which the wiki
says is required for later versions of RT…?

Tia
Lee

From: Schultz, Eric [mailto:ESchultz@corp.untd.com]

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf
Of Jesse Vincent

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.

Do the db-upgrade scripts switch the RT tables to InnoDB, which the wiki
says is required for later versions of RT…?
No, scripts don’t do that because that requirement exists since RT 3.0

Tia
Lee

Best regards, Ruslan.