greenplum数据库创建过程中产生的日志信息

20100908:16:42:30:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking configuration parameters, please wait...

20100908:16:42:30:gpinitsystem:gp-ma:gpadmin-[INFO]:-Reading Greenplum configuration file ./gp_init_config

20100908:16:42:30:gpinitsystem:gp-ma:gpadmin-[INFO]:-Locale has not been set in ./gp_init_config, will set to default value

20100908:16:42:30:gpinitsystem:gp-ma:gpadmin-[INFO]:-Locale set to en_US.utf8

20100908:16:42:31:gpinitsystem:gp-ma:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates

20100908:16:42:31:gpinitsystem:gp-ma:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 25

20100908:16:42:31:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking configuration parameters, Completed

20100908:16:42:32:gpinitsystem:gp-ma:gpadmin-[INFO]:-Commencing multi-home checks, please wait...

....

20100908:16:42:33:gpinitsystem:gp-ma:gpadmin-[INFO]:-Configuring build for multi-home array

20100908:16:42:34:gpinitsystem:gp-ma:gpadmin-[INFO]:-Commencing multi-home checks, Completed

20100908:16:42:34:gpinitsystem:gp-ma:gpadmin-[INFO]:-Building primary segment instance array, please wait...

....

20100908:16:42:37:gpinitsystem:gp-ma:gpadmin-[INFO]:-Building group mirror array type , please wait...

....

20100908:16:42:41:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking Master host

20100908:16:42:42:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking new segment hosts, please wait...

.20100908:16:42:51:gpinitsystem:gp-ma:gpadmin-[FATAL]:-Instance directory /gpdata1/gpseg0 exists on segment instance gp-s1a Script. Exiting!

[gpadmin@gp-ma ~]$ gpinitsystem -c ./gp_init_config

20100908:16:44:40:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking configuration parameters, please wait...

20100908:16:44:41:gpinitsystem:gp-ma:gpadmin-[INFO]:-Reading Greenplum configuration file ./gp_init_config

20100908:16:44:41:gpinitsystem:gp-ma:gpadmin-[INFO]:-Locale has not been set in ./gp_init_config, will set to default value

20100908:16:44:41:gpinitsystem:gp-ma:gpadmin-[INFO]:-Locale set to en_US.utf8

20100908:16:44:42:gpinitsystem:gp-ma:gpadmin-[INFO]:-No DATABASE_NAME set, will exit following template1 updates

20100908:16:44:42:gpinitsystem:gp-ma:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 25

20100908:16:44:42:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking configuration parameters, Completed

20100908:16:44:42:gpinitsystem:gp-ma:gpadmin-[INFO]:-Commencing multi-home checks, please wait...

....

20100908:16:44:44:gpinitsystem:gp-ma:gpadmin-[INFO]:-Configuring build for multi-home array

20100908:16:44:44:gpinitsystem:gp-ma:gpadmin-[INFO]:-Commencing multi-home checks, Completed

20100908:16:44:44:gpinitsystem:gp-ma:gpadmin-[INFO]:-Building primary segment instance array, please wait...

....

20100908:16:44:48:gpinitsystem:gp-ma:gpadmin-[INFO]:-Building group mirror array type , please wait...

....

20100908:16:44:51:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking Master host

20100908:16:44:52:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking new segment hosts, please wait...

........

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checking new segment hosts, Completed

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Greenplum Database Creation Parameters

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:---------------------------------------

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master Configuration

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:---------------------------------------

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master instance name       = Greenplum

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master hostname            = gp-ma

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master port                = 5432

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master instance dir        = /gpmaster/gpseg-1

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master LOCALE              = en_US.utf8

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Greenplum segment prefix   = gpseg

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master Database            =

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master connections         = 25

20100908:16:45:08:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master buffers             = 128000kB

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Segment connections        = 125

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Segment buffers            = 128000kB

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Checkpoint segments        = 8

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Encoding                   = UNICODE

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Postgres param file        = Off

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Initdb to be used          = /usr/local/greenplum-db/./bin/initdb

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-GP_LIBRARY_PATH is         = /usr/local/greenplum-db/./lib

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Ulimit check               = Passed

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Array host connect type    = Multi hostname per node

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master IP address [1]      = 192.168.0.11

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master IP address [2]      = 192.168.1.11

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master IP address [3]      = 192.168.161.157

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Master only build          = Off

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Standby Master             = Not Configured

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Primary segment #          = 2

20100908:16:45:09:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total Database segments    = 4

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Trusted shell              = ssh

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Number segment hosts       = 4

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Mirror port base           = 60000

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Replicaton port base       = 51000

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Mirror replicaton port base= 61000

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Mirror segment #           = 2

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Mirroring config           = ON

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Mirroring type             = Group

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:----------------------------------------

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-Greenplum Primary Segment Configuration

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:----------------------------------------

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s1a     /gpdata1/gpseg0         50000   2       0       51000

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s1b     /gpdata2/gpseg1         50001   3       1       51001

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s2a     /gpdata1/gpseg2         50000   4       2       51000

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s2b     /gpdata2/gpseg3         50001   5       3       51001

20100908:16:45:10:gpinitsystem:gp-ma:gpadmin-[INFO]:---------------------------------------

20100908:16:45:11:gpinitsystem:gp-ma:gpadmin-[INFO]:-Greenplum Mirror Segment Configuration

20100908:16:45:11:gpinitsystem:gp-ma:gpadmin-[INFO]:---------------------------------------

20100908:16:45:11:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s2a     /gpmirror1/gpseg0       60000   6       0       61000

20100908:16:45:11:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s2b     /gpmirror2/gpseg1       60001   7       1       61001

20100908:16:45:11:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s1a     /gpmirror1/gpseg2       60000   8       2       61000

20100908:16:45:11:gpinitsystem:gp-ma:gpadmin-[INFO]:-gp-s1b     /gpmirror2/gpseg3       60001   9       3       61001

Continue with Greenplum creation Yy/Nn>

y

20100908:16:45:14:gpinitsystem:gp-ma:gpadmin-[INFO]:-Building the Master instance database, please wait...

20100908:16:45:35:gpinitsystem:gp-ma:gpadmin-[INFO]:-Starting the Master in admin mode

20100908:16:45:51:gpinitsystem:gp-ma:gpadmin-[INFO]:-Commencing parallel build of primary segment instances

20100908:16:45:52:gpinitsystem:gp-ma:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...

....

20100908:16:45:54:gpinitsystem:gp-ma:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

......................................................

20100908:16:46:49:gpinitsystem:gp-ma:gpadmin-[INFO]:------------------------------------------------

20100908:16:46:49:gpinitsystem:gp-ma:gpadmin-[INFO]:-Parallel process exit status

20100908:16:46:49:gpinitsystem:gp-ma:gpadmin-[INFO]:------------------------------------------------

20100908:16:46:49:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total processes marked as completed           = 4

20100908:16:46:49:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total processes marked as killed              = 0

20100908:16:46:50:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total processes marked as failed              = 0

20100908:16:46:50:gpinitsystem:gp-ma:gpadmin-[INFO]:------------------------------------------------

20100908:16:46:50:gpinitsystem:gp-ma:gpadmin-[INFO]:-Commencing parallel build of mirror segment instances

20100908:16:46:50:gpinitsystem:gp-ma:gpadmin-[INFO]:-Spawning parallel processes    batch [1], please wait...

....

20100908:16:46:52:gpinitsystem:gp-ma:gpadmin-[INFO]:-Waiting for parallel processes batch [1], please wait...

.........................

20100908:16:47:18:gpinitsystem:gp-ma:gpadmin-[INFO]:------------------------------------------------

20100908:16:47:18:gpinitsystem:gp-ma:gpadmin-[INFO]:-Parallel process exit status

20100908:16:47:18:gpinitsystem:gp-ma:gpadmin-[INFO]:------------------------------------------------

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total processes marked as completed           = 4

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total processes marked as killed              = 0

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-Total processes marked as failed              = 0

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:------------------------------------------------

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-Deleting distributed backout files

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-Removing back out file

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-No errors generated from parallel processes

20100908:16:47:19:gpinitsystem:gp-ma:gpadmin-[INFO]:-Restarting the Greenplum instance in production mode

20100908:16:47:20:gpstop:default-[INFO]:-Starting gpstop with args: '-a -i -m -d /gpmaster/gpseg-1'

20100908:16:47:20:gpstop:default-[INFO]:-Gathering information and validating the environment...

20100908:16:47:20:gpstop:default-[INFO]:-Obtaining Greenplum Master catalog information

20100908:16:47:20:gpstop:default-[INFO]:-Obtaining Segment details from master...

20100908:16:47:20:gpstop:default-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.0.0.0 build 1'

20100908:16:47:20:gpstop:default-[INFO]:-There are 0 connections to the database

20100908:16:47:20:gpstop:default-[INFO]:-Commencing Master instance shutdown with mode='immediate'

20100908:16:47:20:gpstop:default-[INFO]:-Master host=gp-ma

20100908:16:47:20:gpstop:default-[INFO]:-Commencing Master instance shutdown with mode=immediate

20100908:16:47:20:gpstop:default-[INFO]:-Master segment instance directory=/gpmaster/gpseg-1

20100908:16:47:20:gpstart:default-[INFO]:-Starting gpstart with args: '-a -d /gpmaster/gpseg-1'

20100908:16:47:20:gpstart:default-[INFO]:-Gathering information and validating the environment...

20100908:16:47:21:gpstart:default-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.0.0.0 build 1'

20100908:16:47:21:gpstart:default-[INFO]:-Greenplum Catalog Version: '201005134'

20100908:16:47:21:gpstart:default-[INFO]:-Starting Master instance in admin mode

20100908:16:47:22:gpstart:default-[INFO]:-Obtaining Greenplum Master catalog information

20100908:16:47:22:gpstart:default-[INFO]:-Obtaining Segment details from master...

20100908:16:47:23:gpstart:default-[INFO]:-Master Started...

20100908:16:47:23:gpstart:default-[INFO]:-Shutting down master

20100908:16:47:26:gpstart:default-[INFO]:-No standby master configured.  skipping...

20100908:16:47:27:gpstart:default-[INFO]:-Commencing parallel mirror segment instance startup, please wait...

........

20100908:16:47:35:gpstart:default-[INFO]:-Process results...

20100908:16:47:35:gpstart:default-[INFO]:-Commencing parallel primary segment instance startup, please wait...

...........

20100908:16:47:46:gpstart:default-[INFO]:-Process results...

20100908:16:47:46:gpstart:default-[INFO]:-----------------------------------------------------

20100908:16:47:46:gpstart:default-[INFO]:-Total successful segment starts             = 8

20100908:16:47:46:gpstart:default-[INFO]:-Total failed segment starts                 = 0

20100908:16:47:46:gpstart:default-[INFO]:-----------------------------------------------------

20100908:16:47:46:gpstart:default-[INFO]:-Total instances that are marked down in configuration and were skipped = 0

20100908:16:47:46:gpstart:default-[INFO]:-Successfully started 8 of 8 segment instances

20100908:16:47:46:gpstart:default-[INFO]:-----------------------------------------------------

20100908:16:47:46:gpstart:default-[INFO]:-Starting Master instance gp-ma directory /gpmaster/gpseg-1

20100908:16:47:49:gpstart:default-[INFO]:-Command pg_ctl reports Master gp-ma instance active

20100908:16:47:49:gpstart:default-[INFO]:-Database successfully started with no errors reported

20100908:16:47:49:gpinitsystem:gp-ma:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode

20100908:16:47:50:gpinitsystem:gp-ma:gpadmin-[INFO]:-Loading gp_toolkit...

ALTER ROLE

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[INFO]:-Scanning utility log file for any warning messages

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[WARN]:-*******************************************************

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[WARN]:-Scan of log file indicates that some warnings or errors

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[WARN]:-were generated during the array creation

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[INFO]:-Please review contents of log file

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[INFO]:-/home/gpadmin/gpAdminLogs/gpinitsystem_20100908.log

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[INFO]:-To determine level of criticality

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[INFO]:-These messages could be from a previous run of the utility

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[INFO]:-that was called today!

20100908:16:47:58:gpinitsystem:gp-ma:gpadmin-[WARN]:-*******************************************************

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-Greenplum Database instance successfully created

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-------------------------------------------------------

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-To complete the environment configuration, please

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-update gpadmin .bashrc file with the following

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-1. Ensure that the greenplum_path.sh file is sourced

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-2. Add "export MASTER_DATA_DIRECTORY=/gpmaster/gpseg-1"

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-   to access the Greenplum scripts for this instance:

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-   or, use -d /gpmaster/gpseg-1 option for the Greenplum scripts

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-   Example gpstate -d /gpmaster/gpseg-1

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-Script. log file = /home/gpadmin/gpAdminLogs/gpinitsystem_20100908.log

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-To remove instance, run gpdeletesystem utility

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-To initialize a Standby Master Segment for this Greenplum instance

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-Review options for gpinitstandby

20100908:16:47:59:gpinitsystem:gp-ma:gpadmin-[INFO]:-------------------------------------------------------

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-The Master /gpmaster/gpseg-1/pg_hba.conf post gpinitsystem

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-has been configured to allow all hosts within this new

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-array to intercommunicate. Any hosts external to this

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-new array must be explicitly added to this file

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-Refer to the Greenplum Admin support guide which is

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-located in the /usr/local/greenplum-db/./docs directory

20100908:16:48:00:gpinitsystem:gp-ma:gpadmin-[INFO]:-------------------------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/280958/viewspace-673024/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/280958/viewspace-673024/