lunny/greenplum-oss-docker
1
0
Fork 0
mirror of https://github.com/kongyew/greenplum-oss-docker synced 2020-06-03 18:44:52 +00:00
Code Issues Releases Wiki Activity
master
greenplum-oss-docker/usecase2/data
History
kongyew 271947c323 updated
2018-11-26 12:06:58 -08:00
..
download_postgresql.sh updated 2018-11-26 12:06:58 -08:00
gpdb_sample.sql updated 2018-11-26 12:06:58 -08:00
README.MD updated 2018-11-26 12:06:58 -08:00
removeDB.sh updated 2018-11-26 12:06:58 -08:00
setEnv.sh updated 2018-11-26 12:06:58 -08:00
setupDB.sh updated 2018-11-26 12:06:58 -08:00
Showusertable.sh updated 2018-11-26 12:06:58 -08:00

README.MD

Readme

This document describes how to setup PXF with JDBC examples.

Error "ERROR: remote component error (0) from ':5888': Failed to connect to localhost port 5888: Connection refused (libchurl.c:944) (seg0 slice1 172.18.0.2:40000 pid=505) (cdbdisp.c:254)"

This error is displayed whenever PXF service is not running.

gpadmin=# select * from pxf_jdbc_postgres_testpxf;
ERROR:  remote component error (0) from ':5888': Failed to connect to localhost port 5888: Connection refused (libchurl.c:944)  (seg0 slice1 172.18.0.2:40000 pid=505) (cdbdisp.c:254)
DETAIL:  External table pxf_jdbc_postgres_testpxf

Error "ERROR: remote component error (500) from '127.0.0.1:5888': type Exception report message org.postgresql.Driver description The server encountered an internal error that prevented it from fulfilling this request. exception java.io.IOException: org.postgresql.Driver (libchurl.c:944) (seg1 slice1 172.18.0.2:40001 pid=718) (cdbdisp.c:254)"

This error is displayed whenever JDBC driver is not loaded by PXF service.

gpadmin=# select * from pxf_jdbc_postgres_testpxf;
ERROR:  remote component error (500) from '127.0.0.1:5888':  type  Exception report   message   org.postgresql.Driver    description   The server encountered an internal error that prevented it from fulfilling this request.    exception   java.io.IOException: org.postgresql.Driver (libchurl.c:944)  (seg1 slice1 172.18.0.2:40001 pid=718) (cdbdisp.c:254)
DETAIL:  External table pxf_jdbc_postgres_testpxf