Hi yogendra, You need to check if space is available on you backend metadata db server like mysql or oracle server.
It might be possible the your queries are getting stuck becoz there is no enough space for mysql logging. Thanks Vikas Srivastava On Dec 4, 2014 7:59 AM, "Yogendra reddy" <yogendra...@gmail.com> wrote: > Thanks Alan, I'm able to see TXNS table and yes I have upgraded from 0.13 > to 0.14. > > any idea as to wht else might cause this issue? > > Thanks, > Yogendra > ------------------------------ > From: Alan Gates <ga...@hortonworks.com> > Sent: 12/3/2014 9:51 AM > To: user@hive.apache.org > Subject: Re: hive transactions > > Usually this means the metastore database was not properly upgraded. You > can check this by logging into your RDBMS and listing all the tables. If > you see a table named TXNS then the proper tables exist. > > Did you install Hive 0.14 fresh or upgrade from a previous version? If > you upgraded did you run the upgrade scripts? In the Hive 0.12 to Hive > 0.13 upgrade script it calls hive-txn-schema-0.13.0.mysql.sql, which will > create these tables. If you're upgrading from 13 to 14 there shouldn't be > a need to create the tables. > > Alan. > > yogendra reddy <yogendra...@gmail.com> > November 30, 2014 at 21:19 > Hi All, > > I'm caught up with the error pasted below after trying to use hive > transaction feature.I have followed this wiki to set required > configuration. > https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions#HiveTransactions-Configuration > > > set hive.support.concurrency=true; > set hive.exec.dynamic.partition.mode=nonstrict; > set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; > set hive.compactor.initiator.on=true; > set hive.compactor.worker.threads=1; > > After setting the above I just ran this command "describe formatted > acidtest;" > any pointers as to why this occurs? > > FAILED: Error in acquiring locks: Error communicating with the metastore > 14/12/01 05:02:05 ERROR ql.Driver: FAILED: Error in acquiring locks: Error > communicating with the metastore > org.apache.hadoop.hive.ql.lockmgr.LockException: Error communicating with > the metastore > at > org.apache.hadoop.hive.ql.lockmgr.DbLockManager.lock(DbLockManager.java:101) > at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.acquireLocks(DbTxnManager.java:202) > at > org.apache.hadoop.hive.ql.Driver.acquireLocksAndOpenTxn(Driver.java:939) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1166) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1004) > at org.apache.hadoop.hive.ql.Driver.run(Driver.java:994) > at > org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:247) > at > org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:199) > at > org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:410) > at > org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:783) > at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:677) > at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:616) > 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.TApplicationException: Internal error > processing lock > at > org.apache.thrift.TApplicationException.read(TApplicationException.java:108) > at > org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_lock(ThriftHiveMetastore.java:3781) > at > org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.lock(ThriftHiveMetastore.java:3768) > at > org.apache.hadoop.hive.metastore.HiveMetaStoreClient.lock(HiveMetaStoreClient.java:1736) > at sun.reflect.GeneratedMethodAccessor3.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:90) > at com.sun.proxy.$Proxy9.lock(Unknown Source) > at > org.apache.hadoop.hive.ql.lockmgr.DbLockManager.lock(DbLockManager.java:80) > ... 17 more > > p.s : Before setting the transaction specific properties I was able to run > hive queries successfully > > Thanks, > Yogendra > > > -- > Sent with Postbox <http://www.getpostbox.com> > > CONFIDENTIALITY NOTICE > NOTICE: This message is intended for the use of the individual or entity > to which it is addressed and may contain information that is confidential, > privileged and exempt from disclosure under applicable law. If the reader > of this message is not the intended recipient, you are hereby notified that > any printing, copying, dissemination, distribution, disclosure or > forwarding of this communication is strictly prohibited. If you have > received this communication in error, please contact the sender immediately > and delete it from your system. Thank You. >
