<!-- Describe the issue -->

When our chainstate activation sequence fails and we're running the GUI, we ask the user via a question box whether or not they'd like to re-run the sequence with `fReindex = true`. Fun fact: despite the fact that this sequence is wrapped in a while loop, we only run it twice at most.

https://github.com/bitcoin/bitcoin/blob/7ecb309c4ed1bb9ae6b9a12cbb4f083328edc125/src/init.cpp#L1539-L1556

If they answer yes, the sequence will always fail, because a chainstate will have already been initialized in the original run and `InitializeChainstate` will throw a `std::logic_error`:

https://github.com/bitcoin/bitcoin/blob/7ecb309c4ed1bb9ae6b9a12cbb4f083328edc125/src/validation.cpp#L4573-L4594

This always reproduces. To reproduce:
```
gdb ./src/qt/bitcoin-qt
(gdb) b InitializeChainstate
(gdb) # add breakpoint for the "if (!fLoaded && !ShutdownRequested()) {" line
(gdb) r  # should stop at the breakpoint for InitializeChainstate
(gdb) c  # to advance to the breakpoint for the "if (!fLoaded && !ShutdownRequested()) {" line
(gdb) set fLoaded=false
(gdb) c  # should stop at the breakpoint for InitializeChainstate
(gdb) n  # step through InitializeChainstate to see that it throws
```

We expect the re-run of the chainstate activation sequence to not always fail.

return outp;
    };
    CChainState& c1 = WITH_LOCK(cs_main, return manager.InitializeChainstate(&mempool));
    c1.InitCoinsDB(
        1 << 23, true, false);
    WITH_LOCK(::cs_main, c1.InitCoinsCache(1 << 23));
    BOOST_REQUIRE(c1.LoadGenesisBlock()); 
    
    {
        LOCK(::cs_main);
        auto outpoint = add_coin(c1.CoinsTip());
        
        
        c1.CoinsTip().SetBestBlock(InsecureRand256());
        BOOST_CHECK(c1.CoinsTip().HaveCoinInCache(outpoint));
        c1.ResizeCoinsCaches(
            1 << 24,  
            1 << 22  
        );
        
        BOOST_CHECK(c1.CoinsTip().HaveCoinInCache(outpoint));
        c1.ResizeCoinsCaches(
            1 << 22,  
            1 << 23  
        );
        
        BOOST_CHECK(!c1.CoinsTip().HaveCoinInCache(outpoint));
    }
}
BOOST_FIXTURE_TEST_CASE(chainstate_update_tip, TestChain100Setup)