[Postgres-xl-general] Not able to run pgxc_ctl

Koichi Suzuki koichi.dbms at gmail.com
Thu Sep 25 18:35:52 PDT 2014


I'm afraid if /home/pgxc/pgxc_ctl has proper privilege.   It needs
write privilege.  Within pgxc_ctl generates dedicated bash script
pgxc_ctl_bash to read necessary configuration parameters.   The log
indicates pgxc_ctl failed to write this to /home/pgxc/pgxc_ctl.

Regards;
---
Koichi Suzuki


2014-09-17 1:16 GMT+09:00 Ramanuj Kumar <ramanujsingh at gmail.com>:
> Hi,
>
> I am evaluating Postgresql-XL for cluster solution in our product.
>
> I have installed pgxl at '/var/tmp/research/tmp_pgxl/pgxl/‘ location via “—prefix” option to configure command. (8.4-RELEASE FreeBSD)
> Had problem with compilation, after including "sys/wait.h” in ./src/gtm/gtm_ctl/gtm_ctl.c, and "sys/types.h” in contrib/pgxc_ctl/utils.h file compilation went fine.
>
> I am not able to run pgxc_ctl command, it gives core dump. Appreciate any help.
>
>
> ——Log—
> $ ./bin/pgxc_ctl prepare
> bash_handler.c:install_pgxc_ctl_bash(33) Installing pgxc_ctl_bash script as /home/pgxl/pgxc_ctl/pgxc_ctl_bash.
> bash_handler.c:install_pgxc_ctl_bash(33) Installing pgxc_ctl_bash script as /home/pgxl/pgxc_ctl/pgxc_ctl_bash.
> pgxc_ctl.c:read_configuration(250) Reading configuration using /home/pgxl/pgxc_ctl/pgxc_ctl_bash --home /home/pgxl/pgxc_ctl --configuration /home/pgxl/pgxc_ctl/pgxc_ctl.conf
> /home/pgxl/pgxc_ctl/pgxc_ctl_bash: not found
> pgxc_ctl.c:read_configuration(260) Finished to read configuration.
> config.c:check_configuration(1069) ERROR: GTM master configuration is missing. gtmName, gtmMasterServer, gtmMasterPort or gtmMasterDir
> config.c:check_configuration(1073) ERROR: Coordinator master configuration is missing. coordNames, coodPorts, poolerPorts, coordMasterPorts or coordMasterDirs
> config.c:check_configuration(1083) ERROR: Datanode master configuration is missing. datanodeNames, datanodePorts, datanodePoolerPorts, datanodeMasterPorts or datanodeMasterDirs
> config.c:reportMissingVar(517) ERROR: gtmName is not configured.
> config.c:reportMissingVar(517) ERROR: gtmMasterServer is not configured.
> config.c:reportMissingVar(517) ERROR: gtmMasterPort is not configured.
> config.c:reportMissingVar(517) ERROR: gtmMasterDir is not configured.
> config.c:reportMissingVar(517) ERROR: coordNames is not configured.
> config.c:reportMissingVar(517) ERROR: coordPorts is not configured.
> config.c:reportMissingVar(517) ERROR: poolerPorts is not configured.
> config.c:reportMissingVar(517) ERROR: coordMasterServers is not configured.
> config.c:reportMissingVar(517) ERROR: coordMasterDirs is not configured.
> config.c:reportMissingVar(517) ERROR: coordMaxWALSenders is not configured.
> config.c:reportMissingVar(517) ERROR: coordNames is not configured.
> config.c:reportMissingVar(517) ERROR: coordPorts is not configured.
> config.c:reportMissingVar(517) ERROR: poolerPorts is not configured.
> config.c:reportMissingVar(517) ERROR: coordMasterServers is not configured.
> config.c:reportMissingVar(517) ERROR: coordMasterDirs is not configured.
> config.c:reportMissingVar(517) ERROR: coordMaxWALSenders is not configured.
> config.c:reportMissingVar(517) ERROR: datanodeNames is not configured.
> config.c:reportMissingVar(517) ERROR: datanodePorts is not configured.
> config.c:reportMissingVar(517) ERROR: datanodePoolerPorts is not configured.
> config.c:reportMissingVar(517) ERROR: datanodeMasterServers is not configured.
> config.c:reportMissingVar(517) ERROR: datanodeMasterDirs is not configured.
> config.c:reportMissingVar(517) ERROR: datanodeMaxWALSenders is not configured.
> config.c:verifyResource(917) ERROR: Found fundamental configuration error.
> Segmentation fault
> $
> ——————
>
> —pgxc_ctl.conf file is ——
> $ cat /home/pgxl/pgxc_ctl/pgxc_ctl.conf
> pgxcOwner=pgxl
> pgxcUser=$pgxcOwner
> pgxcInstallDir=/var/tmp/research/pgxl
>
>
> gtmMasterDir=/var/tmp/research/pgxl/data/gtm_master
> gtmMasterServer=localhost
> gtmSlave=n
> gtmProxy=n
>
> coordMasterDir=/var/tmp/research/pgxl/data/coord_master
> coordNames=(coord1)
> coordPorts=(5432)
> poolerPorts=(20010)
> coordMasterServers=(localhost)
> coordMasterDirs=($coordMasterDir/coord1)
>
> coordMaxWALSenders=($coordMaxWALsernder)
> coordSlave=n
> coordSpecificExtraConfig=(none)
> coordSpecificExtraPgHba=(none)
>
> datanodeNames=(dn1 dn2)
> datanodeMasterDir=/var/tmp/research/pgxl/data/dn_master
> datanodePorts=(5433 5434)
> datanodePoolerPorts=(20011 20012)
> datanodeMasterServers=(localhost localhost)
> datanodeMasterDirs=($datanodeMasterDir/dn1 $datanodeMasterDir/dn2)
>
> datanodeMaxWALSenders=($datanodeMaxWalSender $datanodeMaxWalSender)
> datanodeSlave=n
> primaryDatanode=dn1
>
>
> $
> —————
>
>
>
> Thanks,
> Ramanuj
> ------------------------------------------------------------------------------
> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xl-general mailing list
> Postgres-xl-general at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general




More information about the postgres-xl-general mailing list