Mystery cyrus/lmtp and cyrus/imap DBERROR log entries

[Andy Dorman]

On 03/16/2015 10:08 AM, Patrick Boutilier wrote:
> On 03/16/2015 11:57 AM, Andy Dorman wrote:
>> Hi, I am relatively new to Cyrus...we have been using it for many years,
>> but I have only recently been given the job of administering it.
>>
>> We are using the Debian Cyrus package, 2.4.17.  Everything as far as
>> mail storage and delivery from the user perspective is working great.
>>
>> However, I have noticed DBERROR log entries have been happening for
>> months (possibly longer, our detailed syslogs only go back 6 months).
>>
>> I am concerned that there might be a problem, but if not then I would
>> like to clean up the log entries.
>>
>> 2015-03-16T08:28:18.024064-05:00 yorick cyrus/lmtp[2219]: DBERROR db5:
>> /var/lib/cyrus/db/__db.001: No such file or directory
>> 2015-03-16T08:28:18.024159-05:00 yorick cyrus/lmtp[2219]: DBERROR:
>> dbenv->open '/var/lib/cyrus/db' failed: No such file or directory
>> 2015-03-16T08:28:18.024182-05:00 yorick cyrus/lmtp[2219]: DBERROR:
>> init() on berkeley
>> 2015-03-16T08:28:18.024211-05:00 yorick cyrus/lmtp[2219]: DBERROR:
>> reading /var/lib/cyrus/db/skipstamp, assuming the worst: No such file or
>> directory
>> 2015-03-16T08:28:18.024234-05:00 yorick cyrus/lmtp[2219]: executed
>>
>> 2015-03-16T09:15:20.607017-05:00 yorick cyrus/imap[3716]: DBERROR db5:
>> /var/lib/cyrus/db/__db.001: No such file or directory
>> 2015-03-16T09:15:20.607183-05:00 yorick cyrus/imap[3716]: DBERROR:
>> dbenv->open '/var/lib/cyrus/db' failed: No such file or directory
>> 2015-03-16T09:15:20.607227-05:00 yorick cyrus/imap[3716]: DBERROR:
>> init() on berkeley
>> 2015-03-16T09:15:20.607281-05:00 yorick cyrus/imap[3716]: DBERROR:
>> reading /var/lib/cyrus/db/skipstamp, assuming the worst: No such file or
>> directory
>> 2015-03-16T09:15:20.607334-05:00 yorick cyrus/imap[3716]: executed
>>
>> Based on the 3rd line of each block of errors this looks like a BDB
>> (berkeley db) problem...but I checked our imapd.conf and the previous
>> admin switched everything to skiplist in July 2010 as shown by the
>> snippet below from our imapd.conf.  FWIW, it appears he left one BDB
>> setting in place accidentally, but I would think that would not make a
>> difference since we no longer use BDB.
>>
>> ----- snippets from imapd.conf -----
>> # Use skiplist everywhere
>> annotation_db: skiplist
>> ...
>> berkeley_cachesize: 1024
>> ...
>> # Use skiplist everywhere
>> annotation_db: skiplist
>> ...
>> # Set our quota properly
>> quota_db: skiplist
>> ...
>> # Use skiplist everywhere
>> statuscache_db: skiplist
>>
>> # Use skiplist everywhere
>> tlscache_db: skiplist
>>
>> # Use skiplist everywhere
>> userdeny_db: skiplist
>> ----- end snippets from imapd.conf -----
>>
>> As far as the /var/lib/cyrus/ directory, there is indeed no db
>> sub-directory, but everything else appears to be in order as far as I
>> can tell.
>>
>> drwxr-x--- 12 cyrus mail   4096 Mar 16 09:37 .
>> drwxr-xr-x 49 root  root   4096 Oct 20 14:54 ..
>> -rw-------  1 cyrus mail    144 Mar 16 09:37 annotations.db
>> drwx------  2 cyrus mail   4096 Mar 16 09:11 db.backup1
>> drwx------  2 cyrus mail   4096 Mar 16 08:41 db.backup2
>> -rw-------  1 cyrus mail 114220 Mar 16 09:37 deliver.db
>> drwx------  9 cyrus mail   4096 Feb 15 01:56 domain
>> drwx------ 29 cyrus mail   4096 Apr 27  2011 lock
>> drwx------  2 cyrus mail   4096 Jul 12  2010 log
>> -rw-------  1 cyrus mail   9280 Mar 16 09:37 mailboxes.db
>> drwx------  2 cyrus mail   4096 Nov 15  2007 msg
>> drwx------  2 cyrus mail   4096 Nov 11 10:59 proc
>> drwx------ 28 cyrus mail   4096 Nov 15  2007 quota
>> -rw-------  1 cyrus mail    608 Mar 16 09:37 quotas.db
>> drwxr-x---  2 cyrus mail   4096 Sep 12  2008 socket
>> -rw-------  1 cyrus mail    144 Mar 16 09:37 statuscache.db
>> -rw-------  1 cyrus mail    144 Mar 16 09:37 tls_sessions.db
>> drwx------ 29 cyrus mail   4096 Sep 22  2009 user
>> -rw-------  1 cyrus mail    144 Mar 16 09:37 user_deny.db
>>
>>
>> So, my questions are:
>>
>> 1. Do we actually have a problem here?  If so, then I can certainly
>> create a db sub-directory for BDB to work in, but then I wonder why do
>> we need to if we are no longer using BDB?
>>
>> 2. If we do not have a problem, then what can I change in our
>> configuration to let cyrus know it no longer needs to worry with a db
>> sub-directory for BDB (assuming this IS a BDB issue of course)?
>>
>> I have searched the mailing list archives, Googled for info and studied
>> the imapd.conf man pages and have not found an answer.  It would be
>> appreciated if anyone in this list knows what is going on or can at
>> least point me in the right direction.
>>
>> Thanks,
>>
>
>
> I think you have to compile with --without-bdb to completely get rid of
> BDB. I doubt the Debian packages would be compiled in such a way.
>
>

Thank you.  That makes sense and explains why the previous administrator 
did not worry about these errors.

It would be nice to not have to garbage up the logs with them though...I 
will do some investigating in Debian to see if there is any traction for 
a Debian package compiled without BDB.

Thank you again,

-- 
Andy Dorman