Fix SugarCRM Job Hung in Running State

· MySQL

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. I worked for a few companies in the digital healthcare space. My education is in forensics. Tech guy. Traveler. Runner. Guitar player. Scotch and beer enthusiast. GitHub LinkedIn Twitter Google+

Share this post


Comments powered by Disqus