cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Javier Puerto <jpue...@gmail.com>
Subject Re: database connections used up by script?
Date Fri, 12 Oct 2012 12:04:11 GMT
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 <pjoseph@gmail.com>

> 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<users-unsubscribe@cocoon.apache.org>
> For additional commands, e-mail: users-help@cocoon.apache.org
>
>

Mime
View raw message