sticking his foot in his mouth

To regret saying something harmful, insulting, or stupid to someone

Kyle : How is John doing?
Sarah: He has been dead for 5 years now
(Kyle is sticking his foot in his mouth) not literally