Yep. Had that before. The handyman going round with a "light stick' could not figure it out. Understandable.You don't say if you have live at switch or fitting,losing the neutral will stop the lights working in the same way as losing the live will.
It was a lost neutral. Not accessible.