Geo - The Geo nodes admin page display secondary database state incorrectly
On the Geo nodes admin page, the status screen for a Geo secondary node shows:
However, running the query on Rails console looks fine. Notice pg_is_in_recovery
has the right value:
[1] pry(main)> ActiveRecord::Base.connection.execute('SELECT pg_is_in_recovery()').first
(0.4ms) SELECT pg_is_in_recovery()
=> {"pg_is_in_recovery"=>true}
It looks like this is a regression due to the upgrade to Rails 5. We check if the query returns the string t
, but now this query returns true
or false
.