May 6, 2010
I just installed GlodaQuilla (0.3.1), hoping it might help in debugging some (potentially) search-related problems I've encountered (https://bugzilla.mozilla.org/show_bug.cgi?id=521409, https://bugzilla.mozilla.org/show_bug.cgi?id=564128, and, above all, the fact that the new search is excruciatingly slow for me; still looking for the right bug to comment on for that) — and I found that lots of messages have globa id 1. This is the case for most of the messages in my biggest folder (39485 messages), but also for an isolated one in another folder (in between two consecutive "normal" numbers, so probably not the "real" id 1).These are all from a POP account, onDisk (green dot) and not dirty (0). The indexing took about a day after I installed 3.0.4; it seemed to go through every folder twice as far as I could tell, but after it finished, it has since not indexed large numbers of mails, except when I added an IMAP account; the mails from that seem to have gotten proper ids.
I'll be happy to provide any additional information that would help in investigating this, or if you think that would be appropriate, to file a new bug for this. Here's my Thunderbird version:
Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; de; rv:126.96.36.199) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4
July 12, 2008
I'm not really the guy to try to solve problems with gloda. The GlodaQuilla extension was originally written by request of the team that works directly with gloda, and they are very familiar with it and use it in their work. So really the correct thing for you to do is to work through Mozilla's bugzilla, as apparently you have done.
I do recall Mozilla Messaging's president David Ascher as pointing out to me one time that GlodaQuilla was showing an index of 1 for his messages, but then concluded that it was caused by a recent code change he had done. So that is a sign of gloda failures, but beyond that I cannot say.
At the moment, all effort is devoted to the upcoming TB 3.1 release. What I suggest that you do is to load Thunderbird 3.1 beta 2, reproduce your issues there, and then work through the Mozilla bug reporting channels. You could use bugzilla, or contact asuth on Mozilla's IRC channel #maildev Feel free to mention your glodaquilla results, as all of the gloda devs use it.
I found that lots of messages have globa id 1.
Gloda id is messages.id / messagesText.docid of SQLite3 table.
Select statement example.
"SELECT messages.*, messagesText.*, (snip)
"FROM messagesText, messages " + "WHERE" + (snip)
" AND messages.id = messagesText.docid " (snip)
See https://bugzilla.mozilla.org/show_bug.cgi?id=559022#c15 for detail.
As you can see by log of Gloda Debugging,
( https://wiki.mozilla.org/Thunderbird:Debugging_Gloda )
messages.id / messagesText.docid looks to start from 32 in decimal
(shown in hexadecimal at gloda id column, so starts from 0x20) .
As written in the bug, if something wrong happens in Gloda indexing,
GlodaQuilla looks to show 1 at gloda id column.
Read above bug for it, please.
If you see gloda id=1, get Gloda's log by Thunderbird:Debugging_Gloda, please.
Most Users Ever Online: 41
Guest Posters: 217
Newest Members:JasonJax, SaulutRor, xaipheira, VepMikhail, JosephSuist, EgorcaOl
Administrators: rkent: 423