[
https://issues.apache.org/jira/browse/HIVE-21706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sankar Hariappan updated HIVE-21706:
------------------------------------
Description:
During REPL DUMP of a DB having external tables, if any of the external table
is dropped concurrently, then REPL DUMP fails with below exception.
{code}
2019-05-10T06:29:52,092 ERROR [HiveServer2-Background-Pool: Thread-745399]:
repl.ReplDumpTask (:()) - failed
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found
catalog_sales_new
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1383)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1336)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1316)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1298)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.exec.repl.ReplDumpTask.incrementalDump(ReplDumpTask.java:259)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.exec.repl.ReplDumpTask.execute(ReplDumpTask.java:121)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:212)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2711)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2382)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2054)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1752)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1746)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:226)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hive.service.cli.operation.SQLOperation.access$700(SQLOperation.java:87)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:324)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at java.security.AccessController.doPrivileged(Native Method)
~[?:1.8.0_181]
at javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_181]
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)
~[hadoop-common-3.1.1.3.1.0.31-12.jar:?]
at
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:342)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_181]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[?:1.8.0_181]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_181]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
~[?:1.8.0_181]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[?:1.8.0_181]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[?:1.8.0_181]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
{code}
was:
During REPL DUMP of a DB having external tables, if any of the external table
is dropped concurrently, then REPL DUMP fails with below exception.
{code}
2019-05-08T11:57:25,702 ERROR [HiveServer2-Background-Pool: Thread-3307]:
repl.ReplDumpTask (:()) - failed
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table
catalog_sales_new. null
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1387)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1336)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1316)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1298)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.exec.repl.ReplDumpTask.incrementalDump(ReplDumpTask.java:259)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.exec.repl.ReplDumpTask.execute(ReplDumpTask.java:121)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:212)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2711)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2382)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2054)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1752)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1746)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:226)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hive.service.cli.operation.SQLOperation.access$700(SQLOperation.java:87)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:324)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_181]
at javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_181]
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)
~[hadoop-common-3.1.1.3.1.0.31-12.jar:?]
at
org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:342)
~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_181]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_181]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
~[?:1.8.0_181]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_181]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
~[?:1.8.0_181]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
~[?:1.8.0_181]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
Caused by: org.apache.thrift.transport.TTransportException
at
org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.thrift.transport.TSaslTransport.readLength(TSaslTransport.java:376)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.thrift.transport.TSaslTransport.readFrame(TSaslTransport.java:453)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.thrift.transport.TSaslTransport.read(TSaslTransport.java:435)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.thrift.transport.TSaslClientTransport.read(TSaslClientTransport.java:37)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.metastore.security.TFilterTransport.readAll(TFilterTransport.java:62)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:318)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:219)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_table_req(ThriftHiveMetastore.java:2137)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_table_req(ThriftHiveMetastore.java:2124)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getTable(HiveMetaStoreClient.java:1701)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient.getTable(SessionHiveMetaStoreClient.java:190)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source) ~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_181]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181]
at
org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:212)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at com.sun.proxy.$Proxy58.getTable(Unknown Source) ~[?:?]
at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source) ~[?:?]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:1.8.0_181]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_181]
at
org.apache.hadoop.hive.metastore.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:2990)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
at com.sun.proxy.$Proxy58.getTable(Unknown Source) ~[?:?]
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1378)
~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
... 27 more
2019-05-08T11:57:25,705 INFO [HiveServer2-Background-Pool: Thread-3307]:
reexec.ReOptimizePlugin (:()) - ReOptimization: retryPossible: false
{code}
> REPL Dump with concurrent drop of external table fails.
> -------------------------------------------------------
>
> Key: HIVE-21706
> URL: https://issues.apache.org/jira/browse/HIVE-21706
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2, repl
> Affects Versions: 4.0.0
> Reporter: Sankar Hariappan
> Assignee: Sankar Hariappan
> Priority: Major
> Labels: DR, replication
>
> During REPL DUMP of a DB having external tables, if any of the external table
> is dropped concurrently, then REPL DUMP fails with below exception.
> {code}
> 2019-05-10T06:29:52,092 ERROR [HiveServer2-Background-Pool: Thread-745399]:
> repl.ReplDumpTask (:()) - failed
> org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found
> catalog_sales_new
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1383)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1336)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1316)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1298)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hadoop.hive.ql.exec.repl.ReplDumpTask.incrementalDump(ReplDumpTask.java:259)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hadoop.hive.ql.exec.repl.ReplDumpTask.execute(ReplDumpTask.java:121)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:212)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:97)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2711)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:2382)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:2054)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1752)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1746)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.run(ReExecDriver.java:157)
> ~[hive-exec-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:226)
> ~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hive.service.cli.operation.SQLOperation.access$700(SQLOperation.java:87)
> ~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run(SQLOperation.java:324)
> ~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at java.security.AccessController.doPrivileged(Native Method)
> ~[?:1.8.0_181]
> at javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_181]
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)
> ~[hadoop-common-3.1.1.3.1.0.31-12.jar:?]
> at
> org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run(SQLOperation.java:342)
> ~[hive-service-3.1.0.3.1.0.31-12.jar:3.1.0.3.1.0.31-12]
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> ~[?:1.8.0_181]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ~[?:1.8.0_181]
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> ~[?:1.8.0_181]
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> ~[?:1.8.0_181]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> ~[?:1.8.0_181]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> ~[?:1.8.0_181]
> at java.lang.Thread.run(Thread.java:748) [?:1.8.0_181]
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
