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.
and
Error: getaddrinfo ENOTFOUND enketo_redis_main
Odk version
versions:
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.
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.