The DB sync process:

XRAY: Troubleshooting Database sync issues

AuthorFullName__c
Shai Ben-Zvi
articleNumber
000005251
ft:sourceType
Salesforce
FirstPublishedDate
2022-04-18T08:18:57Z
lastModifiedDate
2022-04-18
VersionNumber
5
  1. Downloading the update files. The files will be downloaded to $JFROG_HOME/var/work/server/updates, where the data will be saved in two folders: components, and vulnerabilities.
  2. Once Xray finished to download all update files, it will start extracting each archive, which contains a lot of json files, each contains lots of information. For each archive it has been finished to extract, Xray will rename the file and add a '.Completed' suffix -  <archive-name>.Completed.
  3. Once the '.Completed' suffix is present, Xray will start to perform an Impact analysis process on the extracted information (this is done after the DB sync).
  4. Once Impact analysis is completed, Xray will remove the '.Completed' files.
Note: In case of HA, one of the nodes will be chosen randomly to perform the DB sync.

The Xray DB sync is a database IOPS intensive operation. This is because we write, update, and delete information in the database, that’s why it is important to assure that the Xray DB is meeting the Xray system requirements.