List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 18 1999 5:01pm
Subject:Re: constant database corruption
View as plain text  
At 7:45 AM -0500 4/18/1999, Michael Widenius wrote:
>>>>>> "unknown" == unknown  <unknown@stripped> writes:
>
>unknown> every single day, I end up with this:
>unknown> Checking ISAM file: outhits
>unknown> Data records:   10604   Deleted blocks:   18049
>unknown> - check file-size
>unknown> - check delete-chain
>unknown> isamchk: error: delete-link-chain corrupted
>unknown> - check index reference
>unknown> - check data record references index: 1
>unknown> isamchk: error: Found key at page 22528 that points to record outside
>unknown> datafile
>unknown> ISAM-table 'outhits' is corrupted
>unknown> Fix it using switch "-r" or "-o"
>
>unknown> I'm not sure what the cause is.  It wasn't happening before --
>now it's
>unknown> *ever* day.  Any ideas?  I'm using 3.22.20a, but it was also
>happening on
>unknown> 3.22.13 before I upgraded (in a vain attempt to fix it).
>
>unknown> ---
>unknown> tani hosokawa
>unknown> river styx internet
>
>Hi!
>
>Are you sure the MySQL server wasn't updating the table while you ran isamchk?
>
>Please read the suggestions at:
>
>http://www.mysql.com/Manual_chapter/manual_Problems.html#Crashing
>
>If you can find any way to replicate this, we will be able to provide
>a patch very fast!


Hey, now.  Monty, you simply cannot make statements like that.
Remember, support for MySQL is non-existent! :-)


For those who don't know what I'm referring to, this claim was
issued by a software vendor recently:
>> Yes, there are free (unsupported) SQL and scripting environments for Unix,
>> for example, MySQL for the database and php for scripting, but although
>> they are good for small development projects, no company on the market
>> develops their professional systems using these tools.  MySQL is still
>> quite buggy, and support is essentially non-existent.  If we were to opt

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
constant database corruptionunknown18 Apr
  • Re: constant database corruptionVan18 Apr
    • Re: constant database corruptionunknown18 Apr
  • constant database corruptionMichael Widenius18 Apr
    • Re: constant database corruptionPaul DuBois18 Apr
      • Re: constant database corruptionBarry20 Apr
        • RE: constant database corruptionBill Gerrard20 Apr
    • Re: constant database corruptionunknown18 Apr
      • Re: constant database corruptionMichael Widenius19 Apr