[influxdb1.x/2.x]: purger code may prevent compactions from finishing [port to main-2.x]

Port [[influxdb1.x/2.x]: purger code may prevent compactions from finishing](https://github.com/influxdata/influxdb/issues/26110) to main-2.x

PR to port: https://github.com/influxdata/influxdb/pull/27146#top