greenplum吧 关注:94贴子:145
  • 3回复贴,共1

关于greenplum扩容报错,救救孩子吧

只看楼主收藏回复

在运行 gpexpand 初始化新 Instance时,出现
错误,大家帮帮忙吧!
[gpadmin@MDW ~/conf]$ gpexpand -i gpexpand_inputfile_20190325_143036 -D gdb
20190325:14:35:50:001688 gpexpand:mdw:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 5.8.1 build commit:6617c3878789b04d0b11fa986ab13c41fcf710d7'
20190325:14:35:50:001688 gpexpand:mdw:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.3.23 (Greenplum Database 5.8.1 build commit:6617c3878789b04d0b11fa986ab13c41fcf710d7) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0, 64-bit compiled on Jun 2 2018 00:03:52'
20190325:14:35:50:001688 gpexpand:mdw:gpadmin-[INFO]:-Querying gpexpand schema for current expansion state
20190325:14:35:51:001688 gpexpand:mdw:gpadmin-[INFO]:-Readying Greenplum Database for a new expansion
20190325:14:36:10:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database template1 for unalterable tables...
20190325:14:36:10:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database postgres for unalterable tables...
20190325:14:36:10:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database help for unalterable tables...
20190325:14:36:10:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database gdb for unalterable tables...
20190325:14:36:11:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database template1 for tables with unique indexes...
20190325:14:36:11:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database postgres for tables with unique indexes...
20190325:14:36:11:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database help for tables with unique indexes...
20190325:14:36:11:001688 gpexpand:mdw:gpadmin-[INFO]:-Checking database gdb for tables with unique indexes...
20190325:14:36:11:001688 gpexpand:mdw:gpadmin-[INFO]:-Heap checksum setting consistent across cluster
20190325:14:36:11:001688 gpexpand:mdw:gpadmin-[INFO]:-Syncing Greenplum Database extensions
20190325:14:36:13:001688 gpexpand:mdw:gpadmin-[INFO]:-The packages on sdw4 are consistent.
20190325:14:36:14:001688 gpexpand:mdw:gpadmin-[INFO]:-The packages on sdw3 are consistent.
20190325:14:36:15:001688 gpexpand:mdw:gpadmin-[INFO]:-Creating segment template
20190325:14:36:15:001688 gpexpand:mdw:gpadmin-[INFO]:-VACUUM FULL on the catalog tables
20190325:14:36:20:001688 gpexpand:mdw:gpadmin-[INFO]:-Starting copy of segment dbid 1 to location /opt/greenplum/gpdata/gpmaster/gpexpand_03252019_1688
20190325:14:36:35:001688 gpexpand:mdw:gpadmin-[INFO]:-Copying postgresql.conf from existing segment into template
20190325:14:36:35:001688 gpexpand:mdw:gpadmin-[INFO]:-Copying pg_hba.conf from existing segment into template
20190325:14:36:36:001688 gpexpand:mdw:gpadmin-[INFO]:-Adding new segments into template pg_hba.conf
20190325:14:36:36:001688 gpexpand:mdw:gpadmin-[INFO]:-Creating schema tar file
20190325:14:36:43:001688 gpexpand:mdw:gpadmin-[INFO]:-Distributing template tar file to new hosts
20190325:14:36:59:001688 gpexpand:mdw:gpadmin-[INFO]:-Configuring new segments (primary)
20190325:14:37:04:001688 gpexpand:mdw:gpadmin-[ERROR]:-gpexpand failed: ExecutionError: 'Error Executing Command: ' occured. Details: 'GPSTART_INTERNAL_MASTER_ONLY=1 && ssh -o 'StrictHostKeyChecking no' sdw4 ". /opt/greenplum/greenplum-db/greenplum_path.sh; GPSTART_INTERNAL_MASTER_ONLY=1 && $GPHOME/bin/lib/gpconfigurenewsegment -c \"/opt/greenplum/gpdata/gpdatap1/gpseg6:33000:true:false:13,/opt/greenplum/gpdata/gpdatap2/gpseg7:33001:true:false:14\" -n -t ./gpexpand_schema.tar -B 8"' cmd had rc=1 completed=True halted=False
stdout='20190325:14:37:04:001202 gpconfigurenewsegment:sdw4:gpadmin-[INFO]:-Starting gpconfigurenewsegment with args: -c /opt/greenplum/gpdata/gpdatap1/gpseg6:33000:true:false:13,/opt/greenplum/gpdata/gpdatap2/gpseg7:33001:true:false:14 -n -t ./gpexpand_schema.tar -B 8
20190325:14:37:04:001202 gpconfigurenewsegment:sdw4:gpadmin-[INFO]:-Validate data directories for new segment
20190325:14:37:04:001202 gpconfigurenewsegment:sdw4:gpadmin-[INFO]:-Validate data directories for new segment
20190325:14:37:04:001202 gpconfigurenewsegment:sdw4:gpadmin-[ERROR]:-ExecutionError: 'Error Executing Command: ' occured. Details: '/opt/greenplum/greenplum-db/bin/lib/gpconfigurenewsegment -c /opt/greenplum/gpdata/gpdatap1/gpseg6:33000:true:false:13,/opt/greenplum/gpdata/gpdatap2/gpseg7:33001:true:false:14 -n -t ./gpexpand_schema.tar -B 8' cmd had rc=1 completed=True halted=False
stdout=''
stderr='Parent directory for system data directory '/opt/greenplum/gpdata/gpdatap1/gpseg6' does not exist'
'
stderr='ExecutionError: 'Error Executing Command: ' occured. Details: '/opt/greenplum/greenplum-db/bin/lib/gpconfigurenewsegment -c /opt/greenplum/gpdata/gpdatap1/gpseg6:33000:true:false:13,/opt/greenplum/gpdata/gpdatap2/gpseg7:33001:true:false:14 -n -t ./gpexpand_schema.tar -B 8' cmd had rc=1 completed=True halted=False
stdout=''
stderr='Parent directory for system data directory '/opt/greenplum/gpdata/gpdatap1/gpseg6' does not exist'
'
Exiting...
20190325:14:37:04:001688 gpexpand:mdw:gpadmin-[ERROR]:-Please run 'gpexpand -r -D gdb' to rollback to the original state.
20190325:14:37:04:001688 gpexpand:mdw:gpadmin-[INFO]:-Shutting down gpexpand...


1楼2019-03-25 15:10回复
    报错是你的新增的从节点下没有创建/opt/greenplum/gpdata/gpdatap1/gpseg6这个路径。
    解决方法:在你新增的节点上按照这个路径 mkdir这个文件夹 别忘了把此文件夹的所属组和所属用户 chown成pg库的那个用户和用户组


    IP属地:湖南2楼2019-04-29 14:09
    回复
      贴主,你的问题跟我一样。请问解决了吗?


      IP属地:江苏3楼2019-05-06 16:16
      收起回复