Postgres Pro
Downloads
Home   >   mailing lists

Re: Some 9.5beta2 backend processes not terminating properly? - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Some 9.5beta2 backend processes not terminating properly?
Date
Msg-id CAA4eK1+5QSR3Ufab0rt4d2Nuzwv7sXdsgmXkEiF68KQH1++pVw@mail.gmail.com
Whole thread Raw
In response to Re: Some 9.5beta2 backend processes not terminating properly?  (Shay Rojansky <roji@roji.org>)
Responses Re: Some 9.5beta2 backend processes not terminating properly?  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Tree view
On Wed, Dec 30, 2015 at 10:31 PM, Shay Rojansky <roji@roji.org> wrote:
OK, I finally found some time to dive into this.

The backends seem to hang when the client closes a socket without first sending a Terminate message - some of the tests make this happen. I've confirmed this happens with 9.5rc1 running on Windows (versions 10 and 7), but this does not occur on Ubuntu 15.10. The client runs on Windows as well (although I doubt that's important).

In case it helps, here's a gist with some .NET code that uses Npgsql 3.0.4 to reproduce this.


I am trying to setup an environment to reproduce this issue.
I have installed Npgsql as below:
PM> Install-Package Npgsql -Version 3.0.4
Installing 'Npgsql 3.0.4'.
Successfully installed 'Npgsql 3.0.4'.

Now, I am trying to use program.cs present in the above link, but
it is neither printing any error nor able to perform any action.
I have just created program.cs file as mentioned by you in one
of the test folders and then trying to run it via:

>program.cs "Host=localhost;Username=amit;Database=postgres"

This program neither prints any error, nor I think it does any action.

Can you guide me in reproducing the issue?


I have tried to close/kill the psql client in various ways (closing the window/
End Process), but it works as expected.  So I think it is important to reproduce
it via Npgsql.

Also I am trying this on latest PostgreSQL code (9.6 version code), but I
think that doesn't matter because once I am able to execute this program
successfully, I can even use 9.5 line to see the issue if it is not reproducible
on 9.6.

I am using Win-7 and Visual Studio 2010.

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Welcome to 2016, time to run src/tools/copyright.pl
Next
From: Oleg Bartunov
Date:
Subject: strange behaviour of psql \e command