lij55/gphost

Image to run Greenplum

gphost's Issues

select error

error show like this:
select * from company;
WARNING: interconnect may encountered a network error, please check your network (seg0 slice1 172.21.0.4:10000 pid=29730)
DETAIL: Failed to send packet (seq 1) to 172.21.0.1:37333 (pid 7331 cid -1) after 100 retries.
WARNING: interconnect may encountered a network error, please check your network (seg1 slice1 172.21.0.4:10001 pid=29731)
DETAIL: Failed to send packet (seq 1) to 172.21.0.1:37333 (pid 7331 cid -1) after 100 retries.
WARNING: interconnect may encountered a network error, please check your network (seg2 slice1 172.21.0.2:10000 pid=29728)
DETAIL: Failed to send packet (seq 1) to 172.21.0.1:37333 (pid 7331 cid -1) after 100 retries.
WARNING: interconnect may encountered a network error, please check your network (seg3 slice1 172.21.0.2:10001 pid=29729)
DETAIL: Failed to send packet (seq 1) to 172.21.0.1:37333 (pid 7331 cid -1) after 100 retries.

but insert or delete can work well.
is there anything i can do to fix this problem?
thanks very much.

etl host是什么

为什么需要etl节点，用来干什么的

安装时报错

installing : greenplum-db-6.4.0-1.el7.x86_64 50/55
error: unpacking of archive failed on file /usr/local/greenplum-db-6.4.0/bin/postgres;5e61bb0f: cpio: read
Error unpacking rpm package greenplum-db-6.4.0-1.el7.x86_64
Cleanup : 1:openssl-libs-1.0.2k-12.el7.x86_64 51/55
error: greenplum-db-6.4.0-1.el7.x86_64: install failed

How to open gpfdist

The installation is complete, I now need to open gpfdist, may I do this

gpinitsystem error

The full log is below:

[gpadmin@mdw artifact]$ gpinitsystem -a -c gpinitsystem_config
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, please wait...
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Reading Greenplum configuration file gpinitsystem_config
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Locale has not been set in gpinitsystem_config, will set to default value
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Locale set to en_US.utf8
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-MASTER_MAX_CONNECT not set, will set to default value 250
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Checking configuration parameters, Completed
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, please wait...
.Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
.Warning: Permanently added 'sdw2,172.19.0.3' (RSA) to the list of known hosts.

20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Configuring build for standard array
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Commencing multi-home checks, Completed
20210323:01:47:19:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Building primary segment instance array, please wait...
Traceback (most recent call last):
  File "/usr/local/greenplum-db-6.15.0/bin/lib/gphostcachelookup.py", line 12, in <module>
    from gppylib.gphostcache import GpInterfaceToHostNameCache
ImportError: No module named gppylib.gphostcache
.Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
.Warning: Permanently added 'sdw2,172.19.0.3' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw2,172.19.0.3' (RSA) to the list of known hosts.

20210323:01:47:20:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Checking Master host
20210323:01:47:20:001165 gpinitsystem:mdw:gpadmin-[INFO]:-Checking new segment hosts, please wait...
Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
Warning: Permanently added 'mdw,172.19.0.5' (RSA) to the list of known hosts.
Warning: Permanently added 'mdw,172.19.0.5' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw2,172.19.0.3' (RSA) to the list of known hosts.
Warning: Permanently added 'mdw,172.19.0.5' (RSA) to the list of known hosts.
Warning: Permanently added 'mdw,172.19.0.5' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw2,172.19.0.3' (RSA) to the list of known hosts.
.Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
Warning: Permanently added 'sdw1,172.19.0.2' (RSA) to the list of known hosts.
/bin/touch: cannot touch ‘/home/gpadmin/artifact/data/tmp_file_test’: No such file or directory
20210323:01:47:21:001165 gpinitsystem:mdw:gpadmin-[FATAL]:-Cannot write to /home/gpadmin/artifact/data on sdw1  Script Exiting!

I can't find this file /home/gpadmin/artifact/data/tmp_file_test in this repo, so what script or program do i think generated this file.

-bash: gpinitsystem: command not found

你好，artifact/prepare.sh -s 2 -n 2 完成之后显示找不到gpinitsystem命令，请问怎么解决
[gpadmin@mdw ~]$ ls
artifact data env.sh gpinitsystem_config hostfile master mirror

error executing configure script

configure: error: cannot run /bin/sh config/config.sub

gpextend exit

不支持mirror添加么

Config greenplum file failed: GPHOME is unset

after installation and ssh to master, I run the artifact/prepare.sh -s 2 -n 2 command, but it reports GPHOME is unset

[gpadmin@mdw ~]$ artifact/prepare.sh -s 2 -n 2
+ '[' -z ']'
+ echo 'GPHOME is unset'
GPHOME is unset
+ exit 1