Support Questions
Find answers, ask questions, and share your expertise

Not able to connect to sqoop after system crash/reboot

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