Unread count in database not consistend
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Evolution |
Fix Released
|
High
|
|||
evolution (Ubuntu) |
Invalid
|
Low
|
Ubuntu Desktop Bugs |
Bug Description
Binary package hint: evolution
I'm using Evolution 2.26.1-0ubuntu1 on Ubuntu 9.04 as IMAP client. The IMAP server runs Courier IMAP on Debian.
The unread_count in the database is often not in sync with the server and the state on disk.
An example:
$ sqlite3 folders.db
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .headers ON
sqlite> .mode line folders
sqlite> SELECT * FROM folders WHERE folder_
folder_name = INBOX/mysql
version = 14.0
flags = 0
nextuid = 0
time = 0
saved_count = 2
unread_count = 2
deleted_count = 0
junk_count = 0
visible_count = 2
jnd_count = 0
bdata = 3 1239302115
sqlite> .quit
$ cd folders/
$ ls -l
total 4
-rw-r--r-- 1 dveeden dveeden 183 2009-05-13 17:24 cmeta
-rw-r--r-- 1 dveeden dveeden 0 2009-05-13 17:27 journal
$
The GUI shows this:
folders: "mysql(2)"
message list: "There are no messages in this folder"
The server:
$ cd Maildir/.mysql/
$ find .
.
./tmp
./new
./cur
./maildirfolder
./courierimapacl
./courierimapuiddb
./courierimapke
$
1. The GUI should update the database if the message count in the database is not 0 and there are no messages in the folder to display.
This happens mostly when I delete (but not expunge) mail using Evolution, then expunge using some other application.
It does not update when I click refresh in the context menu of the folder. Connect/Disconnect also doesn't solve the issue.
It does update when I receive new mail in that folder.
Changed in evolution: | |
status: | Unknown → New |
Changed in evolution: | |
status: | Unknown → Confirmed |
Changed in evolution: | |
importance: | Unknown → High |
Changed in evolution: | |
status: | Confirmed → Incomplete |
Changed in evolution: | |
status: | Incomplete → Fix Released |
Changed in evolution: | |
status: | Fix Released → Confirmed |
Changed in evolution: | |
status: | Confirmed → Fix Released |
To reproduce:
1. evolution --force-shutdown name='Some/ Foldername' ;
2. sqlite3 /path/to/folders.db
3. UPDATE folders SET unread_count='100' WHERE folder_
4. Start evolution
5. New mail count is wrong
6. Send email to that mailbox to fix.