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?