Delete rebuilds series index when series to be deleted are only found in cache

[hpbieker]

System info:
InfluxDB 1.7.0

Steps to reproduce:

1. Start influxd with tsi1
2. Run insert someMeasurement value=1 in the influx client to create a new series that only lives in the cache.
3. Run delete from "someMeasurement" where time=0 in the influx client (which deletes nothing because I do not have any data with time=0)

Influx now decides to rebuild the series index files because the series "someMeasurement" does not exist in any tsm file so it is considered "deleted".

If I do a restart of InfluxDB between 2. and 3. it will not rebuild the series on the delete.

This issue is related to #9015, because it causes deletes to be very slow when the series only exist in cache. I get the profile below when running a query like delete from "someMeasurement" where time=0 in a loop.

Expected behavior:
The series index should only be rebuilt when we actually delete data.

Actual behavior:
The series index is rebuilt if it only exist in cache.

Additional info:

[hpbieker]

Did you have a chance to look at my PR @rbetts?

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.