to me it is still not clear what it exactly does - also in relation to the oc_filecache:
does it scann all connected storage/folders recursively - also new folders and add them to oc_filecache?
or does it only scan known files/folders from the oc_filecache?
does it validate oc_filecache and also remove entries when files are deleted or external_shares are disconnected?
does it validate he data/cache folders and clean them up?
espacially its connection to the oc_filecache is very interesting to me because it seems only be growing and growing.
clearing the table and rescanning is also not a good solution if you are using shares or e.g. audioplayer because they rely on the file-id from filecache
oc_filecache is not a cache, but a file index. Renaming is not possible, but don’t treat it like a cache, so never manually do stuff there (e.g. delete entries, purge, etc)
…but is there a cleanup process somehow available?
I can see that I connected a quite big SMB share for testing. I removed it again but several 1000 files seem to remain in oc_filecache.
I got some database index corruption in oc_filecache and was not able to repair it. Am I right that doing occ files:scan --all will fully recreate this database table?
I did this several times without any problems. My corruption was most likely caused by apache+mysql service restart during occ preview:generate-all ran in background screen . Lucky me that my nextcloud instance is just for private use, playing and tinkering around.