The problem is you don't even know where to learn about the mistakes of others until you make the mistake yourself and in making the mistake you get some clue was to what to search for that then uncovers the mistakes of others.

I've found that when I ask others what mistakes I should avoid, they tend to answer the question.

Another way to discover any mistakes is to ask people why they didn't do certain things which you think are good ideas. Often that reveals that they did do that, and it turned out poorly.

People rarely post their mistakes to stack overflow.

They surely write papers about it.

I bet anyone at Google is able to access ACM, SIGPLAN, HOPL, IEEE, USENIX papers.