Execute below property on hive prompt set hive.support.concurrency=false; and then try running your query, it should work. Let me know if it won't.
On Thu, May 7, 2015 at 8:29 PM, Grant Overby (groverby) <[email protected]> wrote: > My environment has HDP 2.2 installed without hive. Hive 1.1 is installed > independently of HDP. This is a new setup. > > I can get a hive cli prompt, but when I run ‘show databases;’ I get > ‘FAILED: LockException [Error 10280]: Error communicating with the > metastore’. The metastore is running. If I stop the metastore, then the cli > crashes before giving a prompt, so I believe that cli to metastore > communication is happening to some extent. > > The metastore is using MySQL. hive.in.test is set to true to cause hive > to create the mysql schema. > > Thoughts on how to address this? > > These stack traces repeat in the hive.log: > > 2015-05-07 10:39:25,202 ERROR [pool-3-thread-25]: > server.TThreadPoolServer (TThreadPoolServer.java:run(296)) - Error occurred > during processing of message. > > java.lang.RuntimeException: Unable to set up transaction database for > testing: Can't call rollback when autocommit=true > > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.checkQFileTestHack(TxnHandler.java:1147) > > at > org.apache.hadoop.hive.metastore.txn.TxnHandler.<init>(TxnHandler.java:117) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getTxnHandler(HiveMetaStore.java:568) > > at > org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_open_txns(HiveMetaStore.java:5382) > > at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:102) > > at com.sun.proxy.$Proxy1.get_open_txns(Unknown Source) > > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_open_txns.getResult(ThriftHiveMetastore.java:11227) > > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_open_txns.getResult(ThriftHiveMetastore.java:11212) > > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > > at > org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:110) > > at > org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:106) > > at java.security.AccessController.doPrivileged(Native Method) > > at javax.security.auth.Subject.doAs(Subject.java:415) > > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628) > > at > org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:118) > > at > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > at java.lang.Thread.run(Thread.java:745) > > 2015-05-07 10:39:25,240 ERROR [main]: ql.Driver > (SessionState.java:printError(861)) - FAILED: LockException [Error 10280]: > Error communicating with the metastore > > org.apache.hadoop.hive.ql.lockmgr.LockException: Error communicating with > the metastore > > at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.getValidTxns(DbTxnManager.java:300) > > at org.apache.hadoop.hive.ql.Driver.recordValidTxns(Driver.java:927) > > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:403) > > at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:307) > > at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:1112) > > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1160) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1049) > > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1039) > > at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:207) > > at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:159) > > at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:370) > > at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:754) > > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:675) > > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:615) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at org.apache.hadoop.util.RunJar.run(RunJar.java:221) > > at org.apache.hadoop.util.RunJar.main(RunJar.java:136) > > Caused by: org.apache.thrift.transport.TTransportException > > at > org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) > > at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) > > at > org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429) > > at > org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:318) > > at > org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:219) > > at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69) > > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_open_txns(ThriftHiveMetastore.java:3705) > > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_open_txns(ThriftHiveMetastore.java:3693) > > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getValidTxns(HiveMetaStoreClient.java:1755) > > at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at > org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:91) > > at com.sun.proxy.$Proxy5.getValidTxns(Unknown Source) > > at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.getValidTxns(DbTxnManager.java:298) > > ... 19 more > > > > > *Grant Overby* > Software Engineer > Cisco.com <http://www.cisco.com/> > [email protected] > Mobile: *865 724 4910 <865%20724%204910>* > > > > Think before you print. > > This email may contain confidential and privileged material for the sole > use of the intended recipient. Any review, use, distribution or disclosure > by others is strictly prohibited. If you are not the intended recipient (or > authorized to receive for the recipient), please contact the sender by > reply email and delete all copies of this message. > > Please click here > <http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for > Company Registration Information. > > > >
