List:General Discussion« Previous MessageNext Message »
From:Natambu Obleton Date:June 28 2000 3:20pm
Subject:Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD'
View as plain text  
I would actually just recommend running FreeBSD or something like that. I
tried reiserfs w/linux and had problems that were just.... un traceable
with kernel panics and stuff because you have to use a newer (green)
kernel. Reiserfs is a great journaling FS though, I just don't have the
time to debug my system at that level with huge tables being used very
often.

Natambu Obleton
Syncrasy
970.247.4139

On Wed, 28 Jun 2000 sinisa@stripped wrote:

> Date: Wed, 28 Jun 2000 14:17:32 +0300 (EEST)
> From: sinisa@stripped
> To: mysql@stripped
> Subject: Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD'
    (Errcode:  27)]
> 
> Jonathon Padfield writes:
>  > 
>  > I hate to make my first post to the list a request for help, but I've
>  > been looking around on usenet, the list archive (still non-searchable,
>  > and a little non-functional), the mysql docs, the FAQ, but I can't see
>  > any reference to Errcode: 27
>  > 
>  > Its particuarly concerning as I'm trying to repair the index to a 3 gig
>  > table (the index typically was around 4 gigs).
>  > 
>  > The exact error text is 
>  > lindt:/data/repair# isamchk -o records.ISM
>  > - recovering ISAM-table 'records.ISM'
>  > Data records: 19719539
>  > isamchk: Error writing file 'records.TMD' (Errcode: 27)
>  > isamchk: error: 27 when writing to datafile
>  > ISAM-table 'records.ISM' is not fixed because of errors
>  > 
>  > We're using mysql v3.22.27, isamchk 5.13 on a slackware SMP linux system
>  > (2.2.13), compiled with large file support.
>  > 
>  > Can anyone be of assistance here?
>  > 
>  > Regards,
>  > 	Jonathon Padfield
>  > 
> 
> 
> Hi!
> 
> Since like your Linux system can not support too large files.
> 
> What file system are you using. 
> 
> You should try switching to 64 bit Reiser FS or JFS or XFS.
> 
> Regards,
> 
> Sinisa
> 
> +----------------------------------------------------------------------+
> |      ____  __     _____   _____  ___     ==  MySQL AB                |
> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped     |
> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
> |             /*/             \*\                Developers Team       |
> +----------------------------------------------------------------------+
> 
> -- 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/php/manual.php3" before
> posting. To request this thread, e-mail mysql-thread41873@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-no=syncrasy.com@stripped>
> 
> 

Thread
What is Errcode 27? [isamchk: Error writing file 'records.TMD' (Errcode: 27)]Jonathon Padfield28 Jun
  • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD' (Errcode: 27)]Colin Faber28 Jun
  • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD' (Errcode: 27)]Jonathon Padfield28 Jun
    • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD' (Errcode: 27)]sinisa28 Jun
  • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD' (Errcode: 27)]sinisa28 Jun
    • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD'(Errcode: 27)]Natambu Obleton28 Jun
      • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD' (Errcode: 27)]Adrian Phillips5 Jul
        • Re: What is Errcode 27? [isamchk: Error writing file 'records.TMD'(Errcode: 27)]Natambu Obleton5 Jul