Thread

1. PL/PGSQL functions suddenly not working

   Alex <alex@meerkatsoft.com> — 2003-11-12T23:44:42Z

   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
   
   
   
   

2. Re: PL/PGSQL functions suddenly not working

   Shridhar Daithankar <shridhar_daithankar@persistent.co.in> — 2003-11-13T06:39:26Z

   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
   
   
   

3. Re: PL/PGSQL functions suddenly not working

   Alex <alex@meerkatsoft.com> — 2003-11-13T09:21:58Z

   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
   >
   >
   >