ok I think my issue is not the same as your now I dove deeper into it, The rpool is not showing up because the kernal is not negotiating the sata device correctly and disabling the device. I think this is a kernal bug still since rolling back to 6.14 there are no issues. I think I need to...
I am having the same issue on 2 of my 3 proxmox servers bare metal, this started on 6.17.2-1 and i was hoping 6.17.2-2-pve would resolve it. If I use 6.14.11-4-pve no issues.