It wasnarrated that Asma' bint Yazid said:
"When Ibrahim, the son ofthe Messenger of Allah (ﷺ), died, the Messenger of Allah (ﷺ)wept.The one who was consoling him, either Abu Bakr or 'Umar, saidto him:'You are indeed the best of those who glorify Allah withwhat is dueto him.' The Messenger of Allah (ﷺ) said: 'The eyeweeps and theheart grieves, but we do not say anything that angersthe Lord. Wereit not that death is something that inevitably comesto all, and thatthe latter will surely join the former, then wewould have been morethan we are, verily we grieve for you.'"
English reference: Vol. 1, Book 6, Hadith 1589
Arabic reference: Book 6, Hadith 1657