From owner-freebsd-fs Tue May 15 17:38:55 2001 Delivered-To: freebsd-fs@freebsd.org Received: from wantadilla.lemis.com (wantadilla.lemis.com [192.109.197.80]) by hub.freebsd.org (Postfix) with ESMTP id 5E2BD37B423 for ; Tue, 15 May 2001 17:38:46 -0700 (PDT) (envelope-from grog@lemis.com) Received: by wantadilla.lemis.com (Postfix, from userid 1004) id A82896ACBC; Wed, 16 May 2001 10:08:44 +0930 (CST) Date: Wed, 16 May 2001 10:08:44 +0930 From: Greg Lehey To: Noses Cc: fs@freebsd.org Subject: Database integrity (was .*: cvs commit: src/etc rc) Message-ID: <20010516100844.K59553@wantadilla.lemis.com> References: <200105151747.f4FHl7N06711@proxon.bnc.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200105151747.f4FHl7N06711@proxon.bnc.net>; from noses@noses.com on Tue, May 15, 2001 at 07:47:07PM +0200 Organization: LEMIS, PO Box 460, Echunga SA 5153, Australia Phone: +61-8-8388-8286 Fax: +61-8-8388-8725 Mobile: +61-418-838-708 WWW-Home-Page: http://www.lemis.com/~grog X-PGP-Fingerprint: 6B 7B C3 8C 61 CD 54 AF 13 24 52 F8 6D A4 95 EF Sender: owner-freebsd-fs@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Tuesday, 15 May 2001 at 19:47:07 +0200, Noses wrote: > So spoke mi@aldan.algebra.com (Mikhail Teterin): >> On 14 May, Alfred Perlstein wrote: >>> Assuming your database is a serious production quality system it will >>> implement its own style of data integrity and consistancy checking >>> on top of the filesystems in case it happens to crash. >> >> Is not this a slightly wrong attitude? Why does a serious production >> quality database needs its own checking for problems, which can only >> be come from OS if it runs on a serisous production quality OS? > > Well... Once upon a time there was a major German online service provider (I > refuse calling this kind of service ISP) who ran their accounting database > on a faily new fairly big Sun E10K with lots of online storage behind it > (millions of accounting records per day take some space). Only after > recycling the oldest backup tapes someone noticed complete database > corruption - caused by a broken SCSI driver writing nonesense to the disk. > > So much about "serious production quality OS"es. The only OS without any > serious problems of this kind I've ever had was Tandem's Nonstop kernel and > I'm sure I was just lucky. You were just lucky. I've seen unbelievable corruption in NSK. Greg -- Finger grog@lemis.com for PGP public key See complete headers for address and phone numbers To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-fs" in the body of the message