Re: Bug #929: Client connection to postgresql hangs indefi

From: Claudio Natoli <claudio(dot)natoli(at)memetrics(dot)com>
To: 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #929: Client connection to postgresql hangs indefi
Date: 2003-04-01 01:54:45
Message-ID: A02DEC4D1073D611BAE8525405FCCE2B027C78@harris.memetrics.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


> > where test.sql is a file composed of many, many thousands
> of the following pair of statements:
> > create table dud_table (f integer);
> > drop table dud_table;
> > Invariably, after some period of time, the second
> connection (B) will
> > hang.
>
> It would help if you would quantify how many create/drop
> pairs it takes.

[Lots. Ok, I know that doesn't help. =]

The thing is, it happens occasionally. The more statements you throw at it,
the more likely it is to hang before completing the file...

As an attempt at quantification, I'll say this. We are currently using a
test file with about 5000 pairs of create/drop. It (almost?) never makes it
through a pass of this file. Your mileage may vary.


> > Note: Problem may be limited to Windows installation (cygipc?); have
> > reproduced on "virgin" Win2K; have not been able to reproduce under
> > Linux
>
> If you've tried and failed to reproduce on Linux then the most likely
> bet is that it's a Cygwin bug. But it would be good to try on some
> other Unixoid platforms before pointing a finger in that direction.

Absolutely. Certainly possible to imagine some form of race condition in
cygipc being responsible, but I'm only guessing from the symptoms (not from
any knowledge of the implementation of either postgres or cygwin/ipc).

Cheers,
Claudio

Certain disclaimers and policies apply to all email sent from Memetrics.
For the full text of these disclaimers and policies see
http://www.memetrics.com/emailpolicy.html

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message washingtonirving 2003-04-01 02:32:38 geometry test fails on FreeBSD 4.7
Previous Message Tom Lane 2003-04-01 01:42:23 Re: Bug #929: Client connection to postgresql hangs indefinitely (under possibly pathological scenarios)