From owner-freebsd-hackers@FreeBSD.ORG Tue May 13 15:50:54 2008 Return-Path: Delivered-To: freebsd-hackers@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 07E7C106564A for ; Tue, 13 May 2008 15:50:54 +0000 (UTC) (envelope-from yanefbsd@gmail.com) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by mx1.freebsd.org (Postfix) with ESMTP id CEA2F8FC0A for ; Tue, 13 May 2008 15:50:53 +0000 (UTC) (envelope-from yanefbsd@gmail.com) Received: by wa-out-1112.google.com with SMTP id j4so3690832wah.3 for ; Tue, 13 May 2008 08:50:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:cc:message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer; bh=hHNJlqPwsG+1L+lQDJ3Ykrjl1gQp7/qmCUkcIV/umqk=; b=w+jjm5sG9hAbCv43HZtHgCsEV02hJwN99YZSwEGuIDvLfopDVWzaRlFliApW17wJhm86JEgl0vvqapniMs+hQDFZa+y/Utj/3FhzrD2tNMqQMJK95+kig48UTczjNJcweiPini+6+Bl3FNWMNCfWmLW50vPAA5zcsEHww/NT4RM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=cc:message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer; b=td4UNl8G5C6xLjvdKPxtbeVyHx5o7KtrHIsWxcCpBXiy5wF8BHR/7MaLOpwVLPOXLKycSxTf9g4znUiDHfcBJGJhIJ03HkdH77u7QVxgilnaLKRLVElD/IsQo2HYw1aEszccOPQEksVjyGrRic07eqzQ8YO0yg17tXscZTHz5Ow= Received: by 10.114.180.1 with SMTP id c1mr9355433waf.121.1210693853412; Tue, 13 May 2008 08:50:53 -0700 (PDT) Received: from ?192.168.10.42? ( [99.155.199.64]) by mx.google.com with ESMTPS id n20sm13109pof.0.2008.05.13.08.50.51 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 13 May 2008 08:50:52 -0700 (PDT) Message-Id: <48B3E83F-A165-4680-8F29-4EE6FB60D079@gmail.com> From: Garrett Cooper To: Kurt Lidl In-Reply-To: <4828F55E.6020407@pix.net> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Date: Tue, 13 May 2008 08:51:59 -0700 References: <20080509124308.GA596@britannica.bec.de> <9FC19AC2-DAD8-418C-8B9C-F129DEC58CEF@gmail.com> <15336578.20080512123806@mail.ru> <4828F55E.6020407@pix.net> X-Mailer: Apple Mail (2.919.2) Cc: freebsd-hackers@freebsd.org, Joerg Sonnenberger , Anthony Pankov Subject: Re: BDB corrupt X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 May 2008 15:50:54 -0000 On May 12, 2008, at 6:56 PM, Kurt Lidl wrote: > Garrett Cooper wrote: >> On May 12, 2008, at 1:38 AM, Anthony Pankov wrote: >>> >>> Please, can anybody explain what is the problem with BDB (1.86). >>> >>> Is there known caveats of using BDB? Is there some rules which >>> guarantee from curruption or it is fully undesirable to use BDB >>> under >>> high load? >>> >>> It is important for me because of using BDB in my project. >>> >>> >>>> On Fri, May 09, 2008 at 01:52:46PM +0200, Joerg Sonnenberger wrote: >>>>> >>>>> As one of the persons hacking on pkg_install in pkgsrc/NetBSD, I >>>>> would >>>>> *strongly* advisy you against storing the files only in a bdb >>>>> file. >>>>> The change of major and complete corruption with bdb185 is high, >>>>> consider pulling the plug in the middle of a long update. >>> >>>> Sunday, May 11, 2008, 5:38:25 PM, you wrote: >>> >>> GC> +1. BDB is quite easy to corrupt... >> BDB isn't ATOMic, like SQL or other DB backends. > > You mean ACID probably. And there are plenty of SQL databases > that aren't ACID either. (e.g. Mysql 4.x, Mysql 5.x w/o the > right kind of backing store) > > -Kurt Yes, you're right. Atomicity is the A in ACID. -Garrett