Re: Sporadic relay failures using a hash in mynetworks.

[wietse@xxxxxxxxxxxxx (Wietse Venema)]

Josef Karthauser:

Checking application/pgp-signature: FAILURE
-- Start of PGP signed section.
> On Sun, Oct 17, 2004 at 12:12:17PM +0100, Josef Karthauser wrote:
> > 
> > Ok, I've done that.  It appears that the hash lookup is failing
> > periodically,
> > 
> > Oct 15 03:05:37 jonah postfix/smtpd[78064]: match_hostaddr: 80.0.157.230 ~? hash:/usr/local/etc/postfix/mynetworks(0,100)
> > Oct 15 03:05:37 jonah postfix/smtpd[78064]: dict_lookup: 80.0.157.230 = dynamic
> > 
> > Oct 15 13:01:57 jonah postfix/smtpd[45485]: match_hostaddr: 80.0.157.230 ~? hash:/usr/local/etc/postfix/mynetworks(0,100)
> > Oct 15 13:01:57 jonah postfix/smtpd[45485]: dict_lookup: 80.0.157.230 = (notfound)
> > 
> > And yet the mynetworks file hasn't been changed at all:
> > 
> > % ls -l /usr/local/etc/postfix/mynetworks*
> > -rw-r--r--  1 root  wheel     83 Oct  1 20:56 /usr/local/etc/postfix/mynetworks
> > -rw-r--r--  1 root  wheel  65536 Oct  1 20:57 /usr/local/etc/postfix/mynetworks.db
> > 
> > There appears to be a bug here. :(
> > 
> 
> Just a follow up.  The .db files are 1.85 berkeley hashes as created
> using postmap:
> 
> jonah% file mynetworks.db 
> mynetworks.db: Berkeley DB 1.85 (Hash, version 2, native byte-order)
> jonah% file virtual.db 
> virtual.db: Berkeley DB 1.85 (Hash, version 2, native byte-order)
> 
> I don't see any evidence that the virtual.db map is failing at all so I
> am reluctant to think that it a problem in the db lookup code.

Consider how few lines of Postfix code are between the logging of the
following lines:

> Oct 15 13:01:57 jonah postfix/smtpd[45485]: match_hostaddr: 80.0.157.230 ~? hash:/usr/local/etc/postfix/mynetworks(0,100)
> Oct 15 13:01:57 jonah postfix/smtpd[45485]: dict_lookup: 80.0.157.230 = (notfound)

Consider that that same Postfix code does all access DB file lookups.

Consider that the same Postfix DB module is used for all DB file lookups.

Consider that no-one else is experiencing this.  

Consider that I run Postfix on FreeBSD too.

I think it is a site specific problem.

	Wietse