powered by Jive Software

Openfire is not starting, error:Duplicate entry

Openfire is not starting after mysql and openfire restart.

i am getting below in error.log

2013.06.05 21:34:48 org.jivesoftware.util.Log - Unable to update presence for santosh.bhagavatula@zorba.wtc/spark

com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry ‘santosh.bhagavatula-spark’ for key ‘PRIMARY’

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)