【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
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]:-----------------------------------------------------
