Delete consensus data from tables when it is no longer needed (#19697)

Delete consensus data from tables when it is no longer needed (#19697) #5132