When a stored procedure runs a DROP CONNECTION against the connection currently in use by an event, the following message appears in the console log: User "DBA" dropped event connection 1000001154 ("victim-event-name") In some (most) environments, that may be important, but in others (mine) these messages are just annoying... the DROPs are frequently and automatically executed under the covers as part of business-as-usual. Suggestion: allow these messages to be suppressed on a case-by-case basis; e.g., add a clause to the CREATE EVENT statement, or a clause to the event's EXCEPTION block, or something coded at the victim-event level to say "don't fret if my connection is dropped". |
This issue sounds related to your other recent posting related to events - Do not display “Statement interrupted by user” event exceptions when database is shutting down - and perhaps the solution to that issue can also resolve this request as well? ... with "perhaps" being the operative word. From my perspective the contexts are vastly different: database shutdown coming from the outside world, versus DROP CONNECTION done from within another connection as part of normal operations (no shutdown). Other than that, yeah sure :) |