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

Description

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

Environment

None

Activity

Show:
Sean Flanigan
September 29, 2015, 5:39 AM

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, 5:39 AM

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

Sean Flanigan
September 29, 2015, 7:17 AM

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 29, 2015, 11:08 PM

Sure.

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

Alex Eng
April 20, 2018, 12: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

Assignee

Unassigned

Reporter

Alex Eng

Labels

Tested Version/s

None

Fix versions

Affects versions

Priority

unspecified
Configure