From owner-freebsd-database@FreeBSD.ORG Tue Feb 27 20:16:50 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 EFA2A16A400 for ; Tue, 27 Feb 2007 20:16:50 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: from web34508.mail.mud.yahoo.com (web34508.mail.mud.yahoo.com [66.163.178.174]) by mx1.freebsd.org (Postfix) with SMTP id 9F5ED13C4B3 for ; Tue, 27 Feb 2007 20:16:50 +0000 (UTC) (envelope-from drumslayer2@yahoo.com) Received: (qmail 1871 invoked by uid 60001); 27 Feb 2007 20:16:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=QReZQcqcwKlqZ3z7fy6gULKl0rzonmVnQb9/AAcrBDvQ6cwRGdpU6kNyYp/STy+3UrFh/RndiiMSD5dvIXIYE+wxjOcc3fAMQEVbrEwTGQL0BXA3khTWnN47Mn9jq+GFX2w5fJIFD3wk0QMFIg8eFQ9lavNzA9UCnLl34B5bvLA=; X-YMail-OSG: 2p8FPMIVM1lC11eRnMZR8SJP2S0A_.rL.qMme1m9FDIv5r.G8ZTgmIhUdnp7LCpbyrFMSFFTRqmWPFXKIBBt1t1xMWiy8.CZeWj0QtKBLUoIKhzLcrj8rgw6slbre0UTOV52Oz_.Mtr3GUM- Received: from [67.112.21.27] by web34508.mail.mud.yahoo.com via HTTP; Tue, 27 Feb 2007 12:16:49 PST Date: Tue, 27 Feb 2007 12:16:49 -0800 (PST) From: Nicole Harrington To: FreeBSD-DataBase , freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <4279.612.qm@web34508.mail.mud.yahoo.com> Cc: Subject: 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: Tue, 27 Feb 2007 20:16:51 -0000 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!