Smart groups break when database is restored

Question

When we clone our production instance to staging, we restore the database with updated host information prior to restoring the database.

Querying a smart group returns all contacts in database, not just those in the smart group. Running the Rebuild Smart Group Cache scheduled job does not do anything.

Here Eileen says How do the Rebuild Smart Group Cache scheduled job and the Smart group cache timeout setting interact?

Note I DO recommend running the job that flushes expired groups by scheduled job - just not the one that rebuild them all, even the ones you don't really need

Where is that job?

Answer 1

I don't see any such job, nor do I recall such a thing.

But: the contacts that are in smart groups are cached in civicrm_group_contact_cache so you should be able to clear that using the CiviCRM "cleanup caches" option (under Administer -> System settings).