Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
Received-SPF: pass (nike.apache.org: domain of shahab.yunus@gmail.com
 designates 209.85.214.41 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAJ1U_2hpjoeBwa+71W0drr4Mw5ydX+SE+2qWJbs8ipPKX-x1tQ@mail.gmail.com>
References: 
 <CAJ1U_2jmQcjQ0UHQUYKFchht-bGBjXtPUkEjgooYkH7NT7hRGw@mail.gmail.com>
	<CAJ1U_2hpjoeBwa+71W0drr4Mw5ydX+SE+2qWJbs8ipPKX-x1tQ@mail.gmail.com>
Date: Fri, 10 May 2013 08:42:56 -0400
Message-ID: 
 <CAEo-6+RJ5JmLoFN8FYFzUMBm82vy6jAfE24+7kZpAg8zTY47jQ@mail.gmail.com>
Subject: Re: hadoop map-reduce errors
From: Shahab Yunus <shahab.yunus@gmail.com>
To: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=bcaec51a70f69ecacd04dc5c8152

--bcaec51a70f69ecacd04dc5c8152
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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, =E4=B8=99=E5=AD=90 <woyaofala@gmail.com> wr=
ote:

> 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)
>
> =E2=80=A6=E2=80=A6
> =E2=80=A6=E2=80=A6
>         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 .
>
>

--bcaec51a70f69ecacd04dc5c8152
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Have your checked your connection settings to the MySQL DB=
? Where and how are you passing the connection=C2=A0properties=C2=A0for the=
 database? Is it accessible from the machine you are running this? Is the d=
b up?</div>
<div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">On Thu, May 9=
, 2013 at 9:32 PM, =E4=B8=99=E5=AD=90 <span dir=3D"ltr">&lt;<a href=3D"mail=
to:woyaofala@gmail.com" target=3D"_blank">woyaofala@gmail.com</a>&gt;</span=
> wrote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bo=
rder-left:1px #ccc solid;padding-left:1ex">
<div dir=3D"ltr"><span style=3D"font-family:arial,sans-serif;font-size:14px=
">When i =C2=A0run a hadoop job ,there are some errors like this:</span><br=
><div class=3D"gmail_quote"><div dir=3D"ltr"><div style=3D"font-family:aria=
l,sans-serif;font-size:14px">

<div>13/05/10 08:20:59 ERROR manager.SqlManager: Error executing statement:=
 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications li=
nk failure</div>
<div><br></div><div>The last packet successfully received from the server w=
as 28,484 milliseconds ago. =C2=A0The last packet sent successfully to the =
server was 1 milliseconds ago.</div><div>com.mysql.jdbc.exceptions.jdbc4.Co=
mmunicationsException: Communications link failure</div>


<div><br></div><div>The last packet successfully received from the server w=
as 28,484 milliseconds ago. =C2=A0The last packet sent successfully to the =
server was 1 milliseconds ago.</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun=
.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)</div>


</div><div style=3D"font-family:arial,sans-serif;font-size:14px"><br></div>=
<div style=3D"font-family:arial,sans-serif;font-size:14px">=E2=80=A6=E2=80=
=A6</div><div style=3D"font-family:arial,sans-serif;font-size:14px">=E2=80=
=A6=E2=80=A6</div><div style=3D"font-family:arial,sans-serif;font-size:14px=
">


<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.sqoop.Sqoop.main(Sqoop.java:=
238)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.cloudera.sqoop.Sqoop.main=
(Sqoop.java:57)</div><div>Caused by: java.io.EOFException: Can not read res=
ponse from server. Expected to read 4 bytes, read 0 bytes before connection=
 was unexpectedly lost.</div>


<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.MysqlIO.readFully(MysqlI=
O.java:3039)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 at com.mysql.jdbc.MysqlI=
O.reuseAndReadPacket(MysqlIO.java:3489)</div><div>=C2=A0 =C2=A0 =C2=A0 =C2=
=A0 ... 24 more</div><div><br></div><div><br></div><div>


How =C2=A0can i resolve it .</div></div></div>
</div><br></div>
</blockquote></div><br></div>

--bcaec51a70f69ecacd04dc5c8152--