Ahah, yes this happens to almost every engineer.
But but... still, I'm curious what you call "rev. 2" (current board) here. Was the rev. 2 already meant to fix issues you found in rev. 1, or was it an evolution with new "features", which introduced new "bugs"?
Because obviously, in the latter case, well again that's relatively frequent. But in the former case, that doesn't look very good and probably meant you rushed rev. 2 before thoroughly testing rev. 1.
Sure sometimes some issues you find may make it look like it's not worth it/or not even possible to test the board further, so you don't test it "thoroughly", but often this is still possible to test most of it with workarounds, and I tend to do that instead of multiplying the revisions. Of course that also depends on the cost and yield time.