mysql - Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile -


i have replaced sqoop metatsore mysql db.

when try run saved sqoop job command line, "asks" me password , run job when supply it.

however, need run job through oozie.

--password not recognized valid argument here in command line while executing sqoop saved job , anyway, keeps asking password through prompt.

now, when try run through oozie,

i get

caused by: java.sql.sqlexception: database in use   process: org.hsqldb.persist.niolockfile@950abfc6[file   =/home/yarn/.sqoop/metastore.db.lck, exists=false, locked=false,    valid=false, fl =null]: java.io.filenotfoundexception:   /home/yarn/.sqoop/metastore.db.lck (no such file or directory) 

what , why this? directly connecting mysql metatsore , have configured sqoop-site.xml accordingly.

why trying to connect hsqldb?

why locked?

how fix this?

also, how supply password execution of sqoop job in oozie?


Comments

Popular posts from this blog

wireshark - USB mapping with python -

c++ - nodejs socket.io closes connection before upgrading to websocket -

Deploying Qt Application on Android is really slow? -