We have an Openfire 3.6.4 install on Ubuntu using the Embedded database that is not sending MUC history to users. All users are connecting to the MUC rooms with GTalk accounts and so far are all reporting intermittent and incomplete history being sent when joining the room. Using both Pidgin and Empathy on the same workstation to connect to the room will show different history but none are up to date.
Openfire is configured with ‘Show Entire Chat History’ in the Group Chat Settings, a Flush Interval of 300 seconds and Batch Size of 50. I’ve tried changing these values to return only 25 records of History and to write the log to the database after 60 seconds or 10 seconds etc. I made sure to restart the server after each of these changes but nothing seemed to make a difference.
After restarting the server a large portion of the history that actually was being returned is now missing. My guess is that the regularly flushed data is ending up in a transaction or such that is not being written to disc very often so restarting the server is clearing the temporary cache.
Any ideas on how to resolve this? I was considering binning the embedded server and switching to Postgres or MySQL instead. That way at least I would have a better idea of when data is hitting the db.
Thanks!