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

Re: Backend doesn't catch the next command, after SIGUSR2

From: Patrick Samson <p_samson(at)yahoo(dot)com>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: Backend doesn't catch the next command, after SIGUSR2
Date: 2004-03-31 06:54:22
Message-ID: 20040331065422.66786.qmail@web60310.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-cygwin
--- Patrick Samson wrote:
> If I run a test script enough time, it eventually
> freezes in this deadlock situation:
> 
> The client sends a command to a backend and waits
> for an answer. It will wait forever because the
> backend
> is not aware of the arrival of the request and waits
> for a next command.
> 
> What happens in the loop is:
>  SIInsertDataEntry: table is 70% full,
>  signaling postmaster
> 
>  In reaction, the postmaster sends to its children:
>  SignalChildren: sending signal 31 to process <pid>
> 
> Most of the time, it works. But at an unpredictable
> iteration, it freezes.
> 
...
> I can't tell if the source of the problem is in
> cygwin or in postgres, so I post in the two lists.

Nothing to say about Postgres, the problem is
located within Cygwin.
Look at
  http://cygwin.com/ml/cygwin/2004-03/msg00418.html
for the full story.


__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html

In response to

pgsql-cygwin by date

Next:From: Greg B. HillDate: 2004-03-31 17:47:19
Subject: Re: initdb error
Previous:From: mike gDate: 2004-03-31 04:19:24
Subject: Postgres crashing intermittentaly

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