Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Tom Lane
Robert Haas writes: >> 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. Yeah, I was just going to suggest that that might be related, but I see you beat

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Robert Haas
On Mon, Sep 26, 2011 at 12:20 PM, Robert Haas wrote: > On Mon, Sep 26, 2011 at 12:17 PM, Merlin Moncure 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.

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Robert Haas
On Mon, Sep 26, 2011 at 12:17 PM, Merlin Moncure 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 th

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Merlin Moncure
On Mon, Sep 26, 2011 at 11:08 AM, Robert Haas wrote: > On Mon, Sep 26, 2011 at 11:40 AM, Robert Haas wrote: >> To check my work, I did this: >> >> --- a/src/backend/executor/execQual.c >> +++ b/src/backend/executor/execQual.c >> @@ -5003,6 +5003,7 @@ ExecQual(List *qual, ExprContext *econtext, bo

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Robert Haas
On Mon, Sep 26, 2011 at 11:40 AM, Robert Haas wrote: > To check my work, I did this: > > --- a/src/backend/executor/execQual.c > +++ b/src/backend/executor/execQual.c > @@ -5003,6 +5003,7 @@ ExecQual(List *qual, ExprContext *econtext, bool > resultForNull) >                Datum           expr_val

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Robert Haas
On Mon, Sep 26, 2011 at 11:00 AM, Robert Haas wrote: > The whole thing is a bit mysterious because ExecQual() doesn't really > do much that seems like it could generate an invalid memory reference. > > I'll poke at this some more... I added some debugging code which sets a global variable to vari

Re: [BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-26 Thread Robert Haas
On Sun, Sep 25, 2011 at 9:16 PM, Fujii Masao wrote: > When I made pgbench tables unlogged and ran pgbench, I encountered a > segmentation fault. Here is the test case which reproduces a segmentation > fault: > > $ pgbench -i > $ pg_dump > pgbench.dump > $ sed s/"CREATE TABLE"/"CREATE UNLOGGED TABL

[BUGS] BUG #6222: Segmentation fault on unlogged table

2011-09-25 Thread Fujii Masao
The following bug has been logged online: Bug reference: 6222 Logged by: Fujii Masao Email address: masao.fu...@gmail.com PostgreSQL version: 9.2dev Operating system: Linux hermes 2.6.38-11-generic #50-Ubuntu SMP Mon Sep 12 21:18:14 UTC 2011 i686 i686 i386 GNU/Linux Descripti