[ https://issues.apache.org/jira/browse/HIVE-23633?focusedWorklogId=646772&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-646772 ]
ASF GitHub Bot logged work on HIVE-23633: ----------------------------------------- Author: ASF GitHub Bot Created on: 06/Sep/21 07:51 Start Date: 06/Sep/21 07:51 Worklog Time Spent: 10m Work Description: pvary commented on a change in pull request #2344: URL: https://github.com/apache/hive/pull/2344#discussion_r702681959 ########## File path: standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java ########## @@ -2107,15 +2115,17 @@ private ColumnStatisticsObj prepareCSObjWithAdjustedNDV(Object[] row, int i, makeParams(inputColNames.size()), makeParams(inputPartNames.size())); long start = doTrace ? System.nanoTime() : 0; Query query = pm.newQuery("javax.jdo.query.SQL", queryText); - Object qResult = executeWithArray(query, prepareParams( - catName, dbName, tableName, inputPartNames, inputColNames, engine), queryText); - MetastoreDirectSqlUtils.timingTrace(doTrace, queryText0, start, (doTrace ? System.nanoTime() : 0)); - if (qResult == null) { - query.closeAll(); - return Collections.emptyList(); + try { Review comment: I think `addQueryAfterUse` is there for closing the queries. So we might not need them anymore. What do you think? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 646772) Time Spent: 10h 20m (was: 10h 10m) > Metastore some JDO query objects do not close properly > ------------------------------------------------------ > > Key: HIVE-23633 > URL: https://issues.apache.org/jira/browse/HIVE-23633 > Project: Hive > Issue Type: Bug > Reporter: Zhihua Deng > Assignee: Zhihua Deng > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Attachments: HIVE-23633.01.patch > > Time Spent: 10h 20m > Remaining Estimate: 0h > > After patched [HIVE-10895|https://issues.apache.org/jira/browse/HIVE-10895], > The metastore still has seen a memory leak on db resources: many > StatementImpls left unclosed. -- This message was sent by Atlassian Jira (v8.3.4#803005)