Hi,
sorry I did not send the last e-mail to the whole list, so here it is.
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
<[EMAIL PROTECTED]> Faculty of Science, The Charles University
---------- Forwarded message ----------
Date: Mon, 27 Aug 2001 17:39:07 +0200 (MET DST)
From: Martin MOKREJŠ <[EMAIL PROTECTED]>
To: Sinisa Milivojevic <[EMAIL PROTECTED]>
Subject: Re: repairing MyISAM table kills mysqld with SIG11
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote:
> Please try out our binary distro. I guess that you would not like
> either that we spend our time on fixing something that should not be
> fixed.
OK, so this is from mysql-3.23.41-pc-linux-gnu-i686/bin/mysqld.sym.gz et al.:
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.55 sec)
mysql> repair table cogs_data;
ERROR 2013: Lost connection to MySQL server during query
mysql> quit
0x807b1b8 handle_segfault__Fi + 380
0x812af8a pthread_sighandler + 154
0x81517df free + 39
0x8114a6c my_no_flags_free + 16
0x8109304 mi_repair + 2236
0x80c4768 repair__9ha_myisamP3THDR17st_mi_check_paramb + 624
0x80c446e repair__9ha_myisamP3THDP15st_ha_check_opt + 286
0x80cb320
mysql_admin_table__FP3THDP13st_table_listP15st_ha_check_optPCc13thr_lock_typebT5UiPM7handlerFP7handlerP3THDP15st_ha_check_opt_i
+ 1432
0x80ce076 mysql_repair_table__FP3THDP13st_table_listP15st_ha_check_opt + 70
0x8082641 mysql_execute_command__Fv + 4133
0x80856a6 mysql_parse__FP3THDPcUi + 210
0x8080d2d do_command__FP3THD + 1261
0x808022c handle_one_connection__FPv + 548
>
> If that repair crashes our latest binary, make a tar.gz out of your
> table and upload it to:
>
> ftp://support.mysql.com/pub/mysql/secret
kulan$ ftp support.mysql.com
Connected to support.mysql.com.
220 www.mysql.com FTP server ready.
Name (support.mysql.com:pedant): ftp
331 Guest login ok, send your complete e-mail address as password.
Password:
530 Can't set guest privileges.
Login failed.
ftp> user anonymous
331 Guest login ok, send your complete e-mail address as password.
Password:
530 Can't set guest privileges.
Login failed.
ftp>
>
> And send me a direct mail with a name of your tarball.
http://pednew.gsf.de/cogs_data.tgz
Please let me know that I can remove the file. ;)
Thanks!
--
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