Re: db_archive: DB_ENV->log_archive: DB_NOTFOUND: No matching key/data pair found

[Buchan Milne <bgmilne@staff.telkomsa.net>]

On Wednesday 01 July 2009 12:05:12 Andreas Krummrich wrote:
> Hi Jonathan,
>
> > -----Original Message-----
> > From: openldap-technical-bounces+andreas=krummrich.org@OpenLDAP.org
> > [mailto:openldap-technical-bounces+andreas=krummrich.org@OpenLDAP.org]
> > On Behalf Of Jonathan Clarke
> > Sent: Wednesday, July 01, 2009 11:10 AM
> > To: andreas@krummrich.org
> > Cc: openldap-technical@openldap.org
> > Subject: Re: db_archive: DB_ENV->log_archive: DB_NOTFOUND: No matching
> > key/data pair found
> >
> > Hi Andreas,
> >
> > On 30/06/2009 16:42, Andreas Krummrich wrote:
> > > I'm running OpenLDAP 2.4.11 on a debian lenny box and it seems that
> >
> > I'm
> >
> > > having trouble with the log files. I had a corrupt database some days
> >
> > ago
> >
> > > and needed to restore the database from the backup. The log said:
> > >
> > > Jun 28 01:16:59 old slapd[17374]: bdb_db_open: database
> > > "dc=intern,dc=domain,dc=de" cannot be recovered, err -30978. Restore
> >
> > from
> >
> > > backup!
> > >
> > > So I installed a new OpenLDAP server with the same versions and the
> >
> > same
> >
> > > configuration. The first thing what I found out was that db_archive
> >
> > has some
> >
> > > trouble:
> > >
> > > On the new box I get the following results from db_archive:
> > >
> > > root@new:/var/lib/ldap# db4.2_archive -sa
> > > /var/lib/ldap/cn.bdb
> > > /var/lib/ldap/dn2id.bdb
> > > /var/lib/ldap/gidNumber.bdb
> > > /var/lib/ldap/givenName.bdb
> > > /var/lib/ldap/id2entry.bdb
> > > /var/lib/ldap/loginShell.bdb
> > > /var/lib/ldap/objectClass.bdb
> > > /var/lib/ldap/sn.bdb
> > > /var/lib/ldap/uid.bdb
> > > /var/lib/ldap/uidNumber.bdb
> > > root@new:/var/lib/ldap# db4.2_archive -la
> > > /var/lib/ldap/log.0000000001
> > > root@new:/var/lib/ldap#
> > >
> > > Looks good so far. On the old box I get the following results (there
> >
> > are the
> >
> > > same databases)
> > >
> > > root@new:/var/lib/ldap# db4.2_archive -sa
> > > root@new:/var/lib/ldap# db4.2_archive -la
> > > db_archive: DB_ENV->log_archive: DB_NOTFOUND: No matching key/data
> >
> > pair
> >
> > > found
> > > root@new:/var/lib/ldap#
> >
> > If I understand correctly, your new box works fine, and your old box
> > gives you the error "No matching key/data pair found"? (should be
> > root@old above, then?)
>
> Right.
>
> > Have you restored the database from backup on your old box aswell? This
> > would involve something like rm /var/lib/ldap/* (but save DB_CONFIG),
> > then a slapadd.
>
> Yes, I had to restore the db last weekend. I removed everything under
> /var/lib/ldap and restored the db with slapadd. But the error still exists.
>
> This is what I can see in /var/log/syslog, for example:
>
> Jul  1 11:54:28 old slapd[2169]: <= bdb_dn2id: get failed: DB_NOTFOUND: No
> matching key/data pair found (-30990)
>
> Now one interesting point. I restored the backup from the old box to the
> new box this morning and it works fine there. No errors. Db42_archive works
> well and I can archive and remove the logs.

I am not satisfied that we know how you restored. You should have:

1)(Re)moved all the contents from /var/lib/ldap, except for the DB_CONFIG file, 
including the database environment (__db*), database files (*.bdb), and 
transaction logs (log.*)

2)Run slapadd with the ldif export you had from backup

3)Ensure permissions/ownership are correct on the directory and all the files 
(the user running slapd must have write access to all).

Please tell us what the exact process was that you used to restore.

Regards,
Buchan