1

I'm trying to execute an initial DB sync for Xray to an external (Azure) PostgreSQL database.

It ran acceptedly for about an1.5 hrs., and then froze up at 90% (something to do with IOPS limits on Azure PG Database) after pushing about 50 G.B into the database.

So, I aborted it and restarted the server, and doubled the IOPS allocation.

But now, it runs VERY slow, apparently started from the beginning, although the Database size is still at around 50 GB, and I see something, that looks like failure messages in console.log.

"[jfxr ] [WARN ] [job_service:174] [main] Node is offline or does not exist, cannot be job manager".

Does anyone know what that is?

Michael Rudd
  • 13
  • 2

2 Answers2

1

The pattern appears to be indicating exhaustion of the Xray resources (especially on the database's end). It is recommended to have the minimum requirements as described here for the Xray and its database. From the attached link, check the requirements section for Xray that detailly describes the minimum resource requirements based on the size of the environments.

Yuvarajan
  • 450
  • 2
  • 5
  • yes, i have plenty of resources: 8 core/16 GB VM and 4 core/20 GB database VM, and this is just the initial DB sync with no repository. This appears to have something to do with RabbitMQ node/workers. I restarted it once, and things started to move, abut then everything froze up again, and all i see now is "Node is offline or is not ready to become job manager". Nothing else in the log, and db sync is stuck at 93%. very frastrating! – Michael Rudd Mar 18 '22 at 15:31
0

This is usually happening when the disk for the Database is limited. Especially on IOPS. The disk you have for the database is very small compared to the requirements. The bare minimum installation requires:

Xray and DB: 500 GB (SSD, 3000 IOPS)

My recommendation is to provide a larger and faster, with less IOPs limitations for the disk.

https://www.jfrog.com/confluence/display/JFROG/System+Requirements#SystemRequirements-RequirementsMatrix

galusben
  • 5,948
  • 6
  • 33
  • 52