Looks like there are couple dozens of mail about 'Connection Refused'
error. specially with jdbc interpreter. How does zeppelin notebook connects
to drill using zookeeper as discovery ?
I see following in logs:
INFO [2016-08-30 16:05:33,802] ({qtp1537358694-20}
NotebookServer.java[onOpen]:97) - New connection from 10.250.200.174 : 50501
INFO [2016-08-30 16:05:36,587] ({qtp1537358694-16}
NotebookServer.java[sendNote]:433) - New operation from 10.250.200.174 :
50501 : anonymous : GET_NOTE : 2BUMT351E
I see notice two things here:
It's connecting to 10.250.200.174 . is this ipv6?
netstat -anp | grep 11909
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 :::8080 :::*
LISTEN 11909/java
tcp 0 0 ::ffff:10.250.70.140:8080 ::ffff:10.250.200.174:50571
ESTABLISHED 11909/java
Second, New operation from 10.250.200.174 : 50501 : *anonymous* : GET_NOTE
: 2BUMT351E
User seemed to be anonymous instead of a user zeppeling is running as.
There is definitely issue with reaching the host itself but I can't get my
head around this.
PS - I can connect via sqlline just fine from the machine where zeppelin is
installed.
On Fri, Aug 26, 2016 at 4:41 PM, Nirav Patel <npa...@xactlycorp.com> wrote:
> I am trying to test drill connectivity. I added following into jdbc
> interpreter:
>
> drill.url jdbc:drill:zk=h1:5181,h2:5181,h3:5181
> drill.driver org.apache.drill.jdbc.Driver
> I could connect with Sqlline using above configuration so I know that
> works.
>
> Also added following artifact:
> org.apache.drill.exec:drill-jdbc:1.7.0
>
> Restarted interpreter.
>
>
> When trying to run following paragraph:
>
> %jdbc(drill) select * from dfs.root.`/cluster/test/
> salesdata_2016071843221/part-00001` limit 10
>
> I get following errors in logs:
>
>
> ==> logs/zeppelin-xactly-f7.xactlycorporation.local.out <==
>
> SLF4J: Class path contains multiple SLF4J bindings.
>
> SLF4J: Found binding in [jar:file:/home/xactly/npatel/
> zeppelin-0.6.1/interpreter/jdbc/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/
> StaticLoggerBinder.class]
>
> SLF4J: Found binding in [jar:file:/home/xactly/npatel/
> zeppelin-0.6.1/zeppelin-interpreter/target/lib/slf4j-
> log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
> explanation.
>
> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
>
> SLF4J: Detected both log4j-over-slf4j.jar AND slf4j-log4j12.jar on the
> class path, preempting StackOverflowError.
>
> SLF4J: See also http://www.slf4j.org/codes.html#log4jDelegationLoop for
> more details.
>
> Exception in thread "main" java.lang.ExceptionInInitializerError
>
> at org.apache.log4j.LogManager.getLogger(LogManager.java:44)
>
> at org.slf4j.impl.Log4jLoggerFactory.getLogger(Log4jLoggerFactory.java:64)
>
> at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:277)
>
> at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:288)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer.<init>
> (RemoteInterpreterServer.java:56)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer.main(
> RemoteInterpreterServer.java:128)
>
> Caused by: java.lang.IllegalStateException: Detected both
> log4j-over-slf4j.jar AND slf4j-log4j12.jar on the class path, preempting
> StackOverflowError. See also http://www.slf4j.org/codes.
> html#log4jDelegationLoop for more details.
>
> at org.apache.log4j.Log4jLoggerFactory.<clinit>(
> Log4jLoggerFactory.java:51)
>
> ... 6 more
>
>
> ==> logs/zeppelin-xactly-f7.xactlycorporation.local.log <==
>
> INFO [2016-08-26 16:33:04,767] ({Exec Default Executor}
> RemoteInterpreterProcess.java[onProcessComplete]:281) - Interpreter
> process exited 0
>
> ERROR [2016-08-26 16:33:34,580] ({Thread-131}
> RemoteScheduler.java[getStatus]:255)
> - Can't get status information
>
> org.apache.zeppelin.interpreter.InterpreterException:
> org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:53)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:37)
>
> at org.apache.commons.pool2.BasePooledObjectFactory.makeObject(
> BasePooledObjectFactory.java:60)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.create(
> GenericObjectPool.java:861)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:435)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:363)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.
> getClient(RemoteInterpreterProcess.java:189)
>
> at org.apache.zeppelin.scheduler.RemoteScheduler$
> JobStatusPoller.getStatus(RemoteScheduler.java:253)
>
> at org.apache.zeppelin.scheduler.RemoteScheduler$JobStatusPoller.run(
> RemoteScheduler.java:211)
>
> Caused by: org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:187)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:51)
>
> ... 8 more
>
> Caused by: java.net.ConnectException: Connection refused
>
> at java.net.PlainSocketImpl.socketConnect(Native Method)
>
> at java.net.AbstractPlainSocketImpl.doConnect(
> AbstractPlainSocketImpl.java:339)
>
> at java.net.AbstractPlainSocketImpl.connectToAddress(
> AbstractPlainSocketImpl.java:200)
>
> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
> 182)
>
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>
> at java.net.Socket.connect(Socket.java:579)
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:182)
>
> ... 9 more
>
> ERROR [2016-08-26 16:33:34,580] ({pool-1-thread-14} Job.java[run]:189) -
> Job failed
>
> org.apache.zeppelin.interpreter.InterpreterException: org.apache.zeppelin.
> interpreter.InterpreterException:
> org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(
> RemoteInterpreter.java:165)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreter.getFormType(
> RemoteInterpreter.java:328)
>
> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.getFormType(
> LazyOpenInterpreter.java:105)
>
> at org.apache.zeppelin.notebook.Paragraph.jobRun(Paragraph.java:260)
>
> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>
> at org.apache.zeppelin.scheduler.RemoteScheduler$JobRunner.run(
> RemoteScheduler.java:328)
>
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
>
> at java.lang.Thread.run(Thread.java:744)
>
> Caused by: org.apache.zeppelin.interpreter.InterpreterException:
> org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:53)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:37)
>
> at org.apache.commons.pool2.BasePooledObjectFactory.makeObject(
> BasePooledObjectFactory.java:60)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.create(
> GenericObjectPool.java:861)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:435)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:363)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.
> getClient(RemoteInterpreterProcess.java:189)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(
> RemoteInterpreter.java:163)
>
> ... 12 more
>
> Caused by: org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:187)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:51)
>
> ... 19 more
>
> Caused by: java.net.ConnectException: Connection refused
>
> at java.net.PlainSocketImpl.socketConnect(Native Method)
>
> at java.net.AbstractPlainSocketImpl.doConnect(
> AbstractPlainSocketImpl.java:339)
>
> at java.net.AbstractPlainSocketImpl.connectToAddress(
> AbstractPlainSocketImpl.java:200)
>
> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
> 182)
>
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>
> at java.net.Socket.connect(Socket.java:579)
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:182)
>
> ... 20 more
>
> ERROR [2016-08-26 16:33:34,581] ({pool-1-thread-14}
> RemoteScheduler.java[getStatus]:255)
> - Can't get status information
>
> org.apache.zeppelin.interpreter.InterpreterException:
> org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:53)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:37)
>
> at org.apache.commons.pool2.BasePooledObjectFactory.makeObject(
> BasePooledObjectFactory.java:60)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.create(
> GenericObjectPool.java:861)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:435)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:363)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.
> getClient(RemoteInterpreterProcess.java:189)
>
> at org.apache.zeppelin.scheduler.RemoteScheduler$
> JobStatusPoller.getStatus(RemoteScheduler.java:253)
>
> at org.apache.zeppelin.scheduler.RemoteScheduler$JobRunner.run(
> RemoteScheduler.java:341)
>
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
>
> at java.lang.Thread.run(Thread.java:744)
>
> Caused by: org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:187)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:51)
>
> ... 15 more
>
> Caused by: java.net.ConnectException: Connection refused
>
> at java.net.PlainSocketImpl.socketConnect(Native Method)
>
> at java.net.AbstractPlainSocketImpl.doConnect(
> AbstractPlainSocketImpl.java:339)
>
> at java.net.AbstractPlainSocketImpl.connectToAddress(
> AbstractPlainSocketImpl.java:200)
>
> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
> 182)
>
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>
> at java.net.Socket.connect(Socket.java:579)
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:182)
>
> ... 16 more
>
> ERROR [2016-08-26 16:33:34,582] ({pool-1-thread-14}
> NotebookServer.java[afterStatusChange]:1145)
> - Error
>
> org.apache.zeppelin.interpreter.InterpreterException: org.apache.zeppelin.
> interpreter.InterpreterException:
> org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(
> RemoteInterpreter.java:165)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreter.getFormType(
> RemoteInterpreter.java:328)
>
> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.getFormType(
> LazyOpenInterpreter.java:105)
>
> at org.apache.zeppelin.notebook.Paragraph.jobRun(Paragraph.java:260)
>
> at org.apache.zeppelin.scheduler.Job.run(Job.java:176)
>
> at org.apache.zeppelin.scheduler.RemoteScheduler$JobRunner.run(
> RemoteScheduler.java:328)
>
> at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
>
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178)
>
> at java.util.concurrent.ScheduledThreadPoolExecutor$
> ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
>
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1145)
>
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:615)
>
> at java.lang.Thread.run(Thread.java:744)
>
> Caused by: org.apache.zeppelin.interpreter.InterpreterException:
> org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:53)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:37)
>
> at org.apache.commons.pool2.BasePooledObjectFactory.makeObject(
> BasePooledObjectFactory.java:60)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.create(
> GenericObjectPool.java:861)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:435)
>
> at org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:363)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterProcess.
> getClient(RemoteInterpreterProcess.java:189)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreter.init(
> RemoteInterpreter.java:163)
>
> ... 12 more
>
> Caused by: org.apache.thrift.transport.TTransportException:
> java.net.ConnectException: Connection refused
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:187)
>
> at org.apache.zeppelin.interpreter.remote.ClientFactory.create(
> ClientFactory.java:51)
>
> ... 19 more
>
> Caused by: java.net.ConnectException: Connection refused
>
> at java.net.PlainSocketImpl.socketConnect(Native Method)
>
> at java.net.AbstractPlainSocketImpl.doConnect(
> AbstractPlainSocketImpl.java:339)
>
> at java.net.AbstractPlainSocketImpl.connectToAddress(
> AbstractPlainSocketImpl.java:200)
>
> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:
> 182)
>
> at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>
> at java.net.Socket.connect(Socket.java:579)
>
> at org.apache.thrift.transport.TSocket.open(TSocket.java:182)
>
> ... 20 more
>
>
>
> There is slf4j-log4j binding errors but not sure what I can do about it.
> I tried adding "org.slf4j:log4j-over-slf4j.jar:*" in exclude section of
> "org.apache.drill.exec:drill-jdbc:1.7.0" but I think its rather coming
> from installation libs.
>
>
> Thanks
>
--
[image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>
<https://www.nyse.com/quote/XNYS:XTLY> [image: LinkedIn]
<https://www.linkedin.com/company/xactly-corporation> [image: Twitter]
<https://twitter.com/Xactly> [image: Facebook]
<https://www.facebook.com/XactlyCorp> [image: YouTube]
<http://www.youtube.com/xactlycorporation>
