The roster tool was throwing stack traces in most sites after an upgrade from 2.8 to 2.9. This is because profile2 adds new tables with defaults but doesn't provide a conversion for old sites. We need to run this conversion. I'm not sure if this is a problem or not for mysql.
This was briefly discussed on this thread http://permalink.gmane.org/gmane.comp.cms.sakai.devel/49380 But I don't see it fixed anywhere.
In the database I ran it against we had 1010 rows matched in PROFILE_PRIVACY_T and 1086 rows in PROFILE_PREFERENCES_T
This should be in the 2.9.2 scripts as there's no harm in running it if there are no nulls in these columns.
update PROFILE_PREFERENCES_T set USE_GRAVATAR = false where USE_GRAVATAR is null;
update PROFILE_PREFERENCES_T set EMAIL_WALL_ITEM_NEW = true where EMAIL_WALL_ITEM_NEW is null;
update PROFILE_PREFERENCES_T set EMAIL_WORKSITE_NEW = true where EMAIL_WORKSITE_NEW is null;
update PROFILE_PREFERENCES_T set SHOW_ONLINE_STATUS = true where SHOW_ONLINE_STATUS is null;
update PROFILE_PRIVACY_T set MY_WALL = 0 where MY_WALL is null;
update PROFILE_PRIVACY_T set ONLINE_STATUS = 0 where ONLINE_STATUS is null;