On Mon, Nov 14, 2016 at 5:23 PM, George Kozak <gkoz...@gmail.com> wrote:
> I am running DSpace 5.5, XMLUI, MIrage2 modified theme. We have been > running for a long time, and just this weekend we started having PostGres > and java problems. I upped the memory allocated to tomcat (Xms4096; > Xmx8192; Xmn2048) and increased the number of the max db connections (from > 100 to 500), but I am still having problems. I get the PostGres error in > the dspace log: > " FATAL: remaining connection slots are reserved for non-replication > superuser connections" > Any suggestions would be appreciated. > I can confirm that leaking transactions are a long-term unsolved issue since DSpace 3. On the postgres side, you will see that most of the connections are "idle in transaction". It's probably a tricky DSpace context closing issue (or several of them). The workaround is to restart either Tomcat or DSpace. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- 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 dspace-tech+unsubscr...@googlegroups.com. To post to this group, send email to dspace-tech@googlegroups.com. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
