Re: Long running query - connection and keepalives enabled but query not canceled

From: Dmitry Vasiliev <dmitry(dot)vasiliev(at)coins(dot)ph>
To: Tomasz Ostrowski <tometzky+pg(at)ato(dot)waw(dot)pl>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Long running query - connection and keepalives enabled but query not canceled
Date: 2019-06-05 14:07:30
Message-ID: 30208742-05ED-4D2D-A2B5-61BE11F8D758@coins.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Tomasz Ostrowski wrote:
>
>> The database would get an error on the connection socket only after it tries to read or write to it next time. But it does not try to do this - it's busy counting those quarks until statement_timeout is reached.
>>
>

I found relevant patch from postgrespro on commitfest: https://commitfest.postgresql.org/21/1882/

--
Dmitry Vasiliev

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-06-05 14:14:23 Re: Postgresql-11 confusing situtation
Previous Message Sathish Kumar 2019-06-05 13:24:35 Re: pg_repack issue