Re: [Postgres-xc-bugs] Unexpected termination of gtm_proxy

[Koichi S. <koi...@gm...>]

Hemmi-san;

gtm_ctl reconnect needs new target gtm information as the option.
The following is a script I'm using for gtm_proxy reconnect.    I hope
it helps.

--------------
[koichi@willey:pgxc]$ cat gtmreconnect.sh
#!/bin/sh
cd /home/koichi/pgxc
gtm_ctl reconnect -S gtm_proxy -D nodes/gtm_pxy1 -o "-s 172.30.72.74 -t 20000"
gtm_ctl reconnect -S gtm_proxy -D nodes/gtm_pxy2 -o "-s 172.30.72.74 -t 20000"

[koichi@willey:pgxc]$

-s option is the host of new GTM, -t option is its port number.

Regards;
----------
Koichi Suzuki


2012/5/29 Hitoshi HEMMI <hem...@la...>:
> Hi list,
>
> This may be the last one in a series of reports I am putting here.
> For this one, I'm afraid that you might consider it vague;
> I hope you can reproduce it.
>
>
> ============================================================================
> POSTGRES-XC BUG REPORT TEMPLATE
> ============================================================================
>
> Your name : Hitoshi Hemmi
> Your email address : hem...@la...
>
>
> System Configuration:
> ---------------------
> Architecture : x86_64
>
> Operating Systems :
> A. CentOS release 6.2 x86_64
> B. RHEL5.7 x86_64
>
> Postgres-XC version : Postgres-XC 1.0beta2
>
> Compilers used :
> A. gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3)
> B. gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51)
>
> Description of problems:
> ==============================================
> Summary:
> GTM_proxy stops unexpectedly after reconnection.
>
> A little more detailed explanation:
> Three servers involve in this issue.
> GTM runs on the first server. Each of the second and third servers
> accomodates a GTM_proxy, a coordinator and a datanode.
> After necessary initiaization, we started GTM, GTM_proxies, coorinators
> and datanodes, in this order. By issueing CREATE NODE, we incorporated
> each coordinator and datanode into the xc cluster.
> We tried reconnection of gtm_proxy and found it terminated unexpectedly:
>
> [postgres@localhost ~]$ ps faxww | grep gtm | grep -v grep
> 11753 ? Sl 0:00 gtm_proxy -h localhost -p 6680 -s 192.168.129.51 -t 6666
> -D /data/gtm_proxy -i 1
> [postgres@localhost ~]$ gtm_ctl reconnect -S gtm_proxy -D /data/gtm_proxy
> [postgres@localhost ~]$ ps faxww | grep gtm | grep -v grep
> [postgres@localhost ~]$
>
> ==============================================
>
> Regards.
>
> --
> Hitoshi HEMMI
> NTT Open Source Software Center
> hem...@la...
> (Please note that my address has changed.)
> Tel:(03)5860-5115
> Fax:(03)5463-5490
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-bugs mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs