We are getting batches of 40-50 very rapid errors in our postgresql logs from openfire:
“repeated duplicate key error in ofpubsubitem_pk”
These batches occur every few minutes. I’m not sure when they started so I can’t point to a revision. A restart of the openfire service does not stop the problem and neither does deleting the (few) records in that “ofpubsubitem” table. Any ideas anyone?