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
mail.
In general I define a domain default SQL entry for @example.com to cover
all email addresses not otherwise defined. For large mails I create, for
example, an entry for [email protected].
I'm seeing multiple lookups, for email=>"@example.com" and
email=>"[email protected]" and amavis is proceeding with the results
from the email=>"@example.com" 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 https://pastebin.com/nRE8C7uH