[Postgres-xl-general] Problem adding node using pgxc_ctl
Michael Misiewicz
mmisiewicz at gmail.com
Mon Dec 19 19:41:23 PST 2016
File attached. I have 9.5r1.4, as downloaded and compiled from postgres-xl.org <http://postgres-xl.org/>. I was able to reproduce this behavior on both macOS and Ubuntu 14.04.
I was able to get it seemingly working OK with a toy database today - by editing pgxl_ctl.conf, init’ing my new data node, and then starting it. But I understand from Mason’s post that this is nor the recommended procedure (and I want to do this on a database that’s got some data I’d prefer not to lose in it).
> On Dec 19, 2016, at 22:38, Pavan Deolasee <pavan.deolasee at gmail.com> wrote:
>
>
>
> On Tue, Dec 20, 2016 at 4:27 AM, Michael Misiewicz <mmisiewicz at gmail.com <mailto:mmisiewicz at gmail.com>> wrote:
> Seems like this code was last changed here:
> https://git.postgresql.org/gitweb/?p=postgres-xl.git;a=commit;f=contrib/pgxc_ctl/datanode_cmd.c;h=e861c467a05cf70f2c3db94c6993def219c0db47 <https://git.postgresql.org/gitweb/?p=postgres-xl.git;a=commit;f=contrib/pgxc_ctl/datanode_cmd.c;h=e861c467a05cf70f2c3db94c6993def219c0db47>
>
> This block of code seems a bit unclear:
> /*
> * Check if datanode masgter configuration is consistent
> */
> idx = size = arraySizeName(VAR_datanodeNames);
> if ((arraySizeName(VAR_datanodePorts) != size) ||
> (arraySizeName(VAR_datanodePoolerPorts) != size) ||
> (arraySizeName(VAR_datanodeMasterServers) != size) ||
> (arraySizeName(VAR_datanodeMasterDirs) != size) ||
> (arraySizeName(VAR_datanodeMasterWALDirs) != size) ||
> (arraySizeName(VAR_datanodeMaxWALSenders) != size) ||
> (arraySizeName(VAR_datanodeSpecificExtraConfig) != size) ||
> (arraySizeName(VAR_datanodeSpecificExtraPgHba) != size))
> {
> elog(ERROR, "ERROR: Found some conflicts in datanode master configuration.\n");
> return 1;
> }
>
>
> So I'm guessing the error is being caused by one of those things not having the same size as datanodeNames? I don't understand, I'm trying to ADD a data node here...
>
>
>
> Can you share your pgxc_ctl.conf file? Also, which XL version are you using?
>
> Thanks,
> Pavan
>
> --
> Pavan Deolasee http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/>
> PostgreSQL Development, 24x7 Support, Training & Services
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20161219/40585ae1/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgxc_ctl.conf
Type: application/octet-stream
Size: 17476 bytes
Desc: not available
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20161219/40585ae1/attachment.obj>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20161219/40585ae1/attachment-0001.htm>
More information about the postgres-xl-general
mailing list