By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

PL/PGSQL functions suddenly not working

P: n/a
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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.