In Openfire 3.7.x, if a subscription request has been rejected a the contact, the Openfire server doesn’t remove the roster item records from the ofRoster table. This results in many useless (sub == none, ask == none and recv == none) records in the DB, which is really annoying.
According to the XMPP Presence specification 8.2.1 Contact Declines Subscription Request (http://xmpp.org/rfcs/rfc3921.html), the user’s roster items for tracking purposes should be removed when the subscription request has been rejected.
So I wonder if you guys forgot to add the code to remove the (sub == none, ask == none and recv == none) records when the subscption records have been rejected.