Apparently final step to be done

$ sudo pacman -Syyu
$ sudo reboot
$ sudo chmod +r /etc/pacman.d/mirrorlist
$ pacman -Qqn | sudo pacman -S -
$ sudo pacman -Syyu
$ grep "\[ALPM\] upgraded" /var/log/pacman.log | tail -n 880 > log1

$ sudo pacman -S cachyos-kernel-manager
$ pacman -Qs cachyos
local/cachyos-kernel-manager 1.16.1-1 (cachyos)
    Simple kernel manager
local/cachyos-keyring 20240331-1 (cachyos)
    CachyOS keyring
local/cachyos-mirrorlist 22-1 (cachyos)
    CachyOS repository mirrorlist
local/cachyos-v3-mirrorlist 22-1 (cachyos)
    CachyOS repository mirrorlist
local/cachyos-v4-mirrorlist 22-1 (cachyos)
    CachyOS repository mirrorlist
local/chwd 1.16.1-1 (cachyos)
    CachyOS Hardware Detection Tool
local/linux-cachyos 6.17.8-2
    The Linux BORE + LTO + AutoFDO + Propeller Cachy Sauce Kernel by CachyOS with other patches and improvements. kernel and modules
local/linux-cachyos-headers 6.17.8-2
    Headers and scripts for building modules for the Linux BORE + LTO + AutoFDO + Propeller Cachy Sauce Kernel by CachyOS with other patches and
    improvements. kernel
local/pacman 7.0.0.r7.g1f38429-2
    A library-based package manager with dependency support. CachyOS fork.
local/scx-manager 1.15.7-1 (cachyos)
    Simple GUI for managing sched-ext schedulers via scx_loader

UPDATE as of 11/27/2025
Would you exterience any issues with  cachyos-rate-mirrors, just remind that
cachyos-rate-mirrors is a wrapper script for the rate-mirrors tool, specifically configured
to rank and update both Arch Linux and CachyOS  mirrors for the user's mirrorlist file.
It automatically tests available mirrors based on speed and synchronization status to ensure
pacman downloads are optimized. It's a wrapper: It is not a replacement for rate-mirrors but
rather a specific version or a script that uses rate-mirrors's underlying functionality.
See man pages for rate-mirrors.
END UPDATE

UPDATE as of 11/28/2025
The very first time schema proposed in  https://lxer.com/module/newswire/view/358937/index.html 
has been run with no issues on bare metal. 
I would expect the re-sync issues to be back again shortly.
END UPDATE

UPDATE as of 12/03/2025
So far so good ( bare metal upgrade)
END UPDATE.

UPDATE as of 12/14/2025
To avoid failure when running  `sudo ./cachy-repo.sh` on fresh installation following below 
update  is required
$ diff ./NEW/cachyos-repo.sh ./OLD/cachyos-repo.sh
165c165
<               "${mirror_url}/pacman-7.1.0.r7.gb9f7d4a-3-x86_64.pkg.tar.zst"
---
>               "${mirror_url}/pacman-7.0.0.r7.g1f38429-2-x86_64.pkg.tar.zst"
END UPDATE