[Postgres-xl-general] ALTER TABLE - ADD NODE
ajackson at revionics.com
Thu Sep 18 21:06:52 PDT 2014
So I added a datanode to my cluster this evening (more or less by hand for fear of it going sideways with pgxc_ctl). The datanode was added to all coordinators and then to all other datanodes without any incident. Then I did the following:
ALTER TABLE client.foo ADD NODE (datanode4);
Well, client.foo has about 60M rows in it so this took a while. When I came back, I saw the following error on my screen.
ERROR: tuple already updated by self
So, I decided to see if the table sizes on each node via an execute direct with each node.
devanalysis57=# execute direct on (datanode1) 'select count(*) from client.foo';
devanalysis57=# execute direct on (datanode2) 'select count(*) from client.foo';
devanalysis57=# execute direct on (datanode3) 'select count(*) from client.foo';
devanalysis57=# execute direct on (datanode4) 'select count(*) from client.foo';
I think it's a little too coincidental that datanode4 and datanode1 have the same number of entries. I ran pgxc_pool_reload() on all nodes, so they should all be aware but to be sure, I checked pg_catalog.pgxc_node to be sure.
So, I then tried to drop datanode4 from client.foo which it didn't like very much.
ALTER TABLE client.foo delete node (datanode4);
ERROR: PGXC Node datanode4: object not in relation node list
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgres-xl-general