In my case it was a custom filter setting from a plugin(Polylang) that was present in the user metadata. pll_filter_content = en. Once I removed it from the db, I was able to list all pages again.