[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