---- Reported by chaz@yorba.org 2013-03-05 20:22:00 -0800 ----

Original Redmine bug id: 6485
Original URL: http://redmine.yorba.org/issues/6485
Searchable id: yorba-bug-6485
Original author: Charles Lindsay
Original description:

I noticed I couldn't scroll farther down in my All Mail folder, due to a
particular UID not being in the database. Turns out, I had two messages with
identical InternalDate and RFC822.Size fields back to back in IMAP:

    
    
    a uid fetch 21620:21621 (rfc822.size internaldate envelope)
    * 18646 FETCH (UID 21620 RFC822.SIZE 2296 INTERNALDATE "01-Mar-2013 23:30:45 +0000" ENVELOPE ("Fri, 1 Mar 2013 15:30:44 -0800" "[internal - Task #5547] install charts plugin" ((NIL NIL "redmine" "redmine.yorba.org")) ((NIL NIL "redmine" "redmine.yorba.org")) ((NIL NIL "redmine" "redmine.yorba.org")) NIL NIL NIL "<redmine.issue-5547.20120713064142@redmine.yorba.org>" "<redmine.journal-23048.20130301153044@redmine.yorba.org>"))
    * 18647 FETCH (UID 21621 RFC822.SIZE 2296 INTERNALDATE "01-Mar-2013 23:30:45 +0000" ENVELOPE ("Fri, 1 Mar 2013 15:30:44 -0800" "[internal - Task #5423] use HTTPS for donations page" ((NIL NIL "redmine" "redmine.yorba.org")) ((NIL NIL "redmine" "redmine.yorba.org")) ((NIL NIL "redmine" "redmine.yorba.org")) NIL NIL NIL "<redmine.issue-5423.20120620061718@redmine.yorba.org>" "<redmine.journal-23046.20130301153044@redmine.yorba.org>"))
    a OK Success
    

Geary unfortunately drops the ball in this situation, not recording that the
second UID (21621 in this case) even exists:

    
    
    sqlite> SELECT * FROM MessageLocationTable WHERE ordering > 21618 ORDER BY ordering LIMIT 5;
    299|298|8|21619|0
    300|299|8|21620|0
    301|300|8|21622|0
    302|301|8|21623|0
    303|302|8|21624|0
    

Geary should be recording the UID, even if it thinks it's a duplicate of
another message.

The broader question here is what to do when two messages are detected as
duplicates but aren't, especially if they're in the same folder.

Related issues:
related to geary - 6653: can't scroll down to retrieve all mail in All
Mail (Fixed)



---- Additional Comments From geary-maint@gnome.bugs 2013-09-04 17:50:00 -0700 ----

### History

####

#1

Updated by Jim Nelson 9 months ago

  * **Target version** set to _0.4.0_

####

#2

Updated by Jim Nelson 3 months ago

  * **Target version** changed from _0.4.0_ to _0.5.0_



--- Bug imported by chaz@yorba.org 2013-11-21 20:28 UTC  ---

This bug was previously known as _bug_ 6485 at http://redmine.yorba.org/show_bug.cgi?id=6485

Unknown milestone "unknown in product geary. 
   Setting to default milestone for this product, "---".
Setting qa contact to the default for this product.
   This bug either had no qa contact or an invalid one.
Resolution set on an open status.
   Dropping resolution