Behind the Illusion of Perfection: Why Your RAG Pipeline Fails in Production

An Architectural Deep Dive into Retrieval-Augmented Generation Limitations, Breakdowns, and Real-World Failure Modes