Re: BUG #7914: pg_dump aborts occasionally

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Shin-ichi MORITA" <s-morita(at)beingcorp(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7914: pg_dump aborts occasionally
Date: 2013-03-06 18:33:35
Message-ID: 19324.1362594815@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Shin-ichi MORITA" <s-morita(at)beingcorp(dot)co(dot)jp> writes:
>> If so, perhaps injecting a sleep() delay into the right place in pg_dump
>> or libpq would make it reproducible?

> An alternative way would be running pg_dump with a lower priority.
> Actually, I can reproduce this issue by setting the priority of
> pg_dump to Low using Windows Task Manager
> on the "single processor" environment.

I tried nice'ing pg_dump without any success in making it bloat memory.
I'm suspicious that there's something Windows-specific in what you're
seeing, because it's fairly hard to credit that nobody's seen this
problem in the ten years or so that libpq has been doing it like that.

Can anyone else manage to reproduce a similar behavior?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message akurzhan 2013-03-06 19:40:42 BUG #7922: Error installing PostGIS
Previous Message Kevin Grittner 2013-03-06 17:34:29 Re: BUG #7918: limitation of pagination with LIMIT and OFFSET