3 Replies Latest reply on Aug 16, 2004 9:02 AM by Renen W

    delete queue entries

    Renen W Newbie


      I pushed 21000 messages into a queue. These messages have been (correctly) persisted by the server. However, when they get executed an exception is thrown:

      org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms] )
      . These are thrown repeatedly until eventually the jboss server shuts itself down.

      1) Any suggestions as to what is going wrong?
      2) It would strike me as inelegant to delete the jboss instance and start over. Is there a better way to kill a queue and the entries in the queue?

      thanks in advance.


        • 1. Re: delete queue entries
          Renen W Newbie

          1) problem stems from all (?) the MDBs being concurrently instantiated - after a very short time connections in the db connection pool run out (hardly suprising). Clearly I need to throttle the number of instances of this kind of bean that get instantiated. COuld also increase the number of DB connections available (definitely), but must constrain the number of MDB's because otherwise this will fail under load.

          • 2. Re: delete queue entries
            Renen W Newbie

            1) getting there. looks like settimg the <max-pool-size> should do the trick (probably in my service.xml file?). Not sure that I understand the help (?) file: jboss-ds_1_0.dtd which i think is supposed to explain everything...

            2) A program "Hermes" may help with this part of the problem.

            • 3. Re: delete queue entries
              Renen W Newbie

              Within jmx-console, find your queue, and then hit the removeAllMessages button.