Yesterday, I posted a variation on the response below in the Apple Discussion Forums, where you can also read other user reports about this problem, and how well this "fix" I've come up with is working for others.
https://discussions.apple.com/thread/4322106?tstart=0
------
I might have a working "fix". Based on the constant stalling on sandbox-cache.db I decided to take a chance and delete all folders found in /var/folders. What I actually did, in order:
Quit all applications except Terminal, issued the following two commands:
Code:
sudo mdutil -i off /
sudo mdutil -E /
sudo rm -Rf /var/folders/*
Reboot.
There were no further stalls on sandbox-cache.db according to opensnoop, and no further lsboxd complaints in Console. mds and mdworker processes have been very busy, typically 40-100% CPU, unlike before. And now the index estimate is variably saying 6 to 19 minutes for completion instead of 3 days to 5 weeks. It ultimately completed indexing in 45 minutes, which is normal for my system. Previously it had been running for 3 days and was maybe 20% complete.
Now, blowing away the folders in /var/folders may have other consequences, possibly negative, for sandboxing. But the files therein appear to be recreated from scratch after reboot to no ill effect or complaints in Console. But let's just say, the suffering bleeding edgers may end up bleeding more by trying this. Any volunteers?