You can wind up with a broken Berkeley environment without even any databases defined! I'm glad we've removed it entirely now :)
Bron.
On Mon, 13 Mar 2017, at 23:36, Kenneth Marshall wrote:
> On Mon, Mar 13, 2017 at 11:32:38AM +1100, Bron Gondwana wrote:
> > So everything is 2.4 defaults, which are:
> >
> > brong@wot:~/src/cyrus-imapd$ grep '_db"' lib/imapoptions
> > { "annotation_db", "skiplist", STRINGLIST("berkeley", "berkeley-hash", "skiplist")}
> > { "duplicate_db", "skiplist", STRINGLIST("berkeley", "berkeley-nosync", "berkeley-hash", "berkeley-hash-nosync", "skiplist", "sql")}
> > { "mboxkey_db", "skiplist", STRINGLIST("berkeley", "skiplist") }
> > { "mboxlist_db", "skiplist", STRINGLIST("flat", "berkeley", "berkeley-hash", "skiplist")}
> > { "ptscache_db", "skiplist", STRINGLIST("berkeley", "berkeley-hash", "skiplist")}
> > { "quota_db", "quotalegacy", STRINGLIST("flat", "berkeley", "berkeley-hash", "skiplist", "sql", "quotalegacy")}
> > { "seenstate_db", "skiplist", STRINGLIST("flat", "berkeley", "berkeley-hash", "skiplist")}
> > { "subscription_db", "flat", STRINGLIST("flat", "berkeley", "berkeley-hash", "skiplist")}
> > { "statuscache_db", "skiplist", STRINGLIST("berkeley", "berkeley-nosync", "berkeley-hash", "berkeley-hash-nosync", "skiplist") }
> > { "tlscache_db", "skiplist", STRINGLIST("berkeley", "berkeley-nosync", "berkeley-hash", "berkeley-hash-nosync", "skiplist", "sql")}
> > { "userdeny_db", "flat", STRINGLIST("flat", "berkeley", "berkeley-hash", "skiplist", "sql")}
> >
> > So you shouldn't have any berkeley databases at all. It should be perfectly safe to shut down Cyrus, delete the $confdir/db folder, and restart Cyrus.
> >
> > that's:
> >
> > rm -rf /var/lib/imap/db/
> >
> > While Cyrus is shut down :)
> >
> > (Normal warnings about backing up your stuff and making sure that Centos packages aren't doing something different with defaults than upstream)
> >
> > Cheers,
> >
> > Bron.
> >
> > On Mon, 13 Mar 2017, at 08:28, Nick Howitt wrote:
> > >
> > >
> > > On 12/03/2017 21:09, Patrick Boutilier wrote:
> > > > On 03/12/2017 02:24 PM, Nick Howitt wrote:
> > > >> Hi,
> > > >> I've been running cyrus-imap for a few years not. I am using 2.4.17-8 on
> > > >> ClearOS (a Centos derivative). I've been running with "delprune
> > > >> cmd="cyr_expire -E 1 -X 7 -D 7" at=0001" in cyrus.conf, but in the last
> > > >> week or so it has started segfaulting. I've tried moving the command to
> > > >> cron.daily "/usr/lib/cyrus-imapd/cyr_expire -E 1 -X 7 -D 7" but it still
> > > >> segfaulting.
> > > >>
> > > >> In /var/log/maillog I get:
> > > >> Mar 12 03:15:53 server cyr_expire[15065]: Repacking mailbox
> > > >> user.mail-ebay
> > > >> Mar 12 03:15:53 server master[15064]: setrlimit: Unable to set file
> > > >> descriptors limit to -1: Operation not permitted
> > > >> Mar 12 03:15:53 server master[15064]: retrying with 4096 (current max)
> > > >> Mar 12 03:15:53 server cyr_expire[15065]: Repacking mailbox
> > > >> user.mail-ebay.Drafts
> > > >> Mar 12 03:15:54 server cyr_expire[15065]: Repacking mailbox user.nick
> > > >> Mar 12 03:15:54 server cyr_expire[15065]: Repacking mailbox
> > > >> user.ourfamily
> > > >> Mar 12 03:15:54 server cyr_expire[15065]: Repacking mailbox
> > > >> user.ourfamily.Drafts
> > > >> Mar 12 03:15:54 server cyr_expire[15065]: Expunged 0 out of 9150
> > > >> messages from 57 mailboxes
> > > >> Mar 12 03:15:54 server cyr_expire[15065]: duplicate_prune: pruning back
> > > >> 0.00 days
> > > >> Mar 12 03:15:54 server ctl_cyrusdb[15068]: recovering cyrus databases
> > > >> Mar 12 03:15:55 server ctl_cyrusdb[15068]: skiplist: checkpointed
> > > >> /var/lib/imap/mailboxes.db (57 records, 4816 bytes) in 0 seconds
> > > >> Mar 12 03:15:55 server ctl_cyrusdb[15068]: skiplist: checkpointed
> > > >> /var/lib/imap/annotations.db (0 records, 144 bytes) in 0 seconds
> > > >> Mar 12 03:15:55 server ctl_cyrusdb[15068]: done recovering cyrus
> > > >> databases
> > > >> Mar 12 03:15:55 server master[15064]: unable to setsocketopt(IP_TOS):
> > > >> Operation not supported
> > > >> Mar 12 03:15:55 server ctl_cyrusdb[15073]: checkpointing cyrus databases
> > > >> Mar 12 03:15:55 server ctl_cyrusdb[15073]: done checkpointing cyrus
> > > >> databases
> > > >> Mar 12 03:15:55 server imaps[15075]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imap[15074]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imap[15078]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imap[15076]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imaps[15081]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imap[15080]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imaps[15077]: error sending to idled: 3
> > > >> Mar 12 03:15:55 server imaps[15079]: error sending to idled: 3
> > > >> Mar 12 03:15:56 server tls_prune[15071]: skiplist: checkpointed
> > > >> /var/lib/imap/tls_sessions.db (575 records, 122352 bytes) in 0 seconds
> > > >> Mar 12 03:15:56 server cyr_expire[15072]: skiplist: checkpointed
> > > >> /var/lib/imap/deliver.db (37 records, 5464 bytes) in 0 seconds
> > > >> Mar 12 03:15:56 server cyr_expire[15072]: Expunged 0 out of 9112
> > > >> messages from 57 mailboxes
> > > >> Mar 12 03:15:56 server cyr_expire[15072]: duplicate_prune: pruning back
> > > >> 3.00 days
> > > >> Mar 12 03:15:56 server cyr_expire[15072]: duplicate_prune: purged 0 out
> > > >> of 37 entries
> > > >>
> > > >> The "error sending to idled: 3" is probably a red herring as cyrus-imap
> > > >> has just restarted following a db backup, so earlier idled connections
> > > >> have broken.
> > > >>
> > > >> Correspondingly in /var/log/messages I get:
> > > >> Mar 12 03:15:56 server kernel: cyr_expire[15065]: segfault at
> > > >> 7f9c8a79be78 ip 00007f9c8a91c5ed sp 00007ffd44b51d38 error 4 in
> > > >> cyr_expire[7f9c8a8c9000+15c000]
> > > >>
> > > >> It may also be worth mentioning that on some nights, like the night
> > > >> before the segfault, in /var/log/maillog I see:
> > > >> Mar 11 03:42:09 server cyr_expire[3237]: Expunged 0 out of 9145 messages
> > > >> from 61 mailboxes
> > > >> Mar 11 03:42:09 server cyr_expire[3237]: duplicate_prune: pruning back
> > > >> 1.00 days
> > > >> Mar 11 03:42:11 server cyr_expire[3237]: duplicate_prune: purged 58 out
> > > >> of 147 entries
> > > >> Mar 11 03:45:39 server ctl_cyrusdb[25201]: checkpointing cyrus databases
> > > >> Mar 11 03:45:39 server ctl_cyrusdb[25201]: done checkpointing cyrus
> > > >> databases
> > > >> Mar 11 03:49:57 server master[31633]: exiting on SIGTERM/SIGINT
> > > >> Mar 11 03:50:58 server master[27624]: setrlimit: Unable to set file
> > > >> descriptors limit to -1: Operation not permitted
> > > >> Mar 11 03:50:58 server master[27624]: retrying with 4096 (current max)
> > > >> Mar 11 03:50:58 server cyr_expire[27625]: Repacking mailbox
> > > >> user.mail-ebay
> > > >> Mar 11 03:50:58 server cyr_expire[27625]: Repacking mailbox
> > > >> user.ourfamily
> > > >> Mar 11 03:50:59 server cyr_expire[27625]: Repacking mailbox
> > > >> user.ourfamily.Drafts
> > > >> Mar 11 03:50:59 server ctl_cyrusdb[27628]: recovering cyrus databases
> > > >> Mar 11 03:50:59 server ctl_cyrusdb[27628]: skiplist: checkpointed
> > > >> /var/lib/imap/mailboxes.db (61 records, 5148 bytes) in 0 seconds
> > > >> Mar 11 03:50:59 server ctl_cyrusdb[27628]: skiplist: checkpointed
> > > >> /var/lib/imap/annotations.db (0 records, 144 bytes) in 0 seconds
> > > >> Mar 11 03:50:59 server ctl_cyrusdb[27628]: done recovering cyrus
> > > >> databases
> > > >> Mar 11 03:50:59 server cyr_expire[27625]: Expunged 0 out of 9145
> > > >> messages from 61 mailboxes
> > > >> Mar 11 03:50:59 server cyr_expire[27625]: duplicate_prune: pruning back
> > > >> 0.00 days
> > > >> Mar 11 03:50:59 server master[27624]: unable to setsocketopt(IP_TOS):
> > > >> Operation not supported
> > > >> Mar 11 03:50:59 server ctl_cyrusdb[27633]: checkpointing cyrus databases
> > > >> Mar 11 03:50:59 server ctl_cyrusdb[27633]: done checkpointing cyrus
> > > >> databases
> > > >> Mar 11 03:51:00 server tls_prune[27631]: skiplist: checkpointed
> > > >> /var/lib/imap/tls_sessions.db (303 records, 64348 bytes) in 1 second
> > > >> Mar 11 03:51:00 server cyr_expire[27632]: skiplist: checkpointed
> > > >> /var/lib/imap/deliver.db (84 records, 12424 bytes) in 0 seconds
> > > >> Mar 11 03:51:00 server cyr_expire[27632]: Expunged 0 out of 9109
> > > >> messages from 61 mailboxes
> > > >> Mar 11 03:51:00 server cyr_expire[27632]: duplicate_prune: pruning back
> > > >> 3.00 days
> > > >> Mar 11 03:51:00 server tls_prune[27631]: tls_prune: purged 3 out of 303
> > > >> entries
> > > >> Mar 11 03:51:00 server cyr_expire[27632]: duplicate_prune: purged 0 out
> > > >> of 83 entries
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: duplicate_prune: purged 89 out
> > > >> of 89 entries
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: DBERROR db5: BDB1581 File
> > > >> handles still open at environment close
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: DBERROR db5: BDB1582 Open file
> > > >> handle: /var/lib/imap/db/__db.001
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: DBERROR db5: BDB1582 Open file
> > > >> handle: /var/lib/imap/db/__db.002
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: DBERROR db5: BDB1582 Open file
> > > >> handle: /var/lib/imap/db/__db.003
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: DBERROR db5: BDB0060 PANIC:
> > > >> fatal region error detected; run recovery
> > > >> Mar 11 03:51:04 server cyr_expire[27625]: DBERROR: critical database
> > > >> situation
> > > >>
> > > >> I'm afraid I've absolutely no idea how to troubleshoot this. Can anyone
> > > >> please help?
> > > >>
> > > >> Thanks,
> > > >>
> > > >> Nick
> > > >
> > > >
> > > > Looks like you might have a corrupted BerlkeyDB . What is the output of ?
> > > >
> > > > grep _db /etc/imapd.conf
> > > Nothing? I can't see any alternative file that may hold this info.
> > > imapd.conf is:
> > >
> > > configdirectory: /var/lib/imap
> > > partition-default: /var/spool/imap
> > > admins: root
> > > sievedir: /var/lib/imap/sieve
> > > sendmail: /usr/sbin/sendmail
> > > hashimapspool: true
> > > sasl_pwcheck_method: saslauthd
> > > sasl_mech_list: PLAIN
> > > tls_cert_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
> > > tls_key_file: /etc/pki/cyrus-imapd/cyrus-imapd.pem
> > > tls_ca_file: /etc/pki/tls/certs/ca-bundle.crt
> > >
> > > flushseenstate: 1
> > > allowplaintext: yes
> > > reject8bit: no
> > > munge8bit: no
> > > lmtp_over_quota_perm_failure: 1
> > > timeout: 30
> > > imapidlepoll: 60
> > > idlesocket: /var/lib/imap/socket/idle
> > > lmtpsocket: /var/lib/imap/socket/lmtp
> > > allowapop: no
> > > altnamespace: 0
> > > unixhierarchysep: yes
> > > lmtp_downcase_rcpt: yes
> > > username_tolower: 1
> > > autocreatequota: -1
> > > createonpost: 1
> > > virtdomains: off
> > > expire-days: 1
> > > expunge-days: 1
> > > delete-days: 7
> > >
>
> Hi Nick and Bron,
>
> This is the same database that I mentioned in my Email about BerkeleyDB
> in my system, when I do not have one defined either. I did have issues
> with connections until it was repaired. I was trying to find out why
> it was even in use, as well.
>
> Regards,
> Ken
--
Bron Gondwana
brong@xxxxxxxxxxx
----
Cyrus Home Page: http://www.cyrusimap.org/
List Archives/Info: http://lists.andrew.cmu.edu/pipermail/info-cyrus/
To Unsubscribe:
https://lists.andrew.cmu.edu/mailman/listinfo/info-cyrus
