http://qs321.pair.com?node_id=976889

mobiusinversion has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks,

I have a caching daemon and several apache mpm_worker processes which connect to a BDB via CHI. These proceses are designed to run for long periods of time without restart as part of a larger web site. After these processes have been running for two weeks or so, I seem to run into this problem when trying to connect to the BDB:
"cannot open Berkeley DB file 'Default.db' in environment '/dev/shm/ca +che/bdb': Lock table is out of available locker entries at '/home/use +r/perl5/lib/perl5/CHI/Driver/BerkeleyDB.pm line 49."
A few Google searches havent really seemed to provide any useful answers or solutions.

The new constructor I'm using for CHI is:
our $chi = CHI->new( driver => 'BerkeleyDB', root_dir => '/dev/shm/cache/bdb', serializer => 'Storable', l1_cache => { driver => 'RawMemory', global => 1, max_size => 2 ** 15, } );
I've also tried the following based on some best guesses how to fix this:
sub _build_chi { my $root_dir = '/dev/shm/cache/bdb'; CHI->new( driver => 'BerkeleyDB', root_dir => $root_dir, serializer => 'Storable', env => BerkeleyDB::Env->new( '-Home' => $root_dir, '-Config' => {}, '-Flags' => DB_CREATE | DB_INIT_CDB | DB_INIT_MPOOL '-LockDetect' => DB_LOCK_OLDEST, ) ); }
But still encounter this issue. I'm guessing this is happening because there are some locks that are being created but not freed up from these long running processes, but I do not know enough about Berekeley DB or the BerkeleyDB Perl extension to know how to solve this. Are there any BDB wizards out there that have encountered this before? Any help is appreciated.