Re: Query cancel seems to be broken in master since Oct 17 - Mailing list pgsql-hackers

On Tue, Oct 18, 2016 at 1:00 AM, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:

Hi,

In pgjdbc we have regular regression testing against "build from master" PostgreSQL, and recent master builds fail for "statement cancel" test.

The PostgreSQL as of Mon Oct 17 00:09:39 UTC 2016 was fine, then "statement cancel" started to fail.

The test executes "select pg_sleep(10)" and tries to cancel it. In recent master builds, cancel seems to be ignored, and the statement lasts for 10 seconds.

Exactly the same driver and test version works fine for 8.4, 9.1, 9.2, 9.3, 9.4, 9.5, and 9.6:

Here's a sample build report: https://travis-ci.org/pgjdbc/pgjdbc/builds/168444341 

Any hints what could be the issue?

Was the breakage intentional?

My guess is it's related to this: https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=9e083fd4683294f41544e6d0d72f6e258ff3a77c

That's certainly not intended to break things, but that was changed on Oct 17 and it relates to cancel keys.

What platform does the postgres server run on? Can can you check if query cancel works on libpq or if it's completely broken? 

--

 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/