tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object
Date Fri, 16 Feb 2018 19:24:22 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

Arpan,

On 2/15/18 8:54 AM, Halder, Arpan [ITSUS Non J&J] wrote:
> We have already setup below parameters in jdbc-pool.html (see
> below) – could you please advise if we need to modify/add anything
> else here:
> 
> <p>And here is an example on how to configure a resource for JNDI
> lookups</p> <div class="codeBox"><pre><code>&lt;Resource
> name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource" 
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" 
> testWhileIdle="true" testOnBorrow="true" testOnReturn="false" 
> validationQuery="SELECT 1" validationInterval="30000" 
> timeBetweenEvictionRunsMillis="30000" maxActive="100" minIdle="10" 
> maxWait="10000" initialSize="10" removeAbandonedTimeout="60" 
> removeAbandoned="true" logAbandoned="true" 
> minEvictableIdleTimeMillis="30000" jmxEnabled="true" 
> jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionSt
ate;
>
> 
org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
> username="root" password="password" 
> driverClassName="com.mysql.jdbc.Driver" 
> url="jdbc:mysql://localhost:3306/mysql"/&gt;</code></pre></div>

Looks like you copy/pasted that from the Tomcat documentation. How
about copy/pasting your actual configuration (without any secrets, of
course) just in case there are any errors in your interpretation.

Are you sure you don't have capacity problems? If you have only e.g.
10 connections available but hundreds of users, perhaps you simply
need more connections. Are you sure the database is available and
reachable via the network?

Sometimes timeouts are simply a reality. But if you start to see
"timeout" errors and the database is NOT DOWN and still reachable, but
everything grinds to a halt, then you certainly have a resource problem.

I disagree with another poster about abandoned connections: do not
remove them. Log them and allow the pool to become exhausted. That
way, you'll end up finding and fixing the problems instead of just
continuing to bleed.

- -chris
-----BEGIN PGP SIGNATURE-----
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlqHL+YACgkQHPApP6U8
pFgbDxAAhmn6nD0edc0F/3eh3izdZ9KnV5sUAC/E5ubv/1tc+KiE/GPZUhiy/qSa
n4Am3KEhXmyee+ZcQFUg1PNqeZGgq/uLdppeZHG0Vsv0lYH/I1xBJMoluEpDzzQN
nnRFQEHCqlB+ujBP5G4bQGLRuh5fhwVRz9lktoQnwDybG/KjzTh56+SZmYXABSEn
JMFEbr6+ADafPVUiSmu8uMklenH5YXYMXiiB6dAXdtpP/SHAGxko05c0j1g+Snq1
WrM17qKpGI2qdQaXlfr8NChBuXrNQz8zj+2HJrNxzRLDa56GmVBq7tbvgwQwmdTb
r1vqW1sEl4l3y8fnUxFJlyoQixQ8wPKDQH7H8NPpMkts4SyRULqRwpJvp6/L+TYy
D8Ge2j+9uZCxUcccA0ds3E8j1r+FjtpU6w8Ut1ZJIb071JmtEDlvRTYyAEt0Q69w
3MJa0dA59DJ8l4/A2KzNuDhFYtkmuf1UmBHxw6qsfqsseqFD3AzDVcbirpxwNdIj
1mtbH91Fl+hSN4Ww4gGQLXjUfLf1o8MR0bkeLy5236k2UajuH1Jbvf8xCh6GlQoc
yp7PH61Kw5vb2M5Yjqg0C0OSgXspagYYATCM4Y2QTBATUrpLHTLYv679yKXCMPgq
wQlvIn4+jpxnFpB2fhY5ZWH0VdilWhXG8uhGz2FJCI9XhWUaAws=
=vd5m
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message