From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Alex Hunsaker" <badalex(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: 8.3.0 backend segfaults |
Date: | 2008-03-12 06:44:40 |
Message-ID: | 13629.1205304280@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Alex Hunsaker" <badalex(at)gmail(dot)com> writes:
> the mean time here is a new backtrace I just got (lord knows how... it
> seems to be as soon as I stop trying to make it crash and look away,
> thats when it does).
Not sure that you are clear on what's happening here, but the train of
events is something like
- you prepare a statement
- somebody modifies the schema of one of the tables used in the
statement
- you try to execute the statement, and updating the prepared
plan crashes
If you say "none of my stuff is changing any schemas", then I'd guess
that the triggering event is a background autovacuum, which forces
replan just like an intentional schema change would. Does stopping
autovacuum make the problem go away?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-03-12 06:54:09 | Re: BUG #4027: backslash escaping not disabled in plpgsql |
Previous Message | Alex Hunsaker | 2008-03-12 06:34:42 | Re: 8.3.0 backend segfaults |