Error: failed retrieving file 'core.db'...... requested URL returned error: 404

pacman fails to update system, package manager completely empty

Then show us the mirrorlist (/etc/pacman.d/mirrorlist).

check is you have IP connexion ok