sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pratik khadloya <tispra...@gmail.com>
Subject Re: Hive import stuck
Date Thu, 11 Sep 2014 19:26:46 GMT
I got some clue here, seems like the derby database is either read only or
the user that i am using is read only.
Got to know this from the hive query logs.

$ tail -f  /srv/logs/hive/query_logs/<myuser>/hive.log
2014-09-11 15:21:30,664 WARN  [main]: common.LogUtils
(LogUtils.java:logConfigLocation(145)) - hive-site.xml not found on
CLASSPATH
2014-09-11 15:21:30,796 INFO  [main]: SessionState
(SessionState.java:printInfo(543)) -
Logging initialized using configuration in
jar:file:/usr/lib/hive/lib/hive-common-0.13.1.jar!/hive-log4j.properties
2014-09-11 15:21:31,014 INFO  [main]: metastore.HiveMetaStore
(HiveMetaStore.java:newRawStore(496)) - 0: Opening raw store with
implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
2014-09-11 15:21:31,050 INFO  [main]: metastore.ObjectStore
(ObjectStore.java:initialize(246)) - ObjectStore, initialize called
2014-09-11 15:21:32,216 ERROR [BoneCP-pool-watch-thread]:
bonecp.PoolWatchThread (PoolWatchThread.java:fillConnections(118)) - Error
in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: *A read-only user or a user in a read-only database
is not permitted to disable read-only mode on a connection.*
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.EmbedConnection.setReadOnly(Unknown Source)
at
com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
at
com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only
database is not permitted to disable read-only mode on a connection.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
... 13 more
Caused by: ERROR 25505: A read-only user or a user in a read-only database
is not permitted to disable read-only mode on a connection.
at org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)
at
org.apache.derby.impl.sql.conn.GenericAuthorizer.setReadOnlyConnection(Unknown
Source)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.setReadOnly(Unknown
Source)
... 8 more

On Wed, Sep 10, 2014 at 6:17 PM, pratik khadloya <tispratik@gmail.com>
wrote:

> Hello,
>
> My hive table import is getting stuck after the line which prints the
> derby database classpath.
> Am not sure what is missing here. Can anyone please give me some pointers.
>
> 4/09/10 21:11:52 INFO hive.HiveImport: Logging initialized using
> configuration in
> jar:file:/usr/lib/hive/lib/hive-common-0.13.1.jar!/hive-log4j.properties
> 14/09/10 21:11:53 INFO hive.HiveImport: Wed Sep 10 21:11:53 EDT 2014
> Thread[main,5,main] java.io.FileNotFoundException: derby.log (Permission
> denied)
> 14/09/10 21:11:53 INFO hive.HiveImport:
> ----------------------------------------------------------------
> 14/09/10 21:11:53 INFO hive.HiveImport: Wed Sep 10 21:11:53 EDT 2014:
> 14/09/10 21:11:53 INFO hive.HiveImport: Booting Derby (version The Apache
> Software Foundation - Apache Derby - 10.10.1.1 - (1458268)) instance
> a816c00e-0148-6244-425a-000001726a08
> 14/09/10 21:11:53 INFO hive.HiveImport: on database directory
> /home/pkhadloya/sqoop-2e1e094/metastore_db in READ ONLY mode with class
> loader sun.misc.Launcher$AppClassLoader@77cde100.
> 14/09/10 21:11:53 INFO hive.HiveImport: Loaded from
> file:/usr/lib/hive/lib/derby-10.10.1.1.jar.
> 14/09/10 21:11:53 INFO hive.HiveImport: java.vendor=Sun Microsystems Inc.
> 14/09/10 21:11:53 INFO hive.HiveImport: java.runtime.version=1.6.0_16-b01
> 14/09/10 21:11:53 INFO hive.HiveImport:
> user.dir=/home/pkhadloya/sqoop-2e1e094
> 14/09/10 21:11:53 INFO hive.HiveImport: os.name=Linux
> 14/09/10 21:11:53 INFO hive.HiveImport: os.arch=amd64
> 14/09/10 21:11:53 INFO hive.HiveImport:
> os.version=2.6.32-279.22.1.el6.x86_64
> 14/09/10 21:11:53 INFO hive.HiveImport: derby.system.home=null
> 14/09/10 21:11:54 INFO hive.HiveImport: Database Class Loader started -
> derby.database.classpath=''
>
>
> Thanks,
> Pratik
>

Mime
View raw message