If the above doesn’t improve the behaviour, we need to check if there are stale entries still clogging the corresponding database table.
Login to the PostgreSQL database and verify the event_states table.
SELECT * from event_states;
To find the entries specific to a particular repository path, the following commands can be used.
SELECT * from event_states where art_path LIKE '<REPO_NAME>';
If there are no active scans invoked recently but the table displays entries representing concerned repositories and build references, it indicates an issue. We need to clear off the stuck entries and then invoke the new scans against the existing content. Prior to performing the deletion of such stale entries, ensure that the service is stopped (Xray) and no active scans are in progress.
DELETE from from event_states where art_path LIKE '%REPO_NAME%' and action = 'created' ;
IMPORTANT NOTE:
Even though we are executing this query to clear-off the stale processes, it is recommended to execute this query during a scheduled maintenance window [or] outside business hours, considering the query might take time to execute and the resource utilization.
Login to the PostgreSQL database and verify the event_states table.
SELECT * from event_states;
To find the entries specific to a particular repository path, the following commands can be used.
SELECT * from event_states where art_path LIKE '<REPO_NAME>';
If there are no active scans invoked recently but the table displays entries representing concerned repositories and build references, it indicates an issue. We need to clear off the stuck entries and then invoke the new scans against the existing content. Prior to performing the deletion of such stale entries, ensure that the service is stopped (Xray) and no active scans are in progress.
DELETE from from event_states where art_path LIKE '%REPO_NAME%' and action = 'created' ;
IMPORTANT NOTE:
Even though we are executing this query to clear-off the stale processes, it is recommended to execute this query during a scheduled maintenance window [or] outside business hours, considering the query might take time to execute and the resource utilization.