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

greenplum 4.3.33安裝

相關文章