Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive server not starting...on EC2 Ubuntu 10.04 instance


Copy link to this message
-
Hive server not starting...on EC2 Ubuntu 10.04 instance
Hi all,
    I am trying to start hive server, but, after the command, it looks like
nothing is happening. I am not even getting a prompt. Here are some details:

- machine - EC2 Ubuntu 10.04 LTS
- Hive version - 0.7.1-cdh3u2  (as seen from hive-default.xml)
- Hadoop version - 0.20.2
- I currently have an embedded Derby database as my metastore.
(Plan to move it to a remote MySQL DB later. For now, i am the only user).

root@domU-12-31-39-0E-C9-33:/usr/lib/hive/conf# hive --service hiveserver
Starting Hive Thrift Server

<it just hangs here...nothing happens for 10 min..had to Ctrl-c to get out.>
Looks like to it is unable to talk to the metastore. I am able to run hive
shell, create, drop tables and run queries from the shell.
-----------

I did the following:
- # HIVE_PORT=10000 hive --service hiveserver   (same problem)
- Tried changing ports, but, same problem.
Log File (/tmp/<user>/hive.log)

org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Could not create a validated object, cause: 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.hadoop.hive.ql.metadata.Hive.getDatabase(Hive.java:1028)
    at
org.apache.hadoop.hive.ql.metadata.Hive.databaseExists(Hive.java:1013)
    at org.apache.hadoop.hive.ql.exec.DDLTask.showTables(DDLTask.java:1712)
    at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:289)
    at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130)
    at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
    at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063)
    at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900)
    at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748)
    at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:209)
    at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:286)
    at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:485)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.hadoop.util.RunJar.main(RunJar.java:186)
Caused by: javax.jdo.JDOFatalDataStoreException: Cannot get a connection,
pool error Could not create a validated object, cause: A read-only
 user or a user in a read-only database is not permitted to disable
read-only mode on a connection.
NestedThrowables:
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Could not create a validated object, cause: 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.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:298)
    at
org.datanucleus.jdo.JDOPersistenceManagerFactory.freezeConfiguration(JDOPersistenceManagerFactory.java:601)
    at
org.datanucleus.jdo.JDOPersistenceManagerFactory.createPersistenceManagerFactory(JDOPersistenceManagerFactory.java:286)
    at
org.datanucleus.jdo.JDOPersistenceManagerFactory.getPersistenceManagerFactory(JDOPersistenceManagerFactory.java:182)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at javax.jdo.JDOHelper$16.run(JDOHelper.java:1958)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.jdo.JDOHelper.invoke(JDOHelper.java:1953)
    at
javax.jdo.JDOHelper.invokeGetPersistenceManagerFactoryOnImplementation(JDOHelper.java:1159)
    at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:803)
    at javax.jdo.JDOHelper.getPersistenceManagerFactory(JDOHelper.java:698)
    at
org.apache.hadoop.hive.metastore.ObjectStore.getPMF(ObjectStore.java:234)
    at
org.apache.hadoop.hive.metastore.ObjectStore.getPersistenceManager(ObjectStore.java:261)
    ............
What could be going wrong? Am I missing something?

Thanks,
PD.