Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2986017AC3 for ; Mon, 20 Oct 2014 08:59:57 +0000 (UTC) Received: (qmail 77767 invoked by uid 500); 20 Oct 2014 08:59:34 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 77648 invoked by uid 500); 20 Oct 2014 08:59:34 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 77410 invoked by uid 500); 20 Oct 2014 08:59:34 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 77379 invoked by uid 99); 20 Oct 2014 08:59:34 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Oct 2014 08:59:34 +0000 Date: Mon, 20 Oct 2014 08:59:34 +0000 (UTC) From: "Liao, Xiaoge (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-8519) Hive metastore lock wait timeout MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-8519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Liao, Xiaoge updated HIVE-8519: ------------------------------- Summary: Hive metastore lock wait timeout (was: Hive lock wait timeout) > Hive metastore lock wait timeout > -------------------------------- > > Key: HIVE-8519 > URL: https://issues.apache.org/jira/browse/HIVE-8519 > Project: Hive > Issue Type: Bug > Components: Metastore > Affects Versions: 0.10.0 > Reporter: Liao, Xiaoge > > We got a lot of exception as below when doing a drop table partition: > Log: > 2014-10-17 04:04:39,300 INFO metastore.HiveMetaStore (HiveMetaStore.java:logInfo(447)) - 655: source:/*.*.*.* get_table : db=* tbl=* > 2014-10-17 04:04:43,180 INFO metastore.HiveMetaStore (HiveMetaStore.java:logInfo(447)) - 622: source:/*.*.*.* get_table : db=* tbl=* > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) > at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) > at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) > at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) > at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) > at org.datanucleus.store.rdbms.ParamLoggingPreparedStatement.executeUpdate(ParamLoggingPreparedStatement.java:399) > at org.datanucleus.store.rdbms.SQLController.executeStatementUpdate(SQLController.java:439) > at org.datanucleus.store.rdbms.request.UpdateRequest.execute(UpdateRequest.java:374) > at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.updateTable(RDBMSPersistenceHandler.java:417) > at org.datanucleus.store.rdbms.RDBMSPersistenceHandler.updateObject(RDBMSPersistenceHandler.java:390) > at org.datanucleus.state.JDOStateManager.flush(JDOStateManager.java:5012) > at org.datanucleus.FlushOrdered.execute(FlushOrdered.java:106) > at org.datanucleus.ExecutionContextImpl.flushInternal(ExecutionContextImpl.java:4019) > at org.datanucleus.ExecutionContextThreadedImpl.flushInternal(ExecutionContextThreadedImpl.java:450) > at org.datanucleus.store.query.Query.prepareDatastore(Query.java:1575) > at org.datanucleus.store.query.Query.executeQuery(Query.java:1760) > at org.datanucleus.store.query.Query.executeWithArray(Query.java:1672) > at org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:243) > at org.apache.hadoop.hive.metastore.ObjectStore.listStorageDescriptorsWithCD(ObjectStore.java:2185) > at org.apache.hadoop.hive.metastore.ObjectStore.removeUnusedColumnDescriptor(ObjectStore.java:2131) > at org.apache.hadoop.hive.metastore.ObjectStore.preDropStorageDescriptor(ObjectStore.java:2162stStorageDescriptorsWithCD) > at org.apache.hadoop.hive.metastore.ObjectStore.dropPartitionCommon(ObjectStore.java:1361) > at org.apache.hadoop.hive.metastore.ObjectStore.dropPartition(ObjectStore.java:1301) > at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.hive.metastore.RetryingRawStore.invoke(RetryingRawStore.java:111) > at $Proxy4.dropPartition(Unknown Source) > at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_partition_common(HiveMetaStore.java:1865) > at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.drop_partition(HiveMetaStore.java:1911) > at sun.reflect.GeneratedMethodAccessor52.invoke(Unknown Source) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:105) > at $Proxy5.drop_partition(Unknown Source) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$drop_partition.getResult(ThriftHiveMetastore.java:6240) > at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$drop_partition.getResult(ThriftHiveMetastore.java:6224) > at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) > at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:115) > at org.apache.hadoop.hive.metastore.TUGIBasedProcessor$1.run(TUGIBasedProcessor.java:112) > at java.security.AccessController.doPrivileged(Native Method) > at javax.security.auth.Subject.doAs(Subject.java:396) > at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1438) > at org.apache.hadoop.hive.shims.HadoopShimsSecure.doAs(HadoopShimsSecure.java:582) > at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:123) > at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244) > at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) > at java.lang.Thread.run(Thread.java:662) -- This message was sent by Atlassian JIRA (v6.3.4#6332)