Jboss EAP does not apply max-pool-size on database connection
Issue
-
With the instance started, we have execute the
flushcommand in two times.- The first, work ok,
ActiveCount=2after theflushandtestcommand. - The second, failed,
ActiveCount=3after theflushandtestcommand.
- The first, work ok,
-
Following is the command execution output:
[standalone@jboss01:9930 /] /subsystem=datasources/data-source=RedHatDS:flush-all-connection-in-pool
{"outcome" => "success"}
[standalone@jboss01:9930 /] ls /subsystem=datasources/data-source=RedHatDS/statistics=pool
ActiveCount=0 AverageCreationTime=0 InUseCount=0 MaxWaitCount=0 TotalBlockingTime=0
AvailableCount=2 CreatedCount=0 MaxCreationTime=0 MaxWaitTime=0 TotalCreationTime=0
AverageBlockingTime=0 DestroyedCount=0 MaxUsedCount=0 TimedOut=0 statistics-enabled=true
[standalone@jboss01:9930 /] /subsystem=datasources/data-source=RedHatDS:test-connection-in-pool
{
"outcome" => "success",
"result" => [true]
}
[standalone@jboss01:9930 /] ls /subsystem=datasources/data-source=RedHatDS/statistics=pool
ActiveCount=2 AverageCreationTime=111 InUseCount=0 MaxWaitCount=0 TotalBlockingTime=0
AvailableCount=2 CreatedCount=2 MaxCreationTime=117 MaxWaitTime=0 TotalCreationTime=223
AverageBlockingTime=0 DestroyedCount=0 MaxUsedCount=1 TimedOut=0 statistics-enabled=true
[standalone@jboss01:9930 /] /subsystem=datasources/data-source=RedHatDS:flush-all-connection-in-pool
{"outcome" => "success"}
[standalone@jboss01:9930 /] ls /subsystem=datasources/data-source=RedHatDS/statistics=pool
ActiveCount=0 AverageCreationTime=0 InUseCount=0 MaxWaitCount=0 TotalBlockingTime=0
AvailableCount=2 CreatedCount=0 MaxCreationTime=0 MaxWaitTime=0 TotalCreationTime=0
AverageBlockingTime=0 DestroyedCount=0 MaxUsedCount=0 TimedOut=0 statistics-enabled=true
[standalone@jboss01:9930 /] /subsystem=datasources/data-source=RedHatDS:test-connection-in-pool
{
"outcome" => "success",
"result" => [true]
}
[standalone@jboss01:9930 /] ls /subsystem=datasources/data-source=RedHatDS/statistics=pool
ActiveCount=3 AverageCreationTime=99 InUseCount=0 MaxWaitCount=0 TotalBlockingTime=1
AvailableCount=2 CreatedCount=3 MaxCreationTime=113 MaxWaitTime=1 TotalCreationTime=297
AverageBlockingTime=1 DestroyedCount=0 MaxUsedCount=1 TimedOut=0 statistics-enabled=true
- Why
ActiveCountis higher than the configuredmax-pool-sizecount as perdata-sourcestatistics?
Environment
- Red Hat JBoss Enterprise Application Platform 6.4.3
prefill=trueas defined injboss-as-datasources_1_1.xsdjboss-as-datasources_1_2.xsd
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.