404 Errors on Pages/Posts That Should Exist

Symptom

Visiting a known-valid URL returns a 404 page instead of the expected content.