desktop-packages team mailing list archive

Thread
Date
[Bug 604846] Re: Error receiving email "File is encrypted or is not a database"

To: desktop-packages@xxxxxxxxxxxxxxxxxxx
From: Bug Watch Updater <604846@xxxxxxxxxxxxxxxxxx>
Date: Wed, 25 Jan 2012 09:06:37 -0000
Reply-to: Bug 604846 <604846@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: evolution
       Status: New => Fix Released

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to evolution in Ubuntu.
https://bugs.launchpad.net/bugs/604846

Title:
  Error receiving email "File is encrypted or is not a database"

Status in The Evolution Mail & Calendaring Tool:
  Fix Released
Status in “evolution” package in Ubuntu:
  Triaged

Bug description:
  Binary package hint: evolution

  System 10.04 with all current updates. 
  Evolution 2.28.3
  Last week I had a issue printing a PDF attachment.  I forced closed the print job. Shortly after that time I was unable to receive email.  I can send emails but when send/receive is requested the "Error while fetching email".  Clicking on the error message shows "File is encrypted or is not a database".  I set up another laptop with the same versions (did not try to restore or move the old information) and it sends and receives.

  Ran CAMEL_DEBUG=all evolution >& evo.log and received the following
  messages in the top 25% of the log.  Cannot find out how to rebuild
  the database to resolve this issue:

  camel_junk_plugin_init
  ** (evolution:4812): DEBUG: mailto URL command: evolution %s
  ** (evolution:4812): DEBUG: mailto URL program: evolution

  Database succesfully opened

  ===========
  DB SQL operation [(null)] started
  Camel SQL Exec:
  (null)
  DB Operation ended. Time Taken : 0.000089
  ###########

  ===========
  DB SQL operation [ATTACH DATABASE ':memory:' AS mem] started
  Camel SQL Exec:
  ATTACH DATABASE ':memory:' AS mem
  DB Operation ended. Time Taken : 0.162544
  ###########
  store_db_path /home/dllann/.evolution/mail/local/folders.db

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT )] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT )
  DB Operation ended. Time Taken : 0.000116
  ###########

  Database succesfully opened

  ===========
  DB SQL operation [(null)] started
  Camel SQL Exec:
  (null)
  DB Operation ended. Time Taken : 0.000034
  ###########

  ===========
  DB SQL operation [ATTACH DATABASE ':memory:' AS mem] started
  Camel SQL Exec:
  ATTACH DATABASE ':memory:' AS mem
  DB Operation ended. Time Taken : 0.159003
  ###########
  Creating Collation mbox_frompos_sort on bdata with 0x1995aa0

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = 'Inbox' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = 'Inbox'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.001067
  ###########

  camel_db_select:
  SELECT uid,flags FROM 'Inbox' order by bdata collate mbox_frompos_sort 

  ===========
  DB SQL operation [SELECT uid,flags FROM 'Inbox' order by bdata collate mbox_frompos_sort] started
  DB Operation ended. Time Taken : 0.004378
  ###########
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Inbox', 1) = 0x9f69888
  < 0 >
  Creating Collation mbox_frompos_sort on bdata with 0x1995aa0

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = 'Drafts' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = 'Drafts'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.000401
  ###########

  camel_db_select:
  SELECT uid,flags FROM 'Drafts' order by bdata collate mbox_frompos_sort 

  ===========
  DB SQL operation [SELECT uid,flags FROM 'Drafts' order by bdata collate mbox_frompos_sort] started
  DB Operation ended. Time Taken : 0.000227
  ###########
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Drafts', 1) = 0x9f69900
  < 0 >
  Creating Collation mbox_frompos_sort on bdata with 0x1995aa0

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = 'Outbox' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = 'Outbox'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.000393
  ###########

  camel_db_select:
  SELECT uid,flags FROM 'Outbox' order by bdata collate mbox_frompos_sort 

  ===========
  DB SQL operation [SELECT uid,flags FROM 'Outbox' order by bdata collate mbox_frompos_sort] started
  DB Operation ended. Time Taken : 0.000292
  ###########
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Outbox', 1) = 0x9f69978
  < 0 >
  Creating Collation mbox_frompos_sort on bdata with 0x1995aa0

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = 'Sent' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = 'Sent'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.000525
  ###########

  camel_db_select:
  SELECT uid,flags FROM 'Sent' order by bdata collate mbox_frompos_sort 

  ===========
  DB SQL operation [SELECT uid,flags FROM 'Sent' order by bdata collate mbox_frompos_sort] started
  DB Operation ended. Time Taken : 0.001025
  ###########
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Sent', 1) = 0x9f699f0
  < 0 >
  Creating Collation mbox_frompos_sort on bdata with 0x1995aa0

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = 'Templates' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = 'Templates'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.000475
  ###########

  camel_db_select:
  SELECT uid,flags FROM 'Templates' order by bdata collate mbox_frompos_sort 

  ===========
  DB SQL operation [SELECT uid,flags FROM 'Templates' order by bdata collate mbox_frompos_sort] started
  DB Operation ended. Time Taken : 0.000234
  ###########
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Templates', 1) = 0x9f69a68
  < 0 >
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Inbox', 1) = 0x9f69888
  < 0 >

  Database succesfully opened

  ===========
  DB SQL operation [(null)] started
  Camel SQL Exec:
  (null)
  DB Operation ended. Time Taken : 0.000050
  ###########

  ===========
  DB SQL operation [ATTACH DATABASE ':memory:' AS mem] started
  Camel SQL Exec:
  ATTACH DATABASE ':memory:' AS mem
  Error in SQL EXEC statement: ATTACH DATABASE ':memory:' AS mem [file is encrypted or is not a database].
  DB Operation ended. Time Taken : 0.000448
  ###########
  store_db_path /home/dllann/.evolution/mail/pop/David.Lann@192.168.0.252/folders.db

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT )] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT )
  Error in SQL EXEC statement: CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT ) [file is encrypted or is not a database].
  CamelException.set(0xb66660a8, 2, 'file is encrypted or is not a database')
  DB Operation ended. Time Taken : 0.000386
  ###########

  (evolution:4812): camel-WARNING **: something went wrong terribly
  during db creation

  
  Database succesfully closed 

  Database succesfully opened

  ===========
  DB SQL operation [(null)] started
  Camel SQL Exec:
  (null)
  DB Operation ended. Time Taken : 0.000047
  ###########

  ===========
  DB SQL operation [ATTACH DATABASE ':memory:' AS mem] started
  Camel SQL Exec:
  ATTACH DATABASE ':memory:' AS mem
  DB Operation ended. Time Taken : 0.002168
  ###########
  store_db_path /home/dllann/.evolution/mail/vfolder/folders.db

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT )] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS folders ( folder_name TEXT PRIMARY KEY, version REAL, flags INTEGER, nextuid INTEGER, time NUMERIC, saved_count INTEGER, unread_count INTEGER, deleted_count INTEGER, junk_count INTEGER, visible_count INTEGER, jnd_count INTEGER, bdata TEXT )
  DB Operation ended. Time Taken : 0.000093
  ###########

  Database succesfully opened

  ===========
  DB SQL operation [(null)] started
  Camel SQL Exec:
  (null)
  DB Operation ended. Time Taken : 0.000151
  ###########

  ===========
  DB SQL operation [ATTACH DATABASE ':memory:' AS mem] started
  Camel SQL Exec:
  ATTACH DATABASE ':memory:' AS mem
  DB Operation ended. Time Taken : 0.001344
  ###########

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS 'UNMATCHED' (  vuid TEXT PRIMARY KEY)] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS 'UNMATCHED' (  vuid TEXT PRIMARY KEY)
  DB Operation ended. Time Taken : 0.000125
  ###########

  ===========
  DB SQL operation [CREATE INDEX IF NOT EXISTS 'VINDEX-UNMATCHED' ON 'UNMATCHED' (vuid)] started
  Camel SQL Exec:
  CREATE INDEX IF NOT EXISTS 'VINDEX-UNMATCHED' ON 'UNMATCHED' (vuid)
  DB Operation ended. Time Taken : 0.000075
  ###########

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = 'UNMATCHED' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = 'UNMATCHED'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.000359
  ###########

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS 'Unmatched' (  vuid TEXT PRIMARY KEY)] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS 'Unmatched' (  vuid TEXT PRIMARY KEY)
  DB Operation ended. Time Taken : 0.000073
  ###########

  ===========
  DB SQL operation [CREATE INDEX IF NOT EXISTS 'VINDEX-Unmatched' ON 'Unmatched' (vuid)] started
  Camel SQL Exec:
  CREATE INDEX IF NOT EXISTS 'VINDEX-Unmatched' ON 'Unmatched' (vuid)
  DB Operation ended. Time Taken : 0.000075
  ###########
  Thread 0 >
  Get folder info(0x9e77010:vfolder:/home/dllann/.evolution/mail/vfolder, '<null>') =
    uri: vfolder:/home/dllann/.evolution/mail/vfolder#UNMATCHED
    full_name: UNMATCHED
    flags: 0000006a
  < 0 >
  Thread 0 >
  Get folder info(0x9e77010:vfolder:/home/dllann/.evolution/mail/vfolder, '<null>') =
    uri: vfolder:/home/dllann/.evolution/mail/vfolder#UNMATCHED
    full_name: UNMATCHED
    flags: 0000006a
  < 0 >
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('Sent', 0) = 0x9f699f0
  < 0 >

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS '.#evolution/Trash' (  vuid TEXT PRIMARY KEY)] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS '.#evolution/Trash' (  vuid TEXT PRIMARY KEY)
  DB Operation ended. Time Taken : 0.000144
  ###########

  ===========
  DB SQL operation [CREATE INDEX IF NOT EXISTS 'VINDEX-.#evolution/Trash' ON '.#evolution/Trash' (vuid)] started
  Camel SQL Exec:
  CREATE INDEX IF NOT EXISTS 'VINDEX-.#evolution/Trash' ON '.#evolution/Trash' (vuid)
  DB Operation ended. Time Taken : 0.000114
  ###########

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = '.#evolution/Trash' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = '.#evolution/Trash'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.000560
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'AY4I8X6j%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'AY4I8X6j%'] started
  DB Operation ended. Time Taken : 0.000392
  ###########
  sexp is : [(match-all (system-flag "Deleted"))]
  Equivalent sql SELECT uid FROM 'Drafts' WHERE (deleted = 1)

  camel_db_select:
  SELECT uid FROM 'Drafts' WHERE (deleted = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Drafts' WHERE (deleted = 1)] started
  DB Operation ended. Time Taken : 0.000435
  ###########
  vee_rebuild_folder(.#evolution/Trash <- Drafts AY4I8X6j): match 0, correlating 0, rebuilded 1

  ===========
  DB SQL operation [BEGIN] started
  Camel SQL Exec:
  BEGIN
  Camel SQL Exec:
  COMMIT
  DB Operation ended. Time Taken : 0.000133
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'M.DTnCDr%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'M.DTnCDr%'] started
  DB Operation ended. Time Taken : 0.000253
  ###########
  sexp is : [(match-all (system-flag "Deleted"))]
  Equivalent sql SELECT uid FROM 'Templates' WHERE (deleted = 1)

  camel_db_select:
  SELECT uid FROM 'Templates' WHERE (deleted = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Templates' WHERE (deleted = 1)] started
  DB Operation ended. Time Taken : 0.000220
  ###########
  vee_rebuild_folder(.#evolution/Trash <- Templates M.DTnCDr): match 0, correlating 0, rebuilded 1

  ===========
  DB SQL operation [BEGIN] started
  Camel SQL Exec:
  BEGIN
  Camel SQL Exec:
  COMMIT
  DB Operation ended. Time Taken : 0.000110
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'gs1fxbvK%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'gs1fxbvK%'] started
  DB Operation ended. Time Taken : 0.000225
  ###########
  sexp is : [(match-all (system-flag "Deleted"))]
  Equivalent sql SELECT uid FROM 'Outbox' WHERE (deleted = 1)

  camel_db_select:
  SELECT uid FROM 'Outbox' WHERE (deleted = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Outbox' WHERE (deleted = 1)] started
  DB Operation ended. Time Taken : 0.000188
  ###########
  vee_rebuild_folder(.#evolution/Trash <- Outbox gs1fxbvK): match 0, correlating 0, rebuilded 1

  ===========
  DB SQL operation [BEGIN] started
  Camel SQL Exec:
  BEGIN
  Camel SQL Exec:
  COMMIT
  DB Operation ended. Time Taken : 0.000110
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE '7.gDauh7%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE '7.gDauh7%'] started
  DB Operation ended. Time Taken : 0.000212
  ###########
  sexp is : [(match-all (system-flag "Deleted"))]
  Equivalent sql SELECT uid FROM 'Inbox' WHERE (deleted = 1)

  camel_db_select:
  SELECT uid FROM 'Inbox' WHERE (deleted = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Inbox' WHERE (deleted = 1)] started
  DB Operation ended. Time Taken : 0.000363
  ###########
  vee_rebuild_folder(.#evolution/Trash <- Inbox 7.gDauh7): match 0, correlating 0, rebuilded 1

  ===========
  DB SQL operation [BEGIN] started
  Camel SQL Exec:
  BEGIN
  Camel SQL Exec:
  COMMIT
  DB Operation ended. Time Taken : 0.000309
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'qPXQuTsk%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Trash' WHERE vuid LIKE 'qPXQuTsk%'] started
  DB Operation ended. Time Taken : 0.000389
  ###########
  sexp is : [(match-all (system-flag "Deleted"))]
  Equivalent sql SELECT uid FROM 'Sent' WHERE (deleted = 1)

  camel_db_select:
  SELECT uid FROM 'Sent' WHERE (deleted = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Sent' WHERE (deleted = 1)] started
  DB Operation ended. Time Taken : 0.000805
  ###########
  vee_rebuild_folder(.#evolution/Trash <- Sent qPXQuTsk): match 0, correlating 0, rebuilded 1

  ===========
  DB SQL operation [BEGIN] started
  Camel SQL Exec:
  BEGIN
  Camel SQL Exec:
  COMMIT
  DB Operation ended. Time Taken : 0.000176
  ###########
  Thread 0 >
  CamelStore('mbox:/home/dllann/.evolution/mail/local'):get_folder('.#evolution/Trash', 0) = 0xa631400
  < 0 >

  ===========
  DB SQL operation [CREATE TABLE IF NOT EXISTS '.#evolution/Junk' (  vuid TEXT PRIMARY KEY)] started
  Camel SQL Exec:
  CREATE TABLE IF NOT EXISTS '.#evolution/Junk' (  vuid TEXT PRIMARY KEY)
  DB Operation ended. Time Taken : 0.000179
  ###########

  ===========
  DB SQL operation [CREATE INDEX IF NOT EXISTS 'VINDEX-.#evolution/Junk' ON '.#evolution/Junk' (vuid)] started
  Camel SQL Exec:
  CREATE INDEX IF NOT EXISTS 'VINDEX-.#evolution/Junk' ON '.#evolution/Junk' (vuid)
  DB Operation ended. Time Taken : 0.000178
  ###########

  camel_db_select:
  SELECT * FROM folders WHERE folder_name = '.#evolution/Junk' 

  ===========
  DB SQL operation [SELECT * FROM folders WHERE folder_name = '.#evolution/Junk'] started

  read_fir_callback called 
  DB Operation ended. Time Taken : 0.001401
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Junk' WHERE vuid LIKE 'AY4I8X6j%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Junk' WHERE vuid LIKE 'AY4I8X6j%'] started
  DB Operation ended. Time Taken : 0.000727
  ###########
  sexp is : [(match-all (system-flag "Junk"))]
  Equivalent sql SELECT uid FROM 'Drafts' WHERE (junk = 1)

  camel_db_select:
  SELECT uid FROM 'Drafts' WHERE (junk = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Drafts' WHERE (junk = 1)] started
  DB Operation ended. Time Taken : 0.000332
  ###########
  vee_rebuild_folder(.#evolution/Junk <- Drafts AY4I8X6j): match 0, correlating 0, rebuilded 1

  ===========
  DB SQL operation [BEGIN] started
  Camel SQL Exec:
  BEGIN
  Camel SQL Exec:
  COMMIT
  DB Operation ended. Time Taken : 0.000169
  ###########

  camel_db_select:
  SELECT vuid FROM '.#evolution/Junk' WHERE vuid LIKE 'M.DTnCDr%' 

  ===========
  DB SQL operation [SELECT vuid FROM '.#evolution/Junk' WHERE vuid LIKE 'M.DTnCDr%'] started
  DB Operation ended. Time Taken : 0.001491
  ###########
  sexp is : [(match-all (system-flag "Junk"))]
  Equivalent sql SELECT uid FROM 'Templates' WHERE (junk = 1)

  camel_db_select:
  SELECT uid FROM 'Templates' WHERE (junk = 1) 

  ===========
  DB SQL operation [SELECT uid FROM 'Templates' WHERE (junk = 1)] started
  DB Operation ended. Time Taken : 0.000332
  ###########
  vee_rebuild_folder(.#evolution/Junk <- Templates M.DTnCDr): match 0, correlating 0, rebuilded 1

To manage notifications about this bug go to:
https://bugs.launchpad.net/evolution/+bug/604846/+subscriptions