When load data from gemfire to gpdb through gpfdist, generate error : http response code 500 from gpfdist
search cancel

When load data from gemfire to gpdb through gpfdist, generate error : http response code 500 from gpfdist

book

Article ID: 370229

calendar_today

Updated On:

Products

VMware Tanzu Greenplum

Issue/Introduction

When load data from gemfire to gpdb through gpfdist,  the loading job may fail from application side. From gpdb pg log, it will report

"ERROR","08006","http response code 500 from gpfdist (gpfdist://xxx.xxx.xxx:xxxx/xxxxxxxx-xxxxxx ): HTTP/1.1 200 OK  (segx xxx.xxx.xxx:xxxx pid=xxxxx)",,,,,,"INSERT INTO ""gf_ext_xxx_xxx"" 

 

Environment

gemfire + greenplum 6.x

Resolution

In situation, we can check if there is any change made to gemfire server and infrastructures. If yes, then try restart gemfire cache server first. If issue still exist, then contact Greenplum support team for assistance.