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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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