sqoop deadlock on basic job / stuck on booting

mmgraph — Fri, 16 Sep 2022 10:52:11 GMT

Hi,

I'm trying to do a basic job in sqoop using sqoop-import to a sybase db

sqoop import --connect jdbc:sybase:Tds:syserver:5000/mydb?ServiceName=master --username user --password password --driver com.sybase.jdbc4.jdbc.SybDriver --query "SELECT * FROM point_vente WHERE \$CONDITIONS" --split-by id --target-dir /user/sybase/test.csv

I've correctly added the JAR file required for sybase and I'm able to use:

sqoop list-tables
sqoop list-databases
and I can use the same query above with sqoop eval and have correct results.

BUT when launched the above job, it stucks, the jobs is blocked on booting. I only have this for debugging the deadlock:

2016-12-23 13:21:08,222 DEBUG driver.JobManager [org.apache.sqoop.driver.JobManager$UpdateThread.run(JobManager.java:671)] Updating running submissions
2016-12-23 13:21:08,223 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.begin(JdbcRepositoryTransaction.java:74)] Tx count-begin: 1, rollback: false
2016-12-23 13:21:08,223 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.commit(JdbcRepositoryTransaction.java:85)] Tx count-commit: 1, rollback: false
2016-12-23 13:21:08,223 DEBUG repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:104)] Tx count-close: 0, rollback: false
2016-12-23 13:21:08,224 INFO  repository.JdbcRepositoryTransaction [org.apache.sqoop.repository.JdbcRepositoryTransaction.close(JdbcRepositoryTransaction.java:112)] Attempting transaction commit

I've tried with sqoop2 using hue, same problem.

Note : I'm running on the cloudera quickstart docker

Re: sqoop deadlock on basic job / stuck on booting

mmgraph — Fri, 20 Jan 2017 15:59:14 GMT

The problem was solved by re-adding the jar file (maybe corrupted jars) and restart the cluster

question Re: sqoop deadlock on basic job / stuck on booting in Archives of Support Questions (Read Only)

sqoop deadlock on basic job / stuck on booting

Re: sqoop deadlock on basic job / stuck on booting