rake gitlab:geo:check does not give the actual state

While I was running an upgrade I got the feeling the command rake gitlab:geo:check did not give me the present state of FDW.

What happened:

  • I ran rake gitlab:geo:check:

    GitLab Geo tracking database Foreign Data Wrapper schema is up-to-date? ...no"

  • No problem, I just ran rake geo:db:refresh_foreign_tables
  • I ran rake gitlab:geo:check again:

    "GitLab Geo tracking database Foreign Data Wrapper schema is up-to-date? ...no"

  • I was surprised, so I didn't do anything, except for looking around
  • Suddenly I noticed the admin/geo/nodes panel showed the Geo secondary node became healthy again
  • So I ran rake gitlab:geo:check again:

    "GitLab Geo tracking database Foreign Data Wrapper schema is up-to-date? ...yes"

losing my mind