See the pictures. The water is not flowing out, because the piston is in the way.

The piston became invisible and is not working at all. I can't rid this bug nor replace it with another piston. Restarting the game didn't fix it.

I have seen other posts about this, but I can't find the solution from those posts.