Getting weird exception while running sqoop jobs

[sh...@accenture.com]

Hi,

While running sqoop jobs, I am getting a weird error

Caused by: java.sql.SQLException: File input/output error: /home/ucp_intg_user/.sqoop/metastore.db.script.new

Strange fact, is , for some sql server tables , sqoop connects just fine and extracts data. For some tables, its giving the above error.

I had concluded that it's a connection issue on the sql server. But the DB guy for that database said, they did not encounter any connection error in the logs.

What could be the error. Any help is highly appreciated.

The metastore is a private one and not a shared one.


Thanks,
Shouvanik


-----Original Message-----
From: Jarek Jarcec Cecho [mailto:jarcec@apache.org]
Sent: Tuesday, March 25, 2014 8:23 AM
To: user@sqoop.apache.org
Subject: Re: Sqoop version for hadoop-1.2.1

Hi Chandra,
for Hadoop 1.2.1 you should use archive sqoop-1.4.4.bin__hadoop-1.0.0.tar.gz.

Would you mind re-downloading the archive, running Sqoop and sharing entire output generated with parameter --verbose?

Jarcec

On Tue, Mar 25, 2014 at 07:39:55PM +0530, chandra kant wrote:
> Hi,
> I am using hadoop--1.2.1 . I tried sqoop-1.4.4.bin__hadoop-1.0.0  ,
> sqoop-1.4.4.bin__hadoop-0.23 , sqoop-1.4.4.bin__hadoop-0.20  for
> importing mysql database, but none of them worked.
> It shows error - "Exception in thread "main"
> java.lang.IncompatibleClassChangeError: Found class
> org.apache.hadoop.mapreduce.JobContext, but interface was expected"
> ,which I read is a version mismatching issue.
> Can you pls suggest which sqoop version to use for hadoop-1.2.1?
>
> --
> Chandra kant

________________________________

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com

Re: Getting weird exception while running sqoop jobs

[Jarek Jarcec Cecho <ja...@apache.org>]

Hi Shouvanik,
please do start a new email thread when you have a new question or if you are facing different issue.

Would you mind sharing entire Sqoop log generated with parameter --verbose and the version that you're using?

Jarcec

On Wed, Mar 26, 2014 at 10:29:33PM +0000, shouvanik.haldar@accenture.com wrote:
> Hi,
> 
> While running sqoop jobs, I am getting a weird error
> 
> Caused by: java.sql.SQLException: File input/output error: /home/ucp_intg_user/.sqoop/metastore.db.script.new
> 
> Strange fact, is , for some sql server tables , sqoop connects just fine and extracts data. For some tables, its giving the above error.
> 
> I had concluded that it's a connection issue on the sql server. But the DB guy for that database said, they did not encounter any connection error in the logs.
> 
> What could be the error. Any help is highly appreciated.
> 
> The metastore is a private one and not a shared one.
> 
> 
> Thanks,
> Shouvanik
> 
> 
> -----Original Message-----
> From: Jarek Jarcec Cecho [mailto:jarcec@apache.org]
> Sent: Tuesday, March 25, 2014 8:23 AM
> To: user@sqoop.apache.org
> Subject: Re: Sqoop version for hadoop-1.2.1
> 
> Hi Chandra,
> for Hadoop 1.2.1 you should use archive sqoop-1.4.4.bin__hadoop-1.0.0.tar.gz.
> 
> Would you mind re-downloading the archive, running Sqoop and sharing entire output generated with parameter --verbose?
> 
> Jarcec
> 
> On Tue, Mar 25, 2014 at 07:39:55PM +0530, chandra kant wrote:
> > Hi,
> > I am using hadoop--1.2.1 . I tried sqoop-1.4.4.bin__hadoop-1.0.0  ,
> > sqoop-1.4.4.bin__hadoop-0.23 , sqoop-1.4.4.bin__hadoop-0.20  for
> > importing mysql database, but none of them worked.
> > It shows error - "Exception in thread "main"
> > java.lang.IncompatibleClassChangeError: Found class
> > org.apache.hadoop.mapreduce.JobContext, but interface was expected"
> > ,which I read is a version mismatching issue.
> > Can you pls suggest which sqoop version to use for hadoop-1.2.1?
> >
> > --
> > Chandra kant
> 
> ________________________________
> 
> This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
> ______________________________________________________________________________________
> 
> www.accenture.com
>