Postgres DB connection intermittently failing

TAMULib / DSpace

(Official) The DSpace digital asset management system that powers your Institutional Repository

https://wiki.duraspace.org/display/DSDOC4x/Introduction

BSD 3-Clause "New" or "Revised" License

5 stars 0 forks source link

Postgres DB connection intermittently failing #186

Open jcreel opened 3 years ago

jcreel commented 3 years ago

We have seen this problem prevent usage of the command-line importer and the RDF web app. It seems to occur more frequently the longer tomcat has been running. DSpace returns various 500 errors about the database connection

jcreel commented 3 years ago

First observed in upgrade from Postgres 9 -> 10

ghost commented 3 years ago

Requires postgresql.conf to disable idle_in_transaction_session_timeout.

idle_in_transaction_session_timeout = 0

postgres=# show idle_in_transaction_session_timeout;
 idle_in_transaction_session_timeout
-------------------------------------
 0
(1 row)