Re: [Postgres-xc-general] GTM CRASH

[Masataka S. <pg...@gm...>]

I'm afraid you got this issue. Can you check logs in GTM and GTM proxy?
https://sourceforge.net/p/postgres-xc/bugs/474/

If it prove right, please take the following steps.
1. Stop all component
2. Remove register.node in GTM and GTM Proxy
3. Start GTM
4. Start GTM proxy
5. Start coordinators and datanodes

Following materials will be help you to configure.
* Postgres Open 2013 (Especially SPOF Analysis in Slide deck)
  http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=Presentation_Materials

And the configuration topics described in these materials are
deprecated yet, but very helpful to know what pgxc_ctl does.
* PGDay.EU, Oct 24th, 2012, Prague, Czeck
  http://postgres-xc.sourceforge.net/misc-docs/Prague_Presentation_20121024.pdf
* Presentation at PGConfChina 2012, Jun16th, 2012, Beijing, China (I
believe this is the best material for geeks)
  http://postgres-xc.sourceforge.net/misc-docs/PGConfChina_20120610_Distribution.pdf

Regards.

On 20 February 2014 02:03, Sergio Sinuco
<ser...@da...> wrote:
> Hello everybody.
>
> I just begin to try postgrexc 1.1. I have followed configuration tutorial
> for real servers in postgresxc.wikia.com
>
> http://postgresxc.wikia.com/wiki/Real_Server_configuration
>
> I setup three nodes. The first one with a GTM. The second and third with a
> GTM Proxy, a datanode and a coordinator in each one.
>
> Everything is OK, until I kill the GTM process in first node. After restart
> everything in all nodes I can't insert new data in tables. When I try it,
> following message is showed:
>
> ERROR:
> STATEMENT:  INSERT INTO public.test(name) VALUES ('CARLOS'::text)
>
> Then, I can't connect to coordinators and following message is showed:
>
> ERROR:  GTM error, could not obtain snapshot XID = 0
> WARNING:  can not connect to GTM: Connection refused
>
> I know that there is a way to configure Postgres-XC in order to have high
> availability (GTM Stand By and other stuff), but the question is, when GTM
> process and even its contingency crash there is no way to get a right
> behaviour of the cluster?
>
> Thanks.
>
> --
> Sergio E. Sinuco Leon
> Arquitecto de soluciones
> Datatraffic S.A.S.
> Móvil: (57) 310 884 26 50
> Fijo (+571) 7426160 Ext 115
> Calle 93 # 15-27 Ofc. 502
> Calle 29 # 6 - 94 Ofc. 601
> Bogotá, Colombia.
> www.datatraffic.com.co
>
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
> http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>