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

[鈴木 幸市 <ko...@in...>]

Thanks.  I will try it and let you know if it works fine.

Regards;
---
Koichi Suzuki



On 2013/05/13, at 15:23, Abbas Butt <abb...@en...> wrote:

> 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.com
> 
> Follow us on Twitter
> @EnterpriseDB 
> 
> Visit EnterpriseDB for tutorials, webinars, whitepapers and more
> 
> 
> 
> -- 
> -- 
> Abbas
> Architect
> 
> Ph: 92.334.5100153
> Skype ID: gabbasb
> www.enterprisedb.com
> 
> Follow us on Twitter
> @EnterpriseDB 
> 
> Visit EnterpriseDB for tutorials, webinars, whitepapers and more
> <1_drop_node.patch>------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and 
> their applications. This 200-page book is written by three acclaimed 
> leaders in the field. The early access version is available now. 
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may_______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers