Entity error on add new user I am using Drupal 8.05

I am unable to add a new user. I get the following error when I press "Add User" button:

Drupal\Core\Entity\Query\QueryException: 'field_housing_coop_ref' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable() (line 252 of core/lib/Drupal/Core/Entity/Query/Sql/Tables.php).

'field_housing_coop_ref' was an entity reference field (pointing to Content Type A) on Content Type B. I deleted the 'field_housing_coop_ref' field and get the error. 

If I recreate the field then I can add a new user. When I delete the field I get the error again.

I put this on the Drupal core issues list as support request but it got closed as not a reproducible error. So it seems to be something particular to my site. 

Currently I have the field existing but unused and hidden on the form/display modes. Any idea about what I have done and how I might better resolve this much appreciated.
NOTE:Make sure to take backup of database before doing below changes to avoid any issues.

Search for "field_housing_coop_ref" field in entire database including cache tables, mostly cache_* and key_value tables. Once you've all matching records with you, delete one by one very carefully by reading there names properly to make sure nothing else get deleted.

Once you've deleted matching records for "field_housing_coop_ref" field, rebuild cache by navigating to "Admin => Configuration => Development => Performance" or using Drush command "drush cr".

Updates:

If there are any other references for this field inside other fields in key_value table, make sure to delete those field from Field UI and then cross verify again.