[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