List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:October 20 1999 2:16am
Subject:Re: sessions table gets currupted
View as plain text  
>>>>> "miso" == miso  <miso@stripped> writes:

miso> Monty,
miso> Thanks for your response. The corruption of tables happened
miso> again. I was wondering if the following information would
miso> help:

miso> Checking ISAM file: sessions
miso> Data records:    6774   Deleted blocks:    3738
miso> - check file-size
miso> isamchk: error: Size of indexfile is: 417792          Should be: 422912
miso> isamchk: error: Size of datafile is: 10106186         Should be: 12202786
miso> - check delete-chain
miso> isamchk: error: delete-link-chain corrupted
miso> - check index reference
miso> - check data record references index: 1
miso> isamchk: error: Found 0 keys of 6774
miso> - check record links
miso> isamchk: error: Record-count is not ok; is 6780         Should be: 6774
miso> isamchk: warning: Found          0 deleted blocks       Should be: 3738
miso> isamchk: warning: Found       6780 parts                Should be: 269769 parts
miso> ISAM-table 'sessions' is corrupted

miso> THANKS!

Hi!

Sorry, but the above only shows that the table was corrupted, but not
the reason for this!

Any change you can follow the instructions outlined in the 'Debugging
a mysql server' section of the MySQL manual to produce an error free
table + an update log that corrupts it?

Regards,
Monty
Thread
MySQL 3.22.27 on Raq (mysql_install_db fails)Paul Schreiber9 Oct
  • Re: MySQL 3.22.27 on Raq (mysql_install_db fails)sinisa10 Oct
Re: MySQL 3.22.27 on Raq (mysql_install_db fails)Paul Schreiber10 Oct
  • Re: MySQL 3.22.27 on Raq (mysql_install_db fails)sinisa11 Oct
    • sessions table gets curruptedmiso11 Oct
      • sessions table gets curruptedMichael Widenius12 Oct
        • Re: sessions table gets curruptedmiso19 Oct
          • Re: sessions table gets curruptedMichael Widenius20 Oct
Re: MySQL 3.22.27 on Raq (mysql_install_db fails)Paul Schreiber11 Oct
  • Re: MySQL 3.22.27 on Raq (mysql_install_db fails)sinisa11 Oct
  • Re: MySQL 3.22.27 on Raq (mysql_install_db fails)Vivek Khera11 Oct
Re: MySQL 3.22.27 on Raq (mysql_install_db fails)Paul Schreiber11 Oct
  • Re: MySQL 3.22.27 on Raq (mysql_install_db fails)sinisa12 Oct