cant find message using gloda after delete attachment
Categories
(Thunderbird :: Search, defect)
Tracking
(Not tracked)
People
(Reporter: johnkw, Unassigned)
Details
(Whiteboard: [datalossy])
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:88.0) Gecko/20100101 Firefox/88.0
Steps to reproduce:
Delete attachment from email.
Actual results:
The search database is corrupted.
Expected results:
The search database should not be corrupted.
At a minimum the email that had the attachment deleted no longer appears in search. I tried moving the email to another folder and running "Repair Folder", but nothing made search wake up and find it. I'm not sure if other emails are affected - locating emails that can't be found in search is a bit of a pain.
It is fixed by doing a shutdown, delete global-messages-db.sqlite, restart. That is a rather drastic workaround though, since this happens so frequently.
I first noticed that Thunderbird search was often quite broken about a year ago. It took a while to realize this was at least part of the problem. There may be other similar problems though.
I ran a test by having a search term with 998 emails, and 1 of the 998 had an attachment. After detaching the attachment, that email is no longer returned due to the search database being corrupted, and the search now returns 997 emails. The fact that only 1 email is lost from search makes me suspect that the search corruption is confined to just the loss of the email that had the attachment detached. Probably the rest of the search database remained the same.
Running tests on version 68.12.1 and 78.10.2 - Windows OS.
In 68.12.1
Email had attachment - detached
Quick filter still works
Global Search -fails to find the message with attachment which was detached.
Find > Search Messages - works.
In 78.10.2
Email had two attachments - deleted one.
Quick filter still works
Global Search - fails to find the message with attachments where one was deleted.
Find > Search Messages - works.
Exit Thunderbird.
Deleted the global-messages-db.sqlite file
Restarted and tested Global Search
Message found.
I can reproduce this issue in both versions if an attachment was detached or deleted.
Comment 3•3 years ago
|
||
If you wait enough time for indexing to happen, does it find it again?
For years I've resorted to "grep -r" to find Thunderbird emails when search would fail, and usually if I'm searching at all, I'm searching for emails that are months old. So no, I doubt it ever recovers from this database corruption (or perhaps there are other database corruption scenarios I haven't figured out yet).
This also seems to erase/corrupt the "Open Message In Conversation" functionality.
Comment 6•3 years ago
|
||
Sounds like bug 570589
I'll post this info in bug 570589 but included here for relevance.
ReChecked in version: 91.3.2 to see if bug still active.
Email had four attachments - deleted one.
Quick filter still works
Global Search - fails to find the message with attachments where one was deleted.
Find > Search Messages - works.
Exit Thunderbird.
Deleted the global-messages-db.sqlite file
Restarted and tested Global Search
Message found in Global Search.
So bug still active.
Description
•