Hi. Thank you!
It looks like you've found a bug: http://bugs.mysql.com/bug.php?id=6309 Seems, you have myisamchk compiled without debug support. See: http://dev.mysql.com/doc/mysql/en/Compiling_for_debugging.html http://dev.mysql.com/doc/mysql/en/MyODBC_Unix_debugging_options.html And I think the best way for you is to download MySQL with enabled debug support. Then try it with --debug, look at the trace, or send it to us. Please tell me, what OS do you use, MySQL version and how was it compiled? Is there any clues at the end of .err file? "J S" <[EMAIL PROTECTED]> wrote: > That failed with an err27 as well. How do I set the debug flag on myisamchk > ? > > --debug=/tmp/debug doesn't work. > > JS. > > >> >>Hi. >>Sounds OK, but don't forget to make a backup. >> >>"J S" <[EMAIL PROTECTED]> wrote: >> > Thanks for your reply Gleb. I tried running with --safe-recover instead >>of >> > -qr but that caused some other processes running on the box to hang and >> > coredump so I had to kill it off. >> > >> > I'll try running: >> > >> > myisamchk -qr --tmpdir=/proxydb/mysql/tmp -O sort=16M -O key=16M -O >>read=1M >> > -O write=1M --sort-index --analyze internet_usage >> > >> > Sound OK? >> > >> > JS. >> >> >> >>Hi. >> >> >> >>Usually myisamchk doesn't have the suid bit set, and it seems to be ran >>as >> >>root. >> >>See >> >> http://dev.mysql.com/doc/mysql/en/Table_maintenance.html >> >>Especially >> >> http://dev.mysql.com/doc/mysql/en/myisamchk_memory.html >> >> >> >> >> >>"J S" <[EMAIL PROTECTED]> wrote: >> >> > Hi, >> >> > >> >> > I've run myisampack to compress a table and am now trying to recreate >> >>the >> >> > index using myisamchk (as root) but I get an error 27. >> >> > >> >> > # myisamchk -rq --sort-index --analyze --tmpdir=/proxydb/mysql/tmp >> >> > internet_usage.MYI >> >> > - check record delete-chain >> >> > - recovering (with sort) MyISAM-table 'internet_usage.MYI' >> >> > Data records: 30972875 >> >> > - Fixing index 1 >> >> > myisamchk: Error writing file '/proxydb/mysql/tmp/ST3hTDMa' (Errcode: >> >>27) >> >> > myisamchk: error: 27 when fixing table >> >> > MyISAM-table 'internet_usage.MYI' is not fixed because of errors >> >> > Try fixing it by using the --safe-recover (-o), the --force (-f) >>option >> >>or >> >> > by not using the --quick (-q) flag >> >> > # perror 27 >> >> > Error code 27: A file cannot be larger than the value set by >>ulimit. >> >> > >> >> > The ulimits are set as follows: >> >> > >> >> > default: >> >> > fsize = 2097151 >> >> > core = 2097151 >> >> > cpu = -1 >> >> > data = 262144 >> >> > rss = 65536 >> >> > stack = 65536 >> >> > nofiles = 2000 >> >> > >> >> > root: >> >> > fsize = -1 >> >> > core = -1 >> >> > cpu = -1 >> >> > data = -1 >> >> > rss = -1 >> >> > stack = -1 >> >> > nofiles = 4000 >> >> > >> >> > When I run myisamchk, is it running with root privilidges or as user >> >>mysql? >> >> > By the way this is a large enabled filesystem. >> >> > >> >> > Thanks, >> >> > >> >> > JS. >> >> > >> >> > >> >> > >> >> >> >> >> >>-- >> >>For technical support contracts, goto >>https://order.mysql.com/?ref=ensita >> >>This email is sponsored by Ensita.NET http://www.ensita.net/ >> >> __ ___ ___ ____ __ >> >> / |/ /_ __/ __/ __ \/ / Gleb Paharenko >> >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >> >>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> >> <___/ www.mysql.com >> >> >> >> >> >> >> >> >> >>-- >> >>MySQL General Mailing List >> >>For list archives: http://lists.mysql.com/mysql >> >>To unsubscribe: >>http://lists.mysql.com/[EMAIL PROTECTED] >> >> >> > >> > >> > >> >> >>-- >>For technical support contracts, goto https://order.mysql.com/?ref=ensita >>This email is sponsored by Ensita.NET http://www.ensita.net/ >> __ ___ ___ ____ __ >> / |/ /_ __/ __/ __ \/ / Gleb Paharenko >> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] >>/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET >> <___/ www.mysql.com >> >> >> >> >>-- >>MySQL General Mailing List >>For list archives: http://lists.mysql.com/mysql >>To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] >> > > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
