>Description:
010827 16:24:44 Warning: Retrying repair of: './Mloti/blast_data' with keycache
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail
key_buffer_size=268431360
record_buffer=4190208
sort_buffer=67108856
max_used_connections=6
max_connections=100
threads_connected=5
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 3030635 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Stack range sanity check OK, backtrace follows:
0x807b0b8
0x812a6fa
0x8150f4f
0x81141dc
0x8108a84
0x80c4268
0x80c3f6e
0x80cacd0
0x80cd9e6
0x8082421
0x8085476
0x8080b4d
0x808006e
Stack trace seems successful - bottom reached
Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow
instructions on how to resolve the sta
ck trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x859ead0 = repair TABLE blast_data
thd->thread_id=268
Successfully dumped variables, if you ran with --log, take a look at the
details of what thread 268 did to cause the crash. In some cases of really
bad corruption, the above values may be invalid
Please use the information above to create a repeatable test case for the
crash, and send it to [EMAIL PROTECTED]
Number of processes running now: 0
010827 16:24:44 mysqld restarted
>How-To-Repeat:
/usr/local/mysql-3.23.39/bin/mysqlcheck -r --compress Mloti
Mloti.Upd OK
Mloti.blast OK
Mloti.blast_crossupdate OK
Mloti.blast_crossupdate_data OK
/usr/local/mysql-3.23.39/bin/mysqlcheck: Got error: 2013: Lost connection to MySQL
server during query when executing 'REPAIR TABLE'
mysql> check TABLE blast_data;
+------------------+-------+----------+-----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text
| |
+------------------+-------+----------+-----------------------------------------------------------+
| Mloti.blast_data | check | warning | Table is marked as crashed and last repair
|failed |
| Mloti.blast_data | check | warning | Size of datafile is: 178083072 Should
|be: 178083068 |
| Mloti.blast_data | check | error | Can't read indexpage from filepos: -1
| |
| Mloti.blast_data | check | error | Corrupt
| |
+------------------+-------+----------+-----------------------------------------------------------+
4 rows in set (0.01 sec)
mysql> optimize TABLE blast_data;
+------------------+----------+----------+-------------------------------------------------+
| Table | Op | Msg_type | Msg_text
| |
+------------------+----------+----------+-------------------------------------------------+
| Mloti.blast_data | optimize | error | Can't open file: 'blast_data.MYD'. (errno:
|144) |
+------------------+----------+----------+-------------------------------------------------+
1 row in set (0.00 sec)
mysql> repair TABLE blast_data;
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 268
Current database: Mloti
Resolved stack trace generated with the mysqlcheck utility (stack trace generated by
`REPAIR TABLE blast_data' seems exactly same).
kulan$ nm -n /usr/local/mysql-3.23.39/libexec/mysqld > symbol.table
kulan$ /usr/local/mysql-3.23.39/bin/resolve_stack_dump -s symbol.table -n stack
0x807b0b8 handle_connections_sockets__FPv + 948
0x812a6fa uncompress + 122
0x8150f4f ptmalloc_init_all + 7
0x81141dc ptr_compare_2 + 0
0x8108a84 sort_write_record + 856
0x80c4268 rnd_pos__12ha_myisammrgPcT1 + 44
0x80c3f6e create__12ha_myisammrgPCcP8st_tableP24st_ha_create_information + 70
0x80cacd0
mysql_alter_table__FP3THDPcT1P24st_ha_create_informationP13st_table_listRt4List1Z12create_fieldRt4List1Z3KeyRt4List1Z10Alter_dr
+ 7464
0x80cd9e6 read_field__9READ_INFO + 358
0x8082421 mysql_execute_command__Fv + 9845
0x8085476 yyparse__Fv + 4870
0x8080b4d mysql_execute_command__Fv + 3489
0x808006e mysql_execute_command__Fv + 706
kulan$
mysql-3.23.39 has been compiled on thjis machine running currently 2.2.19 kernel
(linux redhat) with egcs-2.91.66.
>Fix:
>Submitter-Id: <submitter ID>
>Originator: mmokrejs
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.39 (Official MySQL binary)
>Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for pc-linux-gnu
>on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.39-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 2 min 41 sec
Threads: 1 Questions: 40 Slow queries: 0 Opens: 20 Flush tables: 1 Open tables:
12 Queries per second avg: 0.248
>Environment:
System: Linux kulan.gsf.de 2.2.19 #4 SMP Mon Aug 20 20:08:08 CEST 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3
-mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 Sep 6 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4106956 Sep 1 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
