1910556 - Unexpected autocomplete in Address bar

Status: RESOLVED INVALID

(Firefox :: Address Bar, defect)

Description

[Mayank Bansal]

Started seeing this a few days ago.
Type "jan" in the address bar:

AR: the suggestion is "http://www.janbambas.cz/" which is a bookmark but one that I hardly ever visit.
ER: Till a few days back, the suggestion would have been "https://phabricator.services.mozilla.com/p/jandem/"

Comment 1

[Mayank Bansal]

Attachment: about:support

Comment 2

[Mayank Bansal]

• The database has been vacuumed
• Final database size is 71680KiB

Task: stats

• Places.sqlite size is 71680KiB
• Favicons.sqlite size is 72992KiB
• pragma_user_version is 77
• pragma_page_size is 32768
• pragma_cache_size is -2048
• pragma_journal_mode is wal
• pragma_synchronous is 1
• History can store a maximum of 108175 unique pages
• Table moz_places has 109184 records
• Table moz_historyvisits has 213143 records
• Table moz_inputhistory has 508 records
• Table moz_bookmarks has 1347 records
• Table moz_keywords has 0 records
• Table sqlite_sequence has 1 records
• Table moz_anno_attributes has 3 records
• Table moz_annos has 952 records
• Table moz_items_annos has 0 records
• Table sqlite_stat1 has 26 records
• Table moz_hosts has 0 records
• Table moz_bookmarks_deleted has 0 records
• Table moz_meta has 10 records
• Table moz_origins has 4810 records
• Table moz_places_metadata has 89551 records
• Table moz_places_metadata_search_queries has 0 records
• Table moz_previews_tombstones has 0 records
• Table moz_places_extra has 0 records
• Table moz_historyvisits_extra has 0 records
• Pages sequentiality: 39
• sqlite_schema: 32KiB (0%), 25.5% eff.
• moz_inputhistory: 32KiB (0%), 39.8% eff.
• sqlite_autoindex_moz_inputhistory_1: 32KiB (0%), 27.4% eff.
• moz_keywords: 32KiB (0%), 0% eff.
• sqlite_autoindex_moz_keywords_1: 32KiB (0%), 0% eff.
• sqlite_sequence: 32KiB (0%), 0.1% eff.
• moz_anno_attributes: 32KiB (0%), 0.3% eff.
• sqlite_autoindex_moz_anno_attributes_1: 32KiB (0%), 0.3% eff.
• moz_items_annos: 32KiB (0%), 0% eff.
• sqlite_stat1: 32KiB (0%), 4.6% eff.
• moz_hosts: 32KiB (0%), 0% eff.
• sqlite_autoindex_moz_hosts_1: 32KiB (0%), 0% eff.
• moz_bookmarks_deleted: 32KiB (0%), 0% eff.
• sqlite_autoindex_moz_bookmarks_deleted_1: 32KiB (0%), 0% eff.
• moz_meta: 32KiB (0%), 2% eff.
• moz_places_metadata_search_queries: 32KiB (0%), 0% eff.
• sqlite_autoindex_moz_places_metadata_search_queries_1: 32KiB (0%), 0% eff.
• moz_previews_tombstones: 32KiB (0%), 0% eff.
• moz_places_extra: 32KiB (0%), 0% eff.
• moz_historyvisits_extra: 32KiB (0%), 0% eff.
• moz_bookmarks_itemindex: 32KiB (0%), 48.2% eff.
• moz_bookmarks_parentindex: 32KiB (0%), 48.6% eff.
• moz_bookmarks_itemlastmodifiedindex: 32KiB (0%), 80.7% eff.
• moz_bookmarks_guid_uniqueindex: 32KiB (0%), 82.2% eff.
• moz_annos_placeattributeindex: 32KiB (0%), 37.7% eff.
• moz_items_annos_itemattributeindex: 32KiB (0%), 0% eff.
• moz_keywords_placepostdata_uniqueindex: 32KiB (0%), 0% eff.
• moz_bookmarks_dateaddedindex: 32KiB (0%), 65.8% eff.
• moz_bookmarks: 160KiB (0.2%), 76.4% eff.
• moz_annos: 128KiB (0.2%), 61.1% eff.
• sqlite_autoindex_moz_origins_1: 224KiB (0.3%), 81.6% eff.
• moz_origins: 256KiB (0.4%), 81.3% eff.
• moz_places_metadata_referrerindex: 928KiB (1.3%), 94.6% eff.
• moz_places_altfrecencyindex: 992KiB (1.4%), 96.8% eff.
• moz_places_visitcount: 1024KiB (1.5%), 95.7% eff.
• moz_places_frecencyindex: 1120KiB (1.6%), 95.6% eff.
• moz_places_originidindex: 1216KiB (1.8%), 95.2% eff.
• moz_places_url_hashindex: 1664KiB (2.4%), 96.2% eff.
• moz_places_metadata_placecreated_uniqueindex: 1696KiB (2.4%), 98% eff.
• moz_places_lastvisitdateindex: 1856KiB (2.7%), 97.3% eff.
• moz_places_guid_uniqueindex: 2272KiB (3.3%), 98.6% eff.
• moz_historyvisits_fromindex: 2400KiB (3.5%), 97.8% eff.
• moz_places_hostindex: 3008KiB (4.3%), 98.8% eff.
• moz_places_metadata: 3520KiB (5.1%), 98.2% eff.
• moz_historyvisits_dateindex: 3584KiB (5.2%), 98.8% eff.
• moz_historyvisits_placedateindex: 4416KiB (6.4%), 99% eff.
• moz_historyvisits: 6208KiB (9%), 99% eff.
• moz_places: 31712KiB (45.8%), 99.4% eff.

Task: _refreshUI

Comment 3

[Marco Bonardo [:mak]]

(In reply to Mayank Bansal from comment #0)

AR: the suggestion is "http://www.janbambas.cz/" which is a bookmark but one that I hardly ever visit.
ER: Till a few days back, the suggestion would have been "https://phabricator.services.mozilla.com/p/jandem/"

we don't autofill urls that don't start with the typed string, so it's not possible we were filling https://phabricator.services.mozilla.com/p/jandem/, likely we were returning it as the second result, while the default result was to search for "jan"? That result should also appear after the new autofill default result. Practically what changes is the default action when typing and pressing Enter, not other results.

As for the first one, it's by design as all the bookmarks are autofilled by default, even if they are unvisited from a long time. That's of course not optimal and we could improve it. The behavior should not have changed, maybe the database fixed itself.

Comment 4

[Mayank Bansal]

So should I close this bug as INVALID or WONTFIX?