GP修改参数导致重启失败

[gpadmin@gp-segment5 ]$ gpstart

.....

20170104:16:35:48:000907 gpstart:gp-segment5:gpadmin-[CRITICAL]:-Failed to start Master instance in admin mode

20170104:16:35:48:000907 gpstart:gp-segment5: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.

'

启动失败，查看startup.log

[gpadmin@gp-segment5 ]$ tail -50f /disk/master/gpseg-1/pg_log/startup.log

....

2017-01-04 08:35:46.082998 GMT,,,p917,th-1719634144,,,,0,,,seg-1,,,,,"FATAL","42601","syntax error in file ""/disk/master/gpseg-1/postgresql.conf"" line 566, near token ""G""",,,,,,,,"ParseConfigFile","guc-file.l",369,

从报错情况来看是参数设置的不对

重启之前是修改了参数 gpconfig -c shared_buffers -v 1.5G，看样子是1.5G惹的祸，那就把/disk/master/gpseg-1/postgresql.conf 文件里的1.5G改成1536M

[gpadmin@gp-segment5 ]$ gpstart

......

20170104:16:37:59:002887 gpstart:gp-segment5:gpadmin-[WARNING]:-Segment instance startup failures reported

20170104:16:37:59:002887 gpstart:gp-segment5:gpadmin-[WARNING]:-Failed start 16 of 16 segment instances <<<<<<<<

20170104:16:37:59:002887 gpstart:gp-segment5:gpadmin-[WARNING]:-Review /home/gpadmin/gpAdminLogs/gpstart_20170104.log

20170104:16:37:59:002887 gpstart:gp-segment5:gpadmin-[INFO]:-----------------------------------------------------

20170104:16:37:59:002887 gpstart:gp-segment5:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...

.

20170104:16:38:00:002887 gpstart:gp-segment5:gpadmin-[ERROR]:-gpstart error: Do not have enough valid segments to start the array.

启动segment失败，原因应该是只修改了master上的配置文件，没有修改segment上的配置文件，还是得通过gpconfig命令修改所有segment的配置了

[gpadmin@gp-segment5 gpperfmon]$ gpconfig -c shared_buffers -v 1536MB

20170104:16:38:39:003832 gpconfig:gp-segment5:gpadmin-[ERROR]:-could not connect to server: Connection refused

        Is the server running on host "localhost" (127.0.0.1) and accepting

        TCP/IP connections on port 5432?

20170104:16:38:39:003832 gpconfig:gp-segment5:gpadmin-[ERROR]:-Failed to connect to database, exiting without action. This script can only be run when the database is up.

GP没有启动没办法使用这个命令

先只启动master吧

[gpadmin@gp-segment5 ]$ gpstart -m

....

[gpadmin@gp-segment5 ]$ gpconfig -c shared_buffers -v 1536MB

20170104:16:39:10:004258 gpconfig:gp-segment5:gpadmin-[INFO]:-completed successfully

修改参数成功，再启动GP集群

[gpadmin@gp-segment5 gpperfmon]$ gpstart

....

20170104:16:40:40:005188 gpstart:gp-segment5:gpadmin-[INFO]:-Database successfully started

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

转载于:http://blog.itpub.net/29989552/viewspace-2131896/