Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Message-ID: <55C4E4BF.6020107@gmail.com>
Date: Fri, 07 Aug 2015 10:02:55 -0700
From: Alan Gates <alanfgates@gmail.com>
User-Agent: Postbox 3.0.11 (Macintosh/20140602)
MIME-Version: 1.0
To: user@hive.apache.org
Subject: Re: Error communicating with metastore
References: 
 <CA+eK9bgo4wWeK0ZjyTf=7+=LfXBi=ytnS7adhvNXH+HOV4hxgA@mail.gmail.com>
 <55BF88D2.6050707@gmail.com>
 <CA+eK9bij-RXdc9bD018GKTuajMzPWp_FhNtZnS5uA0tNFHUSJQ@mail.gmail.com>
 <55C14672.6090103@gmail.com>
 <CA+eK9biSjC5jDg8TqMhCFWCE8SpT+41jpoySy8UwqNRf7aqasA@mail.gmail.com>
In-Reply-To: 
 <CA+eK9biSjC5jDg8TqMhCFWCE8SpT+41jpoySy8UwqNRf7aqasA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------040204090507000908050702"

This is a multi-part message in MIME format.
--------------040204090507000908050702
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

What version of Hive did you say you were using?  In 0.14 we switched to 
make sure all jdbc connections are either serializable or 
read_committed, yet the error message below seems to indicate you're 
seeing a connection request that doesn't match this.

The only other thing I know to try i switching the JDBC pool provider.  
By default Hive uses bonecp (which is what you're using according to the 
logs).  I have seen issues with Oracle 12 and bonecp that went away when 
you switch to using dbcp.  You can try this by setting 
datanucleus.connectionPoolingTypetodbcp  on your thrift metastore and 
then restarting the thrift metastore.

Alan.

> Sarath Chandra <mailto:sarathchandra.josyam@algofusiontech.com>
> August 7, 2015 at 6:13
> Thanks Eugene, Alan.
>
> @Alan,
> As suggested checked the logs, here is what I found -
>
>   * On starting metastore server, I'm seeing following messages in the
>     log file -
>
> /2015-08-07 18:32:56,678 ERROR [Thread-7]: compactor.Initiator 
> (Initiator.java:run(134)) - Caught an exception in the main loop of 
> compactor initiator, exiting MetaException(message:Unable to get jdbc 
> connection from pool, READ_COMMITTED and SERIALIZABLE are the only 
> valid transaction levels)/
> /        at 
> org.apache.hadoop.hive.metastore.txn.TxnHandler.getDbConn(TxnHandler.java:811)/
> /        at 
> org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.revokeFromLocalWorkers(CompactionTxnHandler.java:443)/
> /        at 
> org.apache.hadoop.hive.ql.txn.compactor.Initiator.recoverFailedCompactions(Initiator.java:147)/
> /        at 
> org.apache.hadoop.hive.ql.txn.compactor.Initiator.run(Initiator.java:64)/
>
>   * On bringing up the hive shell, I get the following messages -
>
> tion - enable connectionWatch for additional debugging assistance or 
> set disableConnectionTracking to true to disable this feature entirely.
> 2015-08-07 18:38:51,614 WARN 
>  [org.spark-project.guava.common.base.internal.Finalizer]: 
> bonecp.ConnectionPartition 
> (ConnectionPartition.java:finalizeReferent(162)) - BoneCP detected an 
> unclosed connection and will now attempt to close it for you. You 
> should be closing this connection in your application - enable 
> connectionWatch for additional debugging assistance or set 
> disableConnectionTracking to true to disable this feature entirely.
> 2015-08-07 18:38:51,768 DEBUG [pool-3-thread-1]: metastore.ObjectStore 
> (ObjectStore.java:debugLog(6435)) - Commit transaction: count = 0, 
> isactive true at:
>         
> org.apache.hadoop.hive.metastore.ObjectStore.getFunctions(ObjectStore.java:6657)
>
>   * On firing "show tables" command, I get the following messages in
>     the log file -
>
> 2015-08-07 18:41:02,511 INFO  [main]: hive.metastore 
> (HiveMetaStoreClient.java:open(297)) - Trying to connect to metastore 
> with URI thrift://sarath:9083
> 2015-08-07 18:41:02,511 INFO  [main]: hive.metastore 
> (HiveMetaStoreClient.java:open(385)) - Connected to metastore.
> 2015-08-07 18:41:22,549 ERROR [main]: ql.Driver 
> (SessionState.java:printError(545)) - FAILED: Error in determing valid 
> transactions: 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:281)
>         at 
> org.apache.hadoop.hive.ql.Driver.recordValidTxns(Driver.java:842)
>         at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1036)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:911)
>         at org.apache.hadoop.hive.ql.Driver.run(Driver.java:901)
>         at 
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
>         at 
> org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
>         at 
> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:423)
>         at 
> org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:792)
>         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:686)
>         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
>         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:156)
> Caused by: org.apache.thrift.transport.TTransportException: 
> java.net.SocketTimeoutException: Read timed out
>         at 
> org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)
>         at 
> org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)
>         at 
> org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378)
>         at 
> org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297)
>         at 
> org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204)
>         at 
> org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)
>         at 
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_open_txns(ThriftHiveMetastore.java:3367)
>         at 
> org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_open_txns(ThriftHiveMetastore.java:3355)
>         at 
> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getValidTxns(HiveMetaStoreClient.java:1545)
>         at 
> org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.getValidTxns(DbTxnManager.java:279)
>         ... 15 more
> Caused by: java.net.SocketTimeoutException: Read timed out
>         at java.net.SocketInputStream.socketRead0(Native Method)
>         at java.net.SocketInputStream.read(SocketInputStream.java:129)
>         at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
>         at java.io.BufferedInputStream.read1(BufferedInputStream.java:258)
>         at java.io.BufferedInputStream.read(BufferedInputStream.java:317)
>         at 
> org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127)
>         ... 24 more
>
> Let me know if there is anything to be taken care in the configuration 
> or setup.
>
>
> Alan Gates <mailto:alanfgates@gmail.com>
> August 4, 2015 at 16:10
> Ok, the next step is to look at the logs from your Hive metastore 
> server and see exactly what's happening.  The error you're seeing is 
> from the client.  On your metastore server there should be logs with 
> the same timestamp giving details on why the transaction operation failed.
>
> Alan.
>
> Sarath Chandra <mailto:sarathchandra.josyam@algofusiontech.com>
> August 3, 2015 at 20:02
> Thanks Alan.
>
> Yes I've run metastore scripts for oracle instance. Infact I've 
> removed my previous metastore and created a fresh one by running the 
> schema creation script for 1.2.1. I've looked into the new schema and 
> able to see the table TXNS. I've also removed the hdfs location 
> "/user/hive/warehouse" and created a fresh one.
>
> But still I'm facing this issue.
>
>
>
> Alan Gates <mailto:alanfgates@gmail.com>
> August 3, 2015 at 8:29
> Did you run the hive metastore upgrade scripts for your oracle 
> instance?  This error message usually means the transaction related 
> tables have not been created in your database.  Somewhere in your 
> distribution there should be a set of upgrade scripts.  Look for 
> scripts of the form:
>
> scripts/metastore/upgrade/oracle/upgrade-0.13.0-to-0.14.0.oracle.sql
>
> You'll want to run all of the ones from 0.13 to 1.2 (0.13->0.14, 
> 0.14->1.1, 1.1->1.2).  The 0.13->0.14 scripts assume that you added 
> the transaction tables as part of upgrading to Hive 0.13.  If you did 
> not you will need to first run hive-txn-schema-0.13.0.oracle.sql which 
> will create the initial transaction tables.  You can determine whether 
> this was done by looking for a table named TXNS in the hive schema on 
> your Oracle db.
>
> Alan.
>
> Sarath Chandra <mailto:sarathchandra.josyam@algofusiontech.com>
> August 3, 2015 at 6:29
> Hi All,
>
> Earlier I was using hive 0.13.0 and now trying to migrate to latest 
> version to utilize the transaction support introduced from hive 0.14.0.
>
> I downloaded hive 1.2.1, created a metastore in oracle database and 
> provided all the required configuration parameters in 
> conf/hive-site.xml to enable transactions. For the parameter 
> "hive.txn.manager" given the value 
> "org.apache.hadoop.hive.ql.lockmgr.DbTxnManager".
>
> From the hive prompt when I fire the command "show tables;" I'm 
> getting the below exception -
> /FAILED: Error in determining valid transactions: Error communicating 
> with the metastore/
>
> But if disable the "hive.txn.manager" parameter in hive-site.xml then 
> the command works fine.
>
> Is there anything else to be configured which I'm missing?
>
> Thanks & Regards,
> Sarath.

--------------040204090507000908050702
Content-Type: multipart/related;
 boundary="------------020905010405030002070806"


--------------020905010405030002070806
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html><head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head><body bgcolor="#FFFFFF" text="#000000">What version of Hive did 
you say you were using?  In 0.14 we switched to make sure all jdbc 
connections are either serializable or read_committed, yet the error 
message below seems to indicate you're seeing a connection request that 
doesn't match this.<br>
<br>
The only other thing I know to try i switching the JDBC pool provider.  
By default Hive uses bonecp (which is what you're using according to the
 logs).  I have seen issues with Oracle 12 and bonecp that went away 
when you switch to using dbcp.  You can try this by setting <span><meta 
charset="utf-8"><tt style="border: 1px solid rgb(204, 204, 204); 
border-radius: 2px; padding: 1px 3px; color: rgb(51, 51, 51); font-size:
 14px; font-style: normal; font-variant: normal; font-weight: normal; 
letter-spacing: normal; line-height: 20px; orphans: auto; text-align: 
start; text-indent: 0px; text-transform: none; white-space: normal; 
widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; 
background: rgb(245, 245, 245);">datanucleus.connectionPoolingType</tt><span
 style="color: rgb(51, 51, 51); font-family: Arial, sans-serif; 
font-size: 14px; font-style: normal; font-variant: normal; font-weight: 
normal; letter-spacing: normal; line-height: 20px; orphans: auto; 
text-align: start; text-indent: 0px; text-transform: none; white-space: 
normal; widows: 1; word-spacing: 0px; -webkit-text-stroke-width: 0px; 
display: inline !important; float: none; background-color: rgb(245, 245,
 245);"><span class="Apple-converted-space"> </span>to<span 
class="Apple-converted-space"> </span></span><tt style="border: 1px 
solid rgb(204, 204, 204); border-radius: 2px; padding: 1px 3px; color: 
rgb(51, 51, 51); font-size: 14px; font-style: normal; font-variant: 
normal; font-weight: normal; letter-spacing: normal; line-height: 20px; 
orphans: auto; text-align: start; text-indent: 0px; text-transform: 
none; white-space: normal; widows: 1; word-spacing: 0px; 
-webkit-text-stroke-width: 0px; background: rgb(245, 245, 245);">dbcp</tt> 
 on your thrift metastore and then restarting the thrift metastore.<br>
  <br>
Alan.<br>
</span><br>
<blockquote style="border: 0px none;" 
cite="mid:CA+eK9biSjC5jDg8TqMhCFWCE8SpT+41jpoySy8UwqNRf7aqasA@mail.gmail.com"
 type="cite">
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="display:table;width:100%;border-top:1px solid 
#EDEEF0;padding-top:5px"> 	<div 
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
 photoaddress="sarathchandra.josyam@algofusiontech.com" 
photoname="Sarath Chandra" src="cid:part1.06010205.07050700@gmail.com" 
name="compose-unknown-contact.jpg" height="25px" width="25px"></div>   <div
 
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
   	<a moz-do-not-send="true" 
href="mailto:sarathchandra.josyam@algofusiontech.com" 
style="color:#737F92 
!important;padding-right:6px;font-weight:bold;text-decoration:none 
!important;">Sarath Chandra</a></div>   <div 
style="display:table-cell;white-space:nowrap;vertical-align:middle;">   
  <font color="#9FA2A5"><span style="padding-left:6px">August 7, 2015 at
 6:13</span></font></div></div></div>
  <div style="color:#888888;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr">Thanks Eugene, 
Alan.<div><br></div><div>@Alan,</div><div>As suggested checked the logs,
 here is what I found -</div><div><ul><li>On starting metastore server, 
I'm seeing following messages in the log file -<br></li></ul><div><div><i>2015-08-07
 18:32:56,678 ERROR [Thread-7]: compactor.Initiator 
(Initiator.java:run(134)) - Caught an exception in the main loop of 
compactor initiator, exiting MetaException(<a class="moz-txt-link-freetext" href="message:Unable">message:Unable</a> to get jdbc 
connection from pool, READ_COMMITTED and SERIALIZABLE are the only valid
 transaction levels)</i></div><div><i>        at 
org.apache.hadoop.hive.metastore.txn.TxnHandler.getDbConn(TxnHandler.java:811)</i></div><div><i> 
       at 
org.apache.hadoop.hive.metastore.txn.CompactionTxnHandler.revokeFromLocalWorkers(CompactionTxnHandler.java:443)</i></div><div><i> 
       at 
org.apache.hadoop.hive.ql.txn.compactor.Initiator.recoverFailedCompactions(Initiator.java:147)</i></div><div><i> 
       at 
org.apache.hadoop.hive.ql.txn.compactor.Initiator.run(Initiator.java:64)</i></div></div></div><div><ul><li>On
 bringing up the hive shell, I get the following messages -</li></ul><div><div>tion
 - enable connectionWatch for additional debugging assistance or set 
disableConnectionTracking to true to disable this feature entirely.</div><div>2015-08-07
 18:38:51,614 WARN 
 [org.spark-project.guava.common.base.internal.Finalizer]: 
bonecp.ConnectionPartition 
(ConnectionPartition.java:finalizeReferent(162)) - BoneCP detected an 
unclosed connection and will now attempt to close it for you. You should
 be closing this connection in your application - enable connectionWatch
 for additional debugging assistance or set disableConnectionTracking to
 true to disable this feature entirely.</div><div>2015-08-07 
18:38:51,768 DEBUG [pool-3-thread-1]: metastore.ObjectStore 
(ObjectStore.java:debugLog(6435)) - Commit transaction: count = 0, 
isactive true at:</div><div>        
org.apache.hadoop.hive.metastore.ObjectStore.getFunctions(ObjectStore.java:6657)</div></div></div><div><ul><li>On
 firing "show tables" command, I get the following messages in the log 
file -</li></ul><div><div>2015-08-07 18:41:02,511 INFO  [main]: 
hive.metastore (HiveMetaStoreClient.java:open(297)) - Trying to connect 
to metastore with URI thrift://sarath:9083</div><div>2015-08-07 
18:41:02,511 INFO  [main]: hive.metastore 
(HiveMetaStoreClient.java:open(385)) - Connected to metastore.</div><div>2015-08-07
 18:41:22,549 ERROR [main]: ql.Driver 
(SessionState.java:printError(545)) - FAILED: Error in determing valid 
transactions: Error communicating with the metastore</div><div>org.apache.hadoop.hive.ql.lockmgr.LockException:
 Error communicating with the metastore</div><div>        at 
org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.getValidTxns(DbTxnManager.java:281)</div><div> 
       at 
org.apache.hadoop.hive.ql.Driver.recordValidTxns(Driver.java:842)</div><div> 
       at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1036)</div><div> 
       at org.apache.hadoop.hive.ql.Driver.run(Driver.java:911)</div><div> 
       at org.apache.hadoop.hive.ql.Driver.run(Driver.java:901)</div><div> 
       at 
org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)</div><div> 
       at 
org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)</div><div> 
       at 
org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:423)</div><div> 
       at 
org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:792)</div><div> 
       at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:686)</div><div> 
       at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)</div><div> 
       at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div><div> 
       at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div><div> 
       at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div><div> 
       at java.lang.reflect.Method.invoke(Method.java:597)</div><div>   
     at org.apache.hadoop.util.RunJar.main(RunJar.java:156)</div><div>Caused
 by: org.apache.thrift.transport.TTransportException: 
java.net.SocketTimeoutException: Read timed out</div><div>        at 
org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:129)</div><div> 
       at 
org.apache.thrift.transport.TTransport.readAll(TTransport.java:84)</div><div> 
       at 
org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378)</div><div> 
       at 
org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297)</div><div> 
       at 
org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204)</div><div> 
       at 
org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)</div><div> 
       at 
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_open_txns(ThriftHiveMetastore.java:3367)</div><div> 
       at 
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_open_txns(ThriftHiveMetastore.java:3355)</div><div> 
       at 
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getValidTxns(HiveMetaStoreClient.java:1545)</div><div> 
       at 
org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.getValidTxns(DbTxnManager.java:279)</div><div> 
       ... 15 more</div></div></div><div><div>Caused by: 
java.net.SocketTimeoutException: Read timed out</div><div>        at 
java.net.SocketInputStream.socketRead0(Native Method)</div><div>        
at java.net.SocketInputStream.read(SocketInputStream.java:129)</div><div> 
       at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)</div><div> 
       at 
java.io.BufferedInputStream.read1(BufferedInputStream.java:258)</div><div> 
       at java.io.BufferedInputStream.read(BufferedInputStream.java:317)</div><div> 
       at 
org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:127)</div><div> 
       ... 24 more</div></div><div class="gmail_extra"><br clear="all"><div><div
 class="gmail_signature"><div dir="ltr"><div>Let me know if there is 
anything to be taken care in the configuration or setup.</div></div></div></div>
<br><br></div></div>

  </div>
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="display:table;width:100%;border-top:1px solid 
#EDEEF0;padding-top:5px"> 	<div 
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
 photoaddress="alanfgates@gmail.com" photoname="Alan Gates" 
src="cid:part1.06010205.07050700@gmail.com" 
name="compose-unknown-contact.jpg" height="25px" width="25px"></div>   <div
 
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
   	<a moz-do-not-send="true" href="mailto:alanfgates@gmail.com" 
style="color:#737F92 
!important;padding-right:6px;font-weight:bold;text-decoration:none 
!important;">Alan Gates</a></div>   <div 
style="display:table-cell;white-space:nowrap;vertical-align:middle;">   
  <font color="#9FA2A5"><span style="padding-left:6px">August 4, 2015 at
 16:10</span></font></div></div></div>
  <div style="color:#888888;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Ok, the next step is to 
look at the logs from your Hive metastore server and see exactly what's 
happening.  The error you're seeing is from the client.  On your 
metastore server there should be logs with the same timestamp giving 
details on why the transaction operation failed.<br>
<br>
Alan.<br>
<br>

  </div>
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="display:table;width:100%;border-top:1px solid 
#EDEEF0;padding-top:5px"> 	<div 
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
 photoaddress="sarathchandra.josyam@algofusiontech.com" 
photoname="Sarath Chandra" src="cid:part1.06010205.07050700@gmail.com" 
name="compose-unknown-contact.jpg" height="25px" width="25px"></div>   <div
 
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
   	<a moz-do-not-send="true" 
href="mailto:sarathchandra.josyam@algofusiontech.com" 
style="color:#737F92 
!important;padding-right:6px;font-weight:bold;text-decoration:none 
!important;">Sarath Chandra</a></div>   <div 
style="display:table-cell;white-space:nowrap;vertical-align:middle;">   
  <font color="#9FA2A5"><span style="padding-left:6px">August 3, 2015 at
 20:02</span></font></div></div></div>
  <div style="color:#888888;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr">Thanks Alan.<div><br></div><div>Yes
 I've run metastore scripts for oracle instance. Infact I've removed my 
previous metastore and created a fresh one by running the schema 
creation script for 1.2.1. I've looked into the new schema and able to 
see the table TXNS. I've also removed the hdfs location 
"/user/hive/warehouse" and created a fresh one.</div><div><br></div><div>But
 still I'm facing this issue.</div><div class="gmail_extra"><div><div 
class="gmail_signature"><div dir="ltr"><div dir="ltr"><br></div></div></div></div>
<br><br></div></div>

  </div>
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="display:table;width:100%;border-top:1px solid 
#EDEEF0;padding-top:5px"> 	<div 
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
 photoaddress="alanfgates@gmail.com" photoname="Alan Gates" 
src="cid:part1.06010205.07050700@gmail.com" 
name="compose-unknown-contact.jpg" height="25px" width="25px"></div>   <div
 
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
   	<a moz-do-not-send="true" href="mailto:alanfgates@gmail.com" 
style="color:#737F92 
!important;padding-right:6px;font-weight:bold;text-decoration:none 
!important;">Alan Gates</a></div>   <div 
style="display:table-cell;white-space:nowrap;vertical-align:middle;">   
  <font color="#9FA2A5"><span style="padding-left:6px">August 3, 2015 at
 8:29</span></font></div></div></div>
  <div style="color:#888888;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
Did you run the hive 
metastore upgrade scripts for your oracle instance?  This error message 
usually means the transaction related tables have not been created in 
your database.  Somewhere in your distribution there should be a set of 
upgrade scripts.  Look for scripts of the form:<br>
<br>
scripts/metastore/upgrade/oracle/upgrade-0.13.0-to-0.14.0.oracle.sql<br>
<br>
You'll want to run all of the ones from 0.13 to 1.2 (0.13-&gt;0.14, 
0.14-&gt;1.1, 1.1-&gt;1.2).  The 0.13-&gt;0.14 scripts assume that you 
added the transaction tables as part of upgrading to Hive 0.13.  If you 
did not you will need to first run hive-txn-schema-0.13.0.oracle.sql 
which will create the initial transaction tables.  You can determine 
whether this was done by looking for a table named TXNS in the hive 
schema on your Oracle db.<br>
<br>
Alan.<br>
<br>

  </div>
  <div style="margin:30px 25px 10px 25px;" class="__pbConvHr"><div 
style="display:table;width:100%;border-top:1px solid 
#EDEEF0;padding-top:5px"> 	<div 
style="display:table-cell;vertical-align:middle;padding-right:6px;"><img
 photoaddress="sarathchandra.josyam@algofusiontech.com" 
photoname="Sarath Chandra" src="cid:part1.06010205.07050700@gmail.com" 
name="compose-unknown-contact.jpg" height="25px" width="25px"></div>   <div
 
style="display:table-cell;white-space:nowrap;vertical-align:middle;width:100%">
   	<a moz-do-not-send="true" 
href="mailto:sarathchandra.josyam@algofusiontech.com" 
style="color:#737F92 
!important;padding-right:6px;font-weight:bold;text-decoration:none 
!important;">Sarath Chandra</a></div>   <div 
style="display:table-cell;white-space:nowrap;vertical-align:middle;">   
  <font color="#9FA2A5"><span style="padding-left:6px">August 3, 2015 at
 6:29</span></font></div></div></div>
  <div style="color:#888888;margin-left:24px;margin-right:24px;" 
__pbrmquotes="true" class="__pbConvBody"><div dir="ltr">Hi All,
<div><br></div><div>Earlier I was using hive 0.13.0 and now trying to 
migrate to latest version to utilize the transaction support introduced 
from hive 0.14.0.</div><div><br></div><div>I downloaded hive 1.2.1, 
created a metastore in oracle database and provided all the required 
configuration parameters in conf/hive-site.xml to enable transactions. 
For the parameter "hive.txn.manager" given the value 
"org.apache.hadoop.hive.ql.lockmgr.DbTxnManager".</div><div><br></div><div>From
 the hive prompt when I fire the command "show tables;" I'm getting the 
below exception -</div><div><i>FAILED: Error in determining valid 
transactions: Error communicating with the metastore</i></div><div><br></div><div>But
 if disable the "hive.txn.manager" parameter in hive-site.xml then the 
command works fine.</div><div><br></div><div>Is there anything else to 
be configured which I'm missing?</div><div><br></div><div>Thanks &amp; 
Regards,</div><div>Sarath.</div></div>

  </div>
</blockquote>
</body></html>

--------------020905010405030002070806
Content-Type: image/jpeg; x-apple-mail-type=stationery;
 name="compose-unknown-contact.jpg"
Content-Transfer-Encoding: base64
Content-ID: <part1.06010205.07050700@gmail.com>
Content-Disposition: inline;
 filename="compose-unknown-contact.jpg"

/9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEC
AQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgIC
AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAAR
CAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUK
BwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAA
AAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oA
DAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJ
VIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4
v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx
+a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mR
UfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbab
eg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbz
hbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUi
yeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37y
zqnlfp6FrqbwawG8/9k=
--------------020905010405030002070806--

--------------040204090507000908050702--