Rick Moore wrote:
>
> >Description:
>
> Researched mail archives and couldn't find any info. Posted to
> mysql@stripped but received no useful responses.
>
> su-2.03# cd /usr/local/mysql/var/g
> su-2.03# TMPDIR=.
> su-2.03# export TMPDIR
> su-2.03# myisamchk -r -O sort_buffer_size=64M -O key_buffer_size=64M -O
> read_bu
> ffer_size=64M -O write_buffer_size=64M reference.MYI
> - recovering MyISAM-table 'reference.MYI'
> Data records: 93996874
> - Fixing index 1
> Wrong bytesec: 0- 0- 0 at 3488489516; Skipped
> 102370000
> /usr/local/mysql/var/g: write failed, file system is full
> myisamchk: Error writing file './STovF497' (Errcode: 28)
>
> /usr/local/mysql/var/g: write failed, file system is full
> myisamchk: Error writing file './STovF497' (Errcode: 28)
> myisamchk: error: 28 when fixing table
> MyISAM-table 'reference.MYI' is not fixed because of errors
> Try fixing it by using the --safe-recover (-o) option
> su-2.03#
>
> In another shell, I check disk space on /usr/local/mysql/var/g while
> myisamchk is running:
>
> su-2.03# df -k
> Filesystem 1K-blocks Used Avail Capacity Mounted on
> /dev/ad0a 49583 27125 18492 59% /
> /dev/ad0f 16027176 11486575 3258427 78% /usr
> /dev/ad0e 19815 2209 16021 12% /var
> /dev/vinum/raid 69546157 65076511 -1094046 102% /usr/local/mysql/var/g
> procfs 4 4 0 100% /proc
>
> When myisamchk is complete, I check disk space again:
>
> su-2.03# df -k
> Filesystem 1K-blocks Used Avail Capacity Mounted on
> /dev/ad0a 49583 27125 18492 59% /
> /dev/ad0f 16027176 11486575 3258427 78% /usr
> /dev/ad0e 19815 2211 16019 12% /var
> /dev/vinum/raid 69546157 15945679 48036786 25% /usr/local/mysql/var/g
> procfs 4 4 0 100% /proc
> su-2.03#
>
> >How-To-Repeat:
>
> Rerun the same commands again. Doesn't matter whether "-q" is present.
> Doesn't matter whether the database has errors or not. Reproducible on
> multiple FreeBSD 4.0 machines.
>
> >Fix:
>
> Wish I had one-- this is a serious problem. It would be cheaper for me to
> buy Oracle than maintain a 4x disk farm.
>
> You are welcome to access my server if that would help. Unfortunately the
> database files are rather large, which makes them difficult to send to you.
> If you would be willing to guide me, I'd be happy to try to debug this
> "remotely" for you.
>
> >Submitter-Id: <submitter ID>
>
> >Originator: rick
>
> >Organization: geckobot.com
>
> >MySQL support: none
>
> >Synopsis: myisamchk requires 4x disk space to run
>
> >Severity: serious, critical next time I have a DB error
>
> >Priority: up to you, but I think it's high ;)
>
> >Category: mysql
>
> >Class: bug? design flaw? not sure
>
> >Release: mysql-3.23.15-alpha (Source distribution)
>
> >Environment:
Something is really wrong with your file system on /usr/local/var/g -- 102%
utilization is definitely wrong :-)
--
Sasha Pachev
+------------------------------------------------------------------+
| ____ __ _____ _____ ___ http://www.mysql.com |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
