List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:March 28 2001 5:34pm
Subject:Re: myisam upgrade problem
View as plain text  
error 28 is "No space left on device".


Hang wrote:
> 
> Greetings,
> 
> I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with kernel
> 2.4.0. I followed the instructions on the manual for the upgrade. Every
> goes fine except I can't convert one table from ISAM to MYISAM.
> 
> I got quite a lot of tables and all can be converted successfully but
> not this table. It contains > 3,000,000 rows, 80MB data file and 250MB
> index file. I got following error message when I am converting the table
> format:
> 
> mysql> alter table mytable type=MYISAM;
> ERROR 3: Error writing file '/tmp/ST4kylYE' (Errcode: 28)
> 
> I also found following line by running "ls -al /proc/12121/fd" (12121 is
> the pid of the mysqld):
> 
> lrwx------    1 root     root           64 Mar 28 12:25 17 ->
> /tmp/ST4kylYE (deleted)
> 
> I had run isamcheck before the conversion and my /tmp got > 400MB disk
> space.
> Any one have idea what's going wrong?
> 
> Besides, I also have tables on other Linux machines with about 200MB
> data and 2.0GB index file. Will there be any problem?
> 
> Pls Help. Thanks.
> 
> --
> CH Tsang
> 
> ---------------------------------------------------------------------
> 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 <mysql-thread69760@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
myisam upgrade problemHang28 Mar
  • Re: myisam upgrade problemGerald Clark28 Mar
  • Re: myisam upgrade problemHang29 Mar
    • Re: myisam upgrade problemBenjamin Pflugmann29 Mar
      • Re: myisam upgrade problemLindsay Adams29 Mar
  • Re: myisam upgrade problemGerald Clark29 Mar