Dr Elephand is not starting

[alanheli92]

Hi Guys, we have been trying to install Dr. Elephant and after a lot of troubleshooting we are stuck in this part:

[root@ip-172-31-37-252 bin]# ./start.sh
Using config dir: /usr/dr-elephant/app-conf
Using config file: /usr/dr-elephant/app-conf/elephant.conf
Reading from config file...
db_url:  localhost
db_name:  drelephant
db_user:  root
http port:  8081
This is hadoop2.x grid. Add Java library path: /lib/native
Starting Dr. Elephant ....
Dr. Elephant started.

but the process never start and looking in the logs we found this:

2016-04-22 20:34:50,374 - [ERROR] - from com.jolbox.bonecp.hooks.AbstractConnectionHook in main
Failed to obtain initial connection Sleeping for 0ms and trying again. Attempts left: 0. Exception: java.net.ConnectException: Conn
ection refused.Message:Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
/hadoop/dr-elephant-2.0.3-SNAPSHOT/logs

please let us know if somebody has been experience this issue or have any idea.

[canghaiyisu666]

@alanheli92
there're something to be sure : mysql version 5.6.4+ which declared in Administrator Guide ; env. all set ; elephant.conf is ready.

[akshayrai]

@canghaiyisu666, the mysql requirement has been changed to 5.5+. I had updated this in the developer docs but forgot to do so in the Administrator guide.

@alanheli92, there is a thread open in the mailing list on the same issue reported by Gabriel García. You might want to follow it up there.

[tglstory]

The root cause of this problem is conflicting akka dependencies. If you have spark 1.5.0 or above, you need to exclude the akka dependencies.

[alanheli92]

Thanks, finally I could start the server but when I tried to connect with the web browser the dr.log displays this error message:
tail: dr.log: file truncated
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
Play server process ID is 9122
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/hadoop/dr-elephant-2.0.3-SNAPSHOT/lib/ch.qos.logback.logback-classic-1.0.13.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/hadoop/dr-elephant-2.0.3-SNAPSHOT/lib/org.slf4j.slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/hdp/2.3.4.0-3485/hadoop/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 [ch.qos.logback.classic.util.ContextSelectorStaticBinder]
[info] play - database [default] connected at jdbc:mysql://localhost/drelephant?characterEncoding=UTF-8
[info] application - Starting Application...
[info] play - Application started (Prod)
[info] play - Listening for HTTP on /0:0:0:0:0:0:0:0:8082
[error] play - Cannot invoke the action, eventually got an error: javax.persistence.PersistenceException: Query threw SQLException:Table 'drelephant.yarn_app_result' doesn't exist
Bind values:[Tue Apr 26 15:35:05 UTC 2016]
Query was:
select count(*) from yarn_app_result t0 where t0.finish_time > ?

[error] application -

! @6ppoc7dnn - Internal server error, for (GET) [/] ->

play.api.Application$$anon$1: Execution exception[[PersistenceException: Query threw SQLException:Table 'drelephant.yarn_app_result' doesn't exist
Bind values:[Tue Apr 26 15:35:05 UTC 2016]
Query was:
select count(*) from yarn_app_result t0 where t0.finish_time > ?

]]
at play.api.Application$class.handleError(Application.scala:293) ~[com.typesafe.play.play_2.10-2.2.2.jar:2.2.2]
at play.api.DefaultApplication.handleError(Application.scala:399) [com.typesafe.play.play_2.10-2.2.2.jar:2.2.2]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [com.typesafe.play.play_2.10-2.2.2.jar:2.2.2]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2$$anonfun$applyOrElse$3.apply(PlayDefaultUpstreamHandler.scala:261) [com.typesafe.play.play_2.10-2.2.2.jar:2.2.2]
at scala.Option.map(Option.scala:145) [org.scala-lang.scala-library-2.10.4.jar:na]
at play.core.server.netty.PlayDefaultUpstreamHandler$$anonfun$2.applyOrElse(PlayDefaultUpstreamHandler.scala:261) [com.typesafe.play.play_2.10-2.2.2.jar:2.2.2]
Caused by: javax.persistence.PersistenceException: Query threw SQLException:Table 'drelephant.yarn_app_result' doesn't exist
Bind values:[Tue Apr 26 15:35:05 UTC 2016]
Query was:
select count(*) from yarn_app_result t0 where t0.finish_time > ?

    at com.avaje.ebeaninternal.server.query.CQuery.createPersistenceException(CQuery.java:790) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.query.CQueryEngine.findRowCount(CQueryEngine.java:110) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.query.DefaultOrmQueryEngine.findRowCount(DefaultOrmQueryEngine.java:36) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.core.OrmQueryRequest.findRowCount(OrmQueryRequest.java:235) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.core.DefaultServer.findRowCountWithCopy(DefaultServer.java:1301) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]
    at com.avaje.ebeaninternal.server.core.DefaultServer.findRowCount(DefaultServer.java:1293) ~[org.avaje.ebeanorm.avaje-ebeanorm-3.2.2.jar:na]

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'drelephant.yarn_app_result' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_60]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_60]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_60]
at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[na:1.8.0_60]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:400) ~[mysql.mysql-connector-java-5.1.36.jar:5.1.36]
at com.mysql.jdbc.Util.getInstance(Util.java:383) ~[mysql.mysql-connector-java-5.1.36.jar:5.1.36]

Any help would be appreciated

[alanheli92]

And the web browser displays:
Oops, an error occured
This exception has been logged with id 6ppof9ljo.

The id error changes when I reload the page

[tglstory]

you need to configure your mysql. Make the table drelephant as specified in the docs.