From owner-freebsd-ports@FreeBSD.ORG Mon Jun 9 11:39:45 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 8BEAC697 for ; Mon, 9 Jun 2014 11:39:45 +0000 (UTC) Received: from cpsmtpb-ews02.kpnxchange.com (cpsmtpb-ews02.kpnxchange.com [213.75.39.5]) by mx1.freebsd.org (Postfix) with ESMTP id F1FE22B8A for ; Mon, 9 Jun 2014 11:39:44 +0000 (UTC) Received: from cpsps-ews11.kpnxchange.com ([10.94.84.178]) by cpsmtpb-ews02.kpnxchange.com with Microsoft SMTPSVC(7.5.7601.17514); Mon, 9 Jun 2014 13:38:33 +0200 Received: from CPSMTPM-CMT101.kpnxchange.com ([195.121.3.17]) by cpsps-ews11.kpnxchange.com with Microsoft SMTPSVC(7.5.7601.17514); Mon, 9 Jun 2014 13:38:33 +0200 Received: from donald.offrom.nl ([77.170.60.162]) by CPSMTPM-CMT101.kpnxchange.com over TLS secured channel with Microsoft SMTPSVC(7.0.6002.18264); Mon, 9 Jun 2014 13:38:33 +0200 Received: from squid (squid.offrom.nl [192.168.0.72]) by donald.offrom.nl (8.14.8/8.14.8) with ESMTP id s59BcVMc002634; Mon, 9 Jun 2014 13:38:32 +0200 (CEST) (envelope-from willy@vpn.offrom.nl) Received: from willy by squid with local (Exim 4.72) (envelope-from ) id 1WtxuJ-0007vl-31; Mon, 09 Jun 2014 13:38:31 +0200 Date: Mon, 9 Jun 2014 13:38:31 +0200 From: Willy Offermans To: Niels Dettenbach Subject: Re: Database error Message-ID: <20140609113830.GA30045@vpn.offrom.nl> Reply-To: Willy@Offermans.Rompen.nl References: <20140602141832.GF21704@vpn.offrom.nl> <3548500.yrjecoRN8L@gongo> <20140602144414.GH21704@vpn.offrom.nl> <1787652.HODZAcktA2@gongo> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1787652.HODZAcktA2@gongo> User-Agent: Mutt/1.5.20 (2009-06-14) X-OriginalArrivalTime: 09 Jun 2014 11:38:33.0479 (UTC) FILETIME=[58025970:01CF83D7] X-RcptDomain: freebsd.org Cc: info-cyrus@lists.andrew.cmu.edu, freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 09 Jun 2014 11:39:45 -0000 Dear Niels and cyrus-imap friends, On Mon, Jun 02, 2014 at 07:58:43PM +0200, Niels Dettenbach wrote: > Hi Wiel, > > Am Montag, 2. Juni 2014, 16:44:14 schrieben Sie: > > I already suspected something like that. but I miss some more detailed > > info. > > > > Following plan A: > > > > How can I update DB data? What are the tools to use? What is the content of > > /var/imap/db anyway? Can it be disposed of and will it be regenerated > > automagically? > > > > Following plan B: > > > > How do I export and import the data. Is there a db_dump and db_import? > > At least, this route would allow me to make a judgement about the data. > > Take a look at i.e.: > > http://www.cyrusimap.org/docs/cyrus-imapd/2.4.12/install-upgrade.php > > and/or: > http://www.banquise.org/software/how-to-recover-from-cyrus-when-you-have-some-db-errors/ > > > make a "simple" skiplist file from your mailboxes index db file with the > cvt_cyrusdb tool - i.e. (fit the pathes!). I usually execute cyrus commands > under the cyrus user of that system (typically "cyrus") by sudo or "su cyrus": > > /usr/cyrus/bin/cvt_cyrusdb /var/imap/mailboxes.db berkeley \ > /var/imap/mailboxes.db.new skiplist > > mv /var/imap/mailboxes.db.new /var/imap/mailboxes.db > > This could be used independently from your DB version and is very handy if you > have to "rebuild" your mailbox database "from the ground" (backup). > > A "hard" version is to delete the databases and let regenerate it new from > cyrus. Make shure that you have the mailbox index file (mailboxes.db as > skiplist and as a backup - and pls make a full backup of your /var/lib/cyrus > database directory structure): > > -> STOP/KILL all cyrus processes > su - cyrus > cd /var/lib/cyrus > rm db/* > rm db.backup1/* > rm db.backup2/* > rm deliver.db > rm tls_sessions.db > -> START cyrus > reconstruct > or > cyrreconstruct -r user.* > > (depending from under how name the reconstruct command is available) > > > cheerioh, > > > Niels. > -- After an unplanned and unforeseen reboot, the problem disappeared. To me it seems that the '/var/imap/db' directory was recreated automagically during reboot. As the actual problem started after an update of FreeBSD ports, I have the impression that the update procedure for cyrus-imap and berkely db is not failure free. If the update for berkely db is so crucial for cyrus-imap, then arrangements for that should be settled. -- Met vriendelijke groeten, With kind regards, Mit freundlichen Gruessen, De jrus wah, Wiel ************************************* W.K. Offermans Home: +31 45 544 49 44 Mobile: +31 681 15 87 68 Mobile: +49 1575 414 60 55 e-mail: Willy@Offermans.Rompen.nl Powered by .... (__) \\\'',) \/ \ ^ .\._/_) www.FreeBSD.org