greenplum 4.3.33安装

2020.01.19 查看日志报错： pg_ctl报错日志： FATAL: could not create semaphores: No space left on device 修改 vi /etc/sysctl.conf 更改如下行为： kernel.sem = 50100 128256000 50100 2560 修改结果： [root@demo02 ~]# ipcs -ls ------ Semaphore Limits -------- max number of arrays = 2560 max semaphores per array = 50100 max semaphores system wide = 128256000 max ops per semop call = 50100 semaphore max value = 32767 处理过程： /oradata/gp/gpdata/ mkdir -p /oradata/gp/gpdata/gpdatam1 mkdir -p /oradata/gp/gpdata/gpdatam2 mkdir -p /oradata/gp/gpdata/gpdatap1 mkdir -p /oradata/gp/gpdata/gpdatap2 mkdir -p /oradata/gp/gpdata/gpmaster gpssh -f /home/gpadmin/conf/hostlist  /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config    gpinitsystem -c  /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config -h /home/gpadmin/conf/hostlist    [gpadmin@demo02 gpdata]$  gpinitsystem -c  /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config -h /home/gpadmin/conf/hostlist 20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking configuration parameters, please wait... 20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Reading Greenplum configuration file /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config 20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Locale has not been set in /oradata/gp/greenplum-db/docs/cli_help/gpconfigs/gpinitsystem_config, will set to default value 20200119:22:56:18:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Locale set to en_US.utf8 20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates 20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[WARN]:-ENCODING variable not set, will set to default UTF-8 20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250 20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking configuration parameters, Completed 20200119:22:56:19:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing multi-home checks, please wait... .. 20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Configuring build for standard array 20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing multi-home checks, Completed 20200119:22:56:26:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Building primary segment instance array, please wait... .... 20200119:22:57:06:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Building group mirror array type , please wait... .... 20200119:22:57:29:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking Master host 20200119:22:57:29:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking new segment hosts, please wait... ........ 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checking new segment hosts, Completed 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Database Creation Parameters 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:--------------------------------------- 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master Configuration 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:--------------------------------------- 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master instance name       = Greenplum 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master hostname            = demo02 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master port                = 2345 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master instance dir        = /oradata/gp/gpdata/gpmaster/gpseg-1 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master Database            =  20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master connections         = 250 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master buffers             = 128000kB 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Segment connections        = 750 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Segment buffers            = 128000kB 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Checkpoint segments        = 8 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Encoding                   = UTF-8 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Postgres param file        = Off 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Initdb to be used          = /oradata/gp/greenplum-db/./bin/initdb 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /oradata/gp/greenplum-db/./lib 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Ulimit check               = Passed 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Array host connect type    = Single hostname per node 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [1]      = ::1 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [2]      = 10.138.231.201 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [3]      = 172.32.16.2 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [4]      = 172.32.32.2 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [5]      = fe80::250:56ff:fe8c:20d2 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [6]      = fe80::250:56ff:fe8c:2375 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [7]      = fe80::250:56ff:fe8c:a091 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [8]      = fe80::250:56ff:fe8c:c81 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Master IP address [9]      = fe80::250:56ff:fe8c:d584 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Standby Master             = Not Configured 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Primary segment #          = 2 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total Database segments    = 4 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Trusted shell              = ssh 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Number segment hosts       = 2 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirror port base           = 43000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Replicaton port base       = 34000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirror replicaton port base= 44000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirror segment #           = 2 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirroring config           = ON 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Mirroring type             = Group 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:---------------------------------------- 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Primary Segment Configuration 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:---------------------------------------- 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02     /oradata/gp/gpdata/gpdatap1/gpseg0      33000   2       0       34000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02     /oradata/gp/gpdata/gpdatap2/gpseg1      33001   3       1       34001 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01     /oradata/gp/gpdata/gpdatap1/gpseg2      33000   4       2       34000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01     /oradata/gp/gpdata/gpdatap2/gpseg3      33001   5       3       34001 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:--------------------------------------- 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:--------------------------------------- 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01     /oradata/gp/gpdata/gpdatam1/gpseg0      43000   6       0       44000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo01     /oradata/gp/gpdata/gpdatam2/gpseg1      43001   7       1       44001 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02     /oradata/gp/gpdata/gpdatam1/gpseg2      43000   8       2       44000 20200119:23:02:15:022378 gpinitsystem:demo02:gpadmin-[INFO]:-demo02     /oradata/gp/gpdata/gpdatam2/gpseg3      43001   9       3       44001 Continue with Greenplum creation Yy/Nn> y 20200119:23:03:32:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Building the Master instance database, please wait... 20200119:23:03:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Starting the Master in admin mode 20200119:23:04:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing parallel build of primary segment instances 20200119:23:04:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait... .... 20200119:23:04:45:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait... .................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................. 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------ 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Parallel process exit status 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------ 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as completed           = 4 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as killed              = 0 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as failed              = 0 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------ 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait... .... 20200119:23:13:40:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait... ..................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------ 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Parallel process exit status 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------ 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as completed           = 4 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as killed              = 0 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Total processes marked as failed              = 0 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------ 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Deleting distributed backout files 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Removing back out file 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-No errors generated from parallel processes 20200119:23:22:21:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Starting gpstop with args: -a -l /home/gpadmin/gpAdminLogs -i -m -d /oradata/gp/gpdata/gpmaster/gpseg-1 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Gathering information and validating the environment... 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Obtaining Segment details from master... 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.33.4 build 1' 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-There are 0 connections to the database 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate' 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Master host=demo02 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate 20200119:23:22:22:004847 gpstop:demo02:gpadmin-[INFO]:-Master segment instance directory=/oradata/gp/gpdata/gpmaster/gpseg-1 20200119:23:22:23:004847 gpstop:demo02:gpadmin-[INFO]:-Attempting forceful termination of any leftover master process 20200119:23:22:23:004847 gpstop:demo02:gpadmin-[INFO]:-Terminating processes for segment /oradata/gp/gpdata/gpmaster/gpseg-1 20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Starting gpstart with args: -a -l /home/gpadmin/gpAdminLogs -d /oradata/gp/gpdata/gpmaster/gpseg-1 20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Gathering information and validating the environment... 20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.33.4 build 1' 20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150' 20200119:23:22:23:004874 gpstart:demo02:gpadmin-[INFO]:-Starting Master instance in admin mode 20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Obtaining Segment details from master... 20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Setting new master era 20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Master Started... 20200119:23:22:24:004874 gpstart:demo02:gpadmin-[INFO]:-Shutting down master 20200119:23:22:26:004874 gpstart:demo02:gpadmin-[INFO]:-Commencing parallel primary and mirror segment instance startup, please wait... ................  20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-Process results... 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:----------------------------------------------------- 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-   Successful segment starts                                            = 8 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-   Failed segment starts                                                = 0 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:----------------------------------------------------- 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:- 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-Successfully started 8 of 8 segment instances  20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:----------------------------------------------------- 20200119:23:22:42:004874 gpstart:demo02:gpadmin-[INFO]:-Starting Master instance demo02 directory /oradata/gp/gpdata/gpmaster/gpseg-1  20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-Command pg_ctl reports Master demo02 instance active 20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-No standby master configured.  skipping... 20200119:23:22:43:004874 gpstart:demo02:gpadmin-[INFO]:-Database successfully started 20200119:23:22:46:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode 20200119:23:22:46:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Loading gp_toolkit... 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Scanning utility log file for any warning messages 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-******************************************************* 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-were generated during the array creation 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Please review contents of log file 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To determine level of criticality 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-These messages could be from a previous run of the utility 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-that was called today! 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[WARN]:-******************************************************* 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Greenplum Database instance successfully created 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------------- 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To complete the environment configuration, please  20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-update gpadmin .bashrc file with the following 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/oradata/gp/gpdata/gpmaster/gpseg-1" 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance: 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-   or, use -d /oradata/gp/gpdata/gpmaster/gpseg-1 option for the Greenplum scripts 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-   Example gpstate -d /oradata/gp/gpdata/gpmaster/gpseg-1 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Script log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20200119.log 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Review options for gpinitstandby 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------------- 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-The Master /oradata/gp/gpdata/gpmaster/gpseg-1/pg_hba.conf post gpinitsystem 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-has been configured to allow all hosts within this new 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-new array must be explicitly added to this file 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:-located in the /oradata/gp/greenplum-db/./docs directory 20200119:23:22:47:022378 gpinitsystem:demo02:gpadmin-[INFO]:------------------------------------------------------- 初始化完成后： [gpadmin@demo02 gpseg-1]$ psql -h 10.138.231.201 -d postgres -p 2345