I was taking Metformin for over 50 years and did not have the problem you stated. The problem I finally had with Metformin was projectile diarrhea which was the reason my PCP took me off it advising me that if my A1C went above 7.2 I would be back on it.
I also have BPH (enlarged prostate) which causes frequent urination mainly at night (abt every 2hrs). For the men reading this I now take Tamsulosin and an OTC (Prostate Pro) and stop drinking at 7:30pm and this has helped quite a bit.