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

Re: Temp file missing during large pgbench data set

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thom Brown <thom(at)linux(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Temp file missing during large pgbench data set
Date: 2012-01-28 09:04:09
Message-ID: CABUevExDohwSLaruv=dwU+Xm3kA3yTjKuKBngSiNhxoojzrMtA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sat, Jan 28, 2012 at 09:57, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Sat, Jan 28, 2012 at 05:30, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Thom Brown <thom(at)linux(dot)com> writes:
>>> I'm using latest git master (latest entry
>>> 0816fad6eebddb8f1f0e21635e46625815d690b9) and I'm getting an error
>>> when trying to create a large data set with pgbench:
>>
>>> LOG:  could not stat file "base/pgsql_tmp/pgsql_tmp8056.0": Success
>>> STATEMENT:  alter table pgbench_accounts add primary key (aid)
>>
>> I'll bet lunch this is due to some bug in commit
>> bc3347484a7bf9eddb98e4352d84599cae9a31c6
>
> Not taking that bet. There definitely is a pretty obvious bug in that.
> Will look into it. Pretty sure the else branch is at the wrong
> level...

Yup, it was. Patch applied, can you confirm if that fixes your problem?

-- 
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

In response to

Responses

pgsql-hackers by date

Next:From: hubert depesz lubaczewskiDate: 2012-01-28 09:29:22
Subject: Re: pg_dump -s dumps data?!
Previous:From: Magnus HaganderDate: 2012-01-28 08:57:59
Subject: Re: Temp file missing during large pgbench data set

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