Maybe a pointer - could it be that the root username was renamed?
The rake tasks allow to search for users by email, see the example in How do I change my profile to Admin? - #2 by dnsmichi
gitlab-rails console -e production
Find the user, and print its attributes.
user = User.find_by(email: 'root@domain.com')
pp user.attributes