Nn01.itversity.com:3306 is down for last 5~6 hours


#1

Looks like, nn01.itversity.com:3306 is down for last 5~6 hours
So I am not able to practive the lab from last 6 hours. Could you please check and let me know?

[rajkvalluru123@gw01 ~]$ sqoop eval \

–connect “jdbc:mysql://nn01:itversity.com:3306/retail_db”
–username retail_dba
–password itversity
–query “describe order_items”;
Warning: /usr/hdp/2.5.0.0-1245/accumulo does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/11/12 22:38:46 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6.2.5.0.0-1245
17/11/12 22:38:46 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/11/12 22:38:46 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
17/11/12 22:38:47 WARN tool.EvalSqlTool: SQL exception executing statement: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransi
entConnectionException: Cannot load connection class because of underlying exception: ‘java.lang.NumberFormatException: Fo
r input string: “itversity.com:3306”’.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:359)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop.tool.EvalSqlTool.run(EvalSqlTool.java:64)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:225)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.main(Sqoop.java:243)
Caused by: java.lang.NumberFormatException: For input string: "itversity.com:3306"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:580)
at java.lang.Integer.parseInt(Integer.java:615)
at com.mysql.jdbc.NonRegisteringDriver.port(NonRegisteringDriver.java:882)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:350)
… 11 more


#2

Sorry,it’s my typo error.
Please ignore it.

right one is:
[rajkvalluru123@gw01 ~]$ sqoop eval \

–connect “jdbc:mysql://nn01.itversity.com:3306/retail_db”
–username retail_dba
–password itversity
–query “describe order_items”;


#3

:smile:, that is fine. I hope your preparation is going on well.