I urgently need some help - I did an upgrade from /admin/upgrade today, but the process never finished. I then restarted Discourse and tried a ./launcher rebuild app from the command line, but I keep getting the following error:
SET first_unread_at = u.created_at FROM users u WHERE u.id = us.user_id rake aborted! StandardError: An error has occurred, all later migrations canceled: Index name 'index_topics_on_updated_at_public' on table 'topics' already exists
The problem remains after disabling all plugins.
Our site is down right now, I’d appreciate some help to diagnose and fix this. Thanks!
Update: I found that I could restart Discourse with
./launcher start app, but I’m not entirely sure of the current state of my instance.
Update: After starting the app, I went into psql and deleted the index that was mentioned in the error. After a rebuild, the exact same error came up again.