pgAdmin can't cancel query when role field is filled in connection settings

[Splarv]

pgAdmin can't cancel query when role field is filled in connection settings

[adityatoshniwal]

@Splarv Can you please share PostgreSQL docs link to pg_cancel_query? I failed to find it - https://www.postgresql.org/search/?q=pg_cancel_query

[Splarv]

@Splarv Can you please share PostgreSQL docs link to pg_cancel_query? I failed to find it - https://www.postgresql.org/search/?q=pg_cancel_query

Yep, my mistype.
https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL

pg_cancel_backend ( pid integer ) → boolean
Cancels the current query of the session

Btw, you can cancel query from the same connection, just like psql do it.
https://www.postgresql.org/docs/current/libpq-cancel.html
PQcancel
Requests that the server abandon processing of the current command.

[adityatoshniwal]

@Splarv Can you please share PostgreSQL docs link to pg_cancel_query? I failed to find it - https://www.postgresql.org/search/?q=pg_cancel_query

Yep, my mistype. https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-SIGNAL

pg_cancel_backend ( pid integer ) → boolean Cancels the current query of the session

Btw, you can cancel query from the same connection, just like psql do it. https://www.postgresql.org/docs/current/libpq-cancel.html PQcancel Requests that the server abandon processing of the current command.

Hi @Splarv,

pgAdmin is already using pg_cancel_backend - https://github.com/pgadmin-org/pgadmin4/blob/master/web/pgadmin/dashboard/__init__.py#L657

[Splarv]

Sure, thats why the bug is. Look what did happen, I use role A to login and B to set role after login. To cancel query you send pg_cancel_backend from the other connection by the same user, but the effective user to execute pg_cancel_backend must be not B for this purpose, but A. The error raised because you use user B for this purpose and query doesn't canceled. This is a bug.

[adityatoshniwal]

Hi @Splarv,
The connection made using the details from server dialog is used everywhere. pgAdmin cannot create a connection separately without the role specified and execute pg_cancel_backend.
This is not a bug.
This behaviour is same as psql.

Thanks.