Marta Kuczora created HIVE-22375:
------------------------------------

             Summary: ObjectStore.lockNotificationSequenceForUpdate is leaking 
query in case of error
                 Key: HIVE-22375
                 URL: https://issues.apache.org/jira/browse/HIVE-22375
             Project: Hive
          Issue Type: Bug
          Components: Standalone Metastore
    Affects Versions: 4.0.0
            Reporter: Marta Kuczora
            Assignee: Marta Kuczora


In the ObjectStore.lockNotificationSequenceForUpdate method, the query doesn't 
get closed if an error occur:

{noformat}
 private void lockNotificationSequenceForUpdate() throws MetaException {
 if (sqlGenerator.getDbProduct() == DatabaseProduct.DERBY && directSql != null) 
{
new RetryingExecutor(conf, () -> {
 directSql.lockDbTable("NOTIFICATION_SEQUENCE");
 }).run();
 } else {
 String selectQuery = "select \"NEXT_EVENT_ID\" from \"NOTIFICATION_SEQUENCE\"";
 String lockingQuery = sqlGenerator.addForUpdateClause(selectQuery);
 new RetryingExecutor(conf, () -> {
 prepareQuotes();
 Query query = pm.newQuery("javax.jdo.query.SQL", lockingQuery);
 query.setUnique(true);
 // only need to execute it to get db Lock
 query.execute();
 query.closeAll();
 }).run();
 }
 }
{noformat}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to