Is this a sign of troubles with RT database?

RT Users
1

Basics:

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:

Aug 11 10:35:46 ns2 RT: DBD::mysql::db rollback failed: Warning: Some
non-transactional changed tables couldn’t be rolled back at /usr
/local/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line
644. (/opt/rt3/lib/RT.pm:250)
Aug 11 10:36:37 ns2 RT: DBD::mysql::db rollback failed: Warning: Some
non-transactional changed tables couldn’t be rolled back at /usr
/local/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line
644. (/opt/rt3/lib/RT.pm:250)
Aug 11 10:38:06 ns2 RT: DBD::mysql::db rollback failed: Warning: Some
non-transactional changed tables couldn’t be rolled back at /usr
/local/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line
644. (/opt/rt3/lib/RT.pm:250)
Aug 11 10:40:37 ns2 RT: DBD::mysql::db rollback failed: Warning: Some
non-transactional changed tables couldn’t be rolled back at /usr
/local/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm line
644. (/opt/rt3/lib/RT.pm:250)

Could that be a sign of impending trouble?

    cheers
   - wash

Odhiambo Washington . WANANCHI ONLINE LTD (Nairobi, KE) |
. 1ere Etage, Loita Hse, Loita St., |
GSM: (+254) 722 743 223 . # 10286, 00100 NAIROBI |
GSM: (+254) 733 744 121 . (+254) 020 313 985 - 9 |
“Oh My God! They killed init! You Bastards!”
–from a /. post

2

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