Closed Bug 1587175 Opened 5 years ago Closed 5 years ago

Address Book takes many seconds to open, autocomplete in compose window hangs for ~20 seconds

Categories

(Thunderbird :: Address Book, defect)

defect
Not set
normal

Tracking

(Not tracked)

RESOLVED DUPLICATE of bug 1587259

People

(Reporter: jik, Unassigned)

References

Details

(Keywords: perf, regression)

Attachments

(1 file)

Attached image 2019-10-08_14-53.png

This started between 2019-09-22 and 2019-09-23 nightly build.

Regression from mozregression:

https://hg.mozilla.org/comm-central/pushloghtml?fromchange=981dc700defb0a6146dbb74bdcc7e374f6961173&tochange=145ab0ce87cf701f7ca364a38d4af820af6b4d99

The behavior I'm seeing is threefold:

  1. When I type the start of an email address that should autocomplete and then wait for it to autocomplete, Thunderbird hangs for ~20 seconds and then autocompletes normally.

  2. When I click the Address Book button, it takes about the same amount of time to open.

  3. While the Address Book is opening and when I move my mouse back and forth over the address book entries after it opens, a whole bunch of error messages spew in the error log over and over. See screenshot; note that the 2147746065 error messages are the new one; the 2147500033 error messages happen even in an old, good build.

That's strange. We've converted ABs from Mork to SQLite, the last bug that did the automatic conversion was bug 1581765, see also bug 1572324 and bug 1576525.

The regression range has none of these bugs in it, instead it has bug 1562158 and bug 1427877 which could be relevant.

For me in a local build at current tip auto-complete works as fast as before, both from a local address book as from LDAP. After clicking the address book button, the AB window comes up in about one second on a debug build.

Is there something wrong with your profile?

Keywords: perf
See Also: → 1581765

For me, just opening the AB window and loading 16000 contacts across all addressbooks takes 15 minutes on and AMD Threadripper (debug build of TB).
It was no problem with the old .mab files. This is unusable.
I also see the errors in console as in comment 0.

I got back to acceptable performance by deleting all of the address book files in my profile as well as history.sqlite to get rid of collected addresses.

I don't know whether my sqlite files were corrupt somehow, or whether the new implementation simply cannot handle the number of addresses I had.

Note in particular that I had over 4,000 entries in "Collected addresses" (which, again, appears to be stored in history.sqlite, not in an abook file).

I saved a copy of the old profile before purging everything, so if you want me to do any troubleshooting on it, just let me know.

Sorry, I caused this frustration by forgetting to add the database indices I'd intended to add. I'm doing that now in bug 1587259.

Status: NEW → RESOLVED
Closed: 5 years ago
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: