MesQuilla - Forum: GlodaQuilla

rkent on Need "offset in offline-store file" column. Can GlodaQuilla support it?

Sat, 05 Jun 2010 06:18:33 +0000

Although in theory it can, what you really need is an application that lets you add an arbitrary custom column. Or a "catch-all" extension that adds a lot of possible custom columns (like FiltaQuilla does for custom filter actions). I'm reluctant to add something to GlodaQuilla that is not related to gloda.

WADA on GlodaQuilla shows "gloda id" in hexdecimal, but Gloda debuging shows messages.id column in decimal

Tue, 01 Jun 2010 13:47:00 +0000

Fllowing is comment from asuth in email.

It seems more likely that someone would be debugging usin
g SQLite poking (decimal) versus .msf hacking (hex). And once the msf's are replaced by SQLite, everybody gets to be decimal!

If "gloda id" comes from .msf instead of SQL access of SQLite3 table, I think current hexadecimal representaion is better than decimal for debugging. Understanding of "gloda id is shown in hexadecimal" by we Gloda Debbuging user is sufficient.

And, if it comes from .msf, I can expect "offset in offline-store" in addition to "on disk" will be implemented soon

WADA on globa id 1 on many messages

Tue, 01 Jun 2010 08:49:58 +0000

joriki said:
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.

WADA on Need "offset in offline-store file" column. Can GlodaQuilla support it?

Tue, 01 Jun 2010 08:25:27 +0000

Some bugs of incorect mail data display(other mail's data is shown) are reported with IMP auto-sync. For example.

https://bugzilla.mozilla.org/show_bug.cgi?id=569065 looks involes next bugs.

For analysis of such problem, mail's offset in offline-store is required but it's hard to know.

As GlodaQuilla already has "on disk" column, I expect GlodaQuilla can support "offset in offline-store" column.

Can you support such new column?

rkent on GlodaQuilla shows "gloda id" in hexdecimal, but Gloda debuging shows messages.id column in decimal

Tue, 01 Jun 2010 07:42:45 +0000

I've asked asuth and dascher their preferences for this in an email, as they were the ones who asked for these features.

WADA on GlodaQuilla shows "gloda id" in hexdecimal, but Gloda debuging shows messages.id column in decimal

Fri, 28 May 2010 19:58:56 +0000

GlodaQuilla shows gloda id in hexdecimal, but other tools such as Gloda debuging, SQLite Manager, sqlite3.exe shows message.id etc. in decimal.

GlodaQuilla is better to show integer column in decimal instead of hexadecimal for ease of Gloda debugging.

rkent on globa id 1 on many messages

Fri, 07 May 2010 01:00:40 +0000

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.

joriki on globa id 1 on many messages

Thu, 06 May 2010 23:57:57 +0000

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:1.9.1.9) Gecko/20100317 Lightning/1.0b1 Thunderbird/3.0.4

rkent on GlodaQuilla 0.3.1 released

Thu, 25 Mar 2010 12:35:54 +0000

Today I posted a new version of GlodaQuilla, version 0.3.1 The only change in this version is to up the allowed maximum Thunderbird version to 3.2a1pre.

rkent on thunderbird 3.05

Thu, 25 Mar 2010 12:34:21 +0000

GlodaQuilla version 0.3.1 has now been posted that claims to support Thunderbird through 3.2a1pre.

rkent on thunderbird 3.05

Thu, 25 Mar 2010 12:06:20 +0000

Although I have the maximum version marked on the AMO site as 3.2a1pre, perhaps because it is still experimental the installation is not updating that correctly. Let me upload a version where the maximum allowed version in the code matches that. Because the extensions is not public on AMO, it will not automatically update, so you will need to download the new version (which will be 0.3.1) after I have done that, which should take place in the next 24 hours.

I guess I need to get it moved to public, as GlodaQuilla seems to be used more and more in production. I thought that was going to be temporary, but it looks like the support for gloda indexing control in Thunderbird 3.1 will still be more limited than what is available in GlodaQuilla (mainly that GlodaQuilla uses inherited folder properties to give more precise control of indexing.)

Jon on thunderbird 3.05

Wed, 24 Mar 2010 04:53:12 +0000

I would love to be able to turn back on the global indexing. However I need to be able to stop indexing certain folders (with many 100's of 1000's of messages in them). It looks like glodquilla will do what I need - doesn't work with my thunderbird though (3.05pre). Any chance of a build that works with 3.05pre

ittayd on would love an "advanced search expression" extension

Thu, 10 Dec 2009 03:10:21 +0000

i thought filtaquilla is for creating message filters.

and yes, i'd like the search to work with gloda, otherwise it will be too slow

rkent on would love an "advanced search expression" extension

Thu, 10 Dec 2009 00:31:05 +0000

Have you looked at the FiltaQuilla extension? It now has the capability to add a search term which consists of arbitrary javascript. The example that you gave would be fairly easy to implement in a few lines of javascript in FiltaQuilla.

The custom search terms used in FiltaQuilla use the "traditional" search infrastructure, based on per-folder databases, rather than the gloda sql-based method. I suppose what you are really looking for is a search interface to the gloda database, beyond the "search all messages" faceted search that is offerred in TB3. Hopefully asuth (the gloda developer) is working on that.

ittayd on would love an "advanced search expression" extension

Wed, 09 Dec 2009 23:27:51 +0000

I'd love an extension which adds customized search expressions (sql or otherwise) to be able to search messages in a more advanced way (e.g, messages after date X, with recepient y, not recepient z)