Postgis Connection lost

[kesslerf]

Hey,
Our Mapserver seems to lose the connection to the used DB (both are stored in docker containers) after some (varying) time.
I tried to play with the environment variables, as I thought it might have to do with idle connections that get terminated.

      BUSY_TIMEOUT: 10
      IDLE_TIMEOUT: 10
      IO_TIMEOUT: 10

This however didnt lead to closed connections after 10 seconds which I assumed are the unit for this values. Is there like a minimum threshold or can I set all of them to 0 to never terminate the connections automatically?

[kesslerf]

Ok I should probably add that I am using a docker-compose file:
mapserver:
image: camptocamp/mapserver:7.6-20-04
ports:
- "8080:80"
secrets:
- mapserver-key
configs:
- source: mapfile
target: /etc/mapserver/mapserver.map
environment:
BUSY_TIMEOUT: 10
IDLE_TIMEOUT: 10
IO_TIMEOUT: 10
MS_DEBUGLEVEL: 5

[sbrunner]

Those values are used by Apache to integrate MapServer, to not close the database connections you should add in your layer in the MapFile: PROCESSING "CLOSE_CONNECTION=DEFER"

[kesslerf]

Thank you for the Answer. I will try it and report if it helped.

[kesslerf]

Unfortunately this didnt work. I still get a connection timeout.