Crash with sqlite: "PRIMARY KEY must be unique"

[Daniel Shahaf]

Is it reproducible?  Does it still reproduce if you pass '-1' ("disable
threading") in argv?  What versions of Python, sqlite3 py module,
sqlite3 C library?

Allan Wind wrote on Thu, Jan 26, 2012 at 09:29:09 -0500:
> ... and this is the other crash that I am seeing:
> 
> *** Processing account lifeintegrity
> Syncing Spam: IMAP -> Maildir
> Syncing INBOX: IMAP -> Maildir
> Syncing Sent: IMAP -> Maildir
> Copy message 77152 (1 of 3) imap:Spam -> maildir
> Copy message 77153 (2 of 3) imap:Spam -> maildir
> Copy message 77154 (3 of 3) imap:Spam -> maildir
> Copy message 1152487 (1 of 2) imap:INBOX -> maildir
> Copy message 1152488 (2 of 2) imap:INBOX -> maildir
> Copy message 1152487 (1 of 2) imap:INBOX -> maildir
> Copy message 1152488 (2 of 2) imap:INBOX -> maildir
> ERROR: PRIMARY KEY must be unique
> ERROR: PRIMARY KEY must be unique
> Thread 'Copy message from imap:INBOX' terminated with exception:
> Traceback (most recent call last):
>   File "/home/allan/src/offlineimap/offlineimap/threadutil.py", line 155, in run
>     Thread.run(self)
>   File "/usr/lib/python2.6/threading.py", line 484, in run
>     self.__target(*self.__args, **self.__kwargs)
>   File "/home/allan/src/offlineimap/offlineimap/folder/Base.py", line 289, in copymessageto
>     statusfolder.savemessage(uid, None, flags, rtime)
>   File "/home/allan/src/offlineimap/offlineimap/folder/LocalStatusSQLite.py", line 234, in savemessage
>     (uid,flags))
>   File "/home/allan/src/offlineimap/offlineimap/folder/LocalStatusSQLite.py", line 98, in sql_write
>     cursor = self.connection.execute(sql, vars)
> IntegrityError: PRIMARY KEY must be unique
> 
> 
> Last 1 debug messages logged for Copy message from imap:INBOX prior to exception:
> thread: Register new thread 'Copy message from imap:INBOX' (account 'lifeintegrity')
> ERROR: Exceptions occurred during the run!
> ERROR: IMAP server 'imap' does not have a message with UID '1152473'
> ERROR: IMAP server 'imap' does not have a message with UID '1152474'
> ERROR: IMAP server 'imap' does not have a message with UID '1152475'
> ERROR: IMAP server 'imap' does not have a message with UID '1152476'
> ERROR: IMAP server 'imap' does not have a message with UID '1152477'
> ERROR: IMAP server 'imap' does not have a message with UID '1152478'
> ERROR: IMAP server 'imap' does not have a message with UID '1152481'
> ERROR: IMAP server 'imap' does not have a message with UID '1152482'
> ERROR: IMAP server 'imap' does not have a message with UID '1152483'
> ERROR: IMAP server 'imap' does not have a message with UID '1152486'
> ERROR: IMAP server 'imap' does not have a message with UID '1152487'
> ERROR: PRIMARY KEY must be unique
> ERROR: PRIMARY KEY must be unique
> 
> 
> /Allan
> -- 
> Allan Wind
> Life Integrity, LLC
> <http://lifeintegrity.com>
> 
> _______________________________________________
> OfflineIMAP-project mailing list
> OfflineIMAP-project at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/offlineimap-project
> 
> OfflineIMAP homepage: http://software.complete.org/offlineimap