[
https://issues.apache.org/jira/browse/HIVE-26409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17569415#comment-17569415
]
Sourabh Badhya commented on HIVE-26409:
---------------------------------------
Thanks for the review [~dkuzmenko] .
> Assign NO_TXN operation type for table in global locks for scheduled queries
> ----------------------------------------------------------------------------
>
> Key: HIVE-26409
> URL: https://issues.apache.org/jira/browse/HIVE-26409
> Project: Hive
> Issue Type: Bug
> Reporter: Sourabh Badhya
> Assignee: Sourabh Badhya
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.0.0-alpha-2
>
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> NO_TXN operation type has to be assigned while acquiring locks for the table
> in global locks because this will not add records to COMPLETED_TXN_COMPONENTS
> table. Currently the record introduced by this lock had writeId as NULL.
> There was a situation which lead to large number of records in
> COMPLETED_TXN_COMPONENTS table because these records had writeId as NULL
> which weren't deleted up by AcidHouseKeeperService/Cleaner and this
> subsequently lead to OOM errors.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
