Communities • Migration to PostgreSQL, pubsub table errors

chevron_right

Migration to PostgreSQL, pubsub table errors

admin · pubsub.chatterboxtown.us / chatterboxtown-us-news-and-announcements · Friday, 20 November, 2020 - 08:43

I migrated from Mnesia to PostgreSQL recently and while it appeared that the migration was successful (user accounts were preserved, etc.) the server was failing the OMEMO test on compliance.conversations.im. After speaking with Conversations and ejabberd support MUC, I was led to discovering the ejabberd server was reporting errors with the pubsub index. Unfortunately, I had to empty the pubsub tables to get things working again. That also means that any pubsub related entries (especially in Movim communities on this server) have been delete. I am hoping that there will not be any further errors related to the database migration.