Can not release quarantined mail

[Mark Martinec]

Christian,

> I have (some) false-positive mail in virus quarantine, which I would
> like to release. I tried:
> 
> amavisd-release s91w1PPZQWPr
> 
> And got:
> 
> 450 4.5.0 Failure: Can't open sql obj for reading: No such file or
> directory at (eval 122) line 362, <GEN51> line 4.
> 
> In mail.log I see lines like this:
> 
> Aug  2 13:55:33 mx0 amavis[31847]: (rel-s91w1PPZQWPr)
> Amavis::IO::SQL::open key=s91w1PPZQWPr, p_tag=0: no such record
> Aug  2 13:55:33 mx0 amavis[31847]: (rel-s91w1PPZQWPr) (!!)policy_server
> FAILED: Can't open sql obj for reading: No such file or directory at
> (eval 122) line 362, <GEN51> line 4.

> I use postgres 9.0.4 with amavisd-2.7.0

Apparently this record does not exist in a database.
Perhaps it is stored under a different partition tag.

Check it manually:

select partition_tag, encode(mail_text,'escape') from quarantine
  where mail_id='s91w1PPZQWPr' order by chunk_ind asc;


> Here are my amavis config options that I use.
> [...]
> I put spam and banned files to sql: Only virus mail go to flat files, as
> I currently have no web interface to surf through the SQL stored
> messages. Using Sanesecurity has some false positives, which I want to
> release, if possible,

Such mix should be alright.

  Mark