how to find that stalled query

  • Shaine Gordon
    Shaine Gordon

    every so often a query is run that deadlocks the entire database for a few seconds to minutes.

    I want to use jamon to find this query, so that we I get the alert that the webapp is unavailable (because complete db lock has occured), I can find the exact query param values and SQL for the query.

    however, on the sql monitor tab in jamon.war I can only see a max of 1000 queries.

    is there any way to find that query if it happed to be the first of 1001 querys. ie I only managed to investigate after the lock was released, and the weppapp continued normal operation

  • Steve Souza
    Steve Souza

    You could try one of the other types of listeners.  For example there are listeners you can attach when you get a new min, max, maxactive etc.  This might help.  Does this query show as 'active' on the main jamon page?  If so you could check for queries that never have the active field return to 0.  And if all that fails you could probably create your own listener that tracks the details of open queries.

    For more on listeners: