dysfunction

My boyfriend and I were hanging out last night, we had a few glasses of wine, which always makes me pretty frisky. 😅 So you know we were getting pretty hot and heavy. We moved to the bedroom and yeah... but for some reason he couldn't get hard. 😩 He got so upset. I tried to comfort him and reassure him it's nbd but it really bothered him. He started to cry. It broke my heart to see him like that. I don't care about the sex I just want him to be happy. We just laid there and cuddled and later he was able to... but yeah. Idk. He got so upset. I guess I just don't know a lot about dysfunction in that area. At what age should this start to be a problem? Any tips on how to handle it?