Need help on "org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command" - Mailing list pgsql-general

Hello,I'm using JSP for accessing postgre

My postgre version is 8.1 running on suse enterprise 10 linux machine.

My JSP container is Apache Tomcat 5.5.

My connection method is JNDI(pooling).

Recently I'm having trouble after my web application is being accessed by many users.

My error log shows something like this :

======================================

...

org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1525)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute (AbstractJdbc2Statement.java:452)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:340)
 at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java :239)
 at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
 at org.diknas.sarpras.UtilDiknas.executeQuery(UtilDiknas.java:226)
 at org.apache.jsp.modul.monitoring.gofoto_jsp._jspService (gofoto_jsp.java:157)
 at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.jasper.servlet.JspServletWrapper.service (JspServletWrapper.java:334)
 at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
 at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
 at javax.servlet.http.HttpServlet.service (HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
 at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
 at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
 at org.apache.catalina.core.ApplicationDispatcher.doForward (ApplicationDispatcher.java:398)
 at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
 at org.diknas.sarpras.monitoring.MonitoringFotoProcessor.doEntryView(MonitoringFotoProcessor.java :115)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java :25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.diknas.sarpras.monitoring.MonitoringFotoProcessor.doSelection(MonitoringFotoProcessor.java:96)
 at org.diknas.sarpras.monitoring.MonitoringFotoProcessor.doProcess (MonitoringFotoProcessor.java:54)
 at org.diknas.sarpras.monitoring.MonitoringProcessor.doFotoView(MonitoringProcessor.java:133)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:585)
 at org.diknas.sarpras.monitoring.MonitoringProcessor.doSelection (MonitoringProcessor.java:91)
 at org.diknas.sarpras.monitoring.MonitoringProcessor.doProcess(MonitoringProcessor.java:50)
 at org.diknas.sarpras.Controller.doMonitoringEntry(Controller.java:143)
 at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke (Method.java:585)
 at org.diknas.sarpras.Controller.doSelection(Controller.java:97)
 at org.diknas.sarpras.Controller.doGet(Controller.java:66)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
 at org.apache.catalina.core.StandardEngineValve.invoke (StandardEngineValve.java:107)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection (Http11BaseProtocol.java:664)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
 at java.lang.Thread.run(Thread.java:595)

...

=======================================

 

It seems that the exception came from Postgre : org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command

 

What's this ? I've tried to googling around and found something about resource limiter or something like that, but I don't seems understand the solution.

Is there any straight forward solution for my trouble here ? Cause I got really stuck here.

How to configure postgre to fix this ?

 

 

thanks.