Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

Customer has large about of InProgress Jobs that will never finish.

  • project had a location with targets in a /16 subnet
  • paused project and created a new location with the addresses separated into many /22 subnets to see if performance would increase
  • started new project and now no new jobs are being served.
  • select * from history.v_ProjectOverallSummary shows an impossible number of active jobs in the paused project (see screenshot)
    Image Modified
  • select * from jobs.t_job where TargetStatusID=8 returns over 45k rows
  • restarted iQSonar Service on both scan engine servers, no errors and jobs are still not b being served.
  • cpu on one server in system performance is at 72% but no new scan target logs are being created.



Solution

From the SSMS open a new query from the systems iQSonarSE database

Code Block
languagesql
SELECT * FROM jOBS.t_Queue, Note the JobStatusID is set to -3



Image Modified


Run the following sql to update the JobStatusID to Served/Complete

Code Block
languagesql
UPDATE  jOBS.t_Queue SET JobStatusID = 1

Following that you will be able to set a rescan of the targets or set up a new Project.



Filter by label (Content by label)
showLabelsfalse
max5
spacesCSKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-troubleshooting-article" and type = "page" and space = "CSKB"
labelskb-troubleshooting-article


Page Properties
hiddentrue


Related issues
Jira Legacy
serverIdf64ffcc9-ad0d-3255-a217-cd901e9e7336
keyCS-1127