A sewage pumping station failure killed over 2,000 fish in Melksham, with sewage from a burst rising main also killing fish near Weston-super-Mare.