Thread: BUG #6623: FATAL: terminating connection due to administrator command
The following bug has been logged on the website: Bug reference: 6623 Logged by: Mueen Akhtar Email address: mueena@chetu.com PostgreSQL version: 8.4.1 Operating system: Linux Description:=20=20=20=20=20=20=20=20 Hi, We get below error unexpectedly because my application was working proper since one year and suddenly we are getting below error please advise: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutor= Impl.java:1513) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j= ava:1298) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:190) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.= java:438) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2S= tatement.java:354) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2State= ment.java:258) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) at org.hibernate.loader.Loader.getResultSet(Loader.java:1787) at org.hibernate.loader.Loader.doQuery(Loader.java:674) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.j= ava:236) at org.hibernate.loader.Loader.doList(Loader.java:2220) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104) at org.hibernate.loader.Loader.list(Loader.java:2099) at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1569) at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283) at com.chetu.carecloud.eorder.dao.daoImpl.LabOrderConnectivitiesDAOImpl.getCon= nectivityDetails(LabOrderConnectivitiesDAOImpl.java:34) at com.chetu.carecloud.eorder.StartEngine.startHL7GenerationProcess(StartEngin= e.java:66) at com.chetu.carecloud.eorder.ForwardRequest.run(LabOrderService.java:181) at java.lang.Thread.run(Thread.java:619) WARN [2012-04-30 14:18:27,612] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 57P01 ERROR [2012-04-30 14:18:27,612] org.hibernate.util.JDBCExceptionReporter - FATAL: terminating connection due to administrator command WARN [2012-04-30 14:18:27,612] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08006 ERROR [2012-04-30 14:18:27,612] org.hibernate.util.JDBCExceptionReporter - An I/O error occured while sending to the backend.
Re: BUG #6623: FATAL: terminating connection due to administrator command
From
"Kevin Grittner"
Date:
<mueena@chetu.com> wrote: > PostgreSQL version: 8.4.1 [sigh] Please apply the security and bug fixes which have accumulated over the last two-and-a-half years: http://www.postgresql.org/support/versioning/ > we are getting below error please advise: > org.postgresql.util.PSQLException: FATAL: terminating connection > due to administrator command What do you see in the PostgreSQL server log at the time of this disconnect? -Kevin