[rt-users] Is this a sign of troubles with RT database?

Alex Vandiver alexmv at bestpractical.com
Wed Aug 11 05:31:06 EDT 2004


On Wed, 2004-08-11 at 03:47, Odhiambo Washington wrote: 
> rt-3.2.1, apache-1.3.31, mod_perl1, MySQL- 3.23.58
> I am seeing the following in my log file - /var/log/messages:
> [snip] Could that be a sign of impending trouble?
Almost certainly; your tables are probably not InnoDB tables, and hence
are non-transactional.  This will cause you pain.  You will want to
either ensure your old 3.23 MySQL is built with InnoDB support[1], or
upgrade to MySQL 4.0.x (which RT is actually supported running under). 
You'll then want to go about upgrading all of those tables you have from
MyISAM to InnoDB[2], or just doing a reinstall of RT.
  I'm curious though, as RT 3.2.1's install should be checking to make
sure you have InnoDB support -- was this an upgrade or something?
- Alex

[1] http://dev.mysql.com/doc/mysql/en/InnoDB_in_MySQL_3.23.html
[2] http://dev.mysql.com/doc/mysql/en/Converting_tables_to_InnoDB.html

-- 
Networking -- one letter away from not working



More information about the rt-users mailing list