pooling, datacontext problem?

From: martin ruff (mruf..imeon.ch)
Date: Sun May 04 2003 - 08:53:43 EDT

Next message: Andrus Adamchik: "Re: pooling, datacontext problem?"

Previous message: Laszlo Spoor: "[question] Multiple flattened relationships in a single SelectQuery"
Next in thread: Andrus Adamchik: "Re: pooling, datacontext problem?"
Reply: Andrus Adamchik: "Re: pooling, datacontext problem?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hi I've got a wep application,
I have a menu point to show the user a overview of some kind
the code that is executed when the user clicks the button creates a new
datacontext (resetReusedCayenneDataContext(..) is called when the user
clicks):
        public static DataContext getNewCayenneDataContext(ServletContext
theContext)
        {
                ServletConfiguration conf = new ServletConfiguration();
             conf.setServletContext(theContext);
             Configuration.initSharedConfig(conf);
             return conf.getDomain().createDataContext();
        }

        public static void resetReusedCayenneDataContext(HttpServletRequest
request)
        {
                request.getSession().setAttribute(DATA_CONTEXT_KEY,
getNewCayenneDataContext(request));
        }

If now, I click very often, the I get:
WARN RuntimeLoadDelegate: Started configuration loading.
WARN RuntimeLoadDelegate: loaded domain: Reporting
WARN RuntimeLoadDelegate: loaded <map name='datamap'
location='datamap.map.xml'>.
WARN RuntimeLoadDelegate: loading <node name='datanode'
datasource='datanode.driver.xml'
factory='org.objectstyle.cayenne.conf.DriverDataSourceFactory'>.
WARN RuntimeLoadDelegate: using factory:
org.objectstyle.cayenne.conf.DriverDataSourceFactory
WARN DriverDataSourceFactory: loading driver information from
(datanode.driver.xml).
WARN DriverDataSourceFactory: location found in filesystem.
WARN DriverDataSourceFactory: loading driver org.postgresql.Driver
WARN DriverDataSourceFactory: loading user name and password.
WARN QueryLogger: Connecting. DataSource information:
Driver class: org.postgresql.Driver
Min. Pool Size: 1
Max. Pool Size: 30
Database URL: jdbc:postgresql:reporting
Login: mruff
Password: *******
WARN QueryLogger: *** Connecting: FAILURE.
Something unusual has occured to cause the driver to fail. Please report
this exception: Exception: java.sql.SQLException: FATAL: Sorry, too
many clients already

Stack Trace:

java.sql.SQLException: FATAL: Sorry, too many clients already

        at org.postgresql.Connection.openConnection(Connection.java:274)
        at org.postgresql.Driver.connect(Driver.java:149)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.objectstyle.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:95)
        at
org.objectstyle.cayenne.conn.PoolDataSource.getPooledConnection(PoolDataSource.java:114)
        at
org.objectstyle.cayenne.conn.PoolManager.newPooledConnection(PoolManager.java:196)
        at org.objectstyle.cayenne.conn.PoolManager.growPool(PoolManager.java:242)
        at org.objectstyle.cayenne.conn.PoolManager.init(PoolManager.java:190)
        at org.objectstyle.cayenne.conn.PoolManager.<init>(PoolManager.java:132)
        at
org.objectstyle.cayenne.conf.DriverDataSourceFactory.getDataSource(DriverDataSourceFactory.java:139)
        at
org.objectstyle.cayenne.conf.RuntimeLoadDelegate.shouldLoadDataNode(RuntimeLoadDelegate.java:291)
        at
org.objectstyle.cayenne.conf.ConfigLoader$NodeHandler.init(ConfigLoader.java:301)
        at
org.objectstyle.cayenne.conf.ConfigLoader$DomainHandler.startElement(ConfigLoader.java:227)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
        at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
        at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
        at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
        at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
        at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
        at
org.objectstyle.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:117)
        at org.objectstyle.cayenne.conf.Configuration.init(Configuration.java:260)
        at
org.objectstyle.cayenne.conf.Configuration.initSharedConfig(Configuration.java:214)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.getNewCayenneDataContext(CayenneDateContextFactory.java:32)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.getNewCayenneDataContext(CayenneDateContextFactory.java:25)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.resetReusedCayenneDataContext(CayenneDateContextFactory.java:38)
        at
com.infometis.reporting.action.ShowReportSummaryActionWithFiltersSet.reportingExecute(ShowReportSummaryActionWithFiltersSet.java:44)
        at
com.infometis.reporting.action.ReportingBaseAction.execute(ReportingBaseAction.java:28)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
        at
com.infometis.reporting.application.ReportingRequestProcessor.process(ReportingRequestProcessor.java:35)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
        at java.lang.Thread.run(Thread.java:536)
End of Stack Trace

Stack Trace:

java.sql.SQLException: FATAL: Sorry, too many clients already

        at org.postgresql.Driver.connect(Driver.java:166)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at
org.objectstyle.cayenne.conn.DriverDataSource.getConnection(DriverDataSource.java:95)
        at
org.objectstyle.cayenne.conn.PoolDataSource.getPooledConnection(PoolDataSource.java:114)
        at
org.objectstyle.cayenne.conn.PoolManager.newPooledConnection(PoolManager.java:196)
        at org.objectstyle.cayenne.conn.PoolManager.growPool(PoolManager.java:242)
        at org.objectstyle.cayenne.conn.PoolManager.init(PoolManager.java:190)
        at org.objectstyle.cayenne.conn.PoolManager.<init>(PoolManager.java:132)
        at
org.objectstyle.cayenne.conf.DriverDataSourceFactory.getDataSource(DriverDataSourceFactory.java:139)
        at
org.objectstyle.cayenne.conf.RuntimeLoadDelegate.shouldLoadDataNode(RuntimeLoadDelegate.java:291)
        at
org.objectstyle.cayenne.conf.ConfigLoader$NodeHandler.init(ConfigLoader.java:301)
        at
org.objectstyle.cayenne.conf.ConfigLoader$DomainHandler.startElement(ConfigLoader.java:227)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1488)
        at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
        at org.apache.crimson.parser.Parser2.content(Parser2.java:1779)
        at org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1507)
        at org.apache.crimson.parser.Parser2.parseInternal(Parser2.java:500)
        at org.apache.crimson.parser.Parser2.parse(Parser2.java:305)
        at org.apache.crimson.parser.XMLReaderImpl.parse(XMLReaderImpl.java:442)
        at
org.objectstyle.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:117)
        at org.objectstyle.cayenne.conf.Configuration.init(Configuration.java:260)
        at
org.objectstyle.cayenne.conf.Configuration.initSharedConfig(Configuration.java:214)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.getNewCayenneDataContext(CayenneDateContextFactory.java:32)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.getNewCayenneDataContext(CayenneDateContextFactory.java:25)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.resetReusedCayenneDataContext(CayenneDateContextFactory.java:38)
        at
com.infometis.reporting.action.ShowReportSummaryActionWithFiltersSet.reportingExecute(ShowReportSummaryActionWithFiltersSet.java:44)
        at
com.infometis.reporting.action.ReportingBaseAction.execute(ReportingBaseAction.java:28)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
        at
com.infometis.reporting.application.ReportingRequestProcessor.process(ReportingRequestProcessor.java:35)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
        at java.lang.Thread.run(Thread.java:536)
WARN RuntimeLoadDelegate: loaded map-ref: datamap.
ERROR Configuration: Error initializing shared Configuration
org.objectstyle.cayenne.ConfigException:
[org.objectstyle.cayenne.conf.ServletConfiguration] : Failed to load
domain and/or its maps/nodes.
        at
org.objectstyle.cayenne.conf.RuntimeLoadDelegate.finishedLoading(RuntimeLoadDelegate.java:419)
        at
org.objectstyle.cayenne.conf.ConfigLoader.loadDomains(ConfigLoader.java:118)
        at org.objectstyle.cayenne.conf.Configuration.init(Configuration.java:260)
        at
org.objectstyle.cayenne.conf.Configuration.initSharedConfig(Configuration.java:214)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.getNewCayenneDataContext(CayenneDateContextFactory.java:32)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.getNewCayenneDataContext(CayenneDateContextFactory.java:25)
        at
com.infometis.reporting.db.factory.CayenneDateContextFactory.resetReusedCayenneDataContext(CayenneDateContextFactory.java:38)
        at
com.infometis.reporting.action.ShowReportSummaryActionWithFiltersSet.reportingExecute(ShowReportSummaryActionWithFiltersSet.java:44)
        at
com.infometis.reporting.action.ReportingBaseAction.execute(ReportingBaseAction.java:28)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
        at
com.infometis.reporting.application.ReportingRequestProcessor.process(ReportingRequestProcessor.java:35)
        at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
        at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
        at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:405)
        at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:380)
        at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:508)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:533)
        at java.lang.Thread.run(Thread.java:536)
WARN RequestProcessor: Unhandled Exception thrown: class
java.lang.RuntimeException

and after that NO recovery is possible, so how can I solve this?
Do I have to make a explizit call on the old datacontext before I create
the new one, so that it can internally free the connection resource an
give it back to the pool? (i.e. close it?)

thanks for help
martin

Next message: Andrus Adamchik: "Re: pooling, datacontext problem?"
Previous message: Laszlo Spoor: "[question] Multiple flattened relationships in a single SelectQuery"
Next in thread: Andrus Adamchik: "Re: pooling, datacontext problem?"
Reply: Andrus Adamchik: "Re: pooling, datacontext problem?"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Sun May 04 2003 - 08:50:10 EDT