so i found This information and found someone was able to fix it by downgrading their mariadb to 10.5. I appended the mariadb to 10.5 and the upgrade is going through now and I can use Nextcloud 22.
It looks as if this is a weird error by both nextcloud and mariadb. Definitely going to start appending major.minor versions from now on