Our jabber server has been crashing mysteriously for some time now. I can’‘t be sure how exactly it started happening, but I believe it started happening frequently when we upgraded to Wildfire 3.2.2 from 3.1.0. I’'ve tried to upgrade to 3.3.2, but the problem remains.
I believe I have followed the proper upgrade instructions, but I never upgraded our database (based on the .sql files under resources/database/upgrade) because I couldn’'t figure out which of these I should be using. Below is one of the errors we have been getting on the logs in addition to the crashes:
2007.08.03 12:40:53 org.jivesoftware.openfire.spi.PresenceManagerImpl.userUnavailable(PresenceManage rImpl.java:264) Error storing offline presence of user: nobody#example.com
org.postgresql.util.PSQLException: ERROR: duplicate key violates unique constraint “jivepresence_pk”
Any help would be appreciated.