PostgreSQL on cloudfoundry throws PSQLException: FATAL: terminating connection due to administrator command

Question

I have a grails application successfully running in cloudfoundry with H2 as database. I now want to switch to postgresql. Everything works as expected when I run the application locally against postgreSQL. On the cloudfoundry instance I get an exception during one rather long running analysis, which I perform as a background task (using grails executor plugin). Within this asynchronous task ``` def future = executorService.submit({ return analysisService.analyzeProject(model, project) }) ``` I get the following exception from the database: ``` 2012-11-26 10:27:38,319 [pool-2-thread-1] ERROR interceptor.TransactionInterceptor - Application exception overridden by rollback exception org.springframework.dao.DataAccessResourceFailureException: Hibernate operation: could not execute query; SQL [select this_.id as id8_0_, this_.version as version8_0_, this_.language as language8_0_, this_.url as url8_0_ from sonar_adapter_configuration this_]; FATAL: terminating connection due to administra…

Accepted Answer

Chances are you are hitting the configured timeout for long running connections (which can't be changed if I'm not mistaken, as it is here to protect the server from ill formed queries that would consume all cpu/io)

What you may want to try is to slice your long running query into smaller queries and sum up the results (if it's a select)

PostgreSQL on cloudfoundry throws PSQLException: FATAL: terminating connection due to administrator command

Solution

Problem