Here is a little more information about my problem.
There is a library( that has stored procedures) for processing trigger
events. The library is loaded on first access( i.e when there is a
trigger event to be sent). Normally, it gets unloaded during a
postgres server shutdown but the library seems to be getting unloaded
occasionally. We have logs in the _init( ) and _fini( ) of the
library and we see that there are times when _fini( ) is getting
called when you wouldn't expect it to be.
Has anyone else had issues similar to this?
Thanks,
Jon.
On 8/15/07, Jon Horsman <horshaq@gmail.com> wrote:
> > "Jon Horsman" <horshaq@gmail.com> writes:
> > > I'm randomly having issues with my triggers not firing (it turns out
> > > they are getting removed) and when i turned INFO logs on i saw the
> > > following
> >
> > > 2007-08-14 13:41:44.740305500 LOCATION: _fini, medbevent_init.c:129
> > > 2007-08-14 13:41:45.790850500 INFO: 00000: medbeventlib -Unloading
> > > library _fini() is called
> >
> > > Could someone please explain when a shared library gets
> > > loaded/unloaded and how this all works?
> >
> > Are you sure the above doesn't just occur during server process
> > termination? AFAIK Postgres never unloads a library, except when you
> > specifically command it to load an updated version via the LOAD command.
> >
> > regards, tom lane
>
> Yup, the server process is still up and going, i have other clients
> connected to postgres that still function when this happens. I'm not
> using the LOAD command anywhere so thats not the problem. One of my
> colleagues was doing some reading and said he found something that
> stating that the fini() function is "unreliable", i'm not sure where
> he read that though...
>
> Jon.
>