Question about a common thing I’ve heard…

I’ve heard that at one point, due to humanity’s flaws, G-d wanted to erase everything and start over (what is the context of this by the way?), but if G-d is all knowing and perfect, why would this have been an issue to begin with?

Thanks