When a rollback happens whilst db-sync is off, it seems db-sync doesn't react correctly. This is shown in the restartAndRollback test (function: restartAndRollback) in cardano-chain-gen/test/Test/Cardano/Db/Mock/Unit/Conway/Rollback.hs.
This was made apparent in #2049