Обсуждение: Why is Query NOT getting cancelled with SIGINT in PG14?

Hi,

Looks like the running query is not getting cancelled even though I
issue CTRL+C from psql or kill the backend with SIGINT. This only
happens with PG14 not in PG13. Am I missing something here? Is it a
bug?

create table t1(a1 int);
insert into t1 select * from generate_series(1,10000000000);  --> I
chose an intentionally long running query, now either issue CTRL+C or
kill the backend with SIGINT, the query doesn't get cancelled. Note
that I don't even see "Cancel request sent" message on psql when I
issue CTRL+C.

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com

On Fri, Apr 09, 2021 at 08:24:51AM +0530, Bharath Rupireddy wrote:
> Looks like the running query is not getting cancelled even though I
> issue CTRL+C from psql or kill the backend with SIGINT. This only
> happens with PG14 not in PG13. Am I missing something here? Is it a
> bug?

Yes, see here:

https://www.postgresql.org/message-id/flat/OSZPR01MB631017521EE6887ADC9492E8FD759%40OSZPR01MB6310.jpnprd01.prod.outlook.com#e9228ef1ae32315f8b0df3fa67a32e06

-- 
Justin

On Fri, Apr 9, 2021 at 8:38 AM Justin Pryzby <pryzby@telsasoft.com> wrote:
>
> On Fri, Apr 09, 2021 at 08:24:51AM +0530, Bharath Rupireddy wrote:
> > Looks like the running query is not getting cancelled even though I
> > issue CTRL+C from psql or kill the backend with SIGINT. This only
> > happens with PG14 not in PG13. Am I missing something here? Is it a
> > bug?
>
> Yes, see here:
>
https://www.postgresql.org/message-id/flat/OSZPR01MB631017521EE6887ADC9492E8FD759%40OSZPR01MB6310.jpnprd01.prod.outlook.com#e9228ef1ae32315f8b0df3fa67a32e06

Thanks. I missed to follow that thread. I will respond there.

With Regards,
Bharath Rupireddy.
EnterpriseDB: http://www.enterprisedb.com