Missing policy row causes eZ Publish Platform to always return 404 for affected users

I had a legacy db where a policy was deleted but for whatever reason, the corresponding row had a reference to an role_id which do not exists.
This is handled gracefully by legacy and also with symfony stack in dev mode.

However, in prod, SPI will try to fetch a non-existing role and throw NotFoundException, resulting in a 404 for any page the affected users are trying to access