On Mon, 27 Aug 2001, Sinisa Milivojevic wrote:
Hi!
> Try to repair the same table with 3.23.41.
>
> If it fails, please let us know, so that we can give you upload
> instructions.
kulan$ ls -la /home/mysql/Mbovis/cogs_data*
-rw-rw---- 1 pedant users 54195408 Jul 4 03:52
/home/mysql/Mbovis/cogs_data.MYD
-rw-rw---- 1 pedant users 72704 Aug 27 18:44
/home/mysql/Mbovis/cogs_data.MYI
-rw-rw---- 1 pedant users 8714 Jul 4 03:52
/home/mysql/Mbovis/cogs_data.frm
3.23.41 also fails:
mysql> use Mbovis;
Database changed
mysql> check table cogs_data;
+------------------+-------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
| |
+------------------+-------+----------+---------------------------------------------------------+
| Mbovis.cogs_data | check | warning | Table is marked as crashed and last repair
|failed |
| Mbovis.cogs_data | check | warning | Size of indexfile is: 72704 Should be:
|25600 |
| Mbovis.cogs_data | check | warning | Size of datafile is: 54195408 Should be:
|54195388 |
| Mbovis.cogs_data | check | error | Found 3277 keys of 257
| |
| Mbovis.cogs_data | check | error | Corrupt
| |
+------------------+-------+----------+---------------------------------------------------------+
5 rows in set (0.05 sec)
mysql> repair table cogs_data;
ERROR 2013: Lost connection to MySQL server during query
mysql> quit
0x8079ab8 handle_segfault__Fi + 380
0x8128eba pthread_sighandler + 150
0x814f0b6 chunk_free + 222
0x8151203 free + 155
0x8111cdc my_no_flags_free + 16
0x8106684 mi_repair + 2220
0x80c28e8 repair__9ha_myisamP3THDR17st_mi_check_paramb + 624
0x80c25ee repair__9ha_myisamP3THDP15st_ha_check_opt + 286
0x80c9430
mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13thr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i
+ 1432
0x80cc173 mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 67
0x8080fb1 mysql_execute_command__Fv + 4117
0x8083fa2 mysql_parse__FP3THDPcUi + 210
0x807f6bd do_command__FP3THD + 1269
0x807ebbb handle_one_connection__FPv + 551
Binaries produced on the problematic machine (Redhat 6.2), 2.2.19:
CFLAGS="-O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti" CXX=gcc
CXXFLAGS="-O3 -mpentiumpro -feli
de-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/usr/local/mysql
--enable-assembler --with-mysqld
-ldflags=-all-static -with-libwrap -with-named-z-lib --with-charset=latin1
--enable-thread-safe-client --with-nam
ed-curses-libs=/usr/local/lib/libncurses.a --with-pthread
If I should try also your binary distribution, please let me know.
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
<[EMAIL PROTECTED]> Faculty of Science, The Charles University
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php