Crash with sqlite: "PRIMARY KEY must be unique"

Allan Wind allan_wind at lifeintegrity.com
Thu Jan 26 14:29:09 UTC 2012


... 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>



More information about the OfflineIMAP-project mailing list