I had a feeling there had been a similar topic in the past, but can't actually find it... Apologies in advance is this is a duplication!
We all make mistakes from time to time, and suffer problems caused by others. In over 40 years of playing in church, at the end of last year I had the worst "disaster" I have ever suffered. To cut a long story short, at a very big service which was supposed to proceed unannounced, the priest for some reason announced everything - sometimes at unexpected points. I was caught on the hop with an announcement of a choir piece (Warlock: Where riches is everlastingly) Owing to colds / fatigue amongst choir members it had been decided to perform it in C Minor rather than D Minor. Being caught "off guard" I totally forgot, and played it as writ in d; not having "perfect pitch" I thought nothing of it, until I realized the choir just could not "pitch" it. The performance collapsed - with much sniggering from the congregation. I apologized to the choir afterwards - they were surprisingly unbothered by it. I apologized to the priest, and asked if my apology could be printed in the following week's news sheet, but he said it wasn't necessary, although I pointed out that the choir, who were blameless, seemed to have been at fault to the ears of the congregation.
I was - and still am - totally devastated by what happened. My (admittedly rather silly) immediate "knee-jerk" reaction at the time was to resign from every professional body, unsubscribe from Facebook organists' groups, and "unfriend" on Facebook all my musical contacts as I felt totally unworthy to remain in contact!
I just wondered how others cope with such things?