A section of the retaining wall next to River Avon has fallen away, closing the road for the foreseeable future.