The Messenger of Allah ﷺ said, "Whoever drinks wine, Allah will not accept any prayer from him for forty mornings. If he repents, Allah will accept his repentance. If he goes back to it, Allah will not accept any prayer from him for forty mornings. If he repents, Allah will accept his repentance. If he goes back to it, Allah will not accept any prayer from him for forty mornings. If he repents, Allah will accept his repentance. But if he goes back to it a fourth time, Allah will not accept any prayer from him for forty mornings, and if he repents, Allah will not accept his repentance, and He will give him to drink from the river of Khabal."Someone asked, "Abu Abdul-Rahman, what is the river of Khabal?"He replied, "A river of pus from the people of the Fire."
حدثنا قتيبة حدثنا جرير بن عبد الحميد عن عطاء بن السائب عن عبد الله بن عبيد بن عمير عن أبيه قال
قال رسول الله ﷺ من شرب الخمر لم يقبل الله له صلاة أربعين صباحا فإن تاب تاب الله عليه فإن عاد لم يقبل الله له صلاة أربعين صباحا فإن تاب تاب الله عليه فإن عاد لم يقبل الله له صلاة أربعين صباحا فإن تاب تاب الله عليه فإن عاد الرابعة لم يقبل الله له صلاة أربعين صباحا فإن تاب لم يتب الله عليه وسقاه من نهر الخبال قيل يا أبا عبد الرحمن وما نهر الخبال قال نهر من صديد أهل النار
Sourcing, its chain is daif. The hadith has corroborating narrations in Ibn Majah, no. 3377, and Nasai, no. 5673, and others, without his saying, "If he repents, Allah will not accept his repentance." This wording is extremely objectionable.Ahmad narrated it, 2/35, from the hadith of Mamar, from Abdullah bin Ubayd bin Umayr, from Ibn Umar, through the same chain but without this wording. Ata bin Saaib's memory became confused.