【GP集群部署】问题汇总

【问题一】ERROR]: Expected passwordless ssh to host

$ gpssh-exkeys -f /home/greenplum/gphome/conf/hostlist
[ERROR]: Failed to ssh to t3-guido-app11. No ECDSA host key is known for t3-guido-app11 and you have requested strict checking.
Host key verification failed.

[ERROR]: Expected passwordless ssh to host t3-guido-app11

修改SSH配置（所有节点）
$ cat /etc/ssh/ssh_config|egrep -v "(#|^$)"
PasswordAuthentication no
Host *
GSSAPIAuthentication yes
ForwardX11Trusted yes
SendEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGES
SendEnv LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT
SendEnv LC_IDENTIFICATION LC_ALL LANGUAGE
SendEnv XMODIFIERS

$ source /home/greenplum/gphome/greenplum_path.sh

$ gpssh-exkeys -f /home/greenplum/gphome/conf/hostlist
[STEP 1 of 5] create local ID and authorize on local host
... /home/greenplum/.ssh/id_rsa file exists ... key generation skipped

[STEP 2 of 5] keyscan all hosts and update known_hosts file

[STEP 3 of 5] retrieving credentials from remote hosts
... send to t3-guido-app11
... send to t3-guido-app12
... send to t3-guido-app13

[STEP 4 of 5] determine common authentication file content

[STEP 5 of 5] copy authentication files to all remote hosts
... finished key exchange with t3-guido-app11
... finished key exchange with t3-guido-app12
... finished key exchange with t3-guido-app13

[INFO] completed successfully

【问题二]: gpinitstandby -s t3-guido-app11提示No module named 'yaml' 

python环境需要安装wheel  PyYAML

[greenplum@t3-guido-app09 ~]$$ source /home/greenplum/gphome/greenplum_path.sh
[greenplum@t3-guido-app09 ~]$ gpinitstandby -s t3-guido-app11

+ View Code?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117

20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Validating environment and parameters for standby initialization... 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Checking for data directory /home/greenplum/gpbase/gpmaster/gpseg-1 on t3-guido-app11 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:------------------------------------------------------ 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum standby master initialization parameters 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:------------------------------------------------------ 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum master hostname               = t3-guido-app09 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum master data directory         = /home/greenplum/gpbase/gpmaster/gpseg-1 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum master port                   = 1921 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum standby master hostname       = t3-guido-app11 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum standby master port           = 1921 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum standby master data directory = /home/greenplum/gpbase/gpmaster/gpseg-1 20210929:15:59:30:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Greenplum update system catalog         = On Do you want to continue with standby master initialization? Yy|Nn (default=N): > Y   20210929:15:59:43:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Syncing Greenplum Database extensions to standby 20210929:15:59:44:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-The packages on t3-guido-app11 are consistent. 20210929:15:59:44:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Adding standby master to catalog... 20210929:15:59:44:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Database catalog updated successfully. 20210929:15:59:44:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Updating pg_hba.conf file... Hello , Non maintenance personnel are not allowed to login ! 20210929:15:59:45:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-pg_hba.conf files updated successfully. 20210929:15:59:47:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Starting standby master 20210929:15:59:47:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Checking if standby master is running on host: t3-guido-app11  in directory: /home/greenplum/gpbase/gpmaster/gpseg-1 20210929:15:59:48:022899 gpinitstandby:t3-guido-app09:greenplum-[WARNING]:-Unable to cleanup previously started standby: 'Hello , Non maintenance personnel are not allowed to login ! ' 20210929:15:59:48:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Cleaning up pg_hba.conf backup files... 20210929:15:59:49:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Backup files of pg_hba.conf cleaned up successfully. 20210929:15:59:49:022899 gpinitstandby:t3-guido-app09:greenplum-[INFO]:-Successfully created standby master on t3-guido-app11 [greenplum@t3-guido-app09 ~]$ gpsate -a -bash: gpsate: command not found [greenplum@t3-guido-app09 ~]$ gpstate -a 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-Starting gpstate with args: -a 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.0.0-beta.1 build dev' 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.0.0-beta.1 build dev) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit compiled on Sep 29 2021 11:54:47' 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-Obtaining Segment details from master... 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-Gathering data from segments... 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-Greenplum instance status summary 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Master instance                                           = Active 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Master standby                                            = t3-guido-app11 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Standby master state                                      = Standby host passive 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total segment instance count from metadata                = 16 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Primary Segment Status 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total primary segments                                    = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total primary segment valid (at master)                   = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total primary segment failures (at master)                = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files missing              = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files found                = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs found                 = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files missing                   = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files found                     = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes missing                 = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes found                   = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Mirror Segment Status 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total mirror segments                                     = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total mirror segment valid (at master)                    = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total mirror segment failures (at master)                 = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files missing              = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files found                = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs found                 = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files missing                   = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files found                     = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes missing                 = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes found                   = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number mirror segments acting as primary segments   = 0 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number mirror segments acting as mirror segments    = 8 20210929:16:00:06:023159 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- [greenplum@t3-guido-app09 ~]$ [greenplum@t3-guido-app09 ~]$ gpstate -a 20210929:16:02:04:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-Starting gpstate with args: -a 20210929:16:02:04:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 6.0.0-beta.1 build dev' 20210929:16:02:04:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-master Greenplum Version: 'PostgreSQL 9.4.24 (Greenplum Database 6.0.0-beta.1 build dev) on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit compiled on Sep 29 2021 11:54:47' 20210929:16:02:04:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-Obtaining Segment details from master... 20210929:16:02:04:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-Gathering data from segments... 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-Greenplum instance status summary 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Master instance                                           = Active 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Master standby                                            = t3-guido-app11 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Standby master state                                      = Standby host passive 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total segment instance count from metadata                = 16 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Primary Segment Status 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total primary segments                                    = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total primary segment valid (at master)                   = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total primary segment failures (at master)                = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files missing              = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files found                = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs found                 = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files missing                   = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files found                     = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes missing                 = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes found                   = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Mirror Segment Status 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:----------------------------------------------------- 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total mirror segments                                     = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total mirror segment valid (at master)                    = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total mirror segment failures (at master)                 = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files missing              = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid files found                = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs missing               = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of postmaster.pid PIDs found                 = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files missing                   = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number of /tmp lock files found                     = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes missing                 = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number postmaster processes found                   = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number mirror segments acting as primary segments   = 0 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-   Total number mirror segments acting as mirror segments    = 8 20210929:16:02:05:023540 gpstate:t3-guido-app09:greenplum-[INFO]:-----------------------------------------------------