Is there any way to set the RosterID Sequence to higer number? since i re-install the openfire and only restore 2 tables in mysql. the tables are ofRoster and ofRosterGroups.
on my debug i found that openfire try to execute sqy query
INSERT INTO ofRoster (username, rosterID, jid, sub, ask, recv, nick) VALUES (‘username1’, 41, ‘firstname.lastname@example.org’, 0, -1, -1, ‘username2’)
while the rosterID in ofRoster table is very far from that number, beyond 6000s.
this proble occur when spark client add a contact and then it will suddenly disconnect.
im using openfire 3.6.4 with mysql as database, and openldap for the authentication.