My matrix is borked, synapse has had a good run.
I believe I can still receive messages but sending them won't work....either way after some troubleshooting I may consider just starting a new instance alltogether.

Did you stick it behind CF?

@matty@nicecrew.digital nope

Anything neat in the error log?

@matty@nicecrew.digital
I'm getting:
psycopg2.errors.UndefinedTable: relation "event_txn_id_device_id" does not exist
when I try to send messages.
Nothing useful seems to be in the issues, I know I had to run a script from the issues that was preventing me from upgrading a few versions back, this time when I tried moving to 1.92 (docker container) from 1.89 (intermediate steps won't work) it is now stuck not working.

@gabriel @matty >relation "event_txn_id_device_id"
Hmmm, maybe that table is gone.

@dcc@annihilation.social
For sure, I'm assuming I'll have to dig up what query I need to rebuild that table, if that's even going to work.
Truthfully, I wouldn't lose much starting fresh which is why I'm considering it. I would like to repair the db because the instance is running on the root domain (which I like) but I also want to do a lot of pruning eventually anyways.
@matty@nicecrew.digital

@gabriel @Matty @dcc as long as you keep the instance keys backuped you should be able to reuse the domain iirc