Greenplum data source query exception(had resolved)

1

Hi, dremio friend:
my greenplum version is 4.3.17
greenplum enviroment is

192.168.3.135 master
192.168.3.136 standby
192.168.3.137 gpsegment01
192.168.3.138 gpsegment02
when I query the gp :sql:
SELECT * FROM greenplum.public.a_brand

then tips the errors info that the 192.168.3.137 error.

2018-09-27 13:38:28,596 [com.dremio.exec.catalog.CatalogProtocol$MessageHandler@22a63b58] WARN c.d.exec.catalog.CatalogServiceImpl - Failure while synchronizing source [greenplum].
java.util.concurrent.ExecutionException: java.lang.Exception: Unavailable: Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host “192.168.3.137”, user “gpadmin”, database “postgres”, SSL off)
at com.google.common.util.concurrent.AbstractFuture.getDoneValue(AbstractFuture.java:500) ~[guava-20.0.jar:na]
at com.google.common.util.concurrent.AbstractFuture.get(AbstractFuture.java:401) ~[guava-20.0.jar:na]
at com.google.common.util.concurrent.AbstractFuture$TrustedFuture.get(AbstractFuture.java:83) ~[guava-20.0.jar:na]
at com.google.common.util.concurrent.ForwardingFuture.get(ForwardingFuture.java:68) ~[guava-20.0.jar:na]
at com.google.common.util.concurrent.AbstractCheckedFuture.checkedGet(AbstractCheckedFuture.java:104) ~[guava-20.0.jar:na]
at com.dremio.exec.catalog.CatalogServiceImpl.synchronize(CatalogServiceImpl.java:454) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.CatalogServiceImpl.access$200(CatalogServiceImpl.java:100) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.CatalogServiceImpl$CatalogChangeListener.sourceUpdate(CatalogServiceImpl.java:248) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.exec.catalog.CatalogProtocol$MessageHandler.run(CatalogProtocol.java:162) [dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.RenamingRunnable.run(RenamingRunnable.java:36) [dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.SingletonRunnable.run(SingletonRunnable.java:41) [dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.SafeRunnable.run(SafeRunnable.java:40) [dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:87) [dremio-services-base-rpc-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_152]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_152]
Caused by: java.lang.Exception: Unavailable: Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host “192.168.3.137”, user “gpadmin”, database “postgres”, SSL off)
at com.dremio.exec.catalog.ManagedStoragePlugin$2.run(ManagedStoragePlugin.java:245) ~[dremio-sabot-kernel-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.RenamingRunnable.run(RenamingRunnable.java:36) [dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.SingletonRunnable.run(SingletonRunnable.java:41) [dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.SafeRunnable.run(SafeRunnable.java:40) [dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
at com.dremio.concurrent.Runnables$1.run(Runnables.java:45) ~[dremio-common-2.1.6-201809161906440178-edb5b4d.jar:2.1.6-201809161906440178-edb5b4d]
2018-09-27 13:38:36,320 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 24539322-b69b-bb41-fda9-08cd9b736800:0:0
2018-09-27 13:38:36,322 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 24539322-b69b-bb41-fda9-08cd9b736800:1:0
2018-09-27 13:38:36,325 [e1 - 24539322-b69b-bb41-fda9-08cd9b736800:frag:1:0] INFO c.d.e.catalog.ManagedStoragePlugin - User Error Occurred [ErrorId: 5fd173ca-fb3e-42d6-bbdd-88d939a82172]
com.dremio.common.exceptions.UserException: The source [greenplum] is currently unavailable. Info: [[Message{level=ERROR, msg=Unavailable: Cannot create PoolableConnectionFactory (FATAL: no pg_hba.conf entry for host “192.168.3.137”, user “gpadmin”, database “postgres”, SSL off)}]].

2

Hi, this problem had resove. the problem is not relevent with the dremio .
because I had no config the truth request Ip for the greenplum.

I only config the dremio IP address into the gp master it can visit ok
host all gpadmin 192.168.3.0/24 trust

3

For curiosity sake, can you confirm connecting to Greenplum via a Posstgres connection in Dremio is working as expected?

4

thanks，HappyCowboy, the problem had resolved . I had connected it via postgres.
thank you again^_^