Rinciog Octavian created MARMOTTA-624:
-----------------------------------------
Summary: Apache Marmotta refusing to load queries - Postgresql No
remaining connection
Key: MARMOTTA-624
URL: https://issues.apache.org/jira/browse/MARMOTTA-624
Project: Marmotta
Issue Type: Bug
Affects Versions: 3.3.0
Environment: Postgresql: 9.3.10
Server version: Apache Tomcat/7.0.52 (Ubuntu)
OS Name: Ubuntu 14.04
OS Version: 3.13.0-74-generic
Architecture: amd64
JVM Version: 1.7.0_91-b02
JVM Vendor: Oracle Corporation
Marmotta: 3.3.0
Reporter: Rinciog Octavian
Hello,
I'm running an Apache Marmotta 3.3.0, configured with postgresql 9.3.10 and
Tomcat 7, and from time to time, the resources from Marmotta cannot be
accessed.
In tomcat logs the following lines appear :
0:10:19.937 ERROR - Error retrieving the resource XXX: database error, could
not load URI resource
10:10:27.168 ERROR - database error, could not load URI resource
org.postgresql.util.PSQLException: FATAL: remaining connection slots are
reserved for non-replication superuser connections
Right now, in /etc/postgresql/9.3/main/postgresql.conf I have the following
setting:
- max_connections = 100
There are 97 opened connection to postgresql, all from tomcat process
root@test# netstat -ap | grep postgresql
tcp6 0 0 localhost:33756 localhost:postgresql ESTABLISHED
22632/java
tcp6 0 0 localhost:33733 localhost:postgresql ESTABLISHED
22632/java
tcp6 0 0 localhost:33757 localhost:postgresql ESTABLISHED
22632/java
...
root@test# netstat -ap | grep postgresql | wc -l
97
root@test# ps -ef | grep 22632
tomcat7 22632 1 0 Jan13 ? 00:14:40
/usr/lib/jvm/default-java/bin/java
-Djava.util.logging.config.file=/var/lib/tomcat7/conf/logging.properties
-Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
-Djava.awt.headless=true -Xmx2048m -XX:+UseConcMarkSweepGC
-Djava.endorsed.dirs=/usr/share/tomcat7/endorsed -classpath
/usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-juli.jar
-Dcatalina.base=/var/lib/tomcat7 -Dcatalina.home=/usr/share/tomcat7
-Djava.io.tmpdir=/tmp/tomcat7-tomcat7-tmp org.apache.catalina.startup.Bootstrap
start
But there is no live connection from an outside point to tomcat.
After tomcat restart, all is very good, but in a couple of hours, the problems
appears again.
So, how can I fix this problem?
Thank you,
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
