Storage structure ver003 to V4 leftovers

[Martin Podhovnik]

After our upgrade to Confluence 8 some time ago I rediscovered some small amount of left-overs from the (now legacy) storage structure (ver003) in my file system.

There are only a few thumb_xxxx files in there (which none of my people missed BTW) - but before I delete them, I want to ask if there is any possibility to see where they are/have been referenced in my Confluence instance. 

Is there any known suggested way - or any SQL statement available which does this?

br Martin

[Aron Gombas _Midori_ · Accepted solution]

Slightly related to this, Atlassian provides scripts and a KB article to find missing attachments. 

If it is easy, you could eventually try if the "leftovers" are found by that script. Hopefully, if they are still in use, it will tell where. Or, if they are not used anymore, at least you get another confirmation that you can delete them.

Note: REMEMBER TO create a backup of the directory if you decide to actually delete the files.

[Martin Podhovnik]

Thanks for the answer @Aron Gombas _Midori_ 

the Confluence built-in attachment health check does not complain at all about missing attachments.

I only stumbled upon the thumb_XXXX files when doing some server stuff due to the log files generated when starting confluence. It is ~380 out of 1,2 Mio. attachments on my system - and all of them are thumb_XXXX.

I also just wonder when and how thumbs_xxxx are being created (I believe after user uploaded them) - and if they are being recreated when they're missing.

[Aron Gombas _Midori_]

@Martin Podhovnik  See: https://confluence.atlassian.com/doc/confluence-home-and-other-important-directories-590259707.html

thumbnails/

Stores temporary files for image thumbnails. This directory is essentially a thumbnail cache, and files deleted from this directory will be regenerated the next time the image is accessed.