Hi Gagan, Check the recent Pull Request by Kavinder, which should solve this issue: https://github.com/apache/incubator-hawq/pull/1075
Hi Kavinder - should JIRA HAWQ-762 be set to resolved? The fix will get included in the next (or next+1) Apache HAWQ release as well as the next HDB release. Your workaround for now may include running a cron job to call a PSQL script which queries a simple or dummy HAWQ PXF external table every 12 hours or so. Thanks Vineet On Mon, Jan 23, 2017 at 9:07 PM Gagan Brahmi <gaganbra...@gmail.com> wrote: > Hi All, > > I am seeing issues with secure HAWQ (HDB 2.0.0 and 2.0.1) cluster on top of > HDP. Querying Hive tables using hcatalog.hive_db.hive_table returns errors > after every 24 hours (token expiration for pxf user). The solution looks to > be a restart pxf for now. > > I see a jira mentioning this behavior but not sure if this is actively > worked on right now. The jira in question is > https://issues.apache.org/jira/browse/HAWQ-762 > > While executing the query using PXF I encounter the following error: > > ----------- > > ERROR: remote component error (500) from '127.0.0.1:51200': type > Exception report message java.lang.Exception: > java.lang.RuntimeException: Failed connecting to Hive MetaStore service: > Could not connect to meta store using any of the URIs provided. Most recent > failure: org.apache.thrift.transport.TTransportException: GSS initiate > failed description The server encountered an internal error that > prevented it from fulfilling this request. exception > javax.servlet.ServletException: java.lang.Exception: > java.lang.RuntimeException: Failed connecting to Hive MetaStore service: > Could not connect to meta store using any of the URIs provided. Most recent > failure: org.apache.thrift.transport.TTransportException: GSS initiate > failed (libchurl.c:884) > > ----------- > > > While verifying Hive metastore I found the following error stack. > > ----------- > > 2017-01-23 07:50:16,969 ERROR [pool-6-thread-200]: server.TThreadPoolServer > (TThreadPoolServer.java:run(296)) - Error occurred during processing of > message. > java.lang.RuntimeException: > org.apache.thrift.transport.TTransportException: Peer indicated failure: > GSS initiate failed > at > > org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:219) > at > > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:609) > at > > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory$1.run(HadoopThriftAuthBridge.java:606) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:356) > at > > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1704) > at > > org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge$Server$TUGIAssumingTransportFactory.getTransport(HadoopThriftAuthBridge.java:606) > at > > org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:268) > 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) > Caused by: org.apache.thrift.transport.TTransportException: Peer indicated > failure: GSS initiate failed > at > > org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:199) > at > > org.apache.thrift.transport.TSaslServerTransport.handleSaslStartMessage(TSaslServerTransport.java:125) > at > org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:271) > at > > org.apache.thrift.transport.TSaslServerTransport.open(TSaslServerTransport.java:41) > at > > org.apache.thrift.transport.TSaslServerTransport$Factory.getTransport(TSaslServerTransport.java:216) > ... 10 more > > ----------- > > Is there any workaround for this problem for now besides restarting PXF > every 24 hours (or the kerberos ticket expiration). > > > Regards, > Gagan Brahmi >
