I did a fresh install on my windows desktop of dremio Community Edition, Build 1.4.9-201802191836310213-7195059
I created some sources (mysql, postgresql, greenplum, mongodb).
I can see the schemas and tables but every query fails with this error :
Error setting up remote intermediate fragment execution
Any idea of the issue ?
Could you look at the logs? It should provide more detailed stacktrace.
below extract of the log :
2018-04-05 17:08:02,283 [2539c42e-743a-5dd8-9629-ce8b72767800:foreman] INFO c.d.s.fabric.FabricConnectionManager - [FABRIC]: No connection active, opening new connection to EFR01545.fr01.awl.atosorigin.net:45678.
2018-04-05 17:08:02,286 [out-of-band-observer] ERROR c.d.service.jobs.QueryProfileParser - Failed to parse physical plan for query 2539c42e-743a-5dd8-9629-ce8b72767800, plan {
"\"00-00\"": {
"\"op\"": "com.dremio.exec.planner.physical.ScreenPrel",
"\"values\"": {},
"\"inputs\"": [
"00-01"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{76301.21967633665 rows, 69131.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"00-01\"": {
"\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
"\"values\"": {
"\"fields\"": "[Fragment, Records, Path, Metadata, Partition]",
"\"exprs\"": "[$0, $1, $2, $3, $4]"
},
"\"inputs\"": [
"00-02"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{76101.21967633665 rows, 68931.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"00-02\"": {
"\"op\"": "com.dremio.exec.planner.physical.WriterCommitterPrel",
"\"values\"": {
"\"temp\"": "C:/Utilisateurs/FR20411/AppData/Local/Dremio/pdfs/results/.2539c42e-743a-5dd8-9629-ce8b72767800-1522940881863",
"\"final\"": "C:/Utilisateurs/FR20411/AppData/Local/Dremio/pdfs/results/2539c42e-743a-5dd8-9629-ce8b72767800"
},
"\"inputs\"": [
"00-03"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{74101.21967633665 rows, 58931.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"00-03\"": {
"\"op\"": "com.dremio.exec.planner.physical.UnionExchangePrel",
"\"values\"": {},
"\"inputs\"": [
"01-01"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{72101.21967633665 rows, 56931.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"01-01\"": {
"\"op\"": "com.dremio.exec.planner.physical.WriterPrel",
"\"values\"": {},
"\"inputs\"": [
"01-02"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{70101.21967633665 rows, 40931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
},
"\"01-02\"": {
"\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
"\"values\"": {
"\"fields\"": "[date]",
"\"exprs\"": "[$0]"
},
"\"inputs\"": [
"01-03"
],
"\"rowType\"": "RecordType(TIMESTAMP(0) date)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{68101.21967633665 rows, 38931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
},
"\"01-03\"": {
"\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
"\"values\"": {
"\"fields\"": "[date]",
"\"exprs\"": "[$0]"
},
"\"inputs\"": [
"01-04"
],
"\"rowType\"": "RecordType(TIMESTAMP(0) date)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{66101.21967633665 rows, 36931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
},
"\"01-04\"": {
"\"op\"": "com.dremio.exec.store.jdbc.rel.JdbcPrel",
"\"values\"": {
"\"sql\"": "SELECT *
\nFROM `test`.`calendar`
\nLIMIT 2000
\nOFFSET 0"
},
"\"inputs\"": [],
"\"rowType\"": "RecordType(TIMESTAMP(0) date)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{64101.21967633666 rows, 34931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
}
}
com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value
at [Source: {
"\"00-00\"": {
"\"op\"": "com.dremio.exec.planner.physical.ScreenPrel",
"\"values\"": {},
"\"inputs\"": [
"00-01"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{76301.21967633665 rows, 69131.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"00-01\"": {
"\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
"\"values\"": {
"\"fields\"": "[Fragment, Records, Path, Metadata, Partition]",
"\"exprs\"": "[$0, $1, $2, $3, $4]"
},
"\"inputs\"": [
"00-02"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{76101.21967633665 rows, 68931.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"00-02\"": {
"\"op\"": "com.dremio.exec.planner.physical.WriterCommitterPrel",
"\"values\"": {
"\"temp\"": "C:/Utilisateurs/FR20411/AppData/Local/Dremio/pdfs/results/.2539c42e-743a-5dd8-9629-ce8b72767800-1522940881863",
"\"final\"": "C:/Utilisateurs/FR20411/AppData/Local/Dremio/pdfs/results/2539c42e-743a-5dd8-9629-ce8b72767800"
},
"\"inputs\"": [
"00-03"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{74101.21967633665 rows, 58931.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"00-03\"": {
"\"op\"": "com.dremio.exec.planner.physical.UnionExchangePrel",
"\"values\"": {},
"\"inputs\"": [
"01-01"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{72101.21967633665 rows, 56931.0 cpu, 32930.0 io, 4.099293E7 network, 0.0 memory}"
},
"\"01-01\"": {
"\"op\"": "com.dremio.exec.planner.physical.WriterPrel",
"\"values\"": {},
"\"inputs\"": [
"01-02"
],
"\"rowType\"": "RecordType(VARCHAR(65536) Fragment, BIGINT Records, VARCHAR(65536) Path, VARBINARY(65536) Metadata, INTEGER Partition)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{70101.21967633665 rows, 40931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
},
"\"01-02\"": {
"\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
"\"values\"": {
"\"fields\"": "[date]",
"\"exprs\"": "[$0]"
},
"\"inputs\"": [
"01-03"
],
"\"rowType\"": "RecordType(TIMESTAMP(0) date)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{68101.21967633665 rows, 38931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
},
"\"01-03\"": {
"\"op\"": "com.dremio.exec.planner.physical.ProjectPrel",
"\"values\"": {
"\"fields\"": "[date]",
"\"exprs\"": "[$0]"
},
"\"inputs\"": [
"01-04"
],
"\"rowType\"": "RecordType(TIMESTAMP(0) date)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{66101.21967633665 rows, 36931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
},
"\"01-04\"": {
"\"op\"": "com.dremio.exec.store.jdbc.rel.JdbcPrel",
"\"values\"": {
"\"sql\"": "SELECT *
\nFROM `test`.`calendar`
\nLIMIT 2000
\nOFFSET 0"
},
"\"inputs\"": [],
"\"rowType\"": "RecordType(TIMESTAMP(0) date)",
"\"rowCount\"": 2000.0,
"\"cumulativeCost\"": "{64101.21967633666 rows, 34931.0 cpu, 32930.0 io, 32930.0 network, 0.0 memory}"
}
}; line: 87, column: 28]
at com.fasterxml.jackson.core.JsonParser._constructError(JsonParser.java:1586) ~[jackson-core-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.core.base.ParserMinimalBase._reportError(ParserMinimalBase.java:521) ~[jackson-core-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.core.base.ParserMinimalBase._throwUnquotedSpace(ParserMinimalBase.java:485) ~[jackson-core-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._finishString2(ReaderBasedJsonParser.java:1978) ~[jackson-core-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser._finishString(ReaderBasedJsonParser.java:1950) ~[jackson-core-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.core.json.ReaderBasedJsonParser.getText(ReaderBasedJsonParser.java:260) ~[jackson-core-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:514) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:629) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:496) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.mapObject(UntypedObjectDeserializer.java:638) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.UntypedObjectDeserializer$Vanilla.deserialize(UntypedObjectDeserializer.java:496) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.MapDeserializer._readAndBindStringMap(MapDeserializer.java:496) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:342) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.deser.std.MapDeserializer.deserialize(MapDeserializer.java:26) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:3807) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2797) ~[jackson-databind-2.7.9.jar:2.7.9]
at com.dremio.service.jobs.QueryProfileParser.parsePhysicalPlan(QueryProfileParser.java:253) [dremio-services-jobs-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.service.jobs.QueryProfileParser.parse(QueryProfileParser.java:284) [dremio-services-jobs-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.service.jobs.QueryProfileParser.<init>(QueryProfileParser.java:89) [dremio-services-jobs-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.service.jobs.LocalJobsService$JobResultListener.execStarted(LocalJobsService.java:1161) [dremio-services-jobs-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.planner.observer.OutOfBandAttemptObserver$11.doRun(OutOfBandAttemptObserver.java:165) [dremio-sabot-kernel-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.planner.observer.OutOfBandAttemptObserver$DeferredRunnable.run(OutOfBandAttemptObserver.java:256) [dremio-sabot-kernel-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:87) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_151]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_151]
2018-04-05 17:08:02,297 [FABRIC-9] ERROR com.dremio.exec.rpc.BasicClient - Failed to establish connection
java.util.concurrent.ExecutionException: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:202) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:189) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:507) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:500) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:479) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:420) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:122) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:278) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:294) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:633) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_151]
Caused by: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[na:1.8.0_151]
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source) ~[na:1.8.0_151]
at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:258) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:291) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
... 6 common frames omitted
Caused by: java.net.SocketException: Permission denied: no further information
... 10 common frames omitted
2018-04-05 17:08:02,298 [FABRIC-9] INFO c.d.services.fabric.FabricClient - [FABRIC]: Channel closed null <--> null (fabric client)
2018-04-05 17:08:02,304 [2539c42e-743a-5dd8-9629-ce8b72767800:foreman] INFO c.d.e.p.s.h.commands.FragmentStarter - User Error Occurred [ErrorId: 1473af37-325e-44fe-97d2-7792e900ffb3]
com.dremio.common.exceptions.UserException: Error setting up remote intermediate fragment execution
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:648) ~[dremio-common-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.planner.sql.handlers.commands.FragmentStarter.startFragments(FragmentStarter.java:165) [dremio-sabot-kernel-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.planner.sql.handlers.commands.FragmentStarter.start(FragmentStarter.java:67) [dremio-sabot-kernel-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.execute(HandlerToExec.java:76) [dremio-sabot-kernel-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.work.foreman.AttemptManager.run(AttemptManager.java:298) [dremio-sabot-kernel-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_151]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_151]
Caused by: com.dremio.exec.rpc.ConnectionFailedException: com.dremio.exec.rpc.RpcException: Command failed while establishing connection. Failure type CONNECTION.
at com.dremio.exec.rpc.ConnectionFailedException.mapException(ConnectionFailedException.java:31) ~[dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.ListeningCommand.connectionFailed(ListeningCommand.java:64) ~[dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.services.fabric.FabricServiceImpl$ProxyCommand.connectionFailed(FabricServiceImpl.java:150) ~[dremio-services-fabric-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.ReconnectingConnection$ConnectionListeningFuture.connectionFailed(ReconnectingConnection.java:167) ~[dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:223) ~[dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:189) ~[dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:507) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:500) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:479) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:420) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:122) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:278) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:294) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:633) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
... 1 common frames omitted
Caused by: com.dremio.exec.rpc.RpcException: Command failed while establishing connection. Failure type CONNECTION.
at com.dremio.exec.rpc.RpcException.mapException(RpcException.java:71) ~[dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
... 18 common frames omitted
Caused by: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[na:1.8.0_151]
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source) ~[na:1.8.0_151]
at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:258) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:291) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
... 6 common frames omitted
Caused by: java.net.SocketException: Permission denied: no further information
... 10 common frames omitted
2018-04-05 17:08:02,305 [2539c42e-743a-5dd8-9629-ce8b72767800:foreman] INFO c.d.s.fabric.FabricConnectionManager - [FABRIC]: No connection active, opening new connection to EFR01545.fr01.awl.atosorigin.net:45678.
2018-04-05 17:08:02,312 [FABRIC-10] ERROR com.dremio.exec.rpc.BasicClient - Failed to establish connection
java.util.concurrent.ExecutionException: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:202) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:189) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:507) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:500) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:479) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:420) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:122) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:278) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:294) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:633) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_151]
Caused by: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[na:1.8.0_151]
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source) ~[na:1.8.0_151]
at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:258) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:291) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
... 6 common frames omitted
Caused by: java.net.SocketException: Permission denied: no further information
... 10 common frames omitted
2018-04-05 17:08:02,313 [2539c42e-743a-5dd8-9629-ce8b72767800:foreman] INFO c.d.s.fabric.FabricConnectionManager - [FABRIC]: No connection active, opening new connection to EFR01545.fr01.awl.atosorigin.net:45678.
2018-04-05 17:08:02,313 [FABRIC-10] ERROR c.d.exec.work.foreman.QueryManager - Failure while attempting to CANCEL fragment 2539c42e-743a-5dd8-9629-ce8b72767800:1:0 on endpoint EFR01545.fr01.awl.atosorigin.net:31010 with com.dremio.exec.rpc.ConnectionFailedException: com.dremio.exec.rpc.RpcException: Command failed while establishing connection. Failure type CONNECTION..
2018-04-05 17:08:02,313 [FABRIC-10] INFO c.d.services.fabric.FabricClient - [FABRIC]: Channel closed null <--> null (fabric client)
2018-04-05 17:08:02,319 [FABRIC-1] ERROR com.dremio.exec.rpc.BasicClient - Failed to establish connection
java.util.concurrent.ExecutionException: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at io.netty.util.concurrent.AbstractFuture.get(AbstractFuture.java:54) ~[netty-common-4.0.49.Final.jar:4.0.49.Final]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:202) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at com.dremio.exec.rpc.BasicClient$ConnectionMultiListener$ConnectionHandler.operationComplete(BasicClient.java:189) [dremio-services-base-rpc-1.4.9-201802191836310213-7195059.jar:1.4.9-201802191836310213-7195059]
at io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:507) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:500) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListenersNow(DefaultPromise.java:479) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:420) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:122) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.fulfillConnectPromise(AbstractNioChannel.java:278) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:294) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:633) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) [netty-common-4.0.49.Final.jar:4.0.49.Final]
at java.lang.Thread.run(Unknown Source) [na:1.8.0_151]
Caused by: io.netty.channel.AbstractChannel$AnnotatedSocketException: Permission denied: no further information: EFR01545.fr01.awl.atosorigin.net/192.168.56.1:45678
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[na:1.8.0_151]
at sun.nio.ch.SocketChannelImpl.finishConnect(Unknown Source) ~[na:1.8.0_151]
at io.netty.channel.socket.nio.NioSocketChannel.doFinishConnect(NioSocketChannel.java:258) ~[netty-transport-4.0.49.Final.jar:4.0.49.Final]
at io.netty.channel.nio.AbstractNioChannel$AbstractNioUnsafe.finishConnect(AbstractNioChannel.java:291) [netty-transport-4.0.49.Final.jar:4.0.49.Final]
... 6 common frames omitted
Caused by: java.net.SocketException: Permission denied: no further information
... 10 common frames omitted
2018-04-05 17:08:02,320 [FABRIC-1] ERROR c.d.exec.work.foreman.QueryManager - Failure while attempting to CANCEL fragment 2539c42e-743a-5dd8-9629-ce8b72767800:0:0 on endpoint EFR01545.fr01.awl.atosorigin.net:31010 with com.dremio.exec.rpc.ConnectionFailedException: com.dremio.exec.rpc.RpcException: Command failed while establishing connection. Failure type CONNECTION..
Was there a resolution to this issue? Experiencing the same issue and errors for build 2.0.1-201804132205050000-10b1de0. From the logs it looks like an issue communicating with the local 45678 port.
If you got to Admin, Node Activity, you will get the same message as well.
Confirmed that the standalone MAC install works (2 devices). The standalone Windows10 install results in this error when accessing ElasticSearch (2 devices).
The Windows10 logs for our issue and westmalle’s error show the same error:
AnnotatedSocketException: Permission denied: no further information: device address:45678
I have customized the port and also validated that we can telnet to the 45678 port (and custom port), but the issue persist. Java security is set to allowed.
I got the same error when I refresh reflections of vds. I don’t know why
Looks like above is the offending one. Not sure what could have caused it though.