GP無法啟動，資訊如下：

[gpadmin@gp-master gpseg-1]$ gpstart

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Starting gpstart with args:

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Gathering information and validating the environment...

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.8.0 build 1'

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Greenplum Catalog Version: '201310150'

20161223:09:32:09:002004 gpstart:gp-master:gpadmin-[INFO]:-Starting Master instance in admin mode

20161223:09:32:11:002004 gpstart:gp-master:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode

20161223:09:32:11:002004 gpstart:gp-master:gpadmin-[CRITICAL]:-Error occurred: non-zero rc: 1

Command was: 'env GPSESSID=0000000000 GPERA=None $GPHOME/bin/pg_ctl -D /disk/master/gpseg-1 -l /disk/master/gpseg-1/pg_log/startup.log -w -t 600 -o " -p 5432 -b 1 -z 0 --silent-mode=true -i -M master -C -1 -x 18 -c gp_role=utility " start'

rc=1, stdout='waiting for server to start...... stopped waiting

', stderr='pg_ctl: PID file "/disk/master/gpseg-1/postmaster.pid" does not exist

pg_ctl: could not start server

Examine the log output.

'

這種情況一般是因為pg_hba.conf、環境變數設定的有問題，檢查一遍後沒有問題

於是看下pg_log下的startup.log如下：

2016-12-23 01:31:09.819803 GMT,,,p933,th440502048,,,,0,,,seg-1,,,,,"FATAL","55000","data directory ""/disk/master/gpseg-1"" has group or world access","Permissions should be u=rwx (0700).",,,,,,,"checkDataDir","postmaster.c",1763,

2016-12-23 01:32:09.643918 GMT,,,p2027,th-302590176,,,,0,,,seg-1,,,,,"FATAL","55000","data directory ""/disk/master/gpseg-1"" has group or world access","Permissions should be u=rwx (0700).",,,,,,,"checkDataDir","postmaster.c",1763,

按照錯誤來說/disk/master/gpseg-1資料目錄許可權有問題，應該設定成0700

[gpadmin@gp-master master]$ ls -l

total 4

drwxrwxrwx 17 gpadmin gpadmin 4096 Dec 23 09:49 gpseg-1

許可權是777，改成0700

[gpadmin@gp-master master]$ chmod 0700 gpseg-1

[gpadmin@gp-master master]$ ls -l

total 4

drwx------ 17 gpadmin gpadmin 4096 Dec 23 09:49 gpseg-1

於是成功啟動

很詫異777的許可權是大於0700的，不應該是許可權不足導致，難道GP是出於安全的考慮只允許gpadmin使用者對資料目錄進行操作?!

Failed to start Master instance in admin mode

相關文章