The native New Yorker promptly left both men and the five-time Grammy winner 'was just in a lot of pain' and attempted suicide twice - first with sleeping pills and then by drinking a bottle of furniture polish (pictured 1979)