...
Problems with a runaway queue
If you are here from an in-application link, it is because the last discovery_log was more than 20 minutes ago, but there is a count in the number of running queue items. This may mean the queue process has hung. You can restart Apache to resolve this (see below to restart Apache). Any queue items currently being processed when this is done will be deleted. Other items in the queue will wait for processing to being again (see below to start the queue).
View the number of jobs in the queue.
| Code Block |
|---|
mysql -u openaudit -popenauditpassword openaudit -e "SELECT COUNT(id) FROM queue;" |
Delete the remaining items from the queue.
| Code Block |
|---|
mysql -u openaudit -popenauditpassword openaudit -e "DELETE FROM queue;" |
Reset the queue count.
| Code Block |
|---|
mysql -u openaudit -popenauditpassword openaudit -e "UPDATE configuration SET value = 0 WHERE name = 'queue_count';" |
Restart Apache
Restart Apache to kill the running processes (or you should be able to wait for them to complete, your call).
| Code Block |
|---|
sudo service httpd restart |
Start the Queue Processing
To start the queue being processed (automatically done if you execute a discovery), in a browser, call the below URL (substituting your server name).
You should only have to do this if you manually restart Apache and have items in your queue to be processed.
| Code Block |
|---|
http://YOUR_SERVER/open-audit/index.php/util/queue |