Compact quits when running at the same time as a system checkpoint

This ticket is to investigate and create a unit test either in cppsuite/python to check if compact quits early when running at the same time as system checkpoint.
If you find the above is true then create a ticket to implement the changes to reduce this scenario while running compact.