| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-03 21:17:00 | Re: logging as inserts |
| Previous Message | Josh Berkus | 2005-03-03 21:02:29 | Re: logging as inserts |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-03 21:20:00 | Re: unexpected and reproducable crash in pl/pgsql function |
| Previous Message | Merlin Moncure | 2005-03-03 19:47:59 | unexpected and reproducable crash in pl/pgsql function |