Federation Tab not working after upgrade to 2.9.0

[CherryKitten]

Expected behaviour

When I click on "Federation" the page listing federating and blocked instances should appear.

Actual behaviour

The "We're sorry, but something went wrong on our end. "-Error appears.

Steps to reproduce the problem

1. Log into Mastodon instance where you are moderator or admin
2. Go to Settings
3. Go to Moderation
4. Go to Federation

Specifications

The Error started just after upgrading to v2.9.0, it was tested on Firefox 67.0 on OSX Mojave and Safari on iOS 12

This is the output of journalctl -u mastodon-web:

Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [fff0ee42-80b4-49d7-9dbf-1f801d884fa9] method=GET path=/poco format=*/* controller=ApplicationController action=raise_not_found status=404 durati
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [c73a5a64-4838-450e-bd9f-1822fd003e76] method=GET path=/ format=*/* controller=HomeController action=index status=302 duration=2.55 view=0.00 db=
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b] method=GET path=/about format=*/* controller=AboutController action=show status=500 error='ActionView::Tem
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: LINE 1: ...count_stats"."account_id" = "accounts"."id" WHERE "accounts"...
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]:                                                              ^
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: HINT:  Perhaps you meant to reference the column "accounts.suspended_at".
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: : SELECT  "accounts".* FROM "accounts" INNER JOIN "account_stats" ON "account_stats"."account_id" = "accounts"."id" WHERE "accounts"."suspended"
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b] ActionView::Template::Error (PG::UndefinedColumn: ERROR:  column accounts.suspended does not exist
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: LINE 1: ...count_stats"."account_id" = "accounts"."id" WHERE "accounts"...
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]:                                                              ^
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: HINT:  Perhaps you meant to reference the column "accounts.suspended_at".
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: : SELECT  "accounts".* FROM "accounts" INNER JOIN "account_stats" ON "account_stats"."account_id" = "accounts"."id" WHERE "accounts"."suspended"
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     26:                 %small= t('about.browse_directory')
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     27:
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     28:               .avatar-stack
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     29:                 - @instance_presenter.sample_accounts.each do |account|
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     30:                   = image_tag current_account&.user&.setting_auto_play_gif ? account.avatar_origin
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     31:
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]     32:         - if Setting.timeline_preview
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b]
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b] app/views/about/show.html.haml:29:in `block in _app_views_about_show_html_haml__4030298887702380781_698755
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b] app/helpers/home_helper.rb:62:in `optional_link_to'
Jun 16 23:22:06 Ubuntu-1804-bionic-64-minimal bundle[766]: [b5796385-535b-49cc-b5d6-a758df0aaf1b] app/views/about/show.html.haml:22:in `_app_views_about_show_html_haml__4030298887702380781_69875505514520'

[CherryKitten]

Okay, of course I find the mistake right after posting the issue.

I forgot to clear the cache after updating.

Executing RAILS_ENV=production bin/tootctl cache clear as user mastodon while in /home/mastodon/live fixed the problem.

Sorry.

[bbqrob]

Oct 14 08:46:24 rs130726 bundle[293911]: I, [2023-10-14T08:46:24.410785 #293911]  INFO -- : [4c8d2b79-643c-4b1b-b035-0143e7e9de8a] method=GET path=/admin/instances format=html controller=Admin::InstancesController action=index status=500 allocations=2973 duration=14.46 view=0.00 db=3.90
Oct 14 08:46:24 rs130726 bundle[293911]: [4c8d2b79-643c-4b1b-b035-0143e7e9de8a] ActiveRecord::StatementInvalid (PG::ObjectNotInPrerequisiteState: ERROR:  materialized view "instances" has not been populated
Oct 14 08:46:24 rs130726 bundle[293911]: HINT:  Use the REFRESH MATERIALIZED VIEW command.

here, when accessing /admin/instances?limited=1. Login into postgresql and ran REFRESH MATERIALIZED VIEW instances; helped a lot.