Error displaying Top Referred Topics

After updating Discourse, the following error appears in the dashboard in Top Referred Topics section:
Sorry, an error occurred while executing the query

The error is also explained in the log as follows:
Error while computing report top_referred_topics: PG::ReadOnlySqlTransaction: ERROR: cannot execute UPDATE in a read-only transaction /var/www/discourse/vendor/bundle/ruby/3.3.0/gems/rack-mini-pro

1 Like

Did you upgrade from the Admin panel?

If so, I would try rebuilding through the console; it fixes most of the problems.
I upgraded an instance, and I’m unable to reproduce it. :thinking:

Might be related to DEV: Convert `AdminReport` component to gjs by martin-brennan · Pull Request #31011 · discourse/discourse · GitHub.

1 Like

hi @Arkshine
I upgraded from the Admin panel and then ran ./launcher rebuild app, but the problem still exists.

1 Like