Mire boil water advisory lifted