在Sqoop导入mysql数据过程中的异常信息以及解决_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 2520 | 回复: 0

主题： 在Sqoop导入mysql数据过程中的异常信息以及解决

snisn

注册用户

等级：新兵
经验：51
发帖：84
精华：0
注册：2011-10-23
状态：离线
发送短消息息给snisn

加好友发送短消息息给snisn

发消息

发表于：

2014-12-26 14:28:40 | [全部帖] [楼主帖]

楼主

异常信息如下：

14/08/17 17:58:53 WARN zookeeper.ClientCnxn: Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:712)
at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081)
14/08/17 17:58:54 INFO zookeeper.ClientCnxn: Opening socket connection to server BladeStone-Laptop/192.168.1.107:2181. Will not attempt to authenticate using SASL (unknown error)
14/08/17 17:58:54 WARN zookeeper.ClientCnxn: Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:712)
at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081)
14/08/17 17:58:54 WARN zookeeper.RecoverableZooKeeper: Possibly transient ZooKeeper, quorum=hadoop1-1:2181,BladeStone-Laptop:2181,hadoop1-2:2181, exception=org.apache.zookeeper.KeeperException$ConnectionLossException: KeeperErrorCode = ConnectionLoss for /hbase/hbaseid
14/08/17 17:58:54 INFO zookeeper.ClientCnxn: Opening socket connection to server hadoop1-2/192.168.1.111:2181. Will not attempt to authenticate using SASL (unknown error)
14/08/17 17:58:54 INFO util.RetryCounter: Sleeping 2000ms before retry #1...
14/08/17 17:58:54 WARN zookeeper.ClientCnxn: Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:712)
at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081)
14/08/17 17:58:54 INFO zookeeper.ClientCnxn: Opening socket connection to server hadoop1-1/192.168.1.104:2181. Will not attempt to authenticate using SASL (unknown error)
14/08/17 17:58:54 WARN zookeeper.ClientCnxn: Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:712)
at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361)
at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081)

经过初步判断为ＺｏｏＫｅｅｐｅｒ的启动问题，但是仔细分析之后，发现ZooKeeper本身没有问题，应该是启动过程中，某些信息连接不上。
故此进行分析，发现某个节点的IP地址和hostname拼写不正确。
修改这个问题之后，问题解决。

--转自