When to use flyway repair?

• 
  Hello virajb,
  
  Thank you for the question. Your understanding is indeed correct, it should be invoked as needed, not as a matter of course. There are multiple reasons for this.
  
  As you highlighted, the safety net of checksum changes, in the current configuration, someone could essentially make silent modifications and were this then later run against a new environment, you would have disparate results.
  
  Showing failed migrations is particularly desirable if you have multiple people contributing as it will highlight existing issues, making it easier to avoid compounding them.
  
  Lastly, something often missed is that repair is a targetted command just like migrate. So if the locations were to change in your pipeline for migrate alone, the unmodified repair command would then most likely not do what you were intending and on the next run, remove all the applied migration that it couldn't resolve.
  (source)
  
  The intention of repair should effectively be 'maintenance mode' in the event manual intervention is required.

  Peter_Laws November 28, 2023 15:51

  - 0 +
• 
  Thanks for clarification Peter !

  virajb November 30, 2023 09:48

  - 0 +
• 
  My pleasure virajb, if our answers are helpful please consider marking them as an accepted answer, to help others members of the community find useful information.
  
  Have a good week.

  Peter_Laws December 01, 2023 09:25

  - 0 +
• 
  I can't find a way to mark it as accepted.

  virajb December 01, 2023 09:28

  - 0 +
• 
  It shouldn't be that hard to find it. Can't find anything apart from agree and like buttons. 
  Screenshot
  
  
  
  

  virajb December 01, 2023 10:44

  - 0 +
• 
  I've just noticed your post was marked as a discussion rather than a question, I've just altered it.
  Do you now have the option to mark it as answered? You may need to refresh.

  Peter_Laws December 01, 2023 11:15

  - 0 +

Add comment

Please sign in to leave a comment.