I just came across a PostgreSQL configuration variable that may be of interest: idle_in_transaction_session_timeout appeared in, I think, Pg 9.6. "Terminate any session with an open transaction that has been idle for longer than the specified duration in milliseconds."
While the best answer will be to find out what is causing connections to remain in this state, we may have a more direct way for dealing with them than the various things we've all been trying. I haven't tried this approach yet, but I may set it to, say, 60000 (one minute) just to see how it works. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
