Rollback transactions in connection close as a separate pass before closing all of the sessions.

refs #835