Duplicate key name 'FK98293BFB217F5972'

[jmiranda]

From Tan Li

I have the following errors when doing "grails run-app" under v.8.0 source code to start the app. Any suggestion?

ERROR context.GrailsContextLoader  - Error executing bootstraps: liquibase.exception.MigrationFailedException: Migration failed for change set 0.5.x/ad
d-product-synonyms.xml::1383077886142-3::jmiranda (generated):
     Reason: liquibase.exception.JDBCException: Error executing SQL CREATE INDEX `FK98293BFB217F5972` ON `openboxes_dev`.`synonym`(`created_by_id`):
          Caused By: Error executing SQL CREATE INDEX `FK98293BFB217F5972` ON `openboxes_dev`.`synonym`(`created_by_id`):
          Caused By: Duplicate key name 'FK98293BFB217F5972'
org.codehaus.groovy.runtime.InvokerInvocationException: liquibase.exception.MigrationFailedException: Migration failed for change set 0.5.x/add-product-synonyms.xml::1383077886142-3:
:jmiranda (generated):
     Reason: liquibase.exception.JDBCException: Error executing SQL CREATE INDEX `FK98293BFB217F5972` ON `openboxes_dev`.`synonym`(`created_by_id`):
          Caused By: Error executing SQL CREATE INDEX `FK98293BFB217F5972` ON `openboxes_dev`.`synonym`(`created_by_id`):
          Caused By: Duplicate key name 'FK98293BFB217F5972'

[jmiranda]

This is caused because the index / foreign key constraint already exist (perhaps because the dbCreate attribute on the data source is set to "update", which would be bad).

We can guard against this by adding a preCondition to check if the index / foreign key constriant already exists, but until recently I was convinced that the foreignKeyConstraintExists precondition did not work in Liquibase 1.9.x. I seem to have been mistaken as it's been working for me over the past few weeks (maybe a MySQL version issue?).