Sure thing…are the instructions for gathering such a sample?
Just launch Apple’s Activity Monitor application (see Applications > Utilities), select DEVONthink 3 in the list of processes while (!) it’s frozen, choose the menu item View > Sample Process and send the result to cgrunenberg - at - devon-technologies.com. Thanks in advance!
Ok…I’ll do that next time it happens @cgrunenberg. Shall I assume that indexing and then using a smart group is the right approach for this sort of thing?
There’s no smart group condition to check whether files already exist in the database, therefore the only option is probably a script.
@d1rewolf considers to index everything and to use a Smart Group that checks for duplicates. Not sure whether it’s a good idea to index 100gb+ into a database that already has 100gb+.
@pete31 That’s right…that’s what I was thinking to do. @cgrunenberg, specifically following your advice here: Compare two groups and look for files which *aren't* duplicated between them? - #2 by cgrunenberg
That’s a suggestion related to two groups, not a 100GB+ database! 
Good point @BLUEFROG. I’ll do it on the command line instead. Is there a way to safely kill an index process?
Force quit, while not ideal, is the only option.
What are you planning on doing on the command line?
@BLUEFROG my thought was to roll through the DT3 database Files.noindex directory, and generate checksums to a text file. Then, do the same for the exported directory. Finally, compare the two to find checksums which exist in the exported directory checksums but not in the DT3 one.
I’m very happy to take suggestions from the expert though 
Oh, and just a side note…I did finally force quit because indexing is still running, and yet, when I launched DT again, it resumed indexing…
@cgrunenberg since it’s freezing, albeit under slightly different circumstances, I sent you the sample. Please let me know if you have any ideas what to do, or if restoring from time machine is my only path forward.
Thanks,
d1rewolf
Actually, as soon as I was pressing send, DT came back reporting inconsistencies in the database. So, no sample sent, but now it continues to index. Indexing makes the app very slow to respond 
Any suggestions? If I close the database and restore from backup, will it still try to index?
I don’t see any particular issue with that approach.
If you force quit DEVONthink, no it shouldn’t try to continue Indexing on relaunch.
Hmmm…I’ve force quit it twice, but both times indexing resumes:
And yes, each time I verified it really did quit…
At this point, I’ve moved the directory it’s trying to index. That’s generating errors, but it seems to be speeding up the process. I hope it will finish trying to index soon so that I can have DT back 
Fortunately, moving the directory it was indexing significantly sped things up. I’m back in business.
Glad to hear it.