CODEWITHSUNDEEP
postgresql
Eng.Bassel
Eng.Bassel

Reputation: 137

idle_in_transaction_session_timeout fall down my application

I have application powered by moodle API 3.3 when I active this parameter at postgresql.conf "idle_in_transaction_session_timeout" and restart the service, I get my application down because of losing connection to the database, I tried to put it 300000 milliseconds but no hope once I restart the postgresql I get my application down so any advises ?

Upvotes: 0

Views: 1497

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246013

You have to fix your application code so that it closes all transactions immediately after they are done. Then the problem will disappear.

Upvotes: 2

Related Questions