Subject | Server shut-down |
---|---|
Author | fabiano_bonin |
Post date | 2002-04-03T21:58:18Z |
I have a trigger in a table that is called recursively and some times
it can be called 600 - 700 times in a single operation (when i update
a row, for example).
Inside this trigger there are some calls to stored procedures, many
operations whith double precisions fields and variables, some queryes
on other tables, etc...
My problem is that when there are so many recursions, something above
300-400 recusrions, the server crashes.
Does somebody knows if there is some known problem about trigger
recursions that can be affecting me?
Thanks.
it can be called 600 - 700 times in a single operation (when i update
a row, for example).
Inside this trigger there are some calls to stored procedures, many
operations whith double precisions fields and variables, some queryes
on other tables, etc...
My problem is that when there are so many recursions, something above
300-400 recusrions, the server crashes.
Does somebody knows if there is some known problem about trigger
recursions that can be affecting me?
Thanks.