Public bug reported: 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.l...@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 ** Affects: evolution (Ubuntu) Importance: Undecided Status: New -- Error receiving email "File is encrypted or is not a database" https://bugs.launchpad.net/bugs/604846 You received this bug notification because you are a member of Ubuntu Desktop Bugs, which is subscribed to evolution in ubuntu. -- desktop-bugs mailing list desktop-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/desktop-bugs