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

Re: BUG #6222: Segmentation fault on unlogged table

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, YAMAMOTO Takashi <yamt(at)mwd(dot)biglobe(dot)ne(dot)jp>
Subject: Re: BUG #6222: Segmentation fault on unlogged table
Date: 2011-09-26 16:32:46
Message-ID: CA+TgmoZ78Cnx1aoAGJ2e+-aCehnOY-NwCCBuW3kL-reHaqOVaQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Sep 26, 2011 at 12:20 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Mon, Sep 26, 2011 at 12:17 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
>> hm. any relation to YAMAMOTO Takashi's recent email, [BUGS] bug in
>> plancache.c, which hasn't hit the archives yet?
>>
>>> "GetCachedPlan can pass the 'qlist' to the planner twice.
>> if i understand the code correctly, it's unsafe because the planner is
>> destructive wrt the input tree.  for my application, it often causes
>> a crash in executor."
>
> I was just wondering about that.  It seems like it could very well be
> the same issue, but I have not tested it yet.

OK, I tested it.  On my system, that patch appears to fix this problem.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-09-26 16:39:26
Subject: Re: BUG #6222: Segmentation fault on unlogged table
Previous:From: Tom LaneDate: 2011-09-26 16:26:37
Subject: Re: BUG #6218: TRAP: FailedAssertion( "!(owner->nsnapshots == 0)", File: "resowner.c", Line: 365)

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