jason张_个人页

我发现一个好的解决办法，不知道有什么潜在的危险，首先gp给出了gp用到的命令有python写的，有perl写的，还有一部分是bash写的如下: List of Management Scripts Written in Bash ------------------------------------------ bin/gpcheckos.bash - Like gpcheckos, but in bash bin/gpcrondump - Dumps a database bin/gpdbrestore - Restores a database dumped from gpcrondump bin/gpinitsystem - Creates a new Greenplum Database bin/gpload - Sets env variables and calls gpload.py bin/gpprintdbsizes - Removed in 4.0 bin/gprebuildsystem - Deprecated in 3.4 通过以上命令提供的线索找到bin目录下的lib目录下的gp_bash_functions.sh，注释一下代码即可 # Location Functions #****************************************************************************** #Check that SHELL is /bin/bash # if [ $SHELL != /bin/bash ] && [ `ls -al /bin/sh|grep -c bash` -ne 1 ];then # echo '[FATAL]:-Scripts must be run by a user account that has SHELL=/bin/bash' # if [ -f /bin/bash ];then # echo '[INFO]:-/bin/bash exists, please update user account shell' # else # echo '[WARN]:-/bin/bash does not exist, does bash need to be installed?' # fi # exit 2 # fi

jczhang@jczhang:~/gpdb$ gpstart -a20160126:11:23:07:002880 gpstart:jczhang:jczhang-[INFO]:-Starting gpstart with args: -a20160126:11:23:07:002880 gpstart:jczhang:jczhang-[INFO]:-Gathering information and validating the environment...20160126:11:23:07:002880 gpstart:jczhang:jczhang-[INFO]:-Greenplum Binary Version: 'postgres (Greenplum Database) 4.3.99.00 build dev'20160126:11:23:07:002880 gpstart:jczhang:jczhang-[INFO]:-Greenplum Catalog Version: '301601051'20160126:11:23:07:002880 gpstart:jczhang:jczhang-[INFO]:-Starting Master instance in admin mode20160126:11:23:09:002880 gpstart:jczhang:jczhang-[INFO]:-Obtaining Greenplum Master catalog information20160126:11:23:09:002880 gpstart:jczhang:jczhang-[INFO]:-Obtaining Segment details from master...20160126:11:23:10:002880 gpstart:jczhang:jczhang-[INFO]:-Setting new master era20160126:11:23:10:002880 gpstart:jczhang:jczhang-[INFO]:-Master Started...20160126:11:23:10:002880 gpstart:jczhang:jczhang-[INFO]:-Shutting down master20160126:11:23:12:002880 gpstart:jczhang:jczhang-[INFO]:-Commencing parallel segment instance startup, please wait........... 20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-Process results...20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-----------------------------------------------------20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:- Successful segment starts = 220160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:- Failed segment starts = 020160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 020160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-----------------------------------------------------20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-Successfully started 2 of 2 segment instances 20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-----------------------------------------------------20160126:11:23:20:002880 gpstart:jczhang:jczhang-[INFO]:-Starting Master instance jczhang directory /home/jczhang/gpdb/data/gpseg-1 20160126:11:23:21:002880 gpstart:jczhang:jczhang-[INFO]:-Command pg_ctl reports Master jczhang instance active20160126:11:23:21:002880 gpstart:jczhang:jczhang-[INFO]:-No standby master configured. skipping...20160126:11:23:21:002880 gpstart:jczhang:jczhang-[INFO]:-Database successfully started上面是我启动过程下面是ps x显示的进程 2986 ? Ss 0:00 /home/jczhang/gpdb/build/gpdb.master/bin/postgres -D /home/jczhang/gpdb/data/gpseg0 -p 40000 -b 2 -z 2 --silent-mode=true -i -M mirrorless -C 0 2987 ? Ss 0:00 /home/jczhang/gpdb/build/gpdb.master/bin/postgres -D /home/jczhang/gpdb/data/gpseg1 -p 40001 -b 3 -z 2 --silent-mode=true -i -M mirrorless -C 1 2988 ? Ss 0:00 postgres: port 40001, logger process 2989 ? Ss 0:00 postgres: port 40000, logger process 2996 ? Ss 0:00 postgres: port 40001, stats collector process 2997 ? Ss 0:00 postgres: port 40001, writer process 2998 ? Ss 0:00 postgres: port 40001, checkpoint process 2999 ? S 0:00 postgres: port 40001, sweeper process 3000 ? Ss 0:00 postgres: port 40000, stats collector process 3001 ? Ss 0:00 postgres: port 40000, writer process 3002 ? Ss 0:00 postgres: port 40000, checkpoint process 3003 ? S 0:00 postgres: port 40000, sweeper process 3015 ? Ss 0:00 /home/jczhang/gpdb/build/gpdb.master/bin/postgres -D /home/jczhang/gpdb/data/gpseg-1 -p 5432 -b 1 -z 2 --silent-mode=true -i -M master -C -1 -x 0 -E 3016 ? Ss 0:00 postgres: port 5432, master logger process 3019 ? Ss 0:00 postgres: port 5432, stats collector process 3020 ? Ss 0:00 postgres: port 5432, writer process 3021 ? Ss 0:00 postgres: port 5432, checkpoint process 3022 ? S 0:00 postgres: port 5432, seqserver process 3023 ? S 0:00 postgres: port 5432, ftsprobe process 3024 ? S 0:00 postgres: port 5432, sweeper process 可以看到master进程：3015是启动的然后是关闭集群20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Starting gpstop with args: -a20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Gathering information and validating the environment...20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Obtaining Greenplum Master catalog information20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Obtaining Segment details from master...20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 4.3.99.00 build dev'20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-There are 0 connections to the database20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Commencing Master instance shutdown with mode='smart'20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Master host=jczhang20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Commencing Master instance shutdown with mode=smart20160126:11:24:17:003062 gpstop:jczhang:jczhang-[INFO]:-Master segment instance directory=/home/jczhang/gpdb/data/gpseg-120160126:11:24:18:003062 gpstop:jczhang:jczhang-[INFO]:-Attempting forceful termination of any leftover master process20160126:11:24:18:003062 gpstop:jczhang:jczhang-[INFO]:-Terminating processes for segment /home/jczhang/gpdb/data/gpseg-120160126:11:24:18:003062 gpstop:jczhang:jczhang-[ERROR]:-Failed to kill processes for segment /home/jczhang/gpdb/data/gpseg-1: ([Errno 3] No such process)20160126:11:24:18:003062 gpstop:jczhang:jczhang-[INFO]:-No standby master host configured20160126:11:24:18:003062 gpstop:jczhang:jczhang-[INFO]:-Commencing parallel segment instance shutdown, please wait...20160126:11:24:18:003062 gpstop:jczhang:jczhang-[INFO]:-0.00% of jobs completed20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-100.00% of jobs completed20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-----------------------------------------------------20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:- Segments stopped successfully = 220160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:- Segments with errors during stop = 020160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-----------------------------------------------------20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-Successfully shutdown 2 of 2 segment instances 20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-Database successfully shutdown with no errors reported20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-Cleaning up leftover gpmmon process20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-No leftover gpmmon process found20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-Cleaning up leftover gpsmon processes20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-No leftover gpsmon processes on some hosts. not attempting forceful termination on these hosts20160126:11:24:28:003062 gpstop:jczhang:jczhang-[INFO]:-Cleaning up leftover shared memory注意到有error提示了！

thank you 德哥