Hello, I am using Cloudera 7.1.3. Facing some transaction-related state issues. For details:
The output of transactions:
Here, TXNID: 7560 is still stated as open,( started: Sunday, 7 February 2021 09:39:37.960 ), thought last heartbeat time is also about four months (Sunday, 7 February 2021 09:40:25.838 ) ago, In HiveServer2 configured as
hive.txn.timeout: 5 minutes
according to this parameter, the TXNID: 7560 should be declared aborted after 5 mins if the client has not sent a heartbeat.
In the meantime, several times restart the hive and hiveServer2 services.
How to change aborted the open status of this txnID and why this situation created?