Can't alter table: attachments

I successfully changed all my rt tables, except attachments to innodb.
I’m running mysql 4.0.24 and this is what happens:

ALTER TABLE Attachments TYPE = innodb

#1214 - The used table type doesn’t support FULLTEXT indexes

Also, i get these in my logs (since Attachments is in myisam format);

Jun 17 08:05:42 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:06:14 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:17:09 opteron-prime rsyncd[8387]: name lookup failed for
192.168.255.91: Name or service not known
Jun 17 08:33:06 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:36:54 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:37:08 opteron-prime rsyncd[8566]: name lookup failed for
192.168.255.91: Name or service not known
Jun 17 08:40:29 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:41:53 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:41:57 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:42:20 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)
Jun 17 08:52:58 opteron-prime RT: DBD::mysql::db rollback failed:
Warning: Some non-transactional changed tables couldn’t be rolled back
at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 721.
(/usr/share/request-tracker3.4/lib/RT.pm:277)

tia!

– Tom

Tom Vier wrote:

ALTER TABLE Attachments TYPE = innodb

#1214 - The used table type doesn’t support FULLTEXT indexes

Do you have some kind of locally installed index on the Attachments table?

Phil Homewood wrote:

#1214 - The used table type doesn’t support FULLTEXT indexes
Do you have some kind of locally installed index on the Attachments table?

Apparently rt set some up, at some point, and some are duplicates. I
should be able to delete them, convert to innodb, then recreate the
indexes, right?

Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 8497 Edit Drop id
Attachments1 INDEX 944 Edit Drop Parent
Attachments2 INDEX 8497 Edit Drop TransactionId
Attachments3 INDEX 8497 Edit Drop Parent
TransactionId
Content FULLTEXT 8497 Edit Drop Content
Content_2 FULLTEXT 8497 Edit Drop Content
Content_3 FULLTEXT 8497 Edit Drop Content
Content_4 FULLTEXT 8497 Edit Drop Content
Content_5 FULLTEXT 8497 Edit Drop Content
Content_6 FULLTEXT 8497 Edit Drop Content

  • Tom