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>
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.enterpr
> 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.setSocketOptio
> 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.handleConnecti
> on
> (SelectorThread.java:1439)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.doSelect(Selec
> to
> rThread.java:1350)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.startListener(
> Se
> lectorThread.java:1284)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.startEndpoint(
> Se
> lectorThread.java:1247)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.run(SelectorTh
> re
> ad.java:1223)
> |#]
>
> [#|2009-01-06T12:11:30.661+0000|WARNING|sun-appserver9.1|javax.enterpr
> is e.system.container.web|_ThreadID=37;_ThreadName=SelectorThre
> ad-80;_RequestID=6efe8a2e-b43c-4340-a67d-35366516a5a8;|setReuseAddress
> 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.setSocketOptio
> 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.handleConnecti
> on
> (SelectorThread.java:1439)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.doSelect(Selec
> to
> rThread.java:1350)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.startListener(
> Se
> lectorThread.java:1284)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.startEndpoint(
> Se
> lectorThread.java:1247)
> at
> com.sun.enterprise.web.connector.grizzly.SelectorThread.run(SelectorTh
> re
> ad.java:1223)
> |#]
>
> [#|2009-01-06T12:11:31.928+0000|WARNING|sun-appserver9.1|javax.enterpr
> 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.enterpr
> 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.enterpr
> 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;|RAR5114
:
> 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.enterpr
> 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;|RAR5114
:
> 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_disclaimer
.
> 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