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. 
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