Re: [Postgres-xc-general] GTM CRASH

[Sergio S. <ser...@da...>]

Hi. Thanks for reply. Effectively I applied the patches to 1.1 version and
It worked. However I had to remove register.node files in GTM and GTM Proxy
too because if I didn't do it then the cluster didn't work.

Now I will try 1.1 version with these patches and postgis patch in order to
find if they are compatible. I will let you know my results.

I will try 1.2 version too.

Thanks.


2014-02-19 21:15 GMT-05:00 Masataka Saito <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
> >
>



-- 
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