Re: TCP Resets when closing connection opened via SSL

2019-04-27 Thread Jānis Pūris
Thank you, Peter. It makes more sense now, and I'm so glad someone else is able to reproduce this. To clarify on why I consider this a problem - It is not just the alerts on monitoring system. The alerts themselves can be tuned / thresholds increased etc. The real issue (could argue this is non

Re: TCP Resets when closing connection opened via SSL

2019-04-27 Thread Peter J. Holzer
On 2019-04-26 18:36:12 +0200, Jānis Pūris wrote: > Thanks for the insight, Tom. > > > It's fairly obvious from the postmaster log that the client side > is not bothering to close the transaction it started > > > Thats what I was also thinking, but I've managed to reproduce it with > aut

Re: TCP Resets when closing connection opened via SSL

2019-04-26 Thread Jeremy Harris
On 26/04/2019 18:19, Tom Lane wrote: > =?utf-8?Q?J=C4=81nis_P=C5=ABris?= writes: >> This is only reproducible with SSL connection. > > Seems like you might get more insight from OpenSSL experts, then. > (No idea where you find some, but they must exist.) List-Id: -- Cheers, Jeremy

Re: TCP Resets when closing connection opened via SSL

2019-04-26 Thread Tom Lane
=?utf-8?Q?J=C4=81nis_P=C5=ABris?= writes: > This is only reproducible with SSL connection. Seems like you might get more insight from OpenSSL experts, then. (No idea where you find some, but they must exist.) regards, tom lane

Re: TCP Resets when closing connection opened via SSL

2019-04-26 Thread Jānis Pūris
Thanks for the insight, Tom. > It's fairly obvious from the postmaster log that the client side > is not bothering to close the transaction it started Thats what I was also thinking, but I've managed to reproduce it with autocommit or commit before closing connection as well. This is only reprod

Re: TCP Resets when closing connection opened via SSL

2019-04-26 Thread Tom Lane
=?utf-8?Q?J=C4=81nis_P=C5=ABris?= writes: > I'm trying to do a simple health check for keepalived and other services via > a python script and psycopg2 library. All seems to be all right, until I > close the connection, at which point a packet with TCP reset is produced. Hm. It's fairly obviou

Re: TCP Resets when closing connection opened via SSL

2019-04-26 Thread Rainer Pruy
On 26.04.19 09:41, Jānis Pūris wrote: > /Resending the original message without any formatting./ > > Hello, > > I'm trying to do a simple health check for keepalived and other > services via a python script and psycopg2 library. All seems to be all > right, until I close the connection, at which po

Re: TCP Resets when closing connection opened via SSL

2019-04-26 Thread Jānis Pūris
Resending the original message without any formatting. Hello, I'm trying to do a simple health check for keepalived and other services via a python script and psycopg2 library. All seems to be all right, until I close the connection, at which point a packet with TCP reset is produced. This has

TCP Resets when closing connection opened via SSL

2019-04-26 Thread Jānis Pūris
Hello, I'm trying to do a simple health check for keepalived and other services via a python script and psycopg2 library. All seems to be all right, until I close the connection, at which point a packet with TCP reset is produced. This has become very problematic and creates extensive noise in m