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
> DBmail@dbmail.org
> http://lists.nfg.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://lists.nfg.nl/mailman/listinfo/dbmail
