Issue: Try to set gp_role (read only parameter) session hangs, not able to kill the process, neither restart works, had to use "kill -9" to clear this process.
gpadmin=# set gp_role = 'dispatch';
^CCancel request sent
^Z
[1]+ Stopped psql
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
Page No : 1352
Issue: Try to set gp_role (read only parameter) session hangs, not able to kill the process, neither restart works, had to use "kill -9" to clear this process.
gpadmin=# set gp_role = 'dispatch'; ^CCancel request sent ^Z [1]+ Stopped psql [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$
gpadmin=# select * from pg_stat_activity where usename='gpadmin'; datid | datname | pid | sess_id | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start | qu ery_start | state_change | waiting | state | backend_xid | backend_xmin | query | waiting_reason | rsgid | rsgname | rsg queueduration -------+---------+------+---------+----------+---------+------------------+-------------+-----------------+-------------+-------------------------------+-------------------------------+------------ -------------------+-------------------------------+---------+--------+-------------+--------------+---------------------------------------------------------+----------------+-------+---------+----
16384 | gpadmin | 7390 | 438 | 10 | gpadmin | psql | | | -1 | 2021-07-20 08:14:49.061621+00 | 2021-07-20 08:16:28.701907+00 | 2021-07-20 08:16:28.701907+00 | 2021-07-20 08:16:28.701909+00 | f | active | | | set gp_role = 'dispatch';
gpadmin=# select pg_terminate_backend(7390); pg_terminate_backend
t (1 row)
gpadmin=# select pg_terminate_backend(7390); pg_terminate_backend
t (1 row)
gpadmin=# select pg_terminate_backend(7390); pg_terminate_backend
t (1 row)
gpadmin=# select pg_terminate_backend(7390); pg_terminate_backend
t (1 row)
[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ ps -ef| grep gpadmin| grep 9177 gpadmin 9177 9125 0 08:27 ? 00:00:00 postgres: 5432, gpadmin gpadmin [local] con11 cmd1 SET gpadmin 9333 7886 0 08:29 pts/1 00:00:00 grep --color=auto 9177 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ kill 9177 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ kill -9 9177 [gpadmin@mdw_ipv4 ~]$