Uploaded image for project: 'JBoss A-MQ'
  1. JBoss A-MQ
  2. ENTMQ-2135

AMQ database connections multiply exponentially after multiple database restarts

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • None
    • JBoss A-MQ 6.3
    • broker
    • None
    • Compatibility/Configuration
    • Workaround Exists
    • Hide

      Set the default values for the properties initialSize, minIdle and timeBetweenEvictionRunsMillis

             <property name="initialSize" value="0"/>
       	 <property name="minIdle" value="0"/>
               <property name="timeBetweenEvictionRunsMillis" value="-1"/>
      
      
      Show
      Set the default values for the properties initialSize, minIdle and timeBetweenEvictionRunsMillis <property name= "initialSize" value= "0" /> <property name= "minIdle" value= "0" /> <property name= "timeBetweenEvictionRunsMillis" value= "-1" />
    • Hide

      1. Configure A-MQ 6.3 to use JDBC persistence ( at my end I tried with MariaDB)

      <bean id="mysql-ds"
                class="org.apache.commons.dbcp.BasicDataSource"
                destroy-method="close">
                <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost/activemq?relaxAutoCommit=true"/>
                <property name="username" value="amq"/>
                <property name="password" value="amqPass"/>
                <property name="poolPreparedStatements" value="true"/> 
                <property name="initialSize" value="2"/>
       	  <property name="minIdle" value="20"/>
                <property name="timeBetweenEvictionRunsMillis" value="600000"/>
      </bean>
      
      

      2. Restart database multiple times ( I tried 8-9 times)

      3. Check the opens connections

      netstat -tn | grep 3306
      
      
      Show
      1. Configure A-MQ 6.3 to use JDBC persistence ( at my end I tried with MariaDB) <bean id= "mysql-ds" class= "org.apache.commons.dbcp.BasicDataSource" destroy-method= "close" > <property name= "driverClassName" value= "com.mysql.jdbc.Driver" /> <property name= "url" value= "jdbc:mysql: //localhost/activemq?relaxAutoCommit= true " /> <property name= "username" value= "amq" /> <property name= "password" value= "amqPass" /> <property name= "poolPreparedStatements" value= " true " /> <property name= "initialSize" value= "2" /> <property name= "minIdle" value= "20" /> <property name= "timeBetweenEvictionRunsMillis" value= "600000" /> </bean> 2. Restart database multiple times ( I tried 8-9 times) 3. Check the opens connections netstat -tn | grep 3306

    Description

      AMQ database connections multiply exponentially after multiple database restarts

      Attachments

        Activity

          People

            Unassigned Unassigned
            rhn-support-hnaram Herambh Naram (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: