Postfix default mailbox_size_limit is causing Bogofilter database corruption

[David Relson]

On Wed, 14 Jan 2004 15:59:29 +0300
Sergii Laskavyi <ls+bogofilter.aotto.comede53b7f at gambit.com.ru> wrote:

> >> When trying to run bogofilter 0.15.13.1 with "-u -e -p"
> >> options from maildrop 1.6.3 from postfix 2.0.16,1 under
> >> FreeBSD 4.9-STABLE i386, I'm getting error messages:
> >>
> >>   1. when using db4-4.0.14_1,1:
> >>     (db) db_get_dbvalue( 'head:X-Original-To' ), err: -30988,
> >>     DB_PAGE_NOTFOUND: Requested page not found
> >>
> >>   2. when using qdbm-1.7.26:
> >>     (qdbm) db_set_dbvalue( 'ABSNET' ), err: 1
> >>     (qdbm) dpclose for wordlist.qdbm failed: with fatal error
> >>
> >> How can I localize the problem?
> 
> David Relson wrote:
> > What's your file size limit when running postfix?  
> > Try postconf -e mailbox_size_limit=73000000
> 
> Looks like it solved the problem. David Relson, thank you!
> 
> So the default postfix mailbox_size_limit value 51200000 does not
> allow bogofilter to work (confirmed by other Postfix + Bogofilter
> users).
> 
> Dear Wietse Venema, is it possible to change the Postfix default
> and/or describe this problem in Postfix and/or Bogofilter FAQ?

Sergii,

I'll add an entry to the FAQ - something like 

"Why am I getting DB_PAGE_NOTFOUND messages?"

You have a problem with your BerkeleyDB database.  There are two likely
causes:  either you've hit a max size limit or the database is corrupt.

Mail delivery agents, like postfix, have a file size limit.  When
bogofilter's database reaches that limit problems occur.  Command "ls
-lh /your/path/wordlist.db" will show the database size.  Command
"postconf | grep mailbox_size_limit" will show the postfix setting.  
Use "postconf -e mailbox_size_limit=73000000" to set it to 73MB (or
whatever size is right for you).

If you think your database may be corrupt, read the "How can I tell if
my wordlists are corrupted?" FAQ entry.

David