Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Not able to connect to sqoop after system crash/reboot

Highlighted

Not able to connect to sqoop after system crash/reboot

Explorer

Hi

 

We didnot stop the sqoop-metastore server on the node before a reboot and now not able to connect to the sqoop

 

Getting below error when trying to look at the list of sqoop jobs


17/08/15 17:01:48 ERROR tool.JobTool: I/O error performing job operation: java.io.IOException: Exception creating SQL connection
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:216)
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.open(HsqldbJobStorage.java:161)
at org.apache.sqoop.tool.JobTool.run(JobTool.java:259)
at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
at org.apache.sqoop.Sqoop.main(Sqoop.java:236)
Caused by: java.sql.SQLException: socket creation error
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:233)
at org.apache.sqoop.metastore.hsqldb.HsqldbJobStorage.init(HsqldbJobStorage.java:174)
... 8 more

 

 

I tried to start the metastore server by the below command

/usr/bin/sqoop-metastore start

 

But when I run this command and try to look at the jobs I am getting the same error.

And in .sqoop/ folder the below 2 files are created.

 

cat shared-metastore.db.log
CREATE USER SA PASSWORD "" ADMIN

 

cat shared-metastore.db.properties
#HSQL Database Engine 1.8.0.10
#Tue Aug 15 17:00:28 CDT 2017
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=false
hsqldb.cache_size_scale=8
readonly=false
hsqldb.nio_data_file=true
hsqldb.cache_scale=14
version=1.8.0
hsqldb.default_table_type=memory
hsqldb.cache_file_scale=1
hsqldb.log_size=200
modified=yes
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0

 

I see that in /tmp/ folder I couldnt find the /sqoop-metastore/shared.db folders  (default path for metastore files)

 

Can anyone know the steps to follow to connect to the sqoop metastore?

 

Thanks

 

Don't have an account?
Coming from Hortonworks? Activate your account here