PSQLException: This ResultSet is closed: /home/Support/LabKey Support Forum

PSQLException: This ResultSet is closed

LabKey Support Forum (Inactive)

View Message

PSQLException: This ResultSet is closed

bront

2014-12-16 07:30

Status: Closed

hi,

I am seeing a repeated error on our development machine. It's happening about every minute or so.

ERROR Table 2014-12-16 10:21:58,540 DavCrawler : doFinally
org.postgresql.util.PSQLException: This ResultSet is closed.
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2852)
    at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getStatement(AbstractJdbc2ResultSet.java:623)
    at org.labkey.api.data.Table.doClose(Table.java:563)
    at org.labkey.api.data.JdbcCommand.close(JdbcCommand.java:62)
    at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:269)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:156)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:140)
    at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:135)
    at org.labkey.search.model.SavePaths.getPaths(SavePaths.java:308)
    at org.labkey.search.model.DavCrawler.findSomeWork(DavCrawler.java:529)
    at org.labkey.search.model.DavCrawler$1.run(DavCrawler.java:496)

We're running LabKey 14.3

Product Name PostgreSQL
Product Version 9.3.5
JDBC Driver Name PostgreSQL Native Driver
JDBC Driver Version PostgreSQL 9.3 JDBC4.1 (build 1102)

Any ideas?

thanks,

bront

jeckels responded:	2014-12-16 14:31
Hi Bront, The message itself is pretty harmless. I've got a change I'll commit for 15.1 that should eliminate it. However, reading over the code, I don't see how the ResultSet could be doubly-closed. Are you getting any other warnings or errors in your log file? Thanks, Josh

bront responded:	2014-12-16 14:48
That's good to know that it's relatively harmless. It's still cropping up every minute or so. I am seeing a few other errors that seem along the same lines, but nothing that gives a clue about the doubly-closed issue. thanks, bront ERROR Table 2014-12-16 10:20:49,152 Module Starter : doFinally org.postgresql.util.PSQLException: This ResultSet is closed. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2852) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getStatement(AbstractJdbc2ResultSet.java:623) at org.labkey.api.data.Table.doClose(Table.java:563) at org.labkey.api.data.JdbcCommand.close(JdbcCommand.java:62) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:269) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:156) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:140) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:135) at org.labkey.core.dialect.PostgreSql84Dialect.purgeTempSchema(PostgreSql84Dialect.java:1298) at org.labkey.api.data.TempTableTracker.purgeTempSchema(TempTableTracker.java:200) at org.labkey.api.data.TempTableTracker.init(TempTableTracker.java:86) at org.labkey.core.CoreModule.startupAfterSpringConfig(CoreModule.java:586) at org.labkey.api.module.SpringModule.doStartup(SpringModule.java:113) at org.labkey.api.module.DefaultModule.startup(DefaultModule.java:265) at org.labkey.api.module.ModuleLoader.completeStartup(ModuleLoader.java:1214) at org.labkey.api.module.ModuleLoader.access$200(ModuleLoader.java:119) at org.labkey.api.module.ModuleLoader$2.run(ModuleLoader.java:1177) ERROR Table 2014-12-16 17:07:43,932 ajp-bio-8009-exec-1 : doFinally org.postgresql.util.PSQLException: This ResultSet is closed. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2ResultSet.java:2852) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getStatement(AbstractJdbc2ResultSet.java:623) at org.labkey.api.data.Table.doClose(Table.java:563) at org.labkey.api.data.JdbcCommand.close(JdbcCommand.java:62) at org.labkey.api.data.BaseSelector.handleResultSet(BaseSelector.java:269) at org.labkey.api.data.SqlExecutingSelector.getResultSet(SqlExecutingSelector.java:109) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:274) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:257) at org.labkey.api.data.TableSelector.getResults(TableSelector.java:252) at org.labkey.api.data.DataRegion.initDetailsResultSet(DataRegion.java:1676) at org.labkey.api.data.DataRegion.renderDetails(DataRegion.java:1606) at org.labkey.api.data.DataRegion.render(DataRegion.java:2414) at org.labkey.api.view.DetailsView._renderDataRegion(DetailsView.java:65) at org.labkey.api.view.DataView.renderView(DataView.java:179) at org.labkey.api.view.DataView.renderView(DataView.java:54) at org.labkey.api.view.WebPartView.renderView(WebPartView.java:978) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:382) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:515) at org.labkey.api.view.HttpView.include(HttpView.java:492) at org.labkey.api.view.HttpView.include(HttpView.java:480) at org.labkey.api.view.VBox.renderView(VBox.java:79) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:382) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.view.HttpView.include(HttpView.java:515) at org.labkey.api.view.HttpView.include(HttpView.java:492) at org.labkey.jsp.compiled.org.labkey.api.view.template.CommonTemplate_jsp._jspService(CommonTemplate_jsp.java:213) at org.labkey.api.view.JspView.renderView(JspView.java:141) at org.labkey.api.view.WebPartView.renderInternal(WebPartView.java:382) at org.labkey.api.view.HttpView.render(HttpView.java:137) at org.labkey.api.view.HttpView.render(HttpView.java:122) at org.labkey.api.action.SpringActionController.renderInTemplate(SpringActionController.java:504) at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:399) at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1050) at org.labkey.api.view.ViewServlet._service(ViewServlet.java:190) at org.labkey.api.view.ViewServlet.service(ViewServlet.java:123) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:1049) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:182) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:193) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)