Your connection setting to Mysql may not be correct check that. *Thanks & Regards *
∞ Shashwat Shriparv On Fri, May 10, 2013 at 6:12 PM, Shahab Yunus <[email protected]>wrote: > Have your checked your connection settings to the MySQL DB? Where and how > are you passing the connection properties for the database? Is it > accessible from the machine you are running this? Is the db up? > > > On Thu, May 9, 2013 at 9:32 PM, 丙子 <[email protected]> wrote: > >> When i run a hadoop job ,there are some errors like this: >> 13/05/10 08:20:59 ERROR manager.SqlManager: Error executing statement: >> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications >> link failure >> >> The last packet successfully received from the server was 28,484 >> milliseconds ago. The last packet sent successfully to the server was 1 >> milliseconds ago. >> com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications >> link failure >> >> The last packet successfully received from the server was 28,484 >> milliseconds ago. The last packet sent successfully to the server was 1 >> milliseconds ago. >> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native >> Method) >> >> …… >> …… >> at org.apache.sqoop.Sqoop.main(Sqoop.java:238) >> at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57) >> Caused by: java.io.EOFException: Can not read response from server. >> Expected to read 4 bytes, read 0 bytes before connection was unexpectedly >> lost. >> at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3039) >> at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489) >> ... 24 more >> >> >> How can i resolve it . >> >> >
