I tried -r
I tried -o
I tried to truncate the table and re-build the index from scratch.
I tried to create ex-novo a table, import data from scratch and it
result in a corrupted table.
None of these seems to work
Bob Hall wrote:
> Sir, I looked quickly through the mass of data supplied below, and it
> looks like you only tried myisamchk with the -r -q option combination.
> Try it with just -r. If that doesn't work, try it with -o. If that
> doesn't work, restore from backup.
>
> Got backup?
>
> Bob Hall
>
>> Antonio gulli wrote:
>>
>> > Any help is appreciated
>> >
>> > Welcome to the MySQL monitor. Commands end with ; or \g.
>> > Your MySQL connection id is 158 to server version: 3.23.36-log
>> >
>> > myisamchk -V
>> > myisamchk Ver 1.45 for pc-linux-gnu at i686
>> >
>> > a) Trying a recovery.....
>> >
>> > myisamchk -r -q -Osort_key_blocks=16 keywords
>> > - check key delete-chain
>> > - check record delete-chain
>> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
>> > Data records: 2062985
>> > 7000
>> > [root@ideare queries]# myisamchk -r -q -Osort_key_blocks=16
>> > -Okey_buffer_size=256M -Oread_buffer_size=256M
>> -Osort_buffer_size=256M
>> > keywords
>> > - check key delete-chain
>> > - check record delete-chain
>> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
>> > Data records: 2062985
>> >
>> > ---------
>> >
>> > - check key delete-chain
>> > - check record delete-chain
>> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
>> > Data records: 2062985
>> >
>> > b) Trying a check ....
>> >
>> > Database changed
>> > mysql> CHECK TABLE keywords;
>> >
>> +------------------+-------+----------+-------------------------------
>> ---------+|
>> > Table | Op | Msg_type |
>> > Msg_text
>> >
>> |+------------------+-------+----------+------------------------------
>> ----------+|
>> > keywords | check | error | Key in wrong position at page
>> > 24942592 || queries.keywords | check | error |
>> > Corrupt
>> >
>> |+------------------+-------+----------+------------------------------
>> ----------+2
>> > rows in set (10.12 sec)
>> >
>> > yisamchk -a -Osort_key_blocks=16 -Okey_buffer_size=256M
>> > -Oread_buffer_size=256M -Osort_buffer_size=256M keywords
>> > \Checking MyISAM file: keywords
>> > Data records: 2062985 Deleted blocks: 0
>> > myisamchk: warning: Table is marked as crashed
>> > - check file-size
>> > - check key delete-chain
>> > - check record delete-chain
>> > - check index reference
>> > - check data record references index: 1
>> > - check data record references index: 2
>> > - check data record references index: 3
>> > myisamchk: error: Key in wrong position at page 24942592
>> > - check record links
>> > myisamchk: error: Keypointers and record positions doesn't match
>> > MyISAM-table 'keywords' is corrupted
>> >
>> > 3) Describe this table ...
>> >
>> > myisamchk -dvv keywords
>> >
>> > MyISAM file: keywords
>> > Record format: Packed
>> > Character set: latin1 (8)
>> > File-version: 1
>> > Creation time: 2001-03-28 10:02:22
>> > Recover time: 2001-03-29 11:01:02
>> > Status: crashed
>> > Data records: 2062985 Deleted blocks: 0
>> > Datafile parts: 2062985 Deleted data: 0
>> > Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4
>> > Datafile length: 79274620 Keyfile length: 99454976
>> > Max datafile length: 4294967294 Max keyfile length: 4398046510079
>> > Recordlength: 281
>> >
>> > table description:
>> > Key Start Len Index Type Rec/key Root
>> > Blocksize
>> > 1 5 254 fulltext varchar packed 0
>> > 26022912 2048
>> > 1 4 float 0
>> > 2 266 16 multip. char packed stripped NULL 0
>> > 56983552 1024
>> > 3 2 255 multip. char packed stripped NULL 0
>> > 30499840 2048
>> >
>> > Field Start Length Nullpos Nullbit Type
>> > 1 1 1
>> > 2 2 255 1 1 no endspace
>> > 3 257 4 1 2 no zeros
>> > 4 261 2 1 4 no zeros
>> > 5 263 3 1 8 no zeros
>> > 6 266 16 1 16 no endspace
>> >
>> > 4) Re-check it ....
>> >
>> > mysql> CHECK TABLE keywords;
>> >
>> +------------------+-------+----------+-------------------------------
>> ---------+|
>> > Table | Op | Msg_type |
>> > Msg_text
>> >
>> |+------------------+-------+----------+------------------------------
>> ----------+|
>> > keywords | check | warning | Table is marked as
>> > crashed || keywords | check | error | Key in
>> > wrong position at page 74375168 || queries.keywords | check |
>> error |
>> > Corrupt
>> >
>> |+------------------+-------+----------+------------------------------
>> ----------+3
>> > rows in set (9.12 sec)
>> >
>> > 5) http://www.mysql.com/doc/R/e/Repair.html Stage 3: Difficult repair
>> >
>> > francesca> mysql queries
>> > mysql> SET AUTOCOMMIT=1;
>> > mysql> TRUNCATE TABLE keywords;
>> > mysql> quit
>> >
>> > myisamchk -r -q -Osort_key_blocks=16 -Okey_buffer_size=256M
>> > -Oread_buffer_size=256M -Osort_buffer_size=256M keywords
>> > - check key delete-chain
>> > - check record delete-chain
>> > - recovering (with keycache) MyISAM-table 'keywords.MYI'
>> > Data records: 0
>> >
>> > mysql> use queries;
>> > Database changed
>> > mysql> CHECK TABLE keywords;
>> >
>> +------------------+-------+----------+-------------------------------
>> ---------+|
>> > Table | Op | Msg_type |
>> > Msg_text
>> >
>> |+------------------+-------+----------+------------------------------
>> ----------+|
>> > keywords | check | error | Key in wrong position at page
>> > 65639424 || queries.keywords | check | error |
>> > Corrupt
>> >
>> |+------------------+-------+----------+------------------------------
>> ----------+2
>> > rows in set (9.71 sec)
>> >
>> > mysql> describe keywords;
>> > ERROR 1016: Can't open file: 'keywords.MYD'. (errno: 145)
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
> Know thyself? Absurd direction!
> Bubbles bear no introspection. -Khushhal Khan Khatak
>
> ---------------------------------------------------------------------
> 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
>
>
--
--
Antonio Gulli' Ideare S.p.a tel: (+39) 050 575300
[EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575583
whois: AG2-ORG I-56126 Pisa, Italy http://www.ideare.com net:
print pack"C*",split/\D+/,`echo "16iII*o\U@{$/=$z;[(pop,pop,unpack"H*",<>
)]}\EsMsKsN0[lN*1lK[d2%Sa2/d0<X+d*lMLa^*lN%0]dsXx++lMlN/dsM0<J]dsJxp"|dc`
---------------------------------------------------------------------
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