Jboss EAP does not apply max-pool-size on database connection

Solution Unverified - Updated -

Issue

  • With the instance started, we have execute the flush command in two times.

    • The first, work ok, ActiveCount=2 after the flush and test command.
    • The second, failed, ActiveCount=3 after the flush and test command.
  • 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 ActiveCount is higher than the configured max-pool-size count as per data-source statistics?

Environment

  • Red Hat JBoss Enterprise Application Platform 6.4.3
  • prefill=true as defined in
    • jboss-as-datasources_1_1.xsd
    • jboss-as-datasources_1_2.xsd

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content