Thread: PL/PGSQL functions suddenly not working

PL/PGSQL functions suddenly not working

From
Alex
Date:
Hi,
I have a couple of functions in my database (v7.3.4) and noticed that
after a certain period of time, the functions fail to work This happened
now serveal times and the function fail at different points. The did go
away when I restarted the postmaster.  At one time the function always
failed when another heavy job was running on the system.

Is this a bug? Does anybody have the same experience ?

Thanks
Alex



Re: PL/PGSQL functions suddenly not working

From
Alex
Date:
Shridhar,
yes the behavior is a bit strange. I cant see much in the log except
that it says parse error  ad a date field which does not make sense to me.
It only accesses two tables  which are quite small.  The function fails
now when I run a heavy updated job so my feeling is that I either run
out of connections or memory related.

Alex

Shridhar Daithankar wrote:

> Alex wrote:
>
>> Hi,
>> I have a couple of functions in my database (v7.3.4) and noticed that
>> after a certain period of time, the functions fail to work This
>> happened now serveal times and the function fail at different points.
>> The did go away when I restarted the postmaster.  At one time the
>> function always failed when another heavy job was running on the system.
>>
>> Is this a bug? Does anybody have the same experience ?
>
>
> Can you provide more information? Schema, function bodies, relevant
> logs etc. It is hard to guess what could be wrong with it.
>
> For sure I find it pretty strange behaviour.
>
>  Shridhar
>
>
>



Re: PL/PGSQL functions suddenly not working

From
Shridhar Daithankar
Date:
Alex wrote:
> Hi,
> I have a couple of functions in my database (v7.3.4) and noticed that
> after a certain period of time, the functions fail to work This happened
> now serveal times and the function fail at different points. The did go
> away when I restarted the postmaster.  At one time the function always
> failed when another heavy job was running on the system.
>
> Is this a bug? Does anybody have the same experience ?

Can you provide more information? Schema, function bodies, relevant logs etc. It
is hard to guess what could be wrong with it.

For sure I find it pretty strange behaviour.

  Shridhar