List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:September 8 1999 1:05pm
Subject:Isamchk -R 5 error
View as plain text  
>>>>> "David" == David Stack <dstack@stripped> writes:

David> This is another strange one.  I check for errors, fix errors and then check
David> for errors again in detail (none). Then I try to order using 'R 5' and then
David> I get an error because of errors.

David> Anyone know what is going on here?

David> Dave

David> root /www/mysql/dstack>/usr/bin/isamchk sort_key_blocks=32 -r
David> /www/mysql/dstack/items.ISM
David> - recovering ISAM-table '/www/mysql/dstack/items.ISM'
David> Data records: 333227
David> - Fixing index 1
David> - Fixing index 2
David> - Fixing index 3
David> - Fixing index 4
David> - Fixing index 5
David> - Fixing index 6
David> Data records: 333522

David> root /www/mysql/dstack>/usr/bin/isamchk sort_key_blocks=32 -evs
David> /www/mysql/dstack/items.ISM
David> index  1:
David> index  2:
David> index  3:
David> index  4:
David> index  5:
David> index  6:
David> No recordlinks

David> root /www/mysql/dstack>/usr/bin/isamchk sort_key_blocks=32 -R 5
David> /www/mysql/dstack/items.ISM
David> - Sorting records in ISAM-table '/www/mysql/dstack/items.ISM'
David> Data records:  333522   Deleted:       0
David> /usr/bin/isamchk: error: 126 when updating key-pointers
David> /usr/bin/isamchk: Error writing file 'UNOPENED' (Errcode: 9)
David> ISAM-table '/www/mysql/dstack/items.ISM' is not fixed because of errors


There seams to be some problem with 'isamchk -R5'  Any change you can
make a smaller test case of this so that I can repeat this problem ?


PS: Note that you don't usually have to change the value of
    'sort_key_blocks'.  To get more speed you should just set the
    'sort_buffer_size' much bigger.
Isamchk -R 5 errorDavid Stack8 Sep
  • Isamchk -R 5 errorMichael Widenius8 Sep
  • Isamchk -R 5 errorMichael Widenius22 Sep
Re: Isamchk -R 5 errorMichael Widenius14 Sep