这篇文章主要讲解了“怎么解决Greenplum初始化数据库gpinitsystem报错”，文中的讲解内容简单清晰，易于学习与理解，下面请大家跟着小编的思路慢慢深入，一起来研究和学习“怎么解决Greenplum初始化数据库gpinitsystem报错”吧！

初始化报错解决报错Unable to resolve mdw on this host现象

[gpadmin@sdw1~]$gpinitsystem-cgpconfigs/gpinitsystem_config-hgpconfigs/hostfile_gpinitsystem20200618:15:33:10:010535gpinitsystem:sdw1:gpadmin-[INFO]:-Checkingconfigurationparameters,pleasewait...20200618:15:33:10:010535gpinitsystem:sdw1:gpadmin-[INFO]:-ReadingGreenplumconfigurationfilegpconfigs/gpinitsystem_config20200618:15:33:10:010535gpinitsystem:sdw1:gpadmin-[INFO]:-Localehasnotbeensetingpconfigs/gpinitsystem_config,willsettodefaultvalue20200618:15:33:10:010535gpinitsystem:sdw1:gpadmin-[INFO]:-Localesettoen_US.utf820200618:15:33:10:010535gpinitsystem:sdw1:gpadmin-[WARN]:-Masterhostnamemdwdoesnotmatchhostnameoutput20200618:15:33:10:010535gpinitsystem:sdw1:gpadmin-[INFO]:-Checkingtoseeifmdwcanberesolvedonthishost20200618:15:33:11:010535gpinitsystem:sdw1:gpadmin-[FATAL]:-Masterhostnameinconfigurationfileismdw20200618:15:33:11:010535gpinitsystem:sdw1:gpadmin-[FATAL]:-Operatingsystemcommandreturnssdw120200618:15:33:11:010535gpinitsystem:sdw1:gpadmin-[FATAL]:-Unabletoresolvemdwonthishost20200618:15:33:11:010535gpinitsystem:sdw1:gpadmin-[FATAL]:-MasterhostnameingpinitsystemconfigurationfilemustbemdwScriptExiting!原因

由于gpinitsystem命令config要求不能写master节点hostname，所以无法使用hostfile解析master节点hostname，所以需要使用Master节点初始化Greenplum。

解决

使用mdw节点gpinitsystem初始化Greenplum。

报错Unknown host sdw1: ping: sdw1现象

[gpadmin@mdw~]$gpinitsystem-cgpconfigs/gpinitsystem_config-hgpconfigs/hostfile_gpinitsystem20200618:15:35:11:007212gpinitsystem:mdw:gpadmin-[INFO]:-Checkingconfigurationparameters,pleasewait......>y20200618:15:36:27:007212gpinitsystem:mdw:gpadmin-[INFO]:-BuildingtheMasterinstancedatabase,pleasewait...20200618:15:36:33:007212gpinitsystem:mdw:gpadmin-[INFO]:-StartingtheMasterinadminmode20200618:15:36:34:007212gpinitsystem:mdw:gpadmin-[FATAL]:-Unknownhostsdw1:ping:sdw1:Nameorservicenotknownping:sdw1:NameorservicenotknownScriptExiting!20200618:15:36:34:007212gpinitsystem:mdw:gpadmin-[WARN]:-ScripthasleftGreenplumDatabaseinanincompletestate20200618:15:36:34:007212gpinitsystem:mdw:gpadmin-[WARN]:-Runcommandbash/home/gpadmin/gpAdminLogs/backout_gpinitsystem_gpadmin_20200618_153511toremovethesechanges20200618:15:36:34:007212gpinitsystem:mdw:gpadmin-[INFO]:-StartFunctionBACKOUT_COMMAND20200618:15:36:34:007212gpinitsystem:mdw:gpadmin-[INFO]:-EndFunctionBACKOUT_COMMAND原因

segment两台机器真实的hostname需要在/etc/hosts文件中有映射关系。

解决

需要将segment主机真实hostname加入/etc/hosts文件。

报错No segment started for content: 0现象

初始化命令报错信息：

20200618:15:58:27:014010gpstart:mdw:gpadmin-[INFO]:-Startinggpstartwithargs:-a-l/home/gpadmin/gpAdminLogs-d/data/master/gpseg-120200618:15:58:27:014010gpstart:mdw:gpadmin-[INFO]:-Gatheringinformationandvalidatingtheenvironment...20200618:15:58:27:014010gpstart:mdw:gpadmin-[INFO]:-GreenplumBinaryVersion:'postgres(GreenplumDatabase)6.8.0buildcommit:d9b16e3438fc6e01e6083cd82cf76ba99c1b50b5'20200618:15:58:27:014010gpstart:mdw:gpadmin-[INFO]:-GreenplumCatalogVersion:'301908232'20200618:15:58:27:014010gpstart:mdw:gpadmin-[INFO]:-StartingMasterinstanceinadminmode20200618:15:58:28:014010gpstart:mdw:gpadmin-[INFO]:-ObtainingGreenplumMastercataloginformation20200618:15:58:28:014010gpstart:mdw:gpadmin-[INFO]:-ObtainingSegmentdetailsfrommaster...20200618:15:58:28:014010gpstart:mdw:gpadmin-[INFO]:-Settingnewmasterera20200618:15:58:28:014010gpstart:mdw:gpadmin-[INFO]:-MasterStarted...20200618:15:58:28:014010gpstart:mdw:gpadmin-[INFO]:-Shuttingdownmaster20200618:15:58:28:014010gpstart:mdw:gpadmin-[INFO]:-Commencingparallelsegmentinstancestartup,pleasewait...20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-Processresults...20200618:15:58:34:014010gpstart:mdw:gpadmin-[ERROR]:-Nosegmentstartedforcontent:0.20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-dumpingsuccesssegments:['sdw1:/data2/primary/gpseg1:content=1:dbid=3:role=p:preferred_role=p:mode=n:status=u','sdw2:/data2/primary/gpseg3:content=3:dbid=5:role=p:preferred_role=p:mode=n:status=u']20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-DBID:2FAILEDhost:'sdw1'datadir:'/data1/primary/gpseg0'withreason:'PG_CTLfailed.'20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-DBID:4FAILEDhost:'sdw2'datadir:'/data1/primary/gpseg2'withreason:'PG_CTLfailed.'20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-Successfulsegmentstarts=220200618:15:58:34:014010gpstart:mdw:gpadmin-[WARNING]:-Failedsegmentstarts=2<<<<<<<<20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-Skippedsegmentstarts(segmentsaremarkeddowninconfiguration)=020200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-Successfullystarted2of4segmentinstances<<<<<<<<20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------20200618:15:58:34:014010gpstart:mdw:gpadmin-[WARNING]:-Segmentinstancestartupfailuresreported20200618:15:58:34:014010gpstart:mdw:gpadmin-[WARNING]:-Failedstart2of4segmentinstances<<<<<<<<20200618:15:58:34:014010gpstart:mdw:gpadmin-[WARNING]:-Review/home/gpadmin/gpAdminLogs/gpstart_20200618.log20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-----------------------------------------------------20200618:15:58:34:014010gpstart:mdw:gpadmin-[INFO]:-Commencingparallelsegmentinstanceshutdown,pleasewait...20200618:15:58:36:014010gpstart:mdw:gpadmin-[ERROR]:-gpstarterror:Donothaveenoughvalidsegmentstostartthearray.

gpinitsystem_20200618.log报错信息：

20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:-FailedtostartGreenpluminstance;reviewgpstartoutputto20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:-determinewhygpstartfailedandreinitializeclusterafterresolving20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:-issues.Notallinitializationtaskshavecompletedsothecluster20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:-shouldnotbeused.20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:-gpinitsystemwillnowtrytostopthecluster20200618:16:21:05:015525gpinitsystem:mdw:gpadmin-[WARN]:20200618:16:21:06:015525gpinitsystem:mdw:gpadmin-[INFO]:-StartFunctionERROR_EXIT20200618:16:21:06:015525gpinitsystem:mdw:gpadmin-[WARN]:-FailedtostopnewGreenpluminstanceScriptExiting!诊断

gpstart-m-d/data/master/gpseg-1/*只启动mastergpstop-a-Mfast/*-a禁止输出确认y/n，-Mfast/immediate/smart，相当于oracleshutdownabort/immediate/normalgpstart-a-v/*-vverbose输出详细启动日志。

上翻找到该节点启动失败命令

stderr=''20200618:16:36:06:016487gpsegstart.py_sdw2:gpadmin:sdw2:gpadmin-[DEBUG]:-[worker1]finishedcmd:Startingsegatdir/data1/primary/gpseg2cmdStr='envGPSESSID=0000000000GPERA=8a0d21cca0b8bbb8_200618163604$GPHOME/bin/pg_ctl-D/data1/primary/gpseg2-l/data1/primary/gpseg2/pg_log/startup.log-w-t600-o"-p6000"start2>&1'hadresult:cmdhadrc=1completed=Truehalted=Falsestdout='waitingforservertostart....stoppedwaitingpg_ctl:couldnotstartserver

去对应节点找到启动日志文件/data2/primary/gpseg3/pg_log/startup.log

2020-06-1816:36:05.835068CST,,,p16504,th746150272,,,,0,,,seg2,,,,,"LOG","00000","registeringbackgroundworker""sweeperprocess""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,2020-06-1816:36:05.835486CST,,,p16504,th746150272,,,,0,,,seg2,,,,,"LOG","XX000","couldnotbindIPv4socket:Addressalreadyinuse",,"Isanotherpostmasteralreadyrunningonport6000?Ifnot,waitafewsecondsandretry.",,,,,,"StreamServerPort","pqcomm.c",503,2020-06-1816:36:05.835741CST,,,p16504,th746150272,,,,0,,,seg2,,,,,"LOG","XX000","couldnotbindIPv6socket:Addressalreadyinuse",,"Isanotherpostmasteralreadyrunningonport6000?Ifnot,waitafewsecondsandretry.",,,,,,"StreamServerPort","pqcomm.c",503,2020-06-1816:36:05.836023CST,,,p16504,th746150272,,,,0,,,seg2,,,,,"WARNING","01000","couldnotcreatelistensocketfor""*""",,,,,,,,"PostmasterMain","postmaster.c",1202,2020-06-1816:36:05.836162CST,,,p16504,th746150272,,,,0,,,seg2,,,,,"FATAL","XX000","couldnotcreateanyTCP/IPsockets",,,,,,,,"PostmasterMain","postmaster.c",1207,10xbe84ecpostgreserrstart(elog.c:557)

检查发现图形界面占用了6000端口，导致segment启动失败。

[root@sdw2~]#netstat-anp|grep6000tcp000.0.0.0:60000.0.0.0:*LISTEN3969/Xtcp600:::6000:::*LISTEN3969/X[root@sdw2~]#解决

修改gpinitsystem gpconfig，将Master instance与Segment instance端口修改为：PORT_BASE=6500，MIRROR_PORT_BASE=7500

重新运行初始化

报错Inconsistency between number of multi-home hostnames and number of segments per host现象

[gpadmin@mdwgpconfigs]$gpinitsystem-cgpinitsystem_config-hhostfile_gpinitsystem-smdw-S/data/master/standby/[gpadmin@mdwgpconfigs]$gpinitsystem-cgpinitsystem_config-hhostfile_gpinitsystem-smdw-S/data/standby/20200619:21:15:17:001508gpinitsystem:mdw:gpadmin-[INFO]:-Checkingconfigurationparameters,pleasewait...20200619:21:15:17:001508gpinitsystem:mdw:gpadmin-[INFO]:-ReadingGreenplumconfigurationfilegpinitsystem_config20200619:21:15:17:001508gpinitsystem:mdw:gpadmin-[INFO]:-Localehasnotbeensetingpinitsystem_config,willsettodefaultvalue20200619:21:15:17:001508gpinitsystem:mdw:gpadmin-[INFO]:-Localesettoen_US.utf820200619:21:15:17:001508gpinitsystem:mdw:gpadmin-[INFO]:-MASTER_MAX_CONNECTnotset,willsettodefaultvalue25020200619:21:15:18:001508gpinitsystem:mdw:gpadmin-[INFO]:-Checkingconfigurationparameters,Completed20200619:21:15:18:001508gpinitsystem:mdw:gpadmin-[INFO]:-Commencingmulti-homechecks,pleasewait.......20200619:21:15:19:001508gpinitsystem:mdw:gpadmin-[INFO]:-Configuringbuildformulti-homearray20200619:21:15:19:001508gpinitsystem:mdw:gpadmin-[FATAL]:-Inconsistencybetweennumberofmulti-homehostnamesandnumberofsegmentsperhost20200619:21:15:19:001508gpinitsystem:mdw:gpadmin-[INFO]:-Have3datadirectoriesand2multi-homehostnamesforeachhost20200619:21:15:19:001508gpinitsystem:mdw:gpadmin-[INFO]:-Formulti-homeconfiguration,numberofsegmentinstancedatadirectoriesperhostmustbemultipleof20200619:21:15:19:001508gpinitsystem:mdw:gpadmin-[INFO]:-thenumberofmulti-homehostnameswithintheGPDBarray20200619:21:15:19:001508gpinitsystem:mdw:gpadmin-[FATAL]:-UnabletocontinueScriptExiting!原因

hostfile中只有两个主机名对应segment interface，config文件中DATA_DIRECTORY每个主机指定了3个segment instance，无法平衡，报错。

解决

修改DATA_DIRECTORY为每个segment主机四个segment instance，或者修改hostfile列表，修改为3个interface。

添加Standby Master报错gpinitstandby -S指定目录已存在

[gpadmin@mdwgpconfigs]$gpinitstandby-smdw-S/data/standby/-P543320200619:21:27:37:011844gpinitstandby:mdw:gpadmin-[INFO]:-Validatingenvironmentandparametersforstandbyinitialization...20200619:21:27:38:011844gpinitstandby:mdw:gpadmin-[INFO]:-Checkingfordatadirectory/data/standby/onmdw20200619:21:27:38:011844gpinitstandby:mdw:gpadmin-[ERROR]:-Datadirectoryalreadyexistsonhostmdw20200619:21:27:38:011844gpinitstandby:mdw:gpadmin-[ERROR]:-Ifyouwanttoinitializeanewstandbyonthesamehostasthemaster(notrecommended),use-Sand-Ptospecifyanewdatadirectoryandport20200619:21:27:38:011844gpinitstandby:mdw:gpadmin-[ERROR]:-Failedtocreatestandby20200619:21:27:38:011844gpinitstandby:mdw:gpadmin-[ERROR]:-Errorinitializingstandbymaster:masterdatadirectoryexists

解决

查看目录，如果已经存在，更换或者删除目录，gpinitstandby命令自行创建。

同机器创建Standby Master Instance使用默认端口与Master Instance冲突

[gpadmin@mdwdata]$gpinitstandby-smdw-S/data/standby/20200619:21:29:03:012052gpinitstandby:mdw:gpadmin-[INFO]:-Validatingenvironmentandparametersforstandbyinitialization...20200619:21:29:03:012052gpinitstandby:mdw:gpadmin-[INFO]:-Checkingfordatadirectory/data/standby/onmdw20200619:21:29:04:012052gpinitstandby:mdw:gpadmin-[ERROR]:-Failedtocreatestandby20200619:21:29:04:012052gpinitstandby:mdw:gpadmin-[ERROR]:-Errorinitializingstandbymaster:cannotcreatestandbyonthesamehostandport

解决

使用gpinitstandby -P指定与Master不同端口。

解决问题重新运行

[gpadmin@mdwdata]$gpinitstandby-smdw-S/data/standby/-P553220200619:21:29:23:012192gpinitstandby:mdw:gpadmin-[INFO]:-Validatingenvironmentandparametersforstandbyinitialization...20200619:21:29:23:012192gpinitstandby:mdw:gpadmin-[INFO]:-Checkingfordatadirectory/data/standby/onmdw20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplumstandbymasterinitializationparameters20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:------------------------------------------------------20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplummasterhostname=mdw20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplummasterdatadirectory=/data/master/gpseg-120200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplummasterport=543220200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplumstandbymasterhostname=mdw20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplumstandbymasterport=553220200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplumstandbymasterdatadirectory=/data/standby/20200619:21:29:24:012192gpinitstandby:mdw:gpadmin-[INFO]:-Greenplumupdatesystemcatalog=OnDoyouwanttocontinuewithstandbymasterinitialization?Yy|Nn(default=N):>y20200619:21:29:27:012192gpinitstandby:mdw:gpadmin-[INFO]:-SyncingGreenplumDatabaseextensionstostandby20200619:21:29:28:012192gpinitstandby:mdw:gpadmin-[INFO]:-Thepackagesonmdwareconsistent.20200619:21:29:28:012192gpinitstandby:mdw:gpadmin-[INFO]:-Addingstandbymastertocatalog...20200619:21:29:28:012192gpinitstandby:mdw:gpadmin-[INFO]:-Databasecatalogupdatedsuccessfully.20200619:21:29:28:012192gpinitstandby:mdw:gpadmin-[INFO]:-Updatingpg_hba.conffile...20200619:21:29:51:012192gpinitstandby:mdw:gpadmin-[INFO]:-pg_hba.conffilesupdatedsuccessfully.20200619:21:29:53:012192gpinitstandby:mdw:gpadmin-[INFO]:-Startingstandbymaster20200619:21:29:53:012192gpinitstandby:mdw:gpadmin-[INFO]:-Checkingifstandbymasterisrunningonhost:mdwindirectory:/data/standby/20200619:21:29:58:012192gpinitstandby:mdw:gpadmin-[INFO]:-Cleaninguppg_hba.confbackupfiles...20200619:21:30:07:012192gpinitstandby:mdw:gpadmin-[INFO]:-Backupfilesofpg_hba.confcleanedupsuccessfully.20200619:21:30:07:012192gpinitstandby:mdw:gpadmin-[INFO]:-Successfullycreatedstandbymasteronmdw[gpadmin@mdwdata]$

感谢各位的阅读，以上就是“怎么解决Greenplum初始化数据库gpinitsystem报错”的内容了，经过本文的学习后，相信大家对怎么解决Greenplum初始化数据库gpinitsystem报错这一问题有了更深刻的体会，具体使用情况还需要大家实践验证。这里是亿速云，小编将为大家推送更多相关知识点的文章，欢迎关注！