Weightlifter left red-faced after embarrassing workout fail