[Postgres-xl-general] Regarding query hangs up

Koichi Suzuki koichi.dbms at gmail.com
Thu Jan 14 02:50:17 PST 2016


The reason why the nodes won't stop is some postmaster is waiting for
outstanding transaction/connection to close.    You may be able to make -m
option.   Killing backend/postmaster may not be safe.

Regards;

---
Koichi Suzuki
https://www.linkedin.com/in/koichidbms


2016-01-14 17:40 GMT+09:00 Durgamahesh Manne <maheshpostgres9 at gmail.com>:

> Hi Sir
>
> i am mahesh. still i am getting query hangs up issue which i  had faced on
> manual configuration
>  running query does't roll back when i ran any query on  database server
>
>  at that time server does not shutdown .i used kill command to terminate
> process then i restarted with pgxc_ctl start all
>
> PGXC stop all
>
> Stopping all the coordinator masters.
> Stopping coordinator master coord1.
> Stopping coordinator master coord2.
> pg_ctl: server does not shut down
> Done.
> Stopping all the datanode masters.
> Stopping datanode master datanode1.
> Stopping datanode master datanode2.
> pg_ctl: server does not shut down
>
>
>
> Regards
> Mahesh
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20160114/58bf95af/attachment.htm>


More information about the postgres-xl-general mailing list