Revert "Merge branch 'qmnguyen0711/optimize-transaction-committed-log-retention' into 'master'"

This reverts merge request !6619 (merged). That merge request modifies how a log entry is pruned. However, it creates a race between log entry deletion and transaction closing. As a result, the log entry could not be removed. When the transaction manager re-initializes afterward, the appendedLSN is reset incorrectly.

There should be a fix for this, but let's revert the MR first to unlock master branch.