servererror trigger, can it hurt me? [message #309788] |
Fri, 28 March 2008 16:05  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
I am looking to implement an after servererror trigger in my production databases. I have so far not had any problems with this type of trigger but I know the world is a much bigger place than my company.
so I am wondering if anyone has seen issues that I should avoid with this trigger. So far I have read the following:
Quote: | 1) lots of errors can potentially slow down a system (hmm.. if I am getting that many errors then there is something more serious to worry about I think, but thanks)
2) some errors by there nature may mean potential trouble for the servererror trigger itself. For example, memory errors and out of space errors. If the trigger is not KEPT, then it most likely must be loaded but an out of memory error may prevent this. Also, if writing errors to a table and the tablespace cannot extend when needed, again the trigger will fail (ok again hmm.. logical, but these errors are also reflective of bigger issues so I am not too worried about the servererror trigger being the cause of problems in these situations).
|
What else can the experienced crowd here tell me? Why should I not put this trigger on my production databases?
Kevin
[Updated on: Fri, 28 March 2008 16:05] Report message to a moderator
|
|
|
Re: servererror trigger, can it hurt me? [message #309822 is a reply to message #309788] |
Sat, 29 March 2008 01:32  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
I installed servererror trigger from time to time and I'm not worry about it because this trigger is always simple (just logging, what can you do?) and if an unexpected error raises during its execution, I know this error will raise soon after in an other program/process.
So it is more a detector of problems than a maker of problems and is useful for this as the error does not raise inside the functional code.
Just my 2 cents.
Regards
Michel
|
|
|