From: <sinisa
Date: January 22 2000 1:56pm
Subject: Re: help: Can't find key for index error
List-Archive: http://lists.mysql.com/mysql/25052
Message-Id: <14473.46877.828678.177890@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

webmaster junet writes:
 > Hello all,
 > 
 > please could someone enlighten me what this error means and what cause it ?
 > 
 > we have got ip_log table where we only add or update records but never
 > delete them (some kind of pool ).
 > curently the table is small with 1862 records.
 > somewhere once a week I find the mysql server down and ip_log table
 > corrupted like this:
 > 
 > isamchk -e /usr/local/var/linkwizard/ip_log.ISM
 > Checking ISAM file: /usr/local/var/linkwizard/ip_log.ISM
 > Data records:    1862   Deleted blocks:       0
 > - check file-size
 > - check delete-chain
 > - check index reference
 > - check data record references index: 1
 > - check data record references index: 2
 > isamchk: error: Key in wrong position at page 46080
 > - check records and index references
 > isamchk: error: Record at:       2412  Can't find key for index:  2
 > ISAM-table '/usr/local/var/linkwizard/ip_log.ISM' is corrupted
 > 
 > after isamchk -r /usr/local/var/linkwizard/ip_log.ISM table seems to be
 > repaired
 > but a week ago I have had to delete all the records as table get corupted
 > again and again on every request to it even after repair -r or -o. After
 > deletion there were no problems for a week up to now.
 > 
 > I dont think 1862 connections in 24 hours might be a problem with mySQL.
 > (Server version is 3.22.25-log running on Linux.)
 > 
 > I even don't know where to start fixing this problem.
 > any ideas will be highly appreciated.
 > 
 > Thank you,
 > 
 > Kazys Jocionis
 > 
 > 
 > 
 > 
 > 
 > 
 > 
 > 

Hi!

What you describe is truly low load server, so load is not a cause of
your problems. 

Have you tried using binary version of the latest 3.22.30 version for
Linux.

If you have not tried it, please do and see whether problem reccurs.

regards,

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+