Re: [Postgres-xc-developers] Steps to remove coordinator master

[Abbas B. <abb...@en...>]

PFA patch to fix this issue. If you find that it works for you I can commit
it later today. Thanks.

On Mon, May 13, 2013 at 10:33 AM, Abbas Butt <abb...@en...>wrote:

>
>
> On Mon, May 13, 2013 at 9:31 AM, Koichi Suzuki <koi...@gm...>wrote:
>
>> Hello;
>>
>> I'm testing pgxc_ctl to remove a coordinator master.   Following your
>> suggestions, I first stopped the coordinator master to be removed and then
>> issued "drop node" in all the other coordinators.   Somehow drop node
>> complains that it fails to obtain pooled connection, in fact, in drop node,
>> "execute direct on (node_to_be_removed)" was issued.
>>
>> It worked fine if the removed coordinator is stopped after all the DROP
>> NODE are successful.
>>
>> Did you issue CLEAN CONNECTION or pgxc_pool_reload before you issue "DROP
>> NODE"?
>>
>
> No, I did not issue any such statement. I just tested again and I am also
> getting the following error when I issue DROP NODE
> test=# drop node coord_2;
> ERROR:  Failed to get pooled connections
> CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord_2) 'SELECT
> pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"
> test=#
>
> This is a bug and has to be fixed. The bug is that DROP NODE should not be
> trying to acquire the lock. I will send a fix for this today. The steps
> remain the same as before.
>
>
>
>>
>> Regards;
>> ----------
>> Koichi Suzuki
>>
>
>
>
> --
> --
> *Abbas*
>  Architect
>
> Ph: 92.334.5100153
>  Skype ID: gabbasb
> www.enterprisedb.co <http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
> *
> Follow us on Twitter*
> @EnterpriseDB
>
> Visit EnterpriseDB for tutorials, webinars, whitepapers<http://www.enterprisedb.com/resources-community>and more<http://www.enterprisedb.com/resources-community>
>



-- 
-- 
*Abbas*
 Architect

Ph: 92.334.5100153
 Skype ID: gabbasb
www.enterprisedb.co
<http://www.enterprisedb.com/>m<http://www.enterprisedb.com/>
*
Follow us on Twitter*
@EnterpriseDB

Visit EnterpriseDB for tutorials, webinars,
whitepapers<http://www.enterprisedb.com/resources-community>and
more<http://www.enterprisedb.com/resources-community>