Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Periya.Data 2011-12-18, 04:59
+
Vivek Mishra 2011-12-18, 12:34
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
+
Jasper Knulst 2011-12-18, 17:32
+
Vivek Mishra 2011-12-18, 18:59
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB