Date: Tue, 27 Feb 2007 12:16:49 -0800 (PST) From: Nicole Harrington <drumslayer2@yahoo.com> To: FreeBSD-DataBase <freebsd-database@freebsd.org>, freebsd-questions@freebsd.org Subject: Getting errors while trying to use new Mysql 50 port and pkg Message-ID: <4279.612.qm@web34508.mail.mud.yahoo.com>
next in thread | raw e-mail | index | archive | help
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!
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4279.612.qm>