The Specs repository list shows a deleted repository.

Issue Summary

The repository list shows repositories that are already deleted in linked repository.

Steps to Reproduce

1. For the second repository created, run the following SQL:
   Postgres

   update VCS_LOCATION 
   set MARKED_FOR_DELETION = true 
   where NAME = 'test2';
   

   MySQL

   update VCS_LOCATION 
   set MARKED_FOR_DELETION = 1 
   where NAME = 'test2';
   

Expected Results

The repository should not appear in the Bamboo specs repositories page.

Actual Results

The repository will appear on:

• Bamboo Specs repositories page

  {{<base-url>/rest/api/latest/project/TEST/repository.json}} 
  

  Workaround

Currently, there is no known workaround for this behavior. A workaround will be added here when available