Hi Paul, Your pool is configured to max 200 connections. Is your postgres configured to support this quantity? (by default is 100). The error is thrown by postgres itself so I suspect that's could be the cause. See http://www.postgresql.org/docs/8.1/static/runtime-config-connection.html
Salu2 2012/10/12 Paul Joseph <[email protected]> > Hi there, > > I've supported a Cocoon application for many years now but yesterday a new > problem was reported that I haven't' seen before. > > The customer was doing something relatively unusual---using a script to > read a spreadsheet and automatically fill in a Cocoon CForm and then save > data in a plain old database table. > > The error is as shown below. Not sure what setting to use for my > connection-pool in the jdbc-connection-descriptor (below). > > > <jdbc-connection-descriptor > > jcd-alias="WebStore" > default-connection="true" > platform="PostgreSQL" > jdbc-level="3.0" > driver="org.postgresql.Driver" > protocol="jdbc" > subprotocol="postgresql" > dbalias="//localhost:5432/**WebStore" > username="*****" > eager-release="false" > batch-mode="false"> > > <connection-pool maxActive="200" validationQuery="" /> > <sequence-manager > className="org.apache.ojb.**broker.util.sequence.**SequenceManagerNextValImpl" > /> > > </jdbc-connection-descriptor> > > Other than that it is Cocoon 2.1 using Java6 in Tomcat 7.x and Postgresql > 9.1 with a JDBC 3.0 driver. > The actual error is shown below. > > brgds > Paul > > NFO: Server startup in 5045 ms > org.postgresql.util.**PSQLException: FATAL: sorry, too many clients > already > at org.postgresql.core.v3.**ConnectionFactoryImpl.** > readStartupMessages(**ConnectionFactoryImpl.java:**464) > at org.postgresql.core.v3.**ConnectionFactoryImpl.** > openConnectionImpl(**ConnectionFactoryImpl.java:**112) > at org.postgresql.core.**ConnectionFactory.**openConnection(** > ConnectionFactory.java:66) > at org.postgresql.jdbc2.**AbstractJdbc2Connection.<init>** > (AbstractJdbc2Connection.java:**125) > at org.postgresql.jdbc3.**AbstractJdbc3Connection.<init>** > (AbstractJdbc3Connection.java:**30) > at org.postgresql.jdbc3.**Jdbc3Connection.<init>(** > Jdbc3Connection.java:24) > at org.postgresql.Driver.**makeConnection(Driver.java:**393) > at org.postgresql.Driver.connect(**Driver.java:267) > at java.sql.DriverManager.**getConnection(Unknown Source) > at java.sql.DriverManager.**getConnection(Unknown Source) > at org.apache.cocoon.ojb.samples.**SuperDAO.getConnection(** > SuperDAO.java:302) > at org.apache.cocoon.ojb.samples.**SuperDAO.getMaxValue(SuperDAO.** > java:459) > at sun.reflect.**GeneratedMethodAccessor126.**invoke(Unknown Source) > at sun.reflect.**DelegatingMethodAccessorImpl.**invoke(Unknown Source) > at java.lang.reflect.Method.**invoke(Unknown Source) > at org.mozilla.javascript.**NativeJavaMethod.call(** > NativeJavaMethod.java:230) > at org.mozilla.javascript.**ScriptRuntime.call(** > ScriptRuntime.java:1244) > at org.mozilla.javascript.**continuations.**ContinuationInterpreter.** > interpret(**ContinuationInterpreter.java:**1134) > at org.mozilla.javascript.**continuations.**ContinuationInterpreter.** > interpret(**ContinuationInterpreter.java:**190) > at org.mozilla.javascript.**continuations.**ContinuationInterpreter.** > interpret(**ContinuationInterpreter.java:**138) > at org.mozilla.javascript.**continuations.** > InterpretedFunctionImpl.call(**InterpretedFunctionImpl.java:**121) > at org.mozilla.javascript.**ScriptRuntime.call(** > ScriptRuntime.java:1244) > at org.mozilla.javascript.**ScriptableObject.callMethod(** > ScriptableObject.java:1591) > at org.apache.cocoon.components.**flow.javascript.fom.FOM_** > JavaScriptInterpreter.**handleContinuation(FOM_** > JavaScriptInterpreter.java:**841) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > CallFunctionNode.invoke(**CallFunctionNode.java:124) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:47) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MatchNode.invoke(MatchNode.**java:108) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelineNode.invoke(**PipelineNode.java:143) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelinesNode.invoke(**PipelinesNode.java:93) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**235) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**177) > at org.apache.cocoon.components.**treeprocessor.TreeProcessor.** > process(TreeProcessor.java:**254) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MountNode.invoke(MountNode.**java:118) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:47) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MatchNode.invoke(MatchNode.**java:108) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelineNode.invoke(**PipelineNode.java:143) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelinesNode.invoke(**PipelinesNode.java:93) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**235) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**177) > at org.apache.cocoon.components.**treeprocessor.TreeProcessor.** > process(TreeProcessor.java:**254) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MountNode.invoke(MountNode.**java:118) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:47) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MatchNode.invoke(MatchNode.**java:108) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelineNode.invoke(**PipelineNode.java:143) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelinesNode.invoke(**PipelinesNode.java:93) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**235) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**177) > at org.apache.cocoon.components.**treeprocessor.TreeProcessor.** > process(TreeProcessor.java:**254) > at org.apache.cocoon.Cocoon.**process(Cocoon.java:699) > at org.apache.cocoon.servlet.**CocoonServlet.service(** > CocoonServlet.java:1154) > at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:722) > at org.apache.catalina.core.**ApplicationFilterChain.** > internalDoFilter(**ApplicationFilterChain.java:**305) > at org.apache.catalina.core.**ApplicationFilterChain.**doFilter(** > ApplicationFilterChain.java:**210) > at org.apache.catalina.core.**StandardWrapperValve.invoke(** > StandardWrapperValve.java:224) > at org.apache.catalina.core.**StandardContextValve.invoke(** > StandardContextValve.java:169) > at org.apache.catalina.**authenticator.**AuthenticatorBase.invoke(** > AuthenticatorBase.java:472) > at org.apache.catalina.core.**StandardHostValve.invoke(** > StandardHostValve.java:168) > at org.apache.catalina.valves.**ErrorReportValve.invoke(** > ErrorReportValve.java:98) > at org.apache.catalina.valves.**AccessLogValve.invoke(** > AccessLogValve.java:927) > at org.apache.catalina.core.**StandardEngineValve.invoke(** > StandardEngineValve.java:118) > at org.apache.catalina.connector.**CoyoteAdapter.service(** > CoyoteAdapter.java:407) > at org.apache.coyote.http11.**AbstractHttp11Processor.**process(** > AbstractHttp11Processor.java:**987) > at org.apache.coyote.**AbstractProtocol$**AbstractConnectionHandler.** > process(AbstractProtocol.java:**579) > at org.apache.tomcat.util.net.**JIoEndpoint$SocketProcessor.** > run(JIoEndpoint.java:309) > at java.util.concurrent.**ThreadPoolExecutor$Worker.**runTask(Unknown > Source) > at java.util.concurrent.**ThreadPoolExecutor$Worker.run(**Unknown > Source) > at java.lang.Thread.run(Unknown Source) > org.postgresql.util.**PSQLException: FATAL: sorry, too many clients > already > at org.postgresql.core.v3.**ConnectionFactoryImpl.** > readStartupMessages(**ConnectionFactoryImpl.java:**464) > at org.postgresql.core.v3.**ConnectionFactoryImpl.** > openConnectionImpl(**ConnectionFactoryImpl.java:**112) > at org.postgresql.core.**ConnectionFactory.**openConnection(** > ConnectionFactory.java:66) > at org.postgresql.jdbc2.**AbstractJdbc2Connection.<init>** > (AbstractJdbc2Connection.java:**125) > at org.postgresql.jdbc3.**AbstractJdbc3Connection.<init>** > (AbstractJdbc3Connection.java:**30) > at org.postgresql.jdbc3.**Jdbc3Connection.<init>(** > Jdbc3Connection.java:24) > at org.postgresql.Driver.**makeConnection(Driver.java:**393) > at org.postgresql.Driver.connect(**Driver.java:267) > at java.sql.DriverManager.**getConnection(Unknown Source) > at java.sql.DriverManager.**getConnection(Unknown Source) > at org.apache.cocoon.ojb.samples.**SuperDAO.getConnection(** > SuperDAO.java:302) > at org.apache.cocoon.ojb.samples.**SuperDAO.getMaxValue(SuperDAO.** > java:459) > at sun.reflect.**GeneratedMethodAccessor126.**invoke(Unknown Source) > at sun.reflect.**DelegatingMethodAccessorImpl.**invoke(Unknown Source) > at java.lang.reflect.Method.**invoke(Unknown Source) > at org.mozilla.javascript.**NativeJavaMethod.call(** > NativeJavaMethod.java:230) > at org.mozilla.javascript.**ScriptRuntime.call(** > ScriptRuntime.java:1244) > at org.mozilla.javascript.**continuations.**ContinuationInterpreter.** > interpret(**ContinuationInterpreter.java:**1134) > at org.mozilla.javascript.**continuations.**ContinuationInterpreter.** > interpret(**ContinuationInterpreter.java:**190) > at org.mozilla.javascript.**continuations.**ContinuationInterpreter.** > interpret(**ContinuationInterpreter.java:**138) > at org.mozilla.javascript.**continuations.** > InterpretedFunctionImpl.call(**InterpretedFunctionImpl.java:**121) > at org.mozilla.javascript.**ScriptRuntime.call(** > ScriptRuntime.java:1244) > at org.mozilla.javascript.**ScriptableObject.callMethod(** > ScriptableObject.java:1591) > at org.apache.cocoon.components.**flow.javascript.fom.FOM_** > JavaScriptInterpreter.**handleContinuation(FOM_** > JavaScriptInterpreter.java:**841) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > CallFunctionNode.invoke(**CallFunctionNode.java:124) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:47) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MatchNode.invoke(MatchNode.**java:108) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelineNode.invoke(**PipelineNode.java:143) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelinesNode.invoke(**PipelinesNode.java:93) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**235) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**177) > at org.apache.cocoon.components.**treeprocessor.TreeProcessor.** > process(TreeProcessor.java:**254) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MountNode.invoke(MountNode.**java:118) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:47) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MatchNode.invoke(MatchNode.**java:108) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelineNode.invoke(**PipelineNode.java:143) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelinesNode.invoke(**PipelinesNode.java:93) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**235) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**177) > at org.apache.cocoon.components.**treeprocessor.TreeProcessor.** > process(TreeProcessor.java:**254) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MountNode.invoke(MountNode.**java:118) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:47) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > MatchNode.invoke(MatchNode.**java:108) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelineNode.invoke(**PipelineNode.java:143) > at org.apache.cocoon.components.**treeprocessor.** > AbstractParentProcessingNode.**invokeNodes(**AbstractParentProcessingNode. > **java:69) > at org.apache.cocoon.components.**treeprocessor.sitemap.** > PipelinesNode.invoke(**PipelinesNode.java:93) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**235) > at org.apache.cocoon.components.**treeprocessor.** > ConcreteTreeProcessor.process(**ConcreteTreeProcessor.java:**177) > at org.apache.cocoon.components.**treeprocessor.TreeProcessor.** > process(TreeProcessor.java:**254) > at org.apache.cocoon.Cocoon.**process(Cocoon.java:699) > at org.apache.cocoon.servlet.**CocoonServlet.service(** > CocoonServlet.java:1154) > at javax.servlet.http.**HttpServlet.service(**HttpServlet.java:722) > at org.apache.catalina.core.**ApplicationFilterChain.** > internalDoFilter(**ApplicationFilterChain.java:**305) > at org.apache.catalina.core.**ApplicationFilterChain.**doFilter(** > ApplicationFilterChain.java:**210) > at org.apache.catalina.core.**StandardWrapperValve.invoke(** > StandardWrapperValve.java:224) > at org.apache.catalina.core.**StandardContextValve.invoke(** > StandardContextValve.java:169) > at org.apache.catalina.**authenticator.**AuthenticatorBase.invoke(** > AuthenticatorBase.java:472) > at org.apache.catalina.core.**StandardHostValve.invoke(** > StandardHostValve.java:168) > at org.apache.catalina.valves.**ErrorReportValve.invoke(** > ErrorReportValve.java:98) > at org.apache.catalina.valves.**AccessLogValve.invoke(** > AccessLogValve.java:927) > at org.apache.catalina.core.**StandardEngineValve.invoke(** > StandardEngineValve.java:118) > at org.apache.catalina.connector.**CoyoteAdapter.service(** > CoyoteAdapter.java:407) > at org.apache.coyote.http11.**AbstractHttp11Processor.**process(** > AbstractHttp11Processor.java:**987) > at org.apache.coyote.**AbstractProtocol$**AbstractConnectionHandler.** > process(AbstractProtocol.java:**579) > at org.apache.tomcat.util.net.**JIoEndpoint$SocketProcessor.** > run(JIoEndpoint.java:309) > at java.util.concurrent.**ThreadPoolExecutor$Worker.**runTask(Unknown > Source) > at java.util.concurrent.**ThreadPoolExecutor$Worker.run(**Unknown > Source) > at java.lang.Thread.run(Unknown Source) > > > ------------------------------**------------------------------**--------- > To unsubscribe, e-mail: > users-unsubscribe@cocoon.**apache.org<[email protected]> > For additional commands, e-mail: [email protected] > >
