Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the Greenplum initialization database gpinitsystem error", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "how to solve the Greenplum initialization database gpinitsystem error" bar!

Initialize error reporting to solve Unable to resolve mdw on this host phenomenon [gpadmin@sdw1] $gpinitsystem-c gpconfigs/gpinitsystem_config-h gpconfigs/hostfile_gpinitsystem20200618:15:33:10:010535 gpinitsystem:sdw1:gpadmin- [INFO]:-Checking configuration parameters, please wait...20200618:15:33:10:010535 gpinitsystem:sdw1:gpadmin- [INFO]:-Reading Greenplum configuration file gpconfigs/gpinitsystem_config20200618:15:33:10:010535 gpinitsystem:sdw1:gpadmin- [INFO]:-Locale has not been set in gpconfigs/gpinitsystem_config Will set to default value20200618:15:33:10:010535 gpinitsystem:sdw1:gpadmin- [INFO]:-Locale set to en_US.utf820200618:15:33:10:010535 gpinitsystem:sdw1:gpadmin- [WARN]:-Master hostname mdw does not match hostname output20200618:15:33:10:010535 gpinitsystem:sdw1:gpadmin- [INFO]:-Checking to see if mdw can be resolved on this host20200618:15:33:11:010535 gpinitsystem:sdw1:gpadmin- [FATAL]:-Master hostname in configuration file is mdw20200618:15:33: 11Operating system command returns sdw120200618:15:33:11:010535 gpinitsystem:sdw1:gpadmin- 010535 gpinitsystem:sdw1:gpadmin- [FATAL]:-Operating system command returns sdw120200618:15:33:11:010535 gpinitsystem:sdw1:gpadmin- [FATAL]:-Unable to resolve mdw on this host20200618:15:33:11:010535 gpinitsystem:sdw1:gpadmin- [FATAL]:-Master hostname in gpinitsystem configuration file must be mdwScript Exiting! Reason

Because the gpinitsystem command config requires that the master node hostname cannot be written, the master node hostname cannot be parsed using hostfile, so you need to initialize the Greenplum with the Master node.

Solve

Initialize the Greenplum with the mdw node gpinitsystem.

Error Unknown host sdw1: ping: sdw1 phenomenon [gpadmin@mdw ~] $gpinitsystem-c gpconfigs/gpinitsystem_config-h gpconfigs/hostfile_gpinitsystem20200618:15:35:11:007212 gpinitsystem:mdw:gpadmin- [INFO]:-Checking configuration parameters, please wait... ... > y20200618 gpinitsystem:mdw:gpadmin- 1536 Frev 27lo 007212 gpinitsystem:mdw:gpadmin- [INFO]:-Building the Master instance database Please wait...20200618:15:36:33:007212 gpinitsystem:mdw:gpadmin- [INFO]:-Starting the Master in admin mode20200618:15:36:34:007212 gpinitsystem:mdw:gpadmin- [FATAL]:-Unknown host sdw1: ping: sdw1: Name or service not knownping: sdw1: Name or service not known Script Extravaganza 20200618 :-Run command bash / home/gpadmin/gpAdminLogs/backout_gpinitsystem_gpadmin_20200618_153511 to remove these changes20200618:15:36:34:007212 gpinitsystem:mdw:gpadmin- [INFO]:-Start Function BACKOUT_COMMAND20200618:15:36:34:007212 gpinitsystem:mdw:gpadmin- [INFO]:-End Function BACKOUT_COMMAND reason

Segment the real hostname of the two machines needs to be mapped in the / etc/hosts file.

Solve

The real hostname of the segment host needs to be added to the / etc/hosts file.

Error No segment started for content: 0 phenomenon

Initialization command error message:

20200618 15 home/gpadmin/gpAdminLogs 58 27 gpstart:mdw:gpadmin- 014010 [INFO]:-Starting gpstart with args:-a-l / home/gpadmin/gpAdminLogs-d / data/master/gpseg-120200618:15:58:27:014010 gpstart:mdw:gpadmin- [INFO]:-Gathering information and validating the environment...20200618:15:58:27:014010 gpstart:mdw:gpadmin- [INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 6.8.0 build commit:d9b16e3438fc6e01e6083cd82cf76ba99c1b50b5'20200618:15:58 27INFO 014010 gpstart:mdw:gpadmin- [INFO]:-Greenplum Catalog Version: '301908232mm 20200618 gpstart:mdw:gpadmin- 1558 14010 gpstart:mdw:gpadmin- [INFO]:-Starting Master instance in admin mode20200618:15:58:28:014010 gpstart:mdw:gpadmin- [INFO]:-Obtaining Greenplum Master catalog information20200618:15:58:28:014010 gpstart:mdw:gpadmin- [INFO]:-Obtaining Segment details from master...20200618:15:58:28:014010 gpstart:mdw:gpadmin- [INFO]:- Setting new master era20200618:15:58:28:014010 gpstart:mdw:gpadmin- [INFO]:-Master Started...20200618:15:58:28:014010 gpstart:mdw:gpadmin- [INFO]:-Shutting down master20200618:15:58:28:014010 gpstart:mdw:gpadmin- [INFO]:-Commencing parallel segment instance startup Please wait...20200618:15:58:34:014010 gpstart:mdw:gpadmin- [INFO]:-Process results...20200618:15:58:34:014010 gpstart:mdw:gpadmin- [ERROR]:-No segment started for content: 0.20200618 Process results...20200618:15:58:34:014010 gpstart:mdw:gpadmin- 1515 14010 gpstart:mdw:gpadmin- [INFO]:-dumping success segments: ['sdw1:/data2/primary/gpseg1:content=1:dbid=3:role=p:preferred_role=p:mode=n:status=u' Gpstart:mdw:gpadmin- [INFO]:-20200618 gpstart:mdw:gpadmin- [INFO]:-20200618 gpstart:mdw:gpadmin- [INFO]:-DBID: 2 FAILED host:'sdw1' datadir:'/data1/primary/gpseg0' with reason:'PG_CTL failed.'20200618:15:58:34:014010 gpstart:mdw:gpadmin- [INFO]:-DBID:4 FAILED host:'sdw2' datadir:'/data1/primary/gpseg2' with reason:'PG_CTL failed.'20200618:15:58:34:014010 gpstart:mdw:gpadmin- [INFO]:- -- 20200618 gpstart:mdw:gpadmin- 1514010 gpstart:mdw:gpadmin- [INFO]:-202006181514010 gpstart:mdw:gpadmin-:- Successful segment starts = 220200618 gpstart:mdw:gpadmin- 1558 14010 gpstart:mdw:gpadmin- [WARNING]:-Failed segment starts = 2

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.