Description:
I just pulled bk tree for 4.0 and did:
vrapenec mysql-4.0 # cd /usr/local/mysql-bk/
vrapenec mysql-bk # ls
bin include info lib libexec man mysql-test share sql-bench
vrapenec mysql-bk # ./libexec/mysqld
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 against 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=134217728
read_buffer_size=1044480
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 437871 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x8244590
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...
Cannot determine thread, fp=0xbfffc1b8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x80ed28e handle_segfault + 478
0x4003903c _end + 937452288
0x40037eeb _end + 937447855
0x8193e2f mi_open + 5103
0x81552f8 _ZN9ha_myisam4openEPKcij + 40
0x8153469 _ZN7handler7ha_openEPKcii + 41
0x81168f8 _Z7openfrmPKcS0_jjjP8st_table + 3896
0x81156ed _Z17open_unireg_entryP3THDP8st_tablePKcS4_S4_ + 125
0x811264e _Z10open_tableP3THDPKcS2_S2_Pb + 974
0x8113464 _Z11open_tablesP3THDP13st_table_list + 180
0x813f35f _Z8acl_initP3THDb + 431
0x80ee284 main + 2772
0x401db7a7 _end + 939166315
0x80a1391 _start + 33
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack 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 (nil) is invalid pointer
thd->thread_id=0
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
vrapenec mysql-bk #
How to repeat:
The machine is currently loaded, is Gentoo Linux
vrapenec mysql-bk # vmstat 1
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
r b swpd free buff cache si so bi bo in cs us sy id wa
2 0 0 28944 27800 715464 0 0 16 4 17 29 99 1 0 0
2 0 0 28952 27800 715464 0 0 0 0 106 69 98 2 0 0
vrapenec mysql-bk # ls -la /lib/libc*
-rwxr-xr-x 1 root root 1466302 Sep 9 16:18 /lib/libc-2.3.2.so
lrwxrwxrwx 1 root root 13 Sep 9 16:18 /lib/libc.so.6 -> libc-2.3.2.so
[cut]
vrapenec mysql-bk # ls -la /lib/libthr*
-rwxr-xr-x 1 root root 23109 Sep 9 16:18 /lib/libthread_db-1.0.so
lrwxrwxrwx 1 root root 19 Sep 9 16:18 /lib/libthread_db.so.1 -> libthread_db-1.0.so
vrapenec mysql-bk # ls -la /lib/libpthr*
-rwxr-xr-x 1 root root 91538 Sep 9 16:18 /lib/libpthread-0.10.so
lrwxrwxrwx 1 root root 18 Sep 9 16:18 /lib/libpthread.so.0 -> libpthread-0.10.so
vrapenec mysql-bk #
--------------------------------- -----------------------------
basedir /usr/local/mysql-bk
bind-address (No default value)
console FALSE
chroot (No default value)
character-sets-dir /usr/local/mysql-bk/share/mysql/charsets/
datadir /var/lib/mysql/
default-character-set latin1
enable-locking FALSE
enable-pstack TRUE
gdb FALSE
init-file (No default value)
log (No default value)
language /usr/local/mysql-bk/share/mysql/english/
local-infile TRUE
log-bin (No default value)
log-bin-index (No default value)
log-isam myisam.log
log-update (No default value)
log-slow-queries (No default value)
log-slave-updates FALSE
low-priority-updates FALSE
master-host (No default value)
master-user test
master-port 3306
master-connect-retry 60
master-retry-count 86400
master-info-file master.info
master-ssl FALSE
master-ssl-key (No default value)
master-ssl-cert (No default value)
master-ssl-capath (No default value)
master-ssl-cipher (No default value)
myisam-recover OFF
memlock FALSE
disconnect-slave-event-count 0
abort-slave-event-count 0
max-binlog-dump-events 0
sporadic-binlog-dump-fail FALSE
new FALSE
old-protocol 10
old-rpl-compat FALSE
pid-file /var/lib/mysql/vrapenec.pid
log-error
port 3306
report-host (No default value)
report-user (No default value)
report-password (No default value)
report-port 3306
rpl-recovery-rank 0
relay-log (No default value)
relay-log-index (No default value)
safe-user-create FALSE
server-id 207
show-slave-auth-info FALSE
concurrent-insert TRUE
skip-grant-tables FALSE
skip-slave-start FALSE
relay-log-info-file relay-log.info
slave-load-tmpdir /var/tmp/
socket /var/run/mysqld/mysqld.sock
sql-bin-update-same FALSE
sql-mode OFF
temp-pool TRUE
tmpdir /var/tmp
external-locking FALSE
use-symbolic-links TRUE
symbolic-links TRUE
log-warnings TRUE
warnings TRUE
back_log 100
binlog_cache_size 32768
connect_timeout 60000
delayed_insert_timeout 300
delayed_insert_limit 100
delayed_queue_size 1000
flush_time 0
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_stopword_file (No default value)
interactive_timeout 60000
join_buffer_size 131072
key_buffer_size 134217728
long_query_time 10
lower_case_table_names FALSE
max_allowed_packet 1073740800
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 100
max_connect_errors 10
max_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_tmp_tables 32
max_user_connections 50
max_write_lock_count 4294967295
bulk_insert_buffer_size 8388608
myisam_block_size 1024
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 100663296
myisam_repair_threads 1
myisam_sort_buffer_size 67108864
net_buffer_length 16384
net_retry_count 10
net_read_timeout 60000
net_write_timeout 60
open_files_limit 30000
query_cache_limit 1048576
query_cache_size 33554432
query_cache_type 1
read_buffer_size 1044480
read_rnd_buffer_size 262144
record_buffer 1044480
relay_log_space_limit 0
slave_compressed_protocol FALSE
slave_net_timeout 3600
read-only FALSE
slow_launch_time 2
sort_buffer_size 2097144
table_cache 16384
thread_concurrency 2
thread_cache_size 64
tmp_table_size 134217728
thread_stack 196608
wait_timeout 60000
default-week-format 0
To see what values a running MySQL server is using, type
'mysqladmin variables' instead of 'mysqld --help'.
bind(4, {sa_family=AF_UNIX, path="/var/run/mysqld/mysqld.sock"}, 110) = 0
umask(06) = 0
listen(4, 100) = 0
mmap2(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40300000
open("/var/tmp/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 5
fstat64(5, {st_dev=makedev(3, 2), st_ino=7, st_mode=S_IFDIR|S_ISVTX|0777, st_nlink=3, st_uid=0, st_gid=0, st_blksize=4096, st_blocks=2, st_size=824, st_atime=2003/02/06-23:47:29, st_mtime=2003/09/30-23:59:27, st_ctime=2003/09/30-23:59:27}) = 0
fcntl64(5, F_SETFD, FD_CLOEXEC) = 0
brk(0) = 0x823a000
brk(0x823b000) = 0x823b000
brk(0) = 0x823b000
brk(0x8243000) = 0x8243000
getdents64(5, {{d_ino=7, d_off=2, d_reclen=24, d_name="."} {d_ino=6, d_off=81065216, d_reclen=24, d_name=".."} {d_ino=2639097, d_off=146383744, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3277.err"} {d_ino=4032317, d_off=244966656, d_reclen=32, d_name=".keep"} {d_ino=2212774, d_off=272880256, d_reclen=64, d_name="Rhizobium_leguminosarum_3841.blast.510"} {d_ino=2638012, d_off=741691264, d_reclen=64, d_name="Rhizobium_leguminosarum_3841.blast.510.err"} {d_ino=611405, d_off=833233920, d_reclen=64, d_name="Cryptococcus_neoformans_B3501A.pfam.13281"} {d_ino=2638370, d_off=893214080, d_reclen=64, d_name="Fusobacterium_nucleatum_ATCC10953.pfam.1627"} {d_ino=2638417, d_off=893261568, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3051"} {d_ino=2638318, d_off=898870784, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3277"} {d_ino=604473, d_off=1135410816, d_reclen=64, d_name="Rhizobium_leguminosarum_3841.pfam.1786"} {d_ino=3386242, d_off=1258189952, d_reclen=64, d_name="Prochlorococcus_marinus_MED4.cogs.191"} {d_ino=2638428, d_off=1532808448, d_reclen=72, d_name="Clavibacter_michiganensis_sepedonicus.pfam.5277"} {d_ino=2639063, d_off=2031572480, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3051.err"} {d_ino=402, d_off=2040332416, d_reclen=32, d_name="portage"} {d_ino=3386243, d_off=2040332417, d_reclen=64, d_name="Prochlorococcus_marinus_MED4.cogs.191.err"}}, 4096) = 888
getdents64(5, {}, 4096) = 0
close(5) = 0
mmap2(NULL, 33546240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40321000
mmap2(NULL, 127684608, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4231f000
mmap2(NULL, 6537216, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x49ce4000
sched_get_priority_max(0) = 0
sched_get_priority_min(0) = 0
brk(0) = 0x8243000
brk(0x8244000) = 0x8244000
pipe([5, 6]) = 0
clone(Process 24768 attached (waiting for parent)
Process 24768 resumed (parent 24767 ready)
child_stack=0x8243f70, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND) = 24768
[pid 24768] --- SIGSTOP (Stopped (signal)) @ 0 (0) ---
[pid 24767] write(6, "k\202\0@\5\0\0\0\0\0\0\0\f\267\2@ \362\377\277\327\201"..., 148 <unfinished ...>
[pid 24768] modify_ldt(1, {entry_number:1, base_addr:0x4003b4c0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, 16 <unfinished ...>
[pid 24767] <... write resumed> ) = 148
[pid 24768] <... modify_ldt resumed> ) = 0
[pid 24767] rt_sigprocmask(SIG_SETMASK, NULL, <unfinished ...>
[pid 24768] rt_sigprocmask(SIG_SETMASK, ~[TRAP 33], <unfinished ...>
[pid 24767] <... rt_sigprocmask resumed> [HUP INT QUIT PIPE TERM TSTP RTMIN], 8) = 0
[pid 24768] <... rt_sigprocmask resumed> NULL, 8) = 0
[pid 24767] write(6, "\240\260\3@\0\0\0\0\240\365\377\277P\323\16\10\0\0\0\0"..., 148 <unfinished ...>
[pid 24768] read(5, <unfinished ...>
[pid 24767] <... write resumed> ) = 148
[pid 24768] <... read resumed> "k\202\0@\5\0\0\0\0\0\0\0\f\267\2@ \362\377\277\327\201"..., 148) = 148
[pid 24767] rt_sigprocmask(SIG_SETMASK, NULL, <unfinished ...>
[pid 24768] poll( <unfinished ...>
[pid 24767] <... rt_sigprocmask resumed> [HUP INT QUIT PIPE TERM TSTP RTMIN], 8) = 0
[pid 24768] <... poll resumed> [{fd=5, events=POLLIN, revents=POLLIN}], 1, 2000) = 1
[pid 24767] rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] <unfinished ...>
[pid 24768] getppid() = 24767
[pid 24768] read(5, "\240\260\3@\0\0\0\0\240\365\377\277P\323\16\10\0\0\0\0"..., 148) = 148
[pid 24768] mmap2(NULL, 36864, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40015000
[pid 24768] mprotect(0x40015000, 4096, PROT_NONE) = 0
[pid 24768] clone(Process 24769 attached
child_stack=0x4001dbd0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|SIGRT_1) = 24769
[pid 24768] kill(24767, SIGRTMIN <unfinished ...>
[pid 24769] --- SIGSTOP (Stopped (signal)) @ 0 (0) ---
[pid 24768] <... kill resumed> ) = 0
[pid 24767] --- SIGRTMIN (Unknown signal 32) @ 0 (0) ---
[pid 24767] <... rt_sigsuspend resumed> ) = -1 EINTR (Interrupted system call)
[pid 24767] sigreturn() = ? (mask now [HUP INT QUIT PIPE TERM TSTP RTMIN])
[pid 24767] rt_sigprocmask(SIG_SETMASK, NULL, [HUP INT QUIT PIPE TERM TSTP RTMIN], 8) = 0
[pid 24767] rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] <unfinished ...>
[pid 24769] modify_ldt(1, {entry_number:2, base_addr:0x4001dbe0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, 16 <unfinished ...>
[pid 24768] poll( <unfinished ...>
[pid 24769] <... modify_ldt resumed> ) = 0
[pid 24769] getpid() = 24769
[pid 24769] rt_sigprocmask(SIG_SETMASK, [HUP INT QUIT PIPE TERM TSTP RTMIN], NULL, 8) = 0
[pid 24769] sched_setscheduler(0x60c1, 0, 0x4001dcf8) = 0
[pid 24769] brk(0) = 0x8244000
[pid 24769] brk(0x8245000) = 0x8245000
[pid 24769] rt_sigprocmask(SIG_BLOCK, [ALRM], NULL, 8) = 0
[pid 24769] rt_sigaction(SIGALRM, {0x40038fc0, [], SA_RESTORER, 0x401eedb8}, {0x40038fc0, [], SA_RESTORER, 0x401eedb8}, 8) = 0
[pid 24769] rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0
[pid 24769] rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0
[pid 24769] open("/var/lib/mysql/vrapenec.pid", O_WRONLY|O_CREAT|O_LARGEFILE, 0664) = 7
[pid 24769] getpid() = 24769
[pid 24769] write(7, "24769", 5) = 5
[pid 24769] close(7) = 0
[pid 24769] kill(24767, SIGRTMIN) = 0
[pid 24767] --- SIGRTMIN (Unknown signal 32) @ 0 (0) ---
[pid 24767] <... rt_sigsuspend resumed> ) = -1 EINTR (Interrupted system call)
[pid 24767] sigreturn() = ? (mask now [HUP INT QUIT PIPE TERM TSTP RTMIN])
[pid 24767] brk(0) = 0x8245000
[pid 24767] brk(0x8246000) = 0x8246000
[pid 24767] open("./mysql/host.frm", O_RDONLY|O_LARGEFILE) = 7
[pid 24767] read(7, "\376\1\7\t\3\0\0\20\1\0\0000\0\0\347\0i\0\0\0\0\0\0\0\0"..., 64) = 64
[pid 24767] _llseek(7, 64, [64], SEEK_SET) = 0
[pid 24767] read(7, "//\0\0 \0\0", 7) = 7
[pid 24767] _llseek(7, 4096, [4096], SEEK_SET) = 0
[pid 24767] read(7, "\1\2\34\0\n\0\2\\\0\2\1\200\2\0\0\0\0<\0\2\200>\0\0\0\0"..., 39) = 39
[pid 24767] pread(7, "\377 "..., 105, 4327) = 105
[pid 24767] _llseek(7, 8192, [8192], SEEK_SET) = 0
[pid 24767] read(7, "h\3\0\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 288) = 288
[pid 24767] brk(0) = 0x8246000
[pid 24767] brk(0x8247000) = 0x8247000
[pid 24767] read(7, "\0\1\17\16\2\24) "..., 584) = 584
[pid 24767] close(7) = 0
[pid 24767] getcwd("/var/lib/mysql", 4096) = 15
[pid 24767] lstat64("/var/lib/mysql/mysql", {st_dev=makedev(3, 2), st_ino=3304702, st_mode=S_IFDIR|0700, st_nlink=2, st_uid=60, st_gid=60, st_blksize=4096, st_blocks=2, st_size=632, st_atime=2003/08/06-18:27:59, st_mtime=2003/08/09-21:41:11, st_ctime=2003/08/09-21:41:11}) = 0
[pid 24767] lstat64("/var/lib/mysql/mysql/host.MYI", {st_dev=makedev(3, 2), st_ino=3304710, st_mode=S_IFREG|0660, st_nlink=1, st_uid=60, st_gid=60, st_blksize=4096, st_blocks=8, st_size=1024, st_atime=2003/08/09-21:41:11, st_mtime=2003/08/09-21:41:11, st_ctime=2003/08/09-21:41:11}) = 0
[pid 24767] open("/var/lib/mysql/mysql/host.MYI", O_RDWR|O_LARGEFILE) = 7
[pid 24767] read(7, "\376\376\7\1\0\2\1\305\0\260\0d\0\310\0\2\0\0\1\0\10\1"..., 24) = 24
[pid 24767] readlink("./mysql/host.MYI", 0xbfffe130, 511) = -1 EINVAL (Invalid argument)
[pid 24767] readlink("./mysql/host.MYD", 0xbfffdf30, 511) = -1 EINVAL (Invalid argument)
[pid 24767] _llseek(7, 0, [0], SEEK_SET) = 0
[pid 24767] read(7, "\376\376\7\1\0\2\1\305\0\260\0d\0\310\0\2\0\0\1\0\10\1"..., 453) = 453
[pid 24767] open("./mysql/host.MYD", O_RDWR|O_LARGEFILE) = 8
[pid 24767] getpid() = 24767
[pid 24767] --- SIGSEGV (Segmentation fault) @ 0 (0) ---
[pid 24767] write(2, "mysqld got signal 11;\nThis could"..., 248mysqld got signal 11;
vrapenec mysql-bk # bin/myisamchk -dvv /var/lib/mysql/mysql/host.MYI
Segmentation fault
vrapenec mysql-bk # ls
bin include info lib libexec man mysql-test share sql-bench stack symbols
vrapenec mysql-bk # ulimit -c unlimited
vrapenec mysql-bk # bin/myisamchk -dvv /var/lib/mysql/mysql/host.MYI
Segmentation fault (core dumped)
vrapenec mysql-bk # gdb bin/myisamchk ./core
GNU gdb 5.3
Copyright 2002 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB. Type "show warranty" for details.
This GDB was configured as "i686-pc-linux-gnu"...
Core was generated by `bin/myisamchk -dvv /var/lib/mysql/mysql/host.MYI'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libpthread.so.0...done.
Loaded symbols for /lib/libpthread.so.0
Reading symbols from /usr/lib/libz.so.1...done.
Loaded symbols for /usr/lib/libz.so.1
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libm.so.6...done.
Loaded symbols for /lib/libm.so.6
Reading symbols from /lib/libc.so.6...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
#0 0x40034eeb in pthread_rwlock_init () from /lib/libpthread.so.0
(gdb) where
#0 0x40034eeb in pthread_rwlock_init () from /lib/libpthread.so.0
#1 0x0805407f in mi_open ()
#2 0x0804fa5e in myisamchk ()
#3 0x0804f5eb in main ()
#4 0x401037a7 in __libc_start_main () from /lib/libc.so.6
(gdb)
vrapenec mysql-bk # ls -la /var/lib/mysql/mysql
total 1007
drwx------ 2 mysql mysql 632 Aug 9 21:41 .
drwxr-xr-x 39 mysql mysql 2016 Sep 30 23:50 ..
-rw-rw---- 1 mysql mysql 0 May 9 12:10 Upd.MYD
-rw-rw---- 1 mysql mysql 1024 May 9 12:10 Upd.MYI
-rw-rw---- 1 mysql mysql 8576 May 9 12:10 Upd.frm
-rw-rw---- 1 mysql mysql 0 May 9 12:10 columns_priv.MYD
-rw-rw---- 1 mysql mysql 1024 May 9 12:10 columns_priv.MYI
-rw-rw---- 1 mysql mysql 8778 May 9 12:10 columns_priv.frm
-rw-rw---- 1 mysql mysql 585155 Aug 9 21:41 db.MYD
-rw-rw---- 1 mysql mysql 243712 Aug 9 22:11 db.MYI
-rw-rw---- 1 mysql mysql 9088 Aug 9 21:41 db.frm
-rw-rw---- 1 mysql mysql 0 Aug 9 21:41 func.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 9 21:41 func.MYI
-rw-rw---- 1 mysql mysql 8641 Aug 9 21:41 func.frm
-rw-rw---- 1 mysql mysql 0 Aug 9 21:41 host.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 9 21:41 host.MYI
-rw-rw---- 1 mysql mysql 9064 Aug 9 21:41 host.frm
-rw-r--r-- 1 mysql mysql 57932 Jan 10 2002 kulan.err
-rw-rw---- 1 mysql mysql 8430 Aug 9 21:41 tables_priv.MYD
-rw-rw---- 1 mysql mysql 5120 Aug 9 22:11 tables_priv.MYI
-rw-rw---- 1 mysql mysql 8877 Aug 9 21:41 tables_priv.frm
-rw-rw---- 1 mysql mysql 4304 Aug 9 21:41 user.MYD
-rw-rw---- 1 mysql mysql 2048 Aug 9 22:11 user.MYI
-rw-rw---- 1 mysql mysql 9806 Aug 9 21:41 user.frm
vrapenec mysql-bk #
Hmm, the datafile is empty, but it's empty also on other machines here! This box is my test machine and I stopped tetsing on it after reported previous batch of bugreports.
Get it from http://pedant.gsf.de/mysql-host.tgz
Description: I just pulled bk tree for 4.0 and did: vrapenec mysql-4.0 # cd /usr/local/mysql-bk/ vrapenec mysql-bk # ls bin include info lib libexec man mysql-test share sql-bench vrapenec mysql-bk # ./libexec/mysqld 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 against 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=134217728 read_buffer_size=1044480 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 437871 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8244590 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... Cannot determine thread, fp=0xbfffc1b8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80ed28e handle_segfault + 478 0x4003903c _end + 937452288 0x40037eeb _end + 937447855 0x8193e2f mi_open + 5103 0x81552f8 _ZN9ha_myisam4openEPKcij + 40 0x8153469 _ZN7handler7ha_openEPKcii + 41 0x81168f8 _Z7openfrmPKcS0_jjjP8st_table + 3896 0x81156ed _Z17open_unireg_entryP3THDP8st_tablePKcS4_S4_ + 125 0x811264e _Z10open_tableP3THDPKcS2_S2_Pb + 974 0x8113464 _Z11open_tablesP3THDP13st_table_list + 180 0x813f35f _Z8acl_initP3THDb + 431 0x80ee284 main + 2772 0x401db7a7 _end + 939166315 0x80a1391 _start + 33 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack 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 (nil) is invalid pointer thd->thread_id=0 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. vrapenec mysql-bk # How to repeat: The machine is currently loaded, is Gentoo Linux vrapenec mysql-bk # vmstat 1 procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 2 0 0 28944 27800 715464 0 0 16 4 17 29 99 1 0 0 2 0 0 28952 27800 715464 0 0 0 0 106 69 98 2 0 0 vrapenec mysql-bk # ls -la /lib/libc* -rwxr-xr-x 1 root root 1466302 Sep 9 16:18 /lib/libc-2.3.2.so lrwxrwxrwx 1 root root 13 Sep 9 16:18 /lib/libc.so.6 -> libc-2.3.2.so [cut] vrapenec mysql-bk # ls -la /lib/libthr* -rwxr-xr-x 1 root root 23109 Sep 9 16:18 /lib/libthread_db-1.0.so lrwxrwxrwx 1 root root 19 Sep 9 16:18 /lib/libthread_db.so.1 -> libthread_db-1.0.so vrapenec mysql-bk # ls -la /lib/libpthr* -rwxr-xr-x 1 root root 91538 Sep 9 16:18 /lib/libpthread-0.10.so lrwxrwxrwx 1 root root 18 Sep 9 16:18 /lib/libpthread.so.0 -> libpthread-0.10.so vrapenec mysql-bk # --------------------------------- ----------------------------- basedir /usr/local/mysql-bk bind-address (No default value) console FALSE chroot (No default value) character-sets-dir /usr/local/mysql-bk/share/mysql/charsets/ datadir /var/lib/mysql/ default-character-set latin1 enable-locking FALSE enable-pstack TRUE gdb FALSE init-file (No default value) log (No default value) language /usr/local/mysql-bk/share/mysql/english/ local-infile TRUE log-bin (No default value) log-bin-index (No default value) log-isam myisam.log log-update (No default value) log-slow-queries (No default value) log-slave-updates FALSE low-priority-updates FALSE master-host (No default value) master-user test master-port 3306 master-connect-retry 60 master-retry-count 86400 master-info-file master.info master-ssl FALSE master-ssl-key (No default value) master-ssl-cert (No default value) master-ssl-capath (No default value) master-ssl-cipher (No default value) myisam-recover OFF memlock FALSE disconnect-slave-event-count 0 abort-slave-event-count 0 max-binlog-dump-events 0 sporadic-binlog-dump-fail FALSE new FALSE old-protocol 10 old-rpl-compat FALSE pid-file /var/lib/mysql/vrapenec.pid log-error port 3306 report-host (No default value) report-user (No default value) report-password (No default value) report-port 3306 rpl-recovery-rank 0 relay-log (No default value) relay-log-index (No default value) safe-user-create FALSE server-id 207 show-slave-auth-info FALSE concurrent-insert TRUE skip-grant-tables FALSE skip-slave-start FALSE relay-log-info-file relay-log.info slave-load-tmpdir /var/tmp/ socket /var/run/mysqld/mysqld.sock sql-bin-update-same FALSE sql-mode OFF temp-pool TRUE tmpdir /var/tmp external-locking FALSE use-symbolic-links TRUE symbolic-links TRUE log-warnings TRUE warnings TRUE back_log 100 binlog_cache_size 32768 connect_timeout 60000 delayed_insert_timeout 300 delayed_insert_limit 100 delayed_queue_size 1000 flush_time 0 ft_min_word_len 4 ft_max_word_len 254 ft_max_word_len_for_sort 20 ft_stopword_file (No default value) interactive_timeout 60000 join_buffer_size 131072 key_buffer_size 134217728 long_query_time 10 lower_case_table_names FALSE max_allowed_packet 1073740800 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 100 max_connect_errors 10 max_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_relay_log_size 0 max_seeks_for_key 4294967295 max_sort_length 1024 max_tmp_tables 32 max_user_connections 50 max_write_lock_count 4294967295 bulk_insert_buffer_size 8388608 myisam_block_size 1024 myisam_max_extra_sort_file_size 268435456 myisam_max_sort_file_size 100663296 myisam_repair_threads 1 myisam_sort_buffer_size 67108864 net_buffer_length 16384 net_retry_count 10 net_read_timeout 60000 net_write_timeout 60 open_files_limit 30000 query_cache_limit 1048576 query_cache_size 33554432 query_cache_type 1 read_buffer_size 1044480 read_rnd_buffer_size 262144 record_buffer 1044480 relay_log_space_limit 0 slave_compressed_protocol FALSE slave_net_timeout 3600 read-only FALSE slow_launch_time 2 sort_buffer_size 2097144 table_cache 16384 thread_concurrency 2 thread_cache_size 64 tmp_table_size 134217728 thread_stack 196608 wait_timeout 60000 default-week-format 0 To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --help'. bind(4, {sa_family=AF_UNIX, path="/var/run/mysqld/mysqld.sock"}, 110) = 0 umask(06) = 0 listen(4, 100) = 0 mmap2(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40300000 open("/var/tmp/", O_RDONLY|O_NONBLOCK|O_LARGEFILE|O_DIRECTORY) = 5 fstat64(5, {st_dev=makedev(3, 2), st_ino=7, st_mode=S_IFDIR|S_ISVTX|0777, st_nlink=3, st_uid=0, st_gid=0, st_blksize=4096, st_blocks=2, st_size=824, st_atime=2003/02/06-23:47:29, st_mtime=2003/09/30-23:59:27, st_ctime=2003/09/30-23:59:27}) = 0 fcntl64(5, F_SETFD, FD_CLOEXEC) = 0 brk(0) = 0x823a000 brk(0x823b000) = 0x823b000 brk(0) = 0x823b000 brk(0x8243000) = 0x8243000 getdents64(5, {{d_ino=7, d_off=2, d_reclen=24, d_name="."} {d_ino=6, d_off=81065216, d_reclen=24, d_name=".."} {d_ino=2639097, d_off=146383744, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3277.err"} {d_ino=4032317, d_off=244966656, d_reclen=32, d_name=".keep"} {d_ino=2212774, d_off=272880256, d_reclen=64, d_name="Rhizobium_leguminosarum_3841.blast.510"} {d_ino=2638012, d_off=741691264, d_reclen=64, d_name="Rhizobium_leguminosarum_3841.blast.510.err"} {d_ino=611405, d_off=833233920, d_reclen=64, d_name="Cryptococcus_neoformans_B3501A.pfam.13281"} {d_ino=2638370, d_off=893214080, d_reclen=64, d_name="Fusobacterium_nucleatum_ATCC10953.pfam.1627"} {d_ino=2638417, d_off=893261568, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3051"} {d_ino=2638318, d_off=898870784, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3277"} {d_ino=604473, d_off=1135410816, d_reclen=64, d_name="Rhizobium_leguminosarum_3841.pfam.1786"} {d_ino=3386242, d_off=1258189952, d_reclen=64, d_name="Prochlorococcus_marinus_MED4.cogs.191"} {d_ino=2638428, d_off=1532808448, d_reclen=72, d_name="Clavibacter_michiganensis_sepedonicus.pfam.5277"} {d_ino=2639063, d_off=2031572480, d_reclen=64, d_name="Klebsiella_pneumoniae_MGH78578.cogs.3051.err"} {d_ino=402, d_off=2040332416, d_reclen=32, d_name="portage"} {d_ino=3386243, d_off=2040332417, d_reclen=64, d_name="Prochlorococcus_marinus_MED4.cogs.191.err"}}, 4096) = 888 getdents64(5, {}, 4096) = 0 close(5) = 0 mmap2(NULL, 33546240, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40321000 mmap2(NULL, 127684608, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x4231f000 mmap2(NULL, 6537216, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x49ce4000 sched_get_priority_max(0) = 0 sched_get_priority_min(0) = 0 brk(0) = 0x8243000 brk(0x8244000) = 0x8244000 pipe([5, 6]) = 0 clone(Process 24768 attached (waiting for parent) Process 24768 resumed (parent 24767 ready) child_stack=0x8243f70, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND) = 24768 [pid 24768] --- SIGSTOP (Stopped (signal)) @ 0 (0) --- [pid 24767] write(6, "k\202\0@\5\0\0\0\0\0\0\0\f\267\2@ \362\377\277\327\201"..., 148 <unfinished ...> [pid 24768] modify_ldt(1, {entry_number:1, base_addr:0x4003b4c0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, 16 <unfinished ...> [pid 24767] <... write resumed> ) = 148 [pid 24768] <... modify_ldt resumed> ) = 0 [pid 24767] rt_sigprocmask(SIG_SETMASK, NULL, <unfinished ...> [pid 24768] rt_sigprocmask(SIG_SETMASK, ~[TRAP 33], <unfinished ...> [pid 24767] <... rt_sigprocmask resumed> [HUP INT QUIT PIPE TERM TSTP RTMIN], 8) = 0 [pid 24768] <... rt_sigprocmask resumed> NULL, 8) = 0 [pid 24767] write(6, "\240\260\3@\0\0\0\0\240\365\377\277P\323\16\10\0\0\0\0"..., 148 <unfinished ...> [pid 24768] read(5, <unfinished ...> [pid 24767] <... write resumed> ) = 148 [pid 24768] <... read resumed> "k\202\0@\5\0\0\0\0\0\0\0\f\267\2@ \362\377\277\327\201"..., 148) = 148 [pid 24767] rt_sigprocmask(SIG_SETMASK, NULL, <unfinished ...> [pid 24768] poll( <unfinished ...> [pid 24767] <... rt_sigprocmask resumed> [HUP INT QUIT PIPE TERM TSTP RTMIN], 8) = 0 [pid 24768] <... poll resumed> [{fd=5, events=POLLIN, revents=POLLIN}], 1, 2000) = 1 [pid 24767] rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] <unfinished ...> [pid 24768] getppid() = 24767 [pid 24768] read(5, "\240\260\3@\0\0\0\0\240\365\377\277P\323\16\10\0\0\0\0"..., 148) = 148 [pid 24768] mmap2(NULL, 36864, PROT_READ|PROT_WRITE|PROT_EXEC, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x40015000 [pid 24768] mprotect(0x40015000, 4096, PROT_NONE) = 0 [pid 24768] clone(Process 24769 attached child_stack=0x4001dbd0, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|SIGRT_1) = 24769 [pid 24768] kill(24767, SIGRTMIN <unfinished ...> [pid 24769] --- SIGSTOP (Stopped (signal)) @ 0 (0) --- [pid 24768] <... kill resumed> ) = 0 [pid 24767] --- SIGRTMIN (Unknown signal 32) @ 0 (0) --- [pid 24767] <... rt_sigsuspend resumed> ) = -1 EINTR (Interrupted system call) [pid 24767] sigreturn() = ? (mask now [HUP INT QUIT PIPE TERM TSTP RTMIN]) [pid 24767] rt_sigprocmask(SIG_SETMASK, NULL, [HUP INT QUIT PIPE TERM TSTP RTMIN], 8) = 0 [pid 24767] rt_sigsuspend([HUP INT QUIT PIPE TERM TSTP] <unfinished ...> [pid 24769] modify_ldt(1, {entry_number:2, base_addr:0x4001dbe0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}, 16 <unfinished ...> [pid 24768] poll( <unfinished ...> [pid 24769] <... modify_ldt resumed> ) = 0 [pid 24769] getpid() = 24769 [pid 24769] rt_sigprocmask(SIG_SETMASK, [HUP INT QUIT PIPE TERM TSTP RTMIN], NULL, 8) = 0 [pid 24769] sched_setscheduler(0x60c1, 0, 0x4001dcf8) = 0 [pid 24769] brk(0) = 0x8244000 [pid 24769] brk(0x8245000) = 0x8245000 [pid 24769] rt_sigprocmask(SIG_BLOCK, [ALRM], NULL, 8) = 0 [pid 24769] rt_sigaction(SIGALRM, {0x40038fc0, [], SA_RESTORER, 0x401eedb8}, {0x40038fc0, [], SA_RESTORER, 0x401eedb8}, 8) = 0 [pid 24769] rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0 [pid 24769] rt_sigprocmask(SIG_UNBLOCK, [ALRM], NULL, 8) = 0 [pid 24769] open("/var/lib/mysql/vrapenec.pid", O_WRONLY|O_CREAT|O_LARGEFILE, 0664) = 7 [pid 24769] getpid() = 24769 [pid 24769] write(7, "24769", 5) = 5 [pid 24769] close(7) = 0 [pid 24769] kill(24767, SIGRTMIN) = 0 [pid 24767] --- SIGRTMIN (Unknown signal 32) @ 0 (0) --- [pid 24767] <... rt_sigsuspend resumed> ) = -1 EINTR (Interrupted system call) [pid 24767] sigreturn() = ? (mask now [HUP INT QUIT PIPE TERM TSTP RTMIN]) [pid 24767] brk(0) = 0x8245000 [pid 24767] brk(0x8246000) = 0x8246000 [pid 24767] open("./mysql/host.frm", O_RDONLY|O_LARGEFILE) = 7 [pid 24767] read(7, "\376\1\7\t\3\0\0\20\1\0\0000\0\0\347\0i\0\0\0\0\0\0\0\0"..., 64) = 64 [pid 24767] _llseek(7, 64, [64], SEEK_SET) = 0 [pid 24767] read(7, "//\0\0 \0\0", 7) = 7 [pid 24767] _llseek(7, 4096, [4096], SEEK_SET) = 0 [pid 24767] read(7, "\1\2\34\0\n\0\2\\\0\2\1\200\2\0\0\0\0<\0\2\200>\0\0\0\0"..., 39) = 39 [pid 24767] pread(7, "\377 "..., 105, 4327) = 105 [pid 24767] _llseek(7, 8192, [8192], SEEK_SET) = 0 [pid 24767] read(7, "h\3\0\20\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 288) = 288 [pid 24767] brk(0) = 0x8246000 [pid 24767] brk(0x8247000) = 0x8247000 [pid 24767] read(7, "\0\1\17\16\2\24) "..., 584) = 584 [pid 24767] close(7) = 0 [pid 24767] getcwd("/var/lib/mysql", 4096) = 15 [pid 24767] lstat64("/var/lib/mysql/mysql", {st_dev=makedev(3, 2), st_ino=3304702, st_mode=S_IFDIR|0700, st_nlink=2, st_uid=60, st_gid=60, st_blksize=4096, st_blocks=2, st_size=632, st_atime=2003/08/06-18:27:59, st_mtime=2003/08/09-21:41:11, st_ctime=2003/08/09-21:41:11}) = 0 [pid 24767] lstat64("/var/lib/mysql/mysql/host.MYI", {st_dev=makedev(3, 2), st_ino=3304710, st_mode=S_IFREG|0660, st_nlink=1, st_uid=60, st_gid=60, st_blksize=4096, st_blocks=8, st_size=1024, st_atime=2003/08/09-21:41:11, st_mtime=2003/08/09-21:41:11, st_ctime=2003/08/09-21:41:11}) = 0 [pid 24767] open("/var/lib/mysql/mysql/host.MYI", O_RDWR|O_LARGEFILE) = 7 [pid 24767] read(7, "\376\376\7\1\0\2\1\305\0\260\0d\0\310\0\2\0\0\1\0\10\1"..., 24) = 24 [pid 24767] readlink("./mysql/host.MYI", 0xbfffe130, 511) = -1 EINVAL (Invalid argument) [pid 24767] readlink("./mysql/host.MYD", 0xbfffdf30, 511) = -1 EINVAL (Invalid argument) [pid 24767] _llseek(7, 0, [0], SEEK_SET) = 0 [pid 24767] read(7, "\376\376\7\1\0\2\1\305\0\260\0d\0\310\0\2\0\0\1\0\10\1"..., 453) = 453 [pid 24767] open("./mysql/host.MYD", O_RDWR|O_LARGEFILE) = 8 [pid 24767] getpid() = 24767 [pid 24767] --- SIGSEGV (Segmentation fault) @ 0 (0) --- [pid 24767] write(2, "mysqld got signal 11;\nThis could"..., 248mysqld got signal 11; vrapenec mysql-bk # bin/myisamchk -dvv /var/lib/mysql/mysql/host.MYI Segmentation fault vrapenec mysql-bk # ls bin include info lib libexec man mysql-test share sql-bench stack symbols vrapenec mysql-bk # ulimit -c unlimited vrapenec mysql-bk # bin/myisamchk -dvv /var/lib/mysql/mysql/host.MYI Segmentation fault (core dumped) vrapenec mysql-bk # gdb bin/myisamchk ./core GNU gdb 5.3 Copyright 2002 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i686-pc-linux-gnu"... Core was generated by `bin/myisamchk -dvv /var/lib/mysql/mysql/host.MYI'. Program terminated with signal 11, Segmentation fault. Reading symbols from /lib/libpthread.so.0...done. Loaded symbols for /lib/libpthread.so.0 Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/ld-linux.so.2...done. Loaded symbols for /lib/ld-linux.so.2 #0 0x40034eeb in pthread_rwlock_init () from /lib/libpthread.so.0 (gdb) where #0 0x40034eeb in pthread_rwlock_init () from /lib/libpthread.so.0 #1 0x0805407f in mi_open () #2 0x0804fa5e in myisamchk () #3 0x0804f5eb in main () #4 0x401037a7 in __libc_start_main () from /lib/libc.so.6 (gdb) vrapenec mysql-bk # ls -la /var/lib/mysql/mysql total 1007 drwx------ 2 mysql mysql 632 Aug 9 21:41 . drwxr-xr-x 39 mysql mysql 2016 Sep 30 23:50 .. -rw-rw---- 1 mysql mysql 0 May 9 12:10 Upd.MYD -rw-rw---- 1 mysql mysql 1024 May 9 12:10 Upd.MYI -rw-rw---- 1 mysql mysql 8576 May 9 12:10 Upd.frm -rw-rw---- 1 mysql mysql 0 May 9 12:10 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 May 9 12:10 columns_priv.MYI -rw-rw---- 1 mysql mysql 8778 May 9 12:10 columns_priv.frm -rw-rw---- 1 mysql mysql 585155 Aug 9 21:41 db.MYD -rw-rw---- 1 mysql mysql 243712 Aug 9 22:11 db.MYI -rw-rw---- 1 mysql mysql 9088 Aug 9 21:41 db.frm -rw-rw---- 1 mysql mysql 0 Aug 9 21:41 func.MYD -rw-rw---- 1 mysql mysql 1024 Aug 9 21:41 func.MYI -rw-rw---- 1 mysql mysql 8641 Aug 9 21:41 func.frm -rw-rw---- 1 mysql mysql 0 Aug 9 21:41 host.MYD -rw-rw---- 1 mysql mysql 1024 Aug 9 21:41 host.MYI -rw-rw---- 1 mysql mysql 9064 Aug 9 21:41 host.frm -rw-r--r-- 1 mysql mysql 57932 Jan 10 2002 kulan.err -rw-rw---- 1 mysql mysql 8430 Aug 9 21:41 tables_priv.MYD -rw-rw---- 1 mysql mysql 5120 Aug 9 22:11 tables_priv.MYI -rw-rw---- 1 mysql mysql 8877 Aug 9 21:41 tables_priv.frm -rw-rw---- 1 mysql mysql 4304 Aug 9 21:41 user.MYD -rw-rw---- 1 mysql mysql 2048 Aug 9 22:11 user.MYI -rw-rw---- 1 mysql mysql 9806 Aug 9 21:41 user.frm vrapenec mysql-bk # Hmm, the datafile is empty, but it's empty also on other machines here! This box is my test machine and I stopped tetsing on it after reported previous batch of bugreports. Get it from http://pedant.gsf.de/mysql-host.tgz