sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "arvind@cloudera.com" <arv...@cloudera.com>
Subject Re: [sqoop-user] Sqoop import failed ( connection refused )
Date Fri, 09 Sep 2011 00:49:38 GMT
[Moving conversation to sqoop-user@incubator.apache.org. Please
subscribe there.]

It appears that the map task run by Sqoop cannot establish a JDBC
connection with the database. Check to make sure that your connect
string is correct and that there is no firewall blocking access to the
database machine. It may be worth while to write a short JDBC program
and run it from one of the node machines to make sure that you can
connect correctly.

Thanks,
Arvind


On Thu, Sep 1, 2011 at 10:39 PM, amit kumar <amitkr.cstech@gmail.com> wrote:
> while running an import , i m not able to get connected to mysql
> database. Communication link failure is shooted .
> I m able to connect to mysql via a java program . Problem
> description :
>
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
> Communications link failure
> The last packet sent successfully to the server was 0 milliseconds
> ago. The driver has not received any packets from the server.
>        at
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>        at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:
> 39)
>        at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:
> 27)
>        at java.lang.reflect.Constructor.newInstance(Constructor.java:
> 513)
>        ............
> Caused by: java.net.ConnectException: Connection refused
>        at java.net.PlainSocketImpl.socketConnect(Native Method)
>        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:
> 351)
>        at
> java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
>        ...........
> 11/09/02 12:08:38 INFO mapred.JobClient: Job complete:
> job_201108301643_0036
> 11/09/02 12:08:38 INFO mapred.JobClient: Counters: 6
> 11/09/02 12:08:38 INFO mapred.JobClient:   Job Counters
> 11/09/02 12:08:38 INFO mapred.JobClient:     SLOTS_MILLIS_MAPS=23440
> 11/09/02 12:08:38 INFO mapred.JobClient:     Total time spent by all
> reduces waiting after reserving slots (ms)=0
> 11/09/02 12:08:38 INFO mapred.JobClient:     Total time spent by all
> maps waiting after reserving slots (ms)=0
> 11/09/02 12:08:38 INFO mapred.JobClient:     Launched map tasks=4
> 11/09/02 12:08:38 INFO mapred.JobClient:     SLOTS_MILLIS_REDUCES=0
> 11/09/02 12:08:38 INFO mapred.JobClient:     Failed map tasks=1
> 11/09/02 12:08:38 INFO mapreduce.ImportJobBase: Transferred 0 bytes in
> 34.6672 seconds (0 bytes/sec)
> 11/09/02 12:08:38 INFO mapreduce.ImportJobBase: Retrieved 0 records.
> 11/09/02 12:08:38 ERROR tool.ImportTool: Error during import: Import
> job failed
>
>
>
>
>
> --
> NOTE: The mailing list sqoop-user@cloudera.org is deprecated in favor of Apache Sqoop
mailing list sqoop-user@incubator.apache.org. Please subscribe to it by sending an email to
incubator-sqoop-user-subscribe@apache.org.
>

Mime
View raw message