postgresql – Heroku Postgres：此连接已关闭

概述我开发了一个小型的Heroku Grails Postreg应用程序.部署后20分钟它会工作正常,之后我总是得到： This connection has been closed.. Stacktrace follows: Heroku/myapp- org.postgresql.util.PSQLException: This connection has been closed. Herok 我开发了一个小型的Heroku Grails Postreg应用程序.部署后20分钟它会工作正常,之后我总是得到：

This connection has been closed.. Stacktrace follows: Heroku/myapp- org.postgresql.util.PsqlException: This connection has been closed. Heroku/myapp- at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:837) Heroku/myapp- at org.postgresql.jdbc2.AbstractJdbc2Connection.getautoCommit(AbstractJdbc2Connection.java:798) Heroku/myapp- at org.grails.datastore.gorm.GormStaticAPI$_methodMissing_closure2.doCall(GormStaticAPI.groovy:102) Heroku/myapp- at com.myapp.WorkspaceController.List(WorkspaceController.groovy:18) Heroku/myapp- at grails.plugin.cache.web.filter.PageFragmentCachingFilter.doFilter(PageFragmentCachingFilter.java:198) Heroku/myapp- at grails.plugin.cache.web.filter.AbstractFilter.doFilter(AbstractFilter.java:63) Heroku/myapp- at grails.plugin.springsecurity.web.filter.GrailsAnonymousAuthenticationFilter.doFilter(GrailsAnonymousAuthenticationFilter.java:53) Heroku/myapp- at grails.plugin.springsecurity.web.authentication.RequestHolderAuthenticationFilter.doFilter(RequestHolderAuthenticationFilter.java:53) Heroku/myapp- at grails.plugin.springsecurity.web.authentication.logout.MutablelogoutFilter.doFilter(MutablelogoutFilter.java:62) Heroku/myapp- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) Heroku/myapp- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) Heroku/myapp- at java.lang.Thread.run(Thread.java:745) Heroku/myapp- 2015-08-07 15:11:10,685 [http-nio-20850-exec-5] ERROR spi.sqlExceptionHelper - This connection has been closed. Heroku/myapp- 2015-08-07 15:11:10,689 [http-nio-20850-exec-5] ERROR spi.sqlExceptionHelper - This connection has been closed. Heroku/myapp- 2015-08-07 15:11:10,696 [http-nio-20850-exec-5] ERROR errors.GrailsExceptionResolver - PsqlException occurred when processing request: [GET] /API/users/21/workspaces Heroku/myapp- This connection has been closed.. Stacktrace follows: Heroku/myapp

我已经通过将其添加到DataSource.groovy来解决它：

dataSource {    pooled = true    propertIEs {       maxActive = -1       minevictableIDleTimeMillis=1800000       timeBetweenevictionRunsMillis=1800000       numTestsPerevictionRun=3       testOnBorrow=true       testWhileIDle=true       testOnReturn=true       valIDationquery="SELECT 1"    }}

总结

以上是内存溢出为你收集整理的postgresql – Heroku Postgres：此连接已关闭全部内容，希望文章能够帮你解决postgresql – Heroku Postgres：此连接已关闭所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。