Issue with SQL lookups

Fred Smith amavis45 at
Tue Dec 11 14:12:29 CET 2018

I'm running amavisd-new 2.11.1 and using SQL for lookups.

The problem was discovered when large emails were being bounced when 
there is an SQL entry for the email address that should allow the large 

In general I define a domain default SQL entry for to cover 
all email addresses not otherwise defined. For large mails I create, for 
example, an entry for big.mail at

I'm seeing multiple lookups, for email=>"" and 
email=>"big.mail at" and amavis is proceeding with the results 
from the email=>"" and hence the wrong details.

I've tried changing the ID order in case the lookup was positionally 
related. But this made no difference.

Lookup logs at

More information about the amavis-users mailing list