Negative Lookahead

Hi -

Does the trigger for Error in SQL Logger support negative lookahead in the regex matching? For example, I want to send an email for all errors in the log except for known items. For example, I don't want to receive alerts for "NOAA Weather Plus Error Unknown error getting weather" or "eggnog", however this known good pattern is still sending NOAA Matches: ^(?!(NOAA Weather Plus Error Unknown error getting weather|eggnog)$).+$

Thanks!

[matt (support)]

I'm not 100% positive on this, but I don't believe so. The internals for that Trigger in the plugin uses the python re.search() function and not the re.match() function.

Just to confirm, is the entire error in the log just "NOAA Weather Plus Error Unknown error getting weather"? I seem to remember errors when I was using that would have additional information at the end of the line (e.g. "for coordinate..") The way your regular expression is constructed it will only exclude the line if that text is the entire line in the log.

Thank you Matt and RogueProeliator. I dug in further, and the error produced is as follows:

NOAA Weather Plus Error Unknown error getting weather for coordinates 32.986, -117.234: ('The read operation timed out',)

It seems the spacing in between the plugin name and the actual error was causing issues in the match. Additionally, RogueProeliator was correct and my regex would not have matched with text following the error. However, negative lookahead does seem to work properly and I have changed the regex to the following which matches correctlt, with the exception of the requirement to leave out the plugin name that triggered the error (which is fine as there may be other errors from the plugin that I do want to report on).

^(?:(?!Unknown error getting weather for coordinates|eggnog).)+$