Re: [Postgres-xc-general] GTM CRASH

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

We've found one of the cause of this problem and a patch has been
submitted to developers mailing list.   Hope this is included in the
minor release as well.

The thread is titled Yet another analysis of "GTM error, could not
obtain snapshot"

You will find the patch in developers mailing list.

It's very helpful if you try this patch to 1.1 and let us know how it works.

Masataka: Could you provide info for this patch, what release it is
for and your view how it works with Sergio's case?

Regards;
---
Koichi Suzuki


2014-02-20 2:03 GMT+09:00 Sergio Sinuco <ser...@da...>:
> 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
>