Graph showing 1 host queued but nothing in task management

[fry_p]

Hi everyone,
I am running 1.3.5 with the latest client. I suspect there is some “stuck” entry in the DB that is making the graph show 1 job queued. Not a huge deal, just an aesthetic thing. If you could point me in the right direction, I’d be grateful.

Thanks!

[Wayne Workman]

@fry_p Clean it up with the maintenance commands: https://wiki.fogproject.org/wiki/index.php?title=Troubleshoot_MySQL#Database_Maintenance_Commands

[fry_p]

@Wayne-Workman I figured that was the fix, will do on Monday. Honestly should have tried that before posting.

[fry_p]

@Wayne-Workman Fixed, thanks! I see you recently added a couple of new queries in the cleanup commands. Is there a way to make all of this into a script? I hate copy pasting the lines.

[Wayne Workman]

@fry_p Once you’re into MySQL CLI - you can copy all the SQL commands at once.