Re: Not Deleting Mail

Do this: 

SELECT user_idnr FROM dbmail_users WHERE userid = "YOUR EMAIL ADDRESS" 

Write down the corresponding ID 

SELECT mailbox_idnr, name FROM dbmail_mailboxes WHERE owner_idnr = <THE
ID YOU GOT FROM THE PREVIOUS SELECT> 

Find the ID of your mailbox. 

DELETE FROM dbmail_messages WHERE mailbox_idnr = <THE ID OF THE MAILBOX
YOU JUST FOUND OUT> 

Done. 

dbmail-util -ay will take care of cleaning out everything else later
(mimeparts, headers, etc), don't worry. 

Enjoy. 

---

Andrea Brancatelli

On 2018-01-24 16:47, rich carroll wrote:

> Howdy Folks, 
> 
> I have a mailbox that I used for testing. It has about 300,000 messages in it. I can not open it in webmail. I am trying to empty it out. 
> 
> I have ran: 
> 
> dbmail-users -e <user> -y 
> 
> It looks like its doing something for a bit but nothing gets removed from the box. 
> 
> I am currently trying to pop them into thunderbird to see if that will remove them although that is moving very slow. It gets a message every couple seconds or so. 
> 
> When I run: 
> 
> dbmail-util -pd 
> 
> It tells me: 
> Ok. [3933954] messages have DELETE status.
> 
> but dbmail-util -pdy does not clean them out. 
> 
> I am wondering if I have a problem. Is there another way to ensure messages get deleted and to emtpy mailboxes? 
> 
> Im running dbmail 3.2.3. 
> 
> I am seeing alot of this in my logs. 
> 
> Jan 24 09:44:26 mail2017 dbmail/imap4d[103602]: Error:[db] db_exec(+389): failed query [UPDATE dbmail_messages SET status=2 WHERE message_idnr=92134366 ]
> Jan 24 09:44:26 mail2017 dbmail/imap4d[103602]: Error:[db] db_exec(+388): SQLException: ERROR:  current transaction is aborted, commands ignored until end of transaction 
> 
> and I have a dbmail-imapd process that is really working hard. 
> 
> -- 
> Richard Carroll 
> 
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://lists.nfg.nl/mailman/listinfo/dbmail

_______________________________________________
DBmail mailing list
[email protected]
http://lists.nfg.nl/mailman/listinfo/dbmail