Erreur 500, 502, 504 serveur central ODK

steeve_kevin · August 13, 2024, 12:12am

I am having a lot of difficulty with my ODK server. I have more than 1000 collectors who collect data in the field on a regular basis. I have around 14 projects and I have nearly 180,000 submissions.

I increased the memory to 16 GIGA

versions:
cc2a6725209c466afef9b5e175052b27f05f5aa3 (v2023.4.0-3-gcc2a672)
95326b9ad66ec31c93bdb68c29f8797975d93fd2 client (v2023.4.0)
63fdf150e1ed81e3b1059050f7b1ba323931ab24 server (v2023.4.0)

docker logs --tail 100 central-service-1 (result)
logs1.txt (48.6 KB)

docker logs --since 5m central-nginx-1 (result)
logs2.txt (8.4 KB)

I don't know what the problem could be.
I need help

yanokwa · August 13, 2024, 12:34pm

I see a lot of database timeouts. It's unlikely to be a memory issue. Try increasing the performance (CPU, network, disk) of the machine and see if that helps.

steeve_kevin · August 13, 2024, 4:56pm

I tried without success I think the problem is that the central takes a long time to load but

I don't know why the site is taking so long to load or how to fix it.

yanokwa · August 13, 2024, 5:14pm

Where is your Central install hosted? If it's on AWS/DigitalOcean/Azure, what size of machine are you using? If it's not on a cloud host, what did you do to increase CPU/network/disk speed?

steeve_kevin · August 13, 2024, 10:23pm

I hosted central on my own VPS . I stopped all connections to the server and I still have the same errors when I try to connect .

steeve_kevin · August 13, 2024, 10:25pm

It seems that the central application is no longer communicating well with the postgres DB

steeve_kevin · August 14, 2024, 7:00am

i try to ubgrade but i have this error

$ git pull
fatal: unable to access 'https://github.com/getodk/central/': gnutls_handshake() failed: The TLS connection was non-properly terminated.

steeve_kevin · August 15, 2024, 1:36pm

I contacted my domain administrator and told him to increase the memory and cpu even if the problem was not there. After he increased everything works normally.

I would like to know if the fact that I use the new codes Bare code that allows synchronization and automatic updates This makes me use more memory than if I was using the old bare code where everything is manual.