Fix lookup of project by unknown ref when caching is enabled

I fixed the bug (.compact) and made sure caching worked consistently with project_from_ref_cached .

Closes #24224 (closed)