exposing issue with snapshots that are created during transaction commits