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".

asked 07 Oct '10, 13:38

Breck%20Carter's gravatar image

Breck Carter
27.0k444614889
accept rate: 21%


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?

permanent link

answered 07 Oct '10, 18:59

Mark%20Culp's gravatar image

Mark Culp
23.4k9132275
accept rate: 40%

... 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 :)

(07 Oct '10, 19:38) Breck Carter
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×107

question asked: 07 Oct '10, 13:38

question was seen: 730 times

last updated: 02 Dec '10, 21:22