Fix SugarCRM Job Hung in Running State


If you use SugarCRM and you find a scheduled job that has been stuck in the running state for more than an hour, the job may be hung. I’ve seen this happen when MySQL is restarted or crashed due to memory restrictions.

First, search for the job in the database using this line of SQL:

SELECT * FROM sugarcrm.job_queue WHERE status != 'done';

Then set the job as completed:

UPDATE sugarcrm.job_queue SET status = 'done', resolution = 'success' WHERE id = '[id goes here]' LIMIT 1;

SugarCRM is a flexible, customer relationship management (CRM) software built in PHP. It features a module builder with drag and drop support. There is free version with plenty of great features and modules.

author image

About Joseph Spurrier

I'm passionate about building solutions to automate tasks and improve efficiency. Tech guy. Traveler. Runner. Guitar player. Scotch and beer enthusiast. Keybase GitHub Gists LinkedIn Twitter

Share this post

Comments powered by Disqus