Fix Odoo v16 FATAL error root@root FATAL: role "root" does not exist

Job ID: 37456897

Budget: €36 – €0 EUR

I am looking for an experienced Odoo developer who can help me fix a critical issue on Odoo v16. Currently, I am facing a FATAL error where the role "root" does not exist. I have a backup of my Odoo database, so we can safely proceed with the necessary changes.

There was no change nor any update on the installation. After a reboot last week there was a first error I fixed with this help: https://www.youtube.com/watch?v=1nhX0pNlGII

After another reboot last week, I ran into another fatal error

Skills and Experience Required:
- Strong experience in working with Odoo v16 and resolving FATAL errors
- Proficiency in database management and troubleshooting
- Knowledge of Odoo roles and permissions
- Familiarity with backup and restore procedures in Odoo

Communication:
I prefer to communicate through Freelancer Messaging for this project.

I need to have a transcript on how the problem was resolved, what was the cause of this issue in order to document this and to prevent this in the future.
Related categories: Python Software Architecture ERP MySQL