connection to database don't close

[Marcellino-Palerme]

connection to database don't close

Error message in container ep2m2-web:

[nuxt] [request error] [unhandled] [500] sorry, too many clients already

Reproduction:

1. Start web site
2. Use it several time
   => impossible to open web site

[Marcellino-Palerme]

It have to use promise for each connection to database with a catch and finally with client.close()

[Marcellino-Palerme]

Quick Fix : Every day restart container database or when we have a error or when number of connection is high

[Marcellino-Palerme]

Restart container: It's only if container stop or Docker service restart.
That mean we need to ask container stop itself.

Another idea, it's ask postgres to delete all connection inactive.
=> In postgres we see that with table pg_stat_activity and function pg_terminate_backend
Sample provide by chatGpt

CREATE OR REPLACE FUNCTION kill_idle_connections()
RETURNS void AS $$
DECLARE
    r RECORD;
BEGIN
    FOR r IN
        SELECT pid, state
        FROM pg_stat_activity
        WHERE state = 'idle'
        ORDER BY query_start ASC
        LIMIT 5 -- Limite le nombre de connexions à tuer à la fois
    LOOP
        EXECUTE 'SELECT pg_terminate_backend(' || r.pid || ');';
    END LOOP;
END;
$$ LANGUAGE plpgsql;

Maybe launch this function every connection ?

[Marcellino-Palerme]

TODO: Modify all case called database to use Pool instead of Client