This has happened to me when my sexual interest was rejected by a woman over a long period of time. I would be spending time with her, sitting there with a hard-on, but no opportunity to use it. Eventually the erections go away. It’s called Conditioning.