mysql on Mac throws error migrating DB with indexname 'Idx_lastChanged' vs 'Idx_LastChanged'


When upgrading Zanata in mysql 5.6, liquibase throws error due to same index name 'Idx_lastChanged' which exists in changelog-3.4 and changelog-3.7




Sean Flanigan
September 29, 2015, 3:39 PM

I think the problem is that HTextFlowTarget has an index named "Idx_LastChanged", but now HTextFlowTargetHistory wants an index "Idx_lastChanged" (note the lower case "L").

So the problem will probably only appear in environments where mysql is configured to be case-insensitive.

I'm not sure if the version of mysql really comes into it.

Sean Flanigan
September 29, 2015, 3:39 PM

if you hit the error again, could you please post the error message against this bug?

Sean Flanigan
September 29, 2015, 5:17 PM

I have done some tests with case insensitive mode (lower_case_table_names=1) on mysql 5.6, but I wasn't able to reproduce the problem with index names. I think it only happens with lower_case_table_names=2 (the default on Mac), and perhaps only when importing a database from a system which uses a different value for lower_case_table_names.

If it happens again, the workaround is probably to set mysql's system variable lower_case_table_names=1 in my.cnf, which is the recommended setting when using InnoDB tables.

Luke Brooker
September 30, 2015, 9:08 AM


On Tue, Sep 29, 2015 at 3:40 PM, Sean Flanigan (JIRA) <

Alex Eng
April 20, 2018, 10:23 AM

We are closing all the old issues to have more clarity in our backlog for Zanata project. Feel free to re-open or leave a comment if you require our attention on your Jira.

Not Applicable




Alex Eng


Tested Version/s


Fix versions

Affects versions