2 Replies Latest reply on Nov 15, 2016 5:06 AM by Qu Vad

    Connection Pool strange behaviour

    Qu Vad Newbie

      Hi, I get following DS statistics:

       

              "ActiveCount" => "83",

              "AvailableCount" => "84",

              "AverageBlockingTime" => "1",

              "AverageCreationTime" => "70",

              "CreatedCount" => "86",

              "DestroyedCount" => "3",

              "InUseCount" => "16",

              "MaxCreationTime" => "432",

              "MaxUsedCount" => "86",

              "MaxWaitCount" => "0",

              "MaxWaitTime" => "155",

              "TimedOut" => "0",

              "TotalBlockingTime" => "19887",

              "TotalCreationTime" => "6033"

       

      How can it be, that

       

      1. "TotalBlockingTime" => "19887", if connection limit was never reached. What was blocked for about 20 sec?

      2.  "MaxWaitTime" => "155", if no thead was waiting, i.e  "MaxWaitCount" => "0" ?

        • 1. Re: Connection Pool strange behaviour
          Stefano Maestri Expert

          Are you running latest WildFly?

          Can you provide DS configuration, database used and any environment configuration that could help?

           

          regards

          S.

          • 2. Re: Connection Pool strange behaviour
            Qu Vad Newbie

            ds config

             

                            <datasource jta="true" jndi-name="java:/b4bDB" pool-name="b4bDB" enabled="true" use-java-context="true" use-ccm="true">

                                <connection-url>jdbc:oracle:thin:@192.169.0.7:1521:XE</connection-url>

                                <driver>oracle</driver>

                                <pool>

                                    <min-pool-size>1</min-pool-size>

                                    <max-pool-size>100</max-pool-size>

                                </pool>

                                <security>

                                    <user-name>b4b</user-name>

                                    <password>b4b</password>

                                </security>

                            </datasource>

             

            oracle driver declaration

             

                                <driver name="oracle" module="com.oracle.jdbc">

                                    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

                                    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

                                </driver>

             

            so, nothing specific, I suppose... in general the question is if TotalBlockingTime includes only time when connection pool was asked for connection, but could not give any? Or anything else is also included?