How to clean up some invalid attachments

[openapphub]

This is an early note, and I recently found that the images in the previous notes have all become invalid. However, the size of the notes remains large, without any reduction. How can I delete, clean up, and free up these resources?

I'm not sure if it's due to a version update or an issue with synchronization, but these notes are quite old.~

[openapphub]

Total ： Note Size: 2 KiB (Subtree Size: 78 MiB, Total of 6281 Notes)

But document.db has already reached 170MB; is this because the database is corrupted? I have already clicked on optimize in the settings.

[eliandoran]

@openapphub , did you manage to solve it? I saw the discussion as being closed.

[openapphub]

@openapphub , did you manage to solve it? I saw the discussion as being closed.

@eliandoran Thank you for bringing this issue to my attention. I realize that this should be an isolated case, which is why I decided to close it. Moreover, I have tried several solutions:

1. I attempted to write an SQL query with the assistance of AI, which identified size anomalies, no referenced attachments, and the actual space was only reduced by about 20MB.

2. I tried to recreate the server-side service. I exported the existing notes and re-imported them into a new service. During the export of the old service, I encountered multiple service timeout exceptions. Subsequently, I had to export them in small batches multiple times to successfully complete the process. Post-mortem analysis revealed that the issue was with notes processed through the Trilium Web Clipper tool. The export process became unresponsive, and exporting a single problematic note also caused service exceptions.
   Ultimately, I adopted a combination of import/export methods and manual processing to migrate the notes, which resulted in reducing their size from 170 MB to 86 MB.

---

Oddly, I can see broken or cracked images on the software, but when querying the record in the database, the output of its size appears consistent with normal records. Therefore, I am unable to judge the size based on SQL and cannot delete them.

The specific cause was not identified. I have been using these notes for over three years, and they have undergone multiple migrations and upgrades. I'm not sure which operation led to this issue. Fortunately, the import/export function resolved my problem. Thank you.