From owner-freebsd-database@FreeBSD.ORG Wed Feb 28 08:55:08 2007 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 7FB5716A402 for ; Wed, 28 Feb 2007 08:55:08 +0000 (UTC) (envelope-from gpaharenko@gmail.com) Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by mx1.freebsd.org (Postfix) with ESMTP id 161FD13C491 for ; Wed, 28 Feb 2007 08:55:07 +0000 (UTC) (envelope-from gpaharenko@gmail.com) Received: by nf-out-0910.google.com with SMTP id k27so466212nfc for ; Wed, 28 Feb 2007 00:55:07 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; b=J/wYCT80Za/8pIEXM4TCCqIpUuoeqYyGq5c/tTjAtqkZ/t58lyJFgV2t9EK5TbWvLm2LTV2VJTRRrHOuGImOCHhnqybx7pEXDQJRTSSzG3m/LERKADS74rV12zr3xUO37kFCxRlcqpNeMGn3oymbIzLHhQ6A9wy+hE42B3PYUKw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:from; b=q3bfjBpgWcAsOgCMzeaeSVzXVS50Eehybt8f5i9b37s0uC0M2pFqrgHDYr1IJkwYq5pRfgNCqQRv5VDT6H94peeDzHvyXgNQVDQGA78fCWVcUAXUSZxiRq68U9al3KW4INfT4CzzK7QMMy6dFWuKoCI1PPHR2EdOojChvgkTFzM= Received: by 10.49.55.13 with SMTP id h13mr3150999nfk.1172652906979; Wed, 28 Feb 2007 00:55:06 -0800 (PST) Received: from ?192.168.1.7? ( [212.9.255.254]) by mx.google.com with ESMTP id g8sm1209508muf.2007.02.28.00.55.05; Wed, 28 Feb 2007 00:55:06 -0800 (PST) Message-ID: <45E5436A.2040207@mail.ru> Date: Wed, 28 Feb 2007 10:55:06 +0200 User-Agent: Thunderbird 1.5.0.8 (X11/20061107) MIME-Version: 1.0 To: Nicole Harrington References: <4279.612.qm@web34508.mail.mud.yahoo.com> In-Reply-To: <4279.612.qm@web34508.mail.mud.yahoo.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit From: Gleb Paharenko Cc: FreeBSD-DataBase Subject: Re: Getting errors while trying to use new Mysql 50 port and pkg X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 28 Feb 2007 08:55:08 -0000 Hello. You could try find out which statement causes the problem. Have a look here: http://dev.mysql.com/doc/refman/5.0/en/reproducible-test-case.html Please, provide the output of 'SHOW VARIABLES' and 'SHOW STATUS' statements. There's another good point to start: http://dev.mysql.com/doc/refman/5.0/en/debugging-server.html Regards. Nicole Harrington пишет: > Hello, > I have 2 database servers running as slaves from a > Master database. One (db2) is running FreeBSD > 6.2-PRERELEASE from October. The other, (db3) on a new > build of FreeBSD 6.2-STABLE. Both are AMD64. > > Db2 is running mysql 5.0.24a and has been working > fine. > Db3 however, running mysql 5.0.33 keeps giving an > error 127 after awhile, for a couple of our tables. > The tables all check as ok. > > 070227 11:24:48 [ERROR] Got error 127 when reading > table './user_info' > > We had this problem before with the ports built > version on db2, but when we switched to the pkg build > it went away. Now none of the build options seem to > work and sadly I do not have the old copy of mysql > 5.024a to try on this server. (forgot to use -K) > > I have tried the Ports build with and without various > optimizations, the Pkg build and a downloaded binary > from mysql. (5.0.27) All produced the errors within an > hour of running. > > perror shows this to mean: > MySQL error code 127: Record-file is crashed. > > When the error is reported, the query that caused it > responds with an error, but all other queries work. > Running a repair on the tables shows everything ok. > > > Any suggestions greatly appreciated! > > > Thanks! > > Nicole > > -- > Free The Bound Periodicals! > > > > > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" > -- Gleb Paharenko gleban@mail.ru