After Data Migration from Time Machine, Spotlight fails search localized under user home folder
After a hardware repair, I restored user data from Time Machine using Migration Assistant.
Spotlight now has a strange error: When searching "This Mac", it CAN find any file. But when localizing the search to a folder under my user home folder, e.g., Downloads, if fails to show any results at all.
Here we see the search finding results by using "This Mac"
Below, we see no results when looking for the same file but narrowing the search to ~/Downloads:
This also happened a month ago on two different computers. On both computers the problem was resolved by reinstalling macOS (which was Monterey on both).
Today, I have had to bring the same Time Machine onto the machine again after Apple replaced the logic board.
Now, on Ventura, I did the macOS re-install, thinking that would solve the problem.. but this time it did not. Spotlight still cannot find anything when doing a search on a folder under ~/.
I have also done two techniques to cause spotlight to reindex the drive:
1) mdutil -E /
2) Put Macintosh HD in the Privacy list under System Settings/Siri & Spotlight. Close System Settings, reopen, and remove Macintosh HD from the privacy list.
Oddly, in both cases, there was no change in behavior. I would have thought that mdutil -E / would have caused spotlight to stop working for a while as it rebuilt the indices... but no. Searching using the Finder search continued to give exactly the same results as before running the command.
Also oddly, I put my user home folder into the Privacy list, and while it was there, I could still find files under my user home, as long as it was searching "This Mac".
This makes me speculate that somehow the Data Migration brought over an extra Spotlight index (which is not getting erased), and that the identity of my user home folder is somehow not recognized as being the same. (A vague idea, I know.)
One other data point. For folders outside my user home, (e.g. /Applications or /Library) The finder search has no problem doing a search localized to that folder:
Any ideas on how to solve this?
MacBook Pro 16″, macOS 13.1