Re: sqoop install : unable t load native sqoop library for your platform

[Lee S]

conf and derbyrepo.log.
what's derby's effect in the project?

On Mon, Jul 13, 2015 at 3:21 PM, Zhou, Richard <richard.z...@intel.com>
wrote:

>  Would you share your catalina.properties and sqoop.properties?
>
>
>
>
>
> Regards
>
> Richard
>
>
>
> *From:* Lee S [mailto:sle...@gmail.com]
> *Sent:* Monday, July 13, 2015 2:30 PM
> *To:* user@sqoop.apache.org
> *Subject:* Re: sqoop install : unable t load native sqoop library for
> your platform
>
>
>
> Log as attachment. And I ran sqoop2-tool verify with same error.
>
>
>
> On Mon, Jul 13, 2015 at 2:23 PM, Lee S <sle...@gmail.com> wrote:
>
> 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 <richard.z...@intel.com>
> 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:sle...@gmail.com]
> *Sent:* Monday, July 13, 2015 12:33 PM
> *To:* user@sqoop.apache.org
> *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
>
>
>
>
>

catalina.properties
Description: Binary data

sqoop.properties
Description: Binary data

derbyrepo.log
Description: Binary data