{"action":"created","issue":{"url":"https://api.github.com/repos/flyway/flyway/issues/1351","repository_url":"https://api.github.com/repos/flyway/flyway","labels_url":"https://api.github.com/repos/flyway/flyway/issues/1351/labels{/name}","comments_url":"https://api.github.com/repos/flyway/flyway/issues/1351/comments","events_url":"https://api.github.com/repos/flyway/flyway/issues/1351/events","html_url":"https://github.com/flyway/flyway/issues/1351","id":162003490,"number":1351,"title":"Repair does not fix \"Migration Description mismatch\" error","user":{"login":"nathansgreen","id":342098,"avatar_url":"https://avatars.githubusercontent.com/u/342098?v=3","gravatar_id":"","url":"https://api.github.com/users/nathansgreen","html_url":"https://github.com/nathansgreen","followers_url":"https://api.github.com/users/nathansgreen/followers","following_url":"https://api.github.com/users/nathansgreen/following{/other_user}","gists_url":"https://api.github.com/users/nathansgreen/gists{/gist_id}","starred_url":"https://api.github.com/users/nathansgreen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nathansgreen/subscriptions","organizations_url":"https://api.github.com/users/nathansgreen/orgs","repos_url":"https://api.github.com/users/nathansgreen/repos","events_url":"https://api.github.com/users/nathansgreen/events{/privacy}","received_events_url":"https://api.github.com/users/nathansgreen/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/flyway/flyway/labels/c:%20repair()","name":"c: repair()","color":"346449"},{"url":"https://api.github.com/repos/flyway/flyway/labels/t:%20bug","name":"t: bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/flyway/flyway/milestones/9","html_url":"https://github.com/flyway/flyway/milestones/Flyway%204.1","labels_url":"https://api.github.com/repos/flyway/flyway/milestones/9/labels","id":1381788,"number":9,"title":"Flyway 4.1","description":"","creator":{"login":"axelfontaine","id":684824,"avatar_url":"https://avatars.githubusercontent.com/u/684824?v=3","gravatar_id":"","url":"https://api.github.com/users/axelfontaine","html_url":"https://github.com/axelfontaine","followers_url":"https://api.github.com/users/axelfontaine/followers","following_url":"https://api.github.com/users/axelfontaine/following{/other_user}","gists_url":"https://api.github.com/users/axelfontaine/gists{/gist_id}","starred_url":"https://api.github.com/users/axelfontaine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/axelfontaine/subscriptions","organizations_url":"https://api.github.com/users/axelfontaine/orgs","repos_url":"https://api.github.com/users/axelfontaine/repos","events_url":"https://api.github.com/users/axelfontaine/events{/privacy}","received_events_url":"https://api.github.com/users/axelfontaine/received_events","type":"User","site_admin":false},"open_issues":58,"closed_issues":1,"state":"open","created_at":"2015-10-28T16:32:30Z","updated_at":"2016-09-14T13:15:44Z","due_on":"2016-09-30T00:00:00Z","closed_at":null},"comments":3,"created_at":"2016-06-23T19:26:14Z","updated_at":"2016-09-21T16:13:14Z","closed_at":null,"body":"I want to avoid manually updating `schema_version`. It seems to me this is the purpose of the `repair` command, but it doesn't fix everything.\r\n\r\n###### What version of Flyway are you using?\r\n3.2.1\r\n\r\n\r\n###### What database are you using (type & version)?\r\nPostgreSQL 9.4\r\n\r\n\r\n###### What operating system are you using?\r\nOSX\r\n\r\n\r\n###### What did you do?\r\nI renamed a migration file and ran the migration process. When that failed, I ran the repair command. The error message looked like this:\r\n\r\n```\r\nFlywayException: Validate failed. Migration Description mismatch for migration 2.22.0\r\n-> Applied to database : Updates to some stuff\r\n-> Resolved locally    : Add constraints to mandatory client info\r\n\tat org.flywaydb.core.Flyway.doValidate(Flyway.java:1108)\r\n\tat org.flywaydb.core.Flyway.access$300(Flyway.java:62)\r\n\tat org.flywaydb.core.Flyway$1.execute(Flyway.java:1012)\r\n\tat org.flywaydb.core.Flyway$1.execute(Flyway.java:1006)\r\n\tat org.flywaydb.core.Flyway.execute(Flyway.java:1418)\r\n\tat org.flywaydb.core.Flyway.migrate(Flyway.java:1006)\r\n```\r\n\r\n###### What did you expect to see?\r\nI expected the repair command to fix the metadata table.\r\n\r\n\r\n###### What did you see instead?\r\nThe repair command did nothing because all the checksums matched.\r\n"},"comment":{"url":"https://api.github.com/repos/flyway/flyway/issues/comments/248662197","html_url":"https://github.com/flyway/flyway/issues/1351#issuecomment-248662197","issue_url":"https://api.github.com/repos/flyway/flyway/issues/1351","id":248662197,"user":{"login":"compwron","id":578159,"avatar_url":"https://avatars.githubusercontent.com/u/578159?v=3","gravatar_id":"","url":"https://api.github.com/users/compwron","html_url":"https://github.com/compwron","followers_url":"https://api.github.com/users/compwron/followers","following_url":"https://api.github.com/users/compwron/following{/other_user}","gists_url":"https://api.github.com/users/compwron/gists{/gist_id}","starred_url":"https://api.github.com/users/compwron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/compwron/subscriptions","organizations_url":"https://api.github.com/users/compwron/orgs","repos_url":"https://api.github.com/users/compwron/repos","events_url":"https://api.github.com/users/compwron/events{/privacy}","received_events_url":"https://api.github.com/users/compwron/received_events","type":"User","site_admin":false},"created_at":"2016-09-21T16:13:14Z","updated_at":"2016-09-21T16:13:14Z","body":"I am also having this problem. \r\n\r\nOSX 10.11.6\r\ncompile 'org.postgresql:postgresql:9.4.1209'\r\ncompile \"org.flywaydb:flyway-core:4.0.3\"\r\n\r\nrunning gradle flywayRepair does not prevent me from seeing the error \r\n\"Invocation of init method failed; nested exception is org.flywaydb.core.api.FlywayException: Validate failed: Migration checksum mismatch for migration\""}}
{"actor":{"display_login":"compwron"}}