Re: repairing MyISAM table kills mysqld with SIG11 (fwd)
On Monday 27 August 2001 12:30, Martin MOKREJ? wrote: > > > > Sorry about that - we have now fixed the problems with our anonymous FTP > > upload, and it should be working. > > lokk in pub/mysql/secret/ for: > > 15593452(size) cogs_data.tgz > > But same file should be accessible already via the 2 web links I've sent > to you via personal e-mail. Thanks. Thanks. Monty or Sergei - can you take a look at it - repair table cogs_data; dumps core with the following backtrace: 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 -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - 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
Re: repairing MyISAM table kills mysqld with SIG11 (fwd)
> > Sorry about that - we have now fixed the problems with our anonymous FTP > upload, and it should be working. lokk in pub/mysql/secret/ for: 15593452(size) cogs_data.tgz But same file should be accessible already via the 2 web links I've sent to you via personal e-mail. 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
Re: repairing MyISAM table kills mysqld with SIG11 (fwd)
> > 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_optPCc13t= > hr_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 > > >=20 > > If that repair crashes our latest binary, make a tar.gz out of your > > table and upload it to: > >=20 > > 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:=20 > 530 Can't set guest privileges. > Login failed. > ftp> Sorry about that - we have now fixed the problems with our anonymous FTP upload, and it should be working. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA <___/ - 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
Re: repairing MyISAM table kills mysqld with SIG11 (fwd)
On Mon, 27 Aug 2001, Martin MOKREJŠ wrote: > > ftp://support.mysql.com/pub/mysql/secret Hmm, I can already login as ftp, but can only chdir to /pub/mysql, there's no secret directory. ;( > http://pednew.gsf.de/cogs_data.tgz Hmm, try out http://kulan.gsf.de/cogs_data.tgz , but I'm sure the previous worked for me. ;-) Do you have it? -- 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
Re: repairing MyISAM table kills mysqld with SIG11 (fwd)
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