While I am selecting unchecked the collation type for Author role and save getting error

Something related to the duplicate key issue in DB. Have you tried checking, why there this issue is occurring?
Can’t tell what is the issue here without looking at the DB but something related to the duplication of relation unique key. Please check if thoroughly in the DB.