Probably #Prosody has some problems related to Message Archive Management (including MUCs), my #XMPP server is facing some issues and downtime...
pimux.de/blog/pimux-de-is-faci…
But I am confident I can improve or even fix this 🙂 My monitoring already alerted me a few times but a friendly user told me about the issues, too. That shows me this is a serious problem and I have to do something!
pimux.de is facing some connectivity issues | pimux.de
Grav is an easy to use, yet powerful, open source flat-file CMSpimux.de
Prosody IM
in reply to Finn • • •Community and discussion channels – Prosody IM
prosody.imFinn
in reply to Prosody IM • • •Finn
in reply to Prosody IM • • •@prosodyim I quickly got help, thank you!
There was one user with 131 million records in the prosodyarchive table, perhaps a spam account or a accidental loop as someone/you (?) has mentioned.
Deleting that account and after that doing a VACUUM took about 40 minutes and freed up about 158 GB of space.