John,
Saturday, August 10, 2002, 4:32:37 AM, you wrote:
JP> I keep getting a problem with our MySQL database, I know what error 127 is
JP> ('Record-file is crashed / Network is down'), it keeps occuring on several
JP> tables that are frequently accessed by our website.
JP> I can fix the problem by running OPTIMIZE TABLE on the offending tables but
JP> it seems to be becoming a regular occurence (every 48 hours or so). We
JP> recently lost a load of data because many tables were down, and when these
JP> one of the tables (the session ID table) crashes, our whole site can't be
JP> accessed.
JP> Nothing in the logs about it, disk space is OK and the disk passed a fsck
JP> test ok. Only clue is from the output of isamchk:
JP> ---
JP> Checking ISAM file: Failed.ISM
JP> Data records: 3089 Deleted blocks: 0
JP> - check file-size
JP> - check delete-chain
JP> - check index reference
JP> - check record links
JP> isamchk: error: Wrong bytesec: 0-0-0 at linkstart: 399911
JP> ---
JP> What can I do to stop this happening?
JP> It is MySQL 3.22.32 running on Solaris. I plan on upgrading this soon but
JP> want to get to the bottom of this problem first..
John, 3.22.23 is an outdated version of MySQL. Can I ask you to upgrade
MySQL server first and see if table will be corrupted so often again.
If it recurs, create a repeatable testcase according to:
http://www.mysql.com/doc/en/Reproduceable_test_case.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
