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
-
Re: Hive server not starting...on EC2 Ubuntu 10.04 instance
Hi Vivek,
   Tried doing with sudo and later also changed the permissions. None of
them worked.

root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# ls -l
total 4
drwxr-xr-x 5 root root 4096 2011-12-18 03:19 metastore_db
root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# chmod 777 metastore_db/
root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# ls -l
total 4
drwxrwxrwx 5 root root 4096 2011-12-18 03:19 metastore_db
root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore#

root@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore# hive --service
hiveserver
Starting Hive Thrift Server
^Croot@domU-12-31-39-0E-C9-33:/var/lib/hive/metastore#
-PD

On Sun, Dec 18, 2011 at 4:34 AM, Vivek Mishra <[EMAIL PROTECTED]>wrote:

> try issuing with "sudo".  as metastore_db is locked for root user.
> else do sudo chmod 777 <metastore_db> folder.
>
>
> Vivek
> ________________________________________
> From: Periya.Data [[EMAIL PROTECTED]]
> Sent: 18 December 2011 10:29
> To: [EMAIL PROTECTED]
> Subject: 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