Menu
▾
▴
Re: [Postgres-xc-developers] [JDBC Regression] In XC update of a replicated table cannot be based on OID
|
From: Abbas B. <abb...@en...> - 2013-08-10 05:58:07
|
On Fri, Aug 9, 2013 at 2:19 PM, Masataka Saito <pg...@gm...> wrote: > On Thu, Aug 8, 2013 at 9:41 PM, Abbas Butt <abb...@en...> wrote: >> Hi, >> PFA patch to fix an XC limitation that update of a replicated table >> created with oids cannot be based on oids. > > When did you change distribution rule to REPLICATION from ROUNDROBIN? > I lost your patch. > >> i.e. this update supposed to fail >> update rep_table_with_oids set colum = $1 where oid=$2 >> saying >> ERROR : Write to replicated table returned different results from the Datanodes >> >> The reason is that we would select oid from the primary datanode and >> that particular oid will not be there on the rest of the datanodes. >> The patch comments explain the complete scenario in detail. >> >> With this patch the JDBC regression runs without any failures or >> errors on my machine. >> Strangely I did not have to change any thing on the server side. > > What do you experience the strangeness of? I meant that none of the tests failing in JDBC test suite require any change in the server, when this work was started we thought JDBC test suite might uncover some bug in the server. > Your patch eliminated "oid" column from the selection, therefore, > UPDATE query does not contain "oid" anymore. I think it is > straightforward. > > Regards. > >> >> -- >> Abbas >> Architect >> >> Ph: 92.334.5100153 >> Skype ID: gabbasb >> www.enterprisedb.com >> >> Follow us on Twitter >> @EnterpriseDB >> >> Visit EnterpriseDB for tutorials, webinars, whitepapers and more >> >> ------------------------------------------------------------------------------ >> Get 100% visibility into Java/.NET code with AppDynamics Lite! >> It's a free troubleshooting tool designed for production. >> Get down to code-level detail for bottlenecks, with <2% overhead. >> Download for free and get started troubleshooting in minutes. >> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk >> _______________________________________________ >> Postgres-xc-developers mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers >> -- -- Abbas Architect Ph: 92.334.5100153 Skype ID: gabbasb www.enterprisedb.com Follow us on Twitter @EnterpriseDB Visit EnterpriseDB for tutorials, webinars, whitepapers and more |
