Error storing offline presence of user

Hi All,

I’m seeing quite a few of these in the error log:

org.jivesoftware.openfire.spi.PresenceManagerImpl - Error storing offline presence of user: ‘username’

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint “ofpresence_pk”

Detail: Key (username)=(‘username’) already exists.

This is on the current Openfire version 3.8.2.

Any ideas why?


I had this problem recently with openfire 4.0.2 and Mysql.

After a reboot of mysql and openfire the problem appeared in the logs.

The table ofPresence was crashed. Did a repair of the whole database and never had that errors again.