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

Port https://github.com/influxdata/influxdb/issues/26110 to 1.12 branch.

PR to port: [fix: reduce lock contention and races in purger](https://github.com/influxdata/influxdb/pull/27146#top)