Versions Compared

Old Version 1

changes.mady.by.user Andy Dingley

Saved on

compared with

New Version Current

changes.mady.by.user Joseph (Pepe) Kelly

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Date

Authors

Andy Dingley

Status

DocumentingDone

Summary

NIMDTA reference service could not start

Impact

TIS NIMDTA unavailable

...

  • Flyway migration validation failed due to a lack of permissions to create a trigger.

  • Global variable log_bin_trust_function_creators on NIMDTA production database was set to OFF instead of ON???

  • A MySQL restart on 2021-05-13 reset this to the defaulted value OFF and it is not clear whether this was manually changed

...

Action Items

Action Items

Owner

Ensure any restart/automated process (ansible) sets log_bin_trust_function_creators correctly

Joseph (Pepe) Kelly

Document how to investigate Flyway migration issues.

Andy Dingley

...