Fix database / migration inconsistency

[dasfliege]

Seems my database is somehow messed up. I am unable to perform "migrate" or "post_upgrade". Always getting errors that some colums are missing, f.e. "column extras_job.task_queues does not exist". Is there any script or something that checks and fixes inconsistencies? Nautobot is working perfectly fine. I do not see anything that is not working as it should.
If there's now way to fix it, i guess i have to do a fresh installation and migrate the data. What's the best way to do this?

[glennmatthews]

Any chance you inadvertently downgraded Nautobot to an earlier version? Might double-check which version you have installed versus which you expect to have.

[dasfliege]

No that matches. And i definately always only upgraded.
I created a clone of my VM running nautbot and crated the missing fields manually:

ALTER TABLE extras_job
ADD COLUMN IF NOT EXISTS task_queues TEXT,
ADD COLUMN IF NOT EXISTS task_queues_override TEXT;

I'm very sure this nothing i should do, but post_upgrade is working fine now and everything still seems to work as it should....
Still, i would be interested if there is something like a consistency check

[glennmatthews]

If you're on latest (2.4.x) there shouldn't be a job.task_queues or a job.task_queues_override column, as those should be removed in the upgrade to 2.4.0 or later. Can you perhaps provide the stack trace indicating what was trying to access these columns?