See System Maintenance in the Manjaro Wiki, and look for the heading Pacnew and Pacsave files to learn more about .pacnew
files mentioned.
To find specific information on instances that required manual intervention, look through the previous Stable Announcements.