1274424 - Duplicate history items for the same url

Status: RESOLVED DUPLICATE of bug 1332621

(Firefox for Android Graveyard :: Data Providers, defect)

Description

[:Grisha Kruglov]

Attachment: swith-to-tab-twice.png

It's possible to end up with duplicate history items for the same url. For example, looking at my profile's history table, I see that I have three duplicated urls:

sqlite> select count(url), url from history group by url;
...
2|http://reddit.com/
...
2|https://news.ycombinator.com/
...
2|https://www.reddit.com/

More details:
sqlite> select * from history where url = "https://www.reddit.com/";
42|reddit: the front page of the internet|https://www.reddit.com/|21|7|1463695979785|1463689815609|1463695982302|rD82iAN99zxz|0
51|reddit: the front page of the internet|https://www.reddit.com/|21|7|1463695979785|1463689816585|1463695982302|PTycvyhDNw7n|0

See attached screenshot for how this manifests itself in the Top Sites UI. Notice "Switch to tab" appearing for both reddit entries. I only have one reddit tab open at this time.

Perhaps something in the sync history record reconciliation going bonkers?