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.
@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.
@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
bonifartius 𒂼𒄄
@dcc@annihilation.social
@bonifartius@qoto.org
I'm gonna try that if I can't fix the error.
cc @parker@pl.psion.co @tedb@gigaohm.bio
@Matty@nicecrew.digital @dcc@annihilation.social
