Re: [Postgres-xc-developers] Issues with GTM Standby Syncup

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

Hi, Nikhil.

Sorry for the late response.   I appreciate for this report.   Such
corner-case report is what I expected.   The patch looks reasonable but
please let me take a close look.

Best;

---
Koichi Suzuki


2013/9/16 Nikhil Sontakke <ni...@st...>

> Hi,
>
> There's an issue with GTM Standby syncup when it's joining a busy GTM
> server. This issue will not occur if the GTM has just been started and the
> GTM standby follows immediately when there are no backends asking for GXIDs.
>
> When a standby connects and asks for the GXID list, the GTM goes through
> the gt_transactions_array and sends only those structures which are in use
> (gti_in_use == true). So it's possible that slots
>
> 1, 2, 3 are in use. Then 4 and 5 might be unused and 6 might be used.
>
> So, GTM will send 4 such structures back to the Standby. Now the Standby
> naively assigns these structures to slots 1, 2, 3 and 4 (see
> gtm_standby_restore_gxid()). This messes up the assignment of handles.
>
> The fix is obviously to assign the structure to the specific gxi_handle
> index that has been retrieved from the GTM.
>
> PFA, patch which applies against master, rel11 and rel10.
>
> Regards,
> Nikhils
>
> --
> StormDB - http://www.stormdb.com
> The Database Cloud
>
>
> ------------------------------------------------------------------------------
> LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
> 1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
> SharePoint
> 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
> includes
> Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13.
> http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>