greenplum配置mirror失败,求助

wjzt1987 2013-05-29 03:38:41
单机gp,为两个segment配置mirror
gpaddmirrors -p 10000


gpadmin@linux-aknu:~> gpaddmirrors -p 1000
20130529:03:27:39:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Starting gpaddmirrors with args: -p 1000
20130529:03:27:39:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-local Greenplum Version: 'postgres (Greenplum Database) 4.2.4.0 build 1'
20130529:03:27:39:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-master Greenplum Version: 'PostgreSQL 8.2.15 (Greenplum Database 4.2.4.0 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Jan 29 2013 06:13:20'
20130529:03:27:39:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Obtaining Segment details from master...
Enter mirror segment data directory location 1 of 2 >
/gpsegment1-mirror/
Enter mirror segment data directory location 2 of 2 >
/gpsegment2-mirror/
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Greenplum Add Mirrors Parameters
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:----------------------------------------------------------
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Greenplum master data directory = /gpmaster/gpseg-1
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Greenplum master port = 5432
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Parallel batch limit = 16
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:----------------------------------------------------------
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Mirror 1 of 2
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:----------------------------------------------------------
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance host = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance address = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance directory = /gpsegment1/gpseg0/gpseg0
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance port = 40000
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance replication port = 43000
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance host = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance address = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance directory = /gpsegment1-mirror/gpseg0
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance port = 41000
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance replication port = 42000
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:----------------------------------------------------------
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Mirror 2 of 2
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:----------------------------------------------------------
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance host = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance address = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance directory = /gpsegment2/gpseg1/gpseg1
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance port = 40001
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Primary instance replication port = 43001
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance host = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance address = linux-aknu
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance directory = /gpsegment2-mirror/gpseg1
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance port = 41001
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:- Mirror instance replication port = 42001
20130529:03:28:05:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:----------------------------------------------------------

Continue with add mirrors procedure Yy|Nn (default=N):
> y
20130529:03:28:09:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-2 segment(s) to add
20130529:03:28:09:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Building template directory
20130529:03:28:11:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Validating remote directories
.
20130529:03:28:12:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Copying template directory file
.
20130529:03:28:13:009689 gpaddmirrors:linux-aknu:gpadmin-[INFO]:-Configuring new segments
.
20130529:03:28:14:009689 gpaddmirrors:linux-aknu:gpadmin-[CRITICAL]:-Error occurred: Error Executing Command:
Command was: 'ssh -o 'StrictHostKeyChecking no' linux-aknu ". /usr/local/greenplum-db/./greenplum_path.sh; $GPHOME/bin/lib/gpconfigurenewsegment -c \"/gpsegment1-mirror/gpseg0:41000:false:false:4,/gpsegment2-mirror/gpseg1:41001:false:false:5\" -n -t gp_emptySegmentSchema.tar -B 16"'
rc=1, stdout='20130529:03:28:13:010094 gpconfigurenewsegment:linux-aknu:gpadmin-[INFO]:-Starting gpconfigurenewsegment with args: -c /gpsegment1-mirror/gpseg0:41000:false:false:4,/gpsegment2-mirror/gpseg1:41001:false:false:5 -n -t gp_emptySegmentSchema.tar -B 16
20130529:03:28:13:010094 gpconfigurenewsegment:linux-aknu:gpadmin-[INFO]:-Validate data directories for new segment
20130529:03:28:13:010094 gpconfigurenewsegment:linux-aknu:gpadmin-[INFO]:-Create or update data directories for new segment
20130529:03:28:13:010094 gpconfigurenewsegment:linux-aknu:gpadmin-[INFO]:-Validate data directories for new segment
20130529:03:28:13:010094 gpconfigurenewsegment:linux-aknu:gpadmin-[INFO]:-Create or update data directories for new segment
20130529:03:28:13:010094 gpconfigurenewsegment:linux-aknu:gpadmin-[ERROR]:-ExecutionError: 'Error Executing Command: ' occured. Details: '/usr/local/greenplum-db/./bin/lib/gpconfigurenewsegment -c /gpsegment1-mirror/gpseg0:41000:false:false:4,/gpsegment2-mirror/gpseg1:41001:false:false:5 -n -t gp_emptySegmentSchema.tar -B 16' cmd had rc=1 completed=True halted=False
stdout=''
stderr='[Errno 13] Permission denied: '/gpsegment1-mirror/gpseg0''
', stderr='ExecutionError: 'Error Executing Command: ' occured. Details: '/usr/local/greenplum-db/./bin/lib/gpconfigurenewsegment -c /gpsegment1-mirror/gpseg0:41000:false:false:4,/gpsegment2-mirror/gpseg1:41001:false:false:5 -n -t gp_emptySegmentSchema.tar -B 16' cmd had rc=1 completed=True halted=False
stdout=''
stderr='[Errno 13] Permission denied: '/gpsegment1-mirror/gpseg0''
'
gpadmin@linux-aknu:~>
...全文
12044 回复 打赏 收藏 转发到动态 举报
写回复
用AI写文章
回复
切换为时间正序
请发表友善的回复…
发表回复

951

社区成员

发帖
与我相关
我的任务
社区描述
PostgreSQL相关内容讨论
sql数据库数据库架构 技术论坛(原bbs)
社区管理员
  • PostgreSQL社区
  • yang_z_1
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧