Hi Team,
I have installed dremio on standalone ubuntu machine for testing and tried making a connection to SQL database. After connection and saving the data as virtual dataset i am unable to run queries. Even tried with dremio sample dataset and getting the same error.
Error on UI : Error setting up remote fragment execution
Error in server.log:
2020-03-27 10:54:14,510 [out-of-band-observer] INFO query.logger - {“queryId”:“218224d1-eb6d-9524-d139-269dfd61f300”,“schema”:"[Samples, samples.dremio.com]",“queryText”:“SELECT * FROM “SF_incidents2016.json””,“start”:1585306413169,“finish”:1585306454505,“outcome”:“FAILED”,“username”:“parassaluja23”}
2020-03-27 10:54:19,569 [FABRIC-1] ERROR com.dremio.exec.rpc.BasicClient - Failed to establish connection
java.util.concurrent.ExecutionException: io.netty.channel.ConnectTimeoutException: connection timed out: PBLAP110/10.0.159.110:45678
at io.netty.util.concurrent.DefaultPromise.get(DefaultPromise.java:372) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionEstablishmentListener.operationComplete(BasicClient.java:284) [dremio-services-base-rpc-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionEstablishmentListener.operationComplete(BasicClient.java:272) [dremio-services-base-rpc-4.1.8-202003120636020140-9c2a6b13.jar:4.1.8-202003120636020140-9c2a6b13]
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:577) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:570) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:549) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:490) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.DefaultPromise.setValue0(DefaultPromise.java:615) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.DefaultPromise.setFailure0(DefaultPromise.java:608) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:117) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:263) [netty-transport-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.PromiseTask.runTask(PromiseTask.java:98) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.ScheduledFutureTask.run(ScheduledFutureTask.java:170) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.AbstractEventExecutor.safeExecute(AbstractEventExecutor.java:164) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:472) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:500) [netty-transport-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:989) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74) [netty-common-4.1.45.Final.jar:4.1.45.Final]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_242]
Caused by: io.netty.channel.ConnectTimeoutException: connection timed out: PBLAP876/10.0.159.120:45678
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe$1.run(AbstractNioChannel.java:261) [netty-transport-4.1.45.Final.jar:4.1.45.Final]
… 8 common frames omitted
2020-03-27 10:54:19,569 [FABRIC-1] INFO c.d.services.fabric.FabricClient - [FABRIC]: Channel closed null <–> null (fabric client)