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
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.
if you hit the error again, could you please post the error message against this bug?
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.
On Tue, Sep 29, 2015 at 3:40 PM, Sean Flanigan (JIRA) <
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.