Skip site navigation (1) Skip section navigation (2)

Re: unexpected and reproducable crash in pl/pgsql function

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: <pgsql-hackers-win32(at)postgresql(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: unexpected and reproducable crash in pl/pgsql function
Date: 2005-03-03 21:03:11
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3412A7637@Herge.rcsinc.local (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-hackers-win32
I wrote:
> Ok, I have a fairly nasty situation.  I am having a production server
> that is crashing upon execution of a pl/pgsql function...on code that
> has been working flawlessly for weeks.  My production server is
running
> 8.0 on win32 and I was able to 'sort-of' reproduce the behavior on my
> development machine here at the office.

Ok, problem was due to recursive pl/pgsql function and a recursion loop
in the data.  I traced this problem to the data: somebody disabled the
recursion check constraint.  

I've never had this actually happen before.  It totally nuked the
server.

Merlin

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-03-03 21:17:00
Subject: Re: logging as inserts
Previous:From: Josh BerkusDate: 2005-03-03 21:02:29
Subject: Re: logging as inserts

pgsql-hackers-win32 by date

Next:From: Tom LaneDate: 2005-03-03 21:20:00
Subject: Re: unexpected and reproducable crash in pl/pgsql function
Previous:From: Merlin MoncureDate: 2005-03-03 19:47:59
Subject: unexpected and reproducable crash in pl/pgsql function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group