Hello
One of our users can't read his mails anymore, he always gets an IMAP
timeout. Unfortunately I forgot to install the dbmail-util cronjob when I
reinstalled the box after a HD crash. Now after running it 3 times
(dbmail-util -cturpd -l 24h) most of the 'zombie' messages are gone, but
that one user still has >5000 messages with status 1 as shown by the SQL
script below.
What can I do to solve this problem?
I'm running dbmail 2.0.10 on postgresql 7.4.3.
Martin
select
m.status, u.userid, b.name as foldername,
count(m.message_idnr) as msgcount, sum(p.blocksize) as totsize
from
dbmail_users u, dbmail_mailboxes b, dbmail_messages m,
(
select p.id as physmessage_id, sum(l.blocksize) as blocksize
from dbmail_physmessage p, dbmail_messageblks l
where p.id = l.physmessage_id
group by p.id
) p
where
u.user_idnr = b.owner_idnr and
b.mailbox_idnr = m.mailbox_idnr and
m.status != 0 and
m.physmessage_id = p.physmessage_id
group by m.status, u.userid, b.name
order by m.status, u.userid, b.name;
status | userid | foldername | msgcount | totsize
--------+--------+------------+----------+-------------
1 | alekko | INBOX | 5985 | 15762730690
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
