大橙子网站建设,新征程启航
为企业提供网站建设、域名注册、服务器等服务
本篇内容介绍了“greenplum4.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
“greenplum4.3.33的安装步骤”的内容就介绍到这里了,感谢大家的阅读。如果想了解更多行业相关的知识可以关注创新互联-成都网站建设公司网站,小编将为大家输出更多高质量的实用文章!