DataIntegrityError: Query returns an unexpected result

1. What is the issue? Please be detailed.
For a few days now, I have been getting the following error message .

 2023-04-27T14:08:18.146208588+02:00 DataIntegrityError: Query returns an unexpected result.
 2023-04-27T14:08:18.146352464+02:00     at async Object.createConnection (/usr/odk/node_modules/slonik/dist/src/factories/createConnection.js:96:18)DataIntegrityError: Query returns an unexpected result.


Error: getaddrinfo ENOTFOUND enketo_redis_main

Odk version
24ee74e5f974a518aa1cc8b06e7addb3be6b4690 (v1.3.3-2-g24ee74e)
5cc6fd79d112ce36d6298c61bb8817689c4c323b client (v1.3.2)
1d1a3a59969e61383da74119e405e67778b7a170 server (v1.3.3)
2. What steps can we take to reproduce this issue?
Complete a form
3. What have you tried to fix the issue?
restart de services and restore the database status

getaddrinfo seems like a network or DNS issue. Has anything been changed on your network or install? I'd get that working first and then see if that addresses the other error.

Hi @yanokwa ,
Thanks for your reply !! appreciated. As far as I know we don't change the network, but I'll check it with the sysadmin.

Where are you seeing the network problem? I thought it was a database problem.

It's a network problem that's resulting in a database problem.

getaddrinfo ENOTFOUND usually means that the service (in this case Enketo's main Redis database server) can't resolve its hostname. That's usually because something has gone wrong with Docker's networking or your host machine's networking. If a reboot hasn't helped, talking to IT is a good next step.

The DataIntegrityError may or may not be related, but you have to fix the network problem first before tackling it.

Hello @yanokwa ,
Just to say ,yep we found a problem ,it was a DDoS attack on odk-central . I have changed a ningx configuration and we have alleviated the problem, I don't know if you are interested in this modification and I will make you a PR with the configuration.

Sure, send in a PR or post the change here. Whichever is easiest for you.