Hi All,
well, folks, mysql 3.23 also hangs.
Attempts to connect thru UNIX socket and TCP/IP both hang after asking
for password.
This is what mysqlbug has to say:
>Release: mysql-3.23.25-beta (Source distribution)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: FreeBSD hub.all.yans.ru 4.1-RELEASE FreeBSD 4.1-RELEASE #2: Mon Oct 9 14:22:57
MSD 2000 root@stripped:/usr/src/sys/compile/HUB i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS='-Wall -pipe' CXX='cc' CXXFLAGS='-Wall -pipe -fno-rtti
-fno-exceptions -felide-constructors' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1156960 Jul 28 17:05 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Aug 30 21:17 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 553460 Jul 28 17:05 /usr/lib/libc.so.4
Configure command: ./configure --prefix=/usr/local/mysql --with-debug=full
--without-readline --enable-assembler --localstatedir=/var/db/mysql
--enable-thread-safe-client
Perl: This is perl, version 5.005_03 built for i386-freebsd
Attaching with gdb to mysqld process produced the following output:
bash-2.04# gdb mysqld 47659
GNU gdb 4.18
Copyright 1998 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 "i386-unknown-freebsd"...
/root/mysql-3.23.25-beta/sql/47659: No such file or directory.
Attaching to program: /root/mysql-3.23.25-beta/sql/mysqld, process 47659
Reading symbols from /usr/lib/libc_r.so.4...done.
Reading symbols from /usr/lib/libm.so.2...done.
Reading symbols from /usr/lib/libz.so.2...done.
Reading symbols from /usr/lib/libcrypt.so.2...done.
Reading symbols from /usr/libexec/ld-elf.so.1...done.
0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4
(gdb) info threads
4 process 47659, thread 4 0x2821780e in _thread_kern_sched ()
from /usr/lib/libc_r.so.4
3 process 47659, thread 3 0x2821780e in _thread_kern_sched ()
from /usr/lib/libc_r.so.4
2 process 47659, thread 2 0x2821780e in _thread_kern_sched ()
from /usr/lib/libc_r.so.4
* 1 process 47659, thread 1 0x2821ff64 in _thread_sys_poll ()
from /usr/lib/libc_r.so.4
(gdb) thread 1
[Switching to thread 1 (process 47659, thread 1)]
#0 0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x2821ff64 in _thread_sys_poll () from /usr/lib/libc_r.so.4
#1 0x28218913 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
#2 0x28217ffe in _thread_kern_sched () from /usr/lib/libc_r.so.4
#3 0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
#4 0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4
#5 0x2821d329 in pthread_exit () from /usr/lib/libc_r.so.4
#6 0x8079ca1 in end_thread (thd=0x8a3d000, put_in_cache=true) at mysqld.cc:928
#7 0x807ef15 in handle_one_connection (arg=0x8a3d000) at sql_parse.cc:421
#8 0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
#9 0x0 in ?? ()
(gdb) thread 2
[Switching to thread 2 (process 47659, thread 2)]
#0 0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
#1 0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
#2 0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4
#3 0x2821d329 in pthread_exit () from /usr/lib/libc_r.so.4
#4 0x8079ca1 in end_thread (thd=0x8a3d000, put_in_cache=true) at mysqld.cc:928
#5 0x807ef15 in handle_one_connection (arg=0x8a3d000) at sql_parse.cc:421
#6 0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
#7 0x0 in ?? ()
(gdb) thread 3
[Switching to thread 3 (process 47659, thread 3)]
#0 0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
#1 0x28218493 in _thread_kern_sched_state_unlock () from /usr/lib/libc_r.so.4
#2 0x2821643a in pthread_mutex_lock () from /usr/lib/libc_r.so.4
#3 0x28216744 in _mutex_cv_lock () from /usr/lib/libc_r.so.4
#4 0x2821da14 in pthread_cond_timedwait () from /usr/lib/libc_r.so.4
#5 0x28205389 in _thread_gc () from /usr/lib/libc_r.so.4
#6 0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
#7 0x0 in ?? ()
(gdb) thread 4
[Switching to thread 4 (process 47659, thread 4)]
#0 0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
(gdb) bt
#0 0x2821780e in _thread_kern_sched () from /usr/lib/libc_r.so.4
#1 0x28218422 in _thread_kern_sched_state () from /usr/lib/libc_r.so.4
#2 0x281dd39b in sigwait () from /usr/lib/libc_r.so.4
#3 0x807a244 in signal_hand (arg=0x0) at mysqld.cc:1153
#4 0x281df65b in _thread_start () from /usr/lib/libc_r.so.4
#5 0x0 in ?? ()
(gdb)
Clients left connected were still able to communicate thru the existing
connections. mysqladmin started with -i 60 extended-status variables
produced the following output:
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 6634488 |
| Bytes_sent | 49752465 |
| Connections | 4223 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 6025 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 0 |
| Handler_read_first | 4588 |
| Handler_read_key | 5206 |
| Handler_read_next | 1528 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 244410 |
| Handler_read_rnd_next | 51108326 |
| Handler_update | 144 |
| Handler_write | 3352246 |
| Key_blocks_used | 115 |
| Key_read_requests | 50937 |
| Key_reads | 5 |
| Key_write_requests | 12550 |
| Key_writes | 0 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 13 |
| Open_files | 25 |
| Open_streams | 1 |
| Opened_tables | 19 |
| Questions | 152732 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 63024 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_range | 0 |
| Sort_rows | 244410 |
| Sort_scan | 16025 |
| Threads_cached | 0 |
| Threads_connected | 2 |
| Threads_running | 2 |
| Uptime | 8114 |
+--------------------------+----------+
+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value
|
+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------+
| ansi_mode | OFF
|
| back_log | 50
|
| basedir | /usr/local/mysql/
|
| character_set | latin1
|
| character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251
danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 |
| connect_timeout | 5
|
| concurrent_insert | ON
|
| datadir | /heap/mysql/
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| join_buffer_size | 131072
|
| flush | OFF
|
| flush_time | 0
|
| init_file |
|
| interactive_timeout | 28800
|
| key_buffer_size | 8388572
|
| language | /usr/local/mysql/share/mysql/english/
|
| log | ON
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 0
|
| max_allowed_packet | 1048576
|
| max_connections | 100
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_sort_length | 1024
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_retry_count | 1000000
|
| pid_file | /mysqld.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| skip_locking | OFF
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | /tmp/mysql.sock
|
| sort_buffer | 2097116
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_stack | 65536
|
| thread_cache_size | 0
|
| timezone | MSD
|
| tmp_table_size | 1048576
|
| tmpdir | /var/tmp/
|
| version | 3.23.25-beta-debug-log
|
| wait_timeout | 28800
|
+-------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------+
< This is where mysqld apparently hung as the last query in the log was
4238 >
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 6662509 |
| Bytes_sent | 49954778 |
| Connections | 4240 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 6051 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 0 |
| Handler_read_first | 4604 |
| Handler_read_key | 5206 |
| Handler_read_next | 1528 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 245355 |
| Handler_read_rnd_next | 51351641 |
| Handler_update | 144 |
| Handler_write | 3373881 |
| Key_blocks_used | 115 |
| Key_read_requests | 50937 |
| Key_reads | 5 |
| Key_write_requests | 12550 |
| Key_writes | 0 |
| Max_used_connections | 2 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 13 |
| Open_files | 25 |
| Open_streams | 1 |
| Opened_tables | 19 |
| Questions | 153333 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 63299 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_range | 0 |
| Sort_rows | 245355 |
| Sort_scan | 16105 |
| Threads_cached | 0 |
| Threads_connected | 2 |
| Threads_running | 1 |
| Uptime | 8174 |
+--------------------------+----------+
It would seem that after the last query was processed ok none of the new
connections could be established.
BTW, mysql 3.23 hangs considerably sooner than 3.22 but that may be
accidental.
Any ideas or suggestions ?
Thanx in advance.
Ekaterina Ivannikova
