Roberto Mancini suffered more Champions League heartache as Real Madrid held on for the 1-1 draw to send City out of the competition.