How to 'purge' clean email from quarantine?

Danilo Godec <[email protected]> Thu, 22 Oct 2020 15:53:15 +0200

Newsgroups	gmane.mail.virus.amavis.user
Organization	Agenda d.o.o.
Message-ID	<[email protected]>

Hello,

I accidentally had /$clean_quarantine_method = 'sql:';/ in amavisd.conf
for far too long, so now I have a huge quarantine table...

How to best remove clean messages from quarantine?

I was thinking to go through quarantine.mail_id  and if msgrcpt.ds for
that mail_id is never anything other than 'P' (passed), I can delete
that record from quarantine.


Am I missing something?


   Danilo