Hi Rishi,
* Do you have a test case to reproduce the issue ?
https://glassfish.dev.java.net/issues/show_bug.cgi?id=3279
indicated in the forum thread you have posted is fixed in 9.1 b 56 (Its
not actually a leak)
* what is the version & build of your GlassFish (asadmin version
--verbose) ?
* can you post the leak stack trace from your server.log ?
* What type of application are you using (Web / EJB ) ?
Thanks,
-Jagadish
On Tue, 2009-01-13 at 10:20 +0000, Chopra, Rishi wrote:
> Hi,
>
> After setting the leak reclaim on its saying that there is a potential
> connection leak from with the application.
>
> There are code bits that exist in the system that may be causing this
> issue.
>
> Connection con1 = DbSource.getConnection(); --- on this setAutocommit is
> false [ This one set the chained mode on, therefore is used for calling
> the procedures in the chained mode ]
>
> Connection con2 = DbSource.getConnection(); --- on this setAutocommit is
> true
>
> I was going through this article and seems that my problem has been
> occuring due to this
>
> http://forums.java.net/jive/message.jspa?messageID=224047
>
> Any suggestions.. Struck for a long time on this.
>
> Thanks & Regards,
> Rishi Chopra.
>
> -----Original Message-----
> From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> Sent: 06 January 2009 17:22
> To: Chopra, Rishi
> Cc: users_at_glassfish.dev.java.net
> Subject: RE: Re: FW: Glassfish Problem
>
>
>
> On Tue, 2009-01-06 at 16:53 +0000, Chopra, Rishi wrote:
> > Hi,
> >
> > 1) Pool configuration is as below :
> > <jdbc-connection-pool allow-non-component-callers="false"
> > associate-with-thread="false" connection-creation-retry-attempts="0"
> > connection-creation-retry-interval-in-seconds="10"
> > connection-leak-reclaim="true"
> connection-leak-timeout-in-seconds="120"
> > connection-validation-method="auto-commit"
> > datasource-classname="com.sybase.jdbc3.jdbc.SybDataSource"
> > fail-all-connections="false" idle-timeout-in-seconds="300"
> > is-connection-validation-required="false"
> > is-isolation-level-guaranteed="false"
> > lazy-connection-association="false" lazy-connection-enlistment="false"
> > match-connections="false" max-connection-usage-count="0"
> > max-pool-size="75" max-wait-time-in-millis="60000"
> > name="ARP3_SybaseConnectionPool" non-transactional-connections="false"
> > pool-resize-quantity="10" res-type="javax.sql.DataSource"
> > statement-timeout-in-seconds="-1" steady-pool-size="10"
> > validate-atmost-once-period-in-seconds="0" wrap-jdbc-objects="false">
> > <description>Primary Connection Pool</description>
> > <property name="datasourceName" value="ARP3_SybDataSource"/>
> > <property name="user" value="ABCDEF"/>
> > <property name="password" value="XXXXX"/>
> > <property name="networkProtocol" value="Tds"/>
> > <property name="portNumber" value="9000"/>
> > <property name="databaseName" value="YYYYY"/>
> > <property name="serverName" value="sybukarprd01"/>
> > </jdbc-connection-pool>
> Steady pool size : 10
> Max pool size : 75
>
> There are two reasons why the pool complains that there are no more
> connections to provide.
> 1) load to the pool is such that all 75 connections are given to
> applications and new requests could not get a connection in a "wait time
> period" of 60 seconds or
> 2) connections are leaked. Do you see any leak trace in server.log ?
> [Though I see leak-reclaim is ON]
>
> Thanks
> -Jagadish
> >
> > 2) I don't think so because the application did not reported this
> > issue when it was on Weblogic...
> >
> > This issue has come up only after the migration to glassfish...the
> > application still runs fine on weblogic.
> >
> >
> > Thanks & Regards,
> > Rishi Chopra.
> >
> > -----Original Message-----
> > From: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> > Sent: 06 January 2009 16:01
> > To: users_at_glassfish.dev.java.net
> > Subject: Re: FW: Glassfish Problem
> >
> > I am not sure whether the two set of logs (grizzly & connection pool)
> > are related.
> >
> > w.r.t SybaseConnectionPool :
> > * Can you provide your pool configuration from domain.xml ?
> > * Is it possible that the connections are leaked by your application
> > as there are no more connections left in the pool ?
> > You can refer :
> > http://blogs.sun.com/kshitiz/entry/connection_leak_tracing
> > for using leak tracing feature.
> >
> > Thanks,
> > -Jagadish
> >
> >
> >
> > On Tue, 2009-01-06 at 14:48 +0000, Chopra, Rishi wrote:
> > > I have another issue with the connection pool which throws me an
> > > exception and does not allow me reconnect to the app unless the
> > > server
> >
> > > is restarted.
> > > Could you please help ???
> > >
> > > Error Log is mentioned below :
> > >
> > >
> > > [#|2009-01-06T12:11:30.660+0000|WARNING|sun-appserver9.1|javax.enter
> > > pr is e.system.container.web|_ThreadID=37;_ThreadName=SelectorThre
> > > ad-80;_RequestID=6efe8a2e-b43c-4340-a67d-35366516a5a8;|setTcpNoDelay
> > > exception
> > > java.net.SocketException: Invalid argument
> > > at sun.nio.ch.Net.setIntOption0(Native Method)
> > > at sun.nio.ch.Net.setIntOption(Net.java:154)
> > > at
> > > sun.nio.ch.SocketChannelImpl$1.setInt(SocketChannelImpl.java:406)
> > > at
> > sun.nio.ch.SocketOptsImpl.setBoolean(SocketOptsImpl.java:38)
> > > at
> > > sun.nio.ch.SocketOptsImpl$IP$TCP.noDelay(SocketOptsImpl.java:284)
> > > at
> > sun.nio.ch.OptionAdaptor.setTcpNoDelay(OptionAdaptor.java:48)
> > > at
> > > sun.nio.ch.SocketAdaptor.setTcpNoDelay(SocketAdaptor.java:268)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.setSocketOpt
> > > io
> > > ns
> > > (SelectorThread.java:1902)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.handleAccept
> > > (S
> > > el
> > > ectorThread.java:1475)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.handleConnec
> > > ti
> > > on
> > > (SelectorThread.java:1439)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.doSelect(Sel
> > > ec
> > > to
> > > rThread.java:1350)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.startListene
> > > r(
> > > Se
> > > lectorThread.java:1284)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.startEndpoin
> > > t(
> > > Se
> > > lectorThread.java:1247)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.run(Selector
> > > Th
> > > re
> > > ad.java:1223)
> > > |#]
> > >
> > > [#|2009-01-06T12:11:30.661+0000|WARNING|sun-appserver9.1|javax.enter
> > > pr is e.system.container.web|_ThreadID=37;_ThreadName=SelectorThre
> > > ad-80;_RequestID=6efe8a2e-b43c-4340-a67d-35366516a5a8;|setReuseAddre
> > > ss
> > > exception
> > > java.net.SocketException: Invalid argument
> > > at sun.nio.ch.Net.setIntOption0(Native Method)
> > > at sun.nio.ch.Net.setIntOption(Net.java:154)
> > > at
> > > sun.nio.ch.SocketChannelImpl$1.setInt(SocketChannelImpl.java:406)
> > > at
> > sun.nio.ch.SocketOptsImpl.setBoolean(SocketOptsImpl.java:38)
> > > at
> > > sun.nio.ch.SocketOptsImpl.reuseAddress(SocketOptsImpl.java:156)
> > > at
> > >
> sun.nio.ch.SocketOptsImpl$IP$TCP.reuseAddress(SocketOptsImpl.java:268)
> > > at
> > > sun.nio.ch.OptionAdaptor.setReuseAddress(OptionAdaptor.java:177)
> > > at
> > > sun.nio.ch.SocketAdaptor.setReuseAddress(SocketAdaptor.java:343)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.setSocketOpt
> > > io
> > > ns
> > > (SelectorThread.java:1910)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.handleAccept
> > > (S
> > > el
> > > ectorThread.java:1475)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.handleConnec
> > > ti
> > > on
> > > (SelectorThread.java:1439)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.doSelect(Sel
> > > ec
> > > to
> > > rThread.java:1350)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.startListene
> > > r(
> > > Se
> > > lectorThread.java:1284)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.startEndpoin
> > > t(
> > > Se
> > > lectorThread.java:1247)
> > > at
> > > com.sun.enterprise.web.connector.grizzly.SelectorThread.run(Selector
> > > Th
> > > re
> > > ad.java:1223)
> > > |#]
> > >
> > > [#|2009-01-06T12:11:31.928+0000|WARNING|sun-appserver9.1|javax.enter
> > > pr is e.resource.resourceadapter|_ThreadID=22;_ThreadName=httpWork
> > > erThread-80-6;ARP3_SybaseConnectionPool;In-use connections equal
> > > max-pool-size and expired max-wait-time. Cannot allocate more conne
> > > ctions.;_RequestID=1e35fcca-aa23-4ea6-9370-bf52d6f0a317;|RAR5117 :
> > > Failed to obtain/create connection from connection pool [ ARP3_Sy
> > > baseConnectionPool ]. Reason : In-use connections equal
> > > max-pool-size and expired max-wait-time. Cannot allocate more
> > > connections.|# ]
> > >
> > > [#|2009-01-06T12:11:31.928+0000|WARNING|sun-appserver9.1|javax.enter
> > > pr is e.resource.resourceadapter|_ThreadID=25;_ThreadName=httpWork
> > > erThread-80-9;ARP3_SybaseConnectionPool;In-use connections equal
> > > max-pool-size and expired max-wait-time. Cannot allocate more conne
> > > ctions.;_RequestID=74d7ffa2-cc14-4b01-b1f6-a869c6ea366d;|RAR5117 :
> > > Failed to obtain/create connection from connection pool [ ARP3_Sy
> > > baseConnectionPool ]. Reason : In-use connections equal
> > > max-pool-size and expired max-wait-time. Cannot allocate more
> > > connections.|# ]
> > >
> > > [#|2009-01-06T12:11:31.929+0000|WARNING|sun-appserver9.1|javax.enter
> > > pr is e.resource.resourceadapter|_ThreadID=22;_ThreadName=httpWork
> > > erThread-80-6;Error in allocating a connection. Cause: In-use
> > > connections equal max-pool-size and expired max-wait-time. Cannot
> > > allo
> >
> > > cate more
> > > connections.;_RequestID=1e35fcca-aa23-4ea6-9370-bf52d6f0a317;|RAR511
> > > 4
> > :
> > > Error allocating connection : [Error in allocating a connection.
> > > Cause: In-use connections equal max-pool-size and expired
> > > max-wait-time. Cannot allocate more connections.]|#]
> > >
> > > [#|2009-01-06T12:11:31.930+0000|WARNING|sun-appserver9.1|javax.enter
> > > pr is e.resource.resourceadapter|_ThreadID=25;_ThreadName=httpWork
> > > erThread-80-9;Error in allocating a connection. Cause: In-use
> > > connections equal max-pool-size and expired max-wait-time. Cannot
> > > allo
> >
> > > cate more
> > > connections.;_RequestID=74d7ffa2-cc14-4b01-b1f6-a869c6ea366d;|RAR511
> > > 4
> > :
> > > Error allocating connection : [Error in allocating a connection.
> > > Cause: In-use connections equal max-pool-size and expired
> > > max-wait-time. Cannot allocate more connections.]|#]
> > >
> > >
> > > Thanks & Regards,
> > > Rishi Chopra.
> > > http://www.bgcpartners.com
> > > CONFIDENTIAL: This e-mail has been sent to you by one of the BGC
> > > entities (collectively BGC) listed at the following link
> > http://www.bgcpartners.com/legal/disclaimers/index.html#email_disclaim
> > er
> > .
> > > The link contains company and FSA registration numbers. This e-mail,
>
> > > including its contents and attachments, if any, are confidential. If
>
> > > you are not the named recipient please notify the sender and
> > > immediately delete it. You may not disseminate, distribute, or
> > > forward
> >
> > > this e-mail message or disclose its contents to anybody else.
> > Copyright and any other intellectual property rights in its contents
> > are the sole property of BGC and its affiliates. E-mail transmission
> > cannot be guaranteed to be secure or error-free.
> > > The sender therefore does not accept liability for any errors or
> > > omissions in the contents of this message which arise as a result of
>
> > > e-mail transmission. If verification is required please request a
> > > hard-copy version. Although we routinely screen for viruses,
> > > addressees should check this e-mail and any attachments for viruses.
> > > We make no representation or warranty as to the absence of viruses
> > > in
> > this e-mail or any attachments. Please note that to ensure regulatory
> > compliance and for the protection of our customers and business, we
> > may monitor and read e-mails sent to and from our server(s).
> > > The registered offices of the BGC entities are at 1 Churchill Place,
> > London, E14 5RD.
> > > For any issues arising from this email please reply to the sender.
> > > The FSA register appears at http://www.fsa.gov.uk/register/.
> > > The FSA regulates the financial services industry in the United
> > > Kingdom and is located at
> > > 25 The North Colonnade, Canary Wharf, London, E14 5HS.
> > >
> > > --------------------------------------------------------------------
> > > - To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> > >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> > For additional commands, e-mail: users-help_at_glassfish.dev.java.net
> >
>