[BUG] [Snapshot V2] Restore of latest snapshot post index deletion can restore data only till previous snapshot

[sachinpkale]

Describe the bug

• This bug is applicable for Shallow snapshot V2.
• If snapshot is created between last fetch of pinned timestamps and index deletion and last metadata file is created before the last fetch, the restore of snapshot will restore data corresponding to previous snapshot

Related component

Storage:Snapshots

To Reproduce

If we have following sequence of events, issue can be reproduced

09:58 - second last metadata file
10:00 - S1
10:30 - last metadata file
10:55 - last refresh of pinned timestamp
11:00 - S2
11:05 - Index deleted

Here, restoring S2 will restore data corresponding to snapshot S1.

Expected behavior

Snapshot should be able to restore data corresponding to its own timestamp.