You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-user@hadoop.apache.org by 丙子 <wo...@gmail.com> on 2013/05/10 03:32:02 UTC

Fwd: hadoop map-reduce errors

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 .

Re: hadoop map-reduce errors

Posted by shashwat shriparv <dw...@gmail.com>.
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 <sh...@gmail.com>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, 丙子 <wo...@gmail.com> 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 .
>>
>>
>

Re: hadoop map-reduce errors

Posted by shashwat shriparv <dw...@gmail.com>.
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 <sh...@gmail.com>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, 丙子 <wo...@gmail.com> 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 .
>>
>>
>

Re: hadoop map-reduce errors

Posted by shashwat shriparv <dw...@gmail.com>.
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 <sh...@gmail.com>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, 丙子 <wo...@gmail.com> 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 .
>>
>>
>

Re: hadoop map-reduce errors

Posted by shashwat shriparv <dw...@gmail.com>.
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 <sh...@gmail.com>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, 丙子 <wo...@gmail.com> 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 .
>>
>>
>

Re: hadoop map-reduce errors

Posted by Shahab Yunus <sh...@gmail.com>.
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, 丙子 <wo...@gmail.com> 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 .
>
>

Re: hadoop map-reduce errors

Posted by Shahab Yunus <sh...@gmail.com>.
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, 丙子 <wo...@gmail.com> 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 .
>
>

Re: hadoop map-reduce errors

Posted by Shahab Yunus <sh...@gmail.com>.
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, 丙子 <wo...@gmail.com> 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 .
>
>

Re: hadoop map-reduce errors

Posted by Shahab Yunus <sh...@gmail.com>.
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, 丙子 <wo...@gmail.com> 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 .
>
>