[Postgres-xl-general] Regarding query hangs up

Durgamahesh Manne maheshpostgres9 at gmail.com
Thu Jan 14 03:18:49 PST 2016


Sir   what exactly i can do for query hangs up     let me explain one more
time

i connected to xl server by psql then    hangs up when i was typing query

 at the time i ran top -cu  postgres

i seen that two SELECT  process running

at the time i again connected to xl server then

i ran meta command \l   but  hangs up


Regards
Mahesh


On Thu, Jan 14, 2016 at 4:43 PM, Durgamahesh Manne <
maheshpostgres9 at gmail.com> wrote:

> Sir   what exactly i can do for query hangs up     let me explain one more
> time
>
> i connected to xl server by psql then    hangs up when i was typing query
>
>  at the time i ran top -cu  postgres
>
> i seen that two SELECT  process running
>
> at the time i again connected to xl server then
>
> i ran meta command \l   but  hangs up
>
>
>
>
>
>
> Regards
> Mahesh
>
> On Thu, Jan 14, 2016 at 4:20 PM, Koichi Suzuki <koichi.dbms at gmail.com>
> wrote:
>
>> 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/8764062f/attachment.htm>


More information about the postgres-xl-general mailing list