In my opinion, a relationship of any kind should be one source of happiness in your life. Not the only one and certainly not the most important one.

At 35 yo, that has probably been the biggest lesson I have learned.