Bug 624637 – Error while Fetching Mail, file is encrypted or is not a database

After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.

Bug 624637 - Error while Fetching Mail, file is encrypted or is not a database


Summary:	Error while Fetching Mail, file is encrypted or is not a database


Status:	RESOLVED FIXED

Product:	evolution
Classification:	Applications
Component:	general
Version:	2.28.x (obsolete)
Hardware:	Other Linux

Importance:	Normal major
Target Milestone:	---
Assigned To:	Evolution Shell Maintainers Team
QA Contact:	Evolution QA team

URL:
Whiteboard:

Duplicates:	624639 (view as bug list)
Depends on:
Blocks:

Reported:	2010-07-17 21:20 UTC by David Lann
Modified:	2012-01-24 22:17 UTC

See Also:
GNOME target:	---
GNOME version:	---

Description David Lann 2010-07-17 21:20:48 UTC

System Ubuntu 10.04 with all current updates.
Evolution 2.28.3
I forced closed the PDF attachment print job. Shortly after I was unable to receive email. I CAN send emails, but CANNOT receive emails.  Each time 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 correctly.

How do I correct this issue?

Ran CAMEL_DEBUG=all evolution >& evo.log and received the following messages in the top 25% of the log. 

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

Comment 1 André Klapper 2010-07-18 09:08:43 UTC

*** Bug 624639 has been marked as a duplicate of this bug. ***

Comment 2 Ron Addie 2011-07-08 00:36:56 UTC

I am also experiencing this bug. When I click on "send/receive mail", the rcv mail operation fails with the message: 

"Error while fetching mail: file is encrypted or is not a database". 

I have tried moving index files (the ones associated with Inbox, and also folder.db) to force evolution to reconstruct them, but although evolution did reconstruct the index files, the problem remained. Any help would be appreciated.

Comment 3 André Klapper 2012-01-24 20:52:27 UTC

Ron / David:
Can you please check again whether this issue still happens in Evolution 3.0.3
or 3.2.2 and update this report by adding a comment and changing the "Version"
field? Thanks a lot.

Comment 4 David Lann 2012-01-24 22:17:15 UTC

I have not had any further issues such as this, and have now moved to 3.2.2 and have had very large emails that have caused me to shutdown Evolution.  As an update to my original issue, all or part of the issue was caused by an incomplete message filter.  I do not have a test system to attempt to duplicate the issue again.