Suddenly three quarters of my chat rooms disappear. Not visible in admin console or Spark. Server was rebooted - problem stay the same.
I saw users had similar issues with prior versions of Openfire, but no one answer.
I have OF 3.7 running on server 2003, using MS SQL database.
When I look in dbo.ofMucRoom table, I see all the chat room listed there. There are nothing in serveraudit log (except the creation of the chat rooms and assigning admins) , nothing relevant in Error or Info logs
What can be done other than clear the table and rebuild to get chat rooms back? What can be done to prevent this from happening?
Right now the server is not used by users, but when it will dissapearing chatrooms will present a huge problem.
The server will unload from memory persistent rooms that have been empty for 30 (default) days. The room will still exist in the database and users may still join. The only consequence is that it won’t appear in the discovery list. This option is valid for prior 3.6.0 versions only. As 3.6.0 has introduced multiple conference services.
So how does this property behaves in 3.70?
Tried changing group creation date in database by copying the value from another room that still shows up (http://community.igniterealtime.org/thread/30535), rebooted the server, that chat room still not shown