This ticket is an investigation ticket and to create a unit test to check if compact quits early when a page at the bottom of the file is a root page. If the above investigation is true then create a ticket to implement the changes to reduce this scenario while running compact.