Interesting. I’ve never had anything serious than updating keyring and removing before reinstalling packages. Pacman hasn’t failed me enough to need more than

• error msg is obvious (like keyring), conflicts, fix it
• if not check archlinux.org, follow fix from there,
• new problem I need to search, mostly happens because I haven’t learned about it. Like first time I came across keyring problem.