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

Re: Temp file missing during large pgbench data set

From: Thom Brown <thom(at)linux(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Temp file missing during large pgbench data set
Date: 2012-01-28 10:27:24
Message-ID: CAA-aLv76eaDw1FPMgXZotnF1iaHGZBOp7cnEROttK_2+DnKzQg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 28 January 2012 09:04, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> 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?

Yes, looks fine now.

Thanks

-- 
Thom

In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2012-01-28 13:49:02
Subject: Re: 16-bit page checksums for 9.2
Previous:From: hubert depesz lubaczewskiDate: 2012-01-28 09:30:11
Subject: Re: pg_dump -s dumps data?!

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