[ gpfdist ] http response code 400 from gpfdist

基本信息

系统 : CentOS Linux release 7.4.1708 (Core)
产品 : OushuDB
模块 : DB
子模块 : -

描述详述

原因

Description
PowerExchange GreenPlum session fails with the following error message:

2013-01-25 11:52:54|ERROR|ERROR:  http response code 400 from gpfdist (gpfdist://empetlipcdev01.virginblue.internal:8000/../infa_shared/Temp/derived_history_dv_audited_ticket_coupon_hist_0_pipe): HTTP/1.0 400 time out (url.c:326)  (seg14 slice1 sdw3:40002 pid=29191) (cdbdisp.c:1462)

This message is from GreenPlum database and even if you run the gpload outside PowerCenter, the same issue occurs.

This issue occurs when the network is busy. This is a timeout error. By default, the time out value is set to 30.

To address this issue, the default gpfdist timeout value has been changed to 0 (no timeout). This issue is fixed in GreenPlum Database 3.3.6.7.

## 参考: https://knowledge.informatica.com/s/article/146453?language=en_US

解决方案

gpfdist --help
......
-t <timeout>

Sets the time (in seconds) allowed for HAWQ to 
establish a connection to a gpfdist process. Default is 5 seconds.
Valid values are 2 to 30 seconds.  May need to be increased on 
systems with a lot of network traffic.
......

启动gpfdist的时候( -t 0 )