Subject Re: Is there a way for a stored procedure to know its own name ?
Author olivier_lucaes
--- In, "Alan McDonald" <alan@...>
> > Dear all,
> >
> > I'm trying to find an issue that happens time to time (2 times per
> > month) that triggers the crash of the firebird server. The server
is a
> > superserver, version 1.5.2 running on a Linux box. There are
usually 5
> > users working on 5 five different clients during the day.
> > I have around 350 stored procedures. In my application, there are
> > few read access that are done out of the scope of the stored
> > procedures. Last time this happened, this was somehow easy to
> > reproduce therefore I found it easily.
> > This time, I have no clue what could cause the issue and it is not
> > easy to recognize which client has really triggered the error.
> > Therefore I would like to insert a kind of debugging message in
> > procedures. I would call at the beginning and at the end a new
> > procedure that would get the calling procedure name in parameter.
> > In order to insert by copy and past a piece of code I wanted to
> > if the name of the procedure is available in any reserved word,
> > built-in function or so ?
> > If anyone has any idea how to debug this king of error (I can not
> > reproduce the 'productive' activity on my test version...), I'm
> > to any hint.
> > Unfortunately I don't have the exact message found in the firebird
> > log, but it is the same that I used to have when there was a data
> > overflow. It just mentions that the server crashes and that it is
> > restarted.
> > Thanks and best regards
> > Olivier
> 1. there are debug UDFs available, take a look at them.
> 2. what UDF libaraies are you using and which function in those
libs are you
> using?
> I would first suspect UDFs as the reason for crashes, so debugging
the ones
> with UDFs may cut down your work.
> Alan
Hello Alan,
Thank you for your hints.
1. I've never heard about but I will google for this...
2. I'm using TBUDF. I have only customized one of the original
functions and use very few of them. I keep your hint about UDf in
mind and will focus on those SP that use some.
Best regards