sqoop server didnt start.
2015-07-13 14:23:44,524 INFO derby.DerbyRepositoryHandler
[org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:196)]
Can't fetch repository structure version.
org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from
pool failed
at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:113)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at
org.apache.sqoop.repository.derby.DerbyRepositoryHandler.detectRepositoryVersion(DerbyRepositoryHandler.java:185)
at
org.apache.sqoop.repository.derby.DerbyRepositoryHandler.createOrUpgradeRepository(DerbyRepositoryHandler.java:209)
at
org.apache.sqoop.repository.JdbcRepository$1.doIt(JdbcRepository.java:133)
at
org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:92)
at
org.apache.sqoop.repository.JdbcRepository.doWithConnection(JdbcRepository.java:63)
at
org.apache.sqoop.repository.JdbcRepository.createOrUpgradeRepository(JdbcRepository.java:129)
at
org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:123)
at
org.apache.sqoop.repository.RepositoryManager.initialize(RepositoryManager.java:77)
at org.apache.sqoop.core.SqoopServer.initialize(SqoopServer.java:56)
at
org.apache.sqoop.server.ServerInitializer.contextInitialized(ServerInitializer.java:41)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206)
Caused by: java.sql.SQLSyntaxErrorException: Table/View 'SQOOP.SQ_SYSTEM'
does not exist.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:285)
at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(GenericKeyedObjectPool.java:1179)
at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection.java:107)
On Mon, Jul 13, 2015 at 1:08 PM, Zhou, Richard <[email protected]>
wrote:
> Would you attach the log? Have you checked whether the Sqoop server
> works fine? Use “ps aux | grep sqoop” and “netstat –anp | grep 12000”.
>
>
>
>
>
> Regards
>
> Richard
>
>
>
> *From:* Lee S [mailto:[email protected]]
> *Sent:* Monday, July 13, 2015 12:33 PM
> *To:* [email protected]
> *Subject:* sqoop install : unable t load native sqoop library for your
> platform
>
>
>
> Hi all , I try to start sqoop sever and encounter the error below.
>
>
>
> And I checked the hadoop config in catalina.properties, that's
>
>
>
> all right. Can anybody help？
>
>
>
>
>
>
>
> sqoop:000> set server -host your.host.com -port 12000 -webapp sqoop
>
> Server is set successfully
>
> sqoop:000> show version -all
>
> client version:
>
> Sqoop 1.99.6 source revision 07244c3915975f26f03d9e1edf09ab7d06619bb8
>
> Compiled by root on Wed Apr 29 10:40:43 CST 2015
>
> 0 [main] WARN org.apache.hadoop.util.NativeCodeLoader - Unable to
> load native-hadoop library for your platform... using builtin-java classes
> where applicable
>
> Exception has occurred during processing command
>
> Exception: org.apache.sqoop.common.SqoopException Message: CLIENT_0000:An
> unknown error has occurred
>
