I ran into this issue today, never have I ever before though. Omarchy looking a bit sus on me. This was even after a fresh boot, no pacman process running. just realized I forgot to check yay which it has installed for me. I had to force it in.
sudo rm /var/lib/pacman/db.lck