usually erect all night

It is normal and healthy for a guy to have nocturnal erections. If you can keep it up all night, you must be a stud. Most guys would love to be as virile as you are. If the erection doesn't hurt, it can't possibly hurt you. You said you are looking for a wife. That sounded a bit too serious. Why not find some girlfriends instead? Once you start having an active sex life, I guarantee your "problem" will go away. Have you ever tried online dating?

I find it hard to believe that you have a solid erection all night, you are talking about nearly eight hours, medically it would be a very unsafe situation, as it it is not healthy to have an erection for more than four hours, you don't mention if you have erections of any significants during the day, Now when I was a teenager one of my rituals at the time when i was in my bed was to retract my foreskin, and develop an erection, I loved the feeling, and one of the things I actually like doing was actually falling asleep with a full blown erection, sometimes, I'd awake with an erection, often wondering if I'd been that way all night, however, I discovered, when I awoke during the night, or was woken by some reason or another, that I hadn't an erection, now if I got back to sleep for a while, I'd again wake up with one. I never found it distressing or uncomfortable to fall asleep with an erection

Yes I don't believe all night erection. Since you are single and you couldn't find anyone to enjoy your buddy, it could erect 30 or 40 minutes till you think about sex. If this is not the case, consult urology and take treatments. Or immediately find someone, have continuous intercourse for 15 to 20 days, Then you will never see this issue for long time until you find permanently

I have something similar I
I wake up every hour on the hour and it takes me four minutes from four to go away I can’t sleep over today it’s horrible

You need to see doctor [urology] and get treated. If doctor say no issue, discuss with your lady partner, enjoy long intercourse twice a week before go to sleep. Trust this works. But don't do masturbate

Thoughtful mothers, when they begin to notice frequent erections in their boys, will begin a special nighttime ritual at least several times a week. At bedtime, the mom will give her son a very relaxing and thorough back rub which puts the boy in a very passive relaxed sleep, with many boys almost asleep at that point. The mom gently helps flip the boy into his back and proceeds to give a very soft and soothing massage to the boys neck and chest. This puts most boys into a quasi-sleep mode. At that point, the mom simply moves the massage lower on the boy’s body, including his boxer briefs. Many boys at this point aren’t mentally aware or register what’s going on. He won’t notice (or care) when her fingertips start to gently massage his boxer briefs. Won’t notice when his penis begins to lengthen and stiffen inside the briefs. But mom will. She will then begin to focus her massage on the material over the head of the boy’s penis, the most sensitive area of his young body. He will attain a full erection very rapidly. He won’t notice when her fingers then begin to massage the glans of his penis, below the head, nor that her other hand is gently massaging the fabric covering his testicles. At this point he is fully sexually aroused. The mom will soon feel the wetness through the fabric of his precum. At this point, the mom will stop and use her fingers to open the slit of the boxer briefs, allowing her son’s erection to naturally come out in the open air. Using her son’s own precum as a lubricant, she can gently massage his entire penis with her hand to bring him to a full and quick ejaculation in his sleep. Some mothers instead will simply lower their mouth onto the head of the penis and using a combination of sucking and licking the head, bring the boy to ejaculate directly into her mouth.

does it wake you up at night? i’d wake up every hour it was awful i was single and it went on for five years
and then i was put on antibiotics for something else and it went away now it’s only morning wood

I had the same for years it would wake me up at least every hour and it was awful. It went away when I starting taking antibiotics for another condition unrelated. I think I had some form of U.T.I. and the antibiotics took care of it. I know it sucks but this might help