Versions Compared

Old Version 2

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

  • ??? Did A MySQL restart on 2021-05-13 cause reset this to the defaulted value to be defaulted to OFF? 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

...