Hi Adrian,
Problem reoccured again for us last nite. We managed to get
listInUseConnections from CachedConnectionManager. Below is the output. It
shows only 4 connections . We haven't modified WeakHashMAp to HashMap. But in
use connections still have the first connection created (So I believe
anonymous wrote :
|
| The AvailableConnections is actually the number of permits available to
enter the pool.
| Its not necessarily the same thing as the checked out connections
| though it should be pretty similar and only transiently different.
|
|
Noted.
Next time the probl
anonymous wrote :
| 0 (Avl conn cnt) + 25 (in use conn cnt) << 130 (Conf max conn count). These
figures are taken from jmx-console.
|
Sorry Adrian for bugging you with the same question again. This problem hits me
only on a production system and i can't enable traces on it. Like viewing st
Hi Adrian,
This is lot of useful info.
1) We have been watching thread dump and havent seen threads using connections
while application doesn't has any available connection left.
2) From the pool stats available in jmx-console (actually we even log
AvailableConnectionCount and InUseConnectio
Hi Adrian,
Thanks for the update.
We do have EJBs and at runtime we do also hit the database through them (But
this shouldn't be at a high TPS).
Below is the stack trace for the failure through EJB. What we do is just a read
from the database.
anonymous wrote :
| 19:39:12,435 ERROR [BeanL
Thanks for updating the ticket.
anonymous wrote :
| This means that the TX timeout occurs in your application code , you either
need to fine tune the SQL or configure the TX timeout
|
None of the queries we fire take more then 5-10 ms. Also all the connections
are already closed in a f
We are running Jboss4.0.2. We use it for queuing as well as maintaing
connection pool to the database.
Occasionally we see (lots of when it happens) below error in the logs.
anonymous wrote :
| 19:34:32,947 WARN [TransactionImpl] Transaction
TransactionImpl:XidImpl[FormatId=257, GlobalId=