Hi,
I am using rt50-5.0.8 with MySQL 8.0.
I attempted to move rt database from dedicated standalone MySQL instance to group-replicated InnoDB cluster, but rt wouldn’t start, throws the following error:
[76331] [Tue Mar 17 07:07:56 2026] [warning]: DBD::mysql::st execute failed: Table 'example_rt.Users' doesn't exist at /usr/local/lib/perl5/site_perl/DBIx/SearchBuilder/Handle.pm line 622. (/usr/local/lib/perl5/site_perl/DBIx/SearchBuilder/Handle.pm:622)
[76331] [Tue Mar 17 07:07:56 2026] [warning]: RT::Handle=HASH(0x1af0435d0df8) couldn't execute the query 'SELECT * FROM `Users` WHERE Name = ?' at /usr/local/lib/perl5/site_perl/DBIx/SearchBuilder/Handle.pm line 635.
The problem appears to be related to different MySQL settings for lower_case_table_names:
- standalone: lower_case_table_names=1
- innodb cluster: lower_case_table_names=0
Both uppercase and lowercase table can be queried on Standalone:
- SELECT * FROM Users - fine
- SELECT * FROM users - fine
Only lowercase table can be queried on InnoDB cluster:
- SELECT * FROM Users - table does not exist
- SELECT * FROM users - fine
Is there a way to make RT work with lower case table names?
Thank you in advance,