From owner-freebsd-questions  Sun May 17 23:23:50 1998
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Received: (from majordom@localhost)
          by hub.freebsd.org (8.8.8/8.8.8) id XAA15427
          for freebsd-questions-outgoing; Sun, 17 May 1998 23:23:50 -0700 (PDT)
          (envelope-from owner-freebsd-questions@FreeBSD.ORG)
Received: from couatl.uchicago.edu (couatl.uchicago.edu [128.135.21.64])
          by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id XAA15422
          for <freebsd-questions@freebsd.org>; Sun, 17 May 1998 23:23:45 -0700 (PDT)
          (envelope-from sfarrell@couatl.uchicago.edu)
Received: (from sfarrell@localhost)
	by couatl.uchicago.edu (8.8.8/8.8.8) id BAA04337;
	Mon, 18 May 1998 01:23:31 -0500 (CDT)
	(envelope-from sfarrell)
To: Jahan <jahan@pc.jaring.my>
Cc: "freebsd-questions@FreeBSD.ORG" <freebsd-questions@FreeBSD.ORG>
Subject: Re: Core dumped, FreeBSD 226-S, Am I alone ?
References: <356096A2.8F80157E@pc.jaring.my>
From: sfarrell@farrell.org
Mime-Version: 1.0 (generated by tm-edit 7.108)
Content-Type: text/plain; charset=US-ASCII
Date: 18 May 1998 01:23:31 -0500
In-Reply-To: Jahan's message of "Mon, 18 May 1998 13:14:27 -0700"
Message-ID: <87som89jx8.fsf@couatl.uchicago.edu>
Lines: 42
X-Mailer: Gnus v5.6.9/XEmacs 20.4 - "Emerald"
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

Jahan <jahan@pc.jaring.my> writes:

> Core dumped, FreeBSD 226-S, Am I alone ?
> 
> Does not look like. Its definitely not RAM or other cuz , mysql was
> already running .
> 
> 16MB RAM p75 2.1+2.1GB HDD .
> 
> Kindly confirm, if it is running perfectly. Mysql 3.21.29g.
> 
> Thank you very much.
> 
> Jahan
> 
> Here is the output
> ============
> 
> tuna# mysqladmin -V
> mysqladmin  Ver 6.8 Distrib 3.21.29-gamma, for unknown-freebsd2.2.6 on
> i386
> tuna# mysqlshow
> mysqlshow: Lost connection to MySQL server during query
> Segmentation fault - core dumped
> mysqld restarted
> tuna# uname -a
> FreeBSD tuna.jjsoft2.com 2.2.6-STABLE FreeBSD 2.2.6-STABLE #0: Mon May
> 18 20:
> 37:40 MYT 1998     jahan@tuna.jjsoft2.com:/usr/src/sys/compile/JJSOFT2
> i386
> tuna#

It's my impression that mysql hoses its data periodically and
segfaults when it tries to read it.  Keep backups of data, and then
replace data with latest backup when mysql starts segfaulting.

Then write to sybase/oracle/informix and beg...

--

Steve Farrell


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message