>DescripWell, for some reason after a table is being automatically repaired
by mysql , some thread will be a suspended state. Mysqladmin will report
a "waiting for table" in the state column of those threads. A look at
the .err file showed me a "Warning: Checking table:" message.
I waited a while and eventually I got my usual "Aborted connection"
but the threads were still there. The oldest one had a times value of
95510.
<precise description of the problem (multiple lines)>
>How-To-Repeat:
run your server with myisam-recover
and wait.
>Fix:
mysqladmin flush-tables got rid of the offending threads
>Submitter-Id: <submitter ID>
>Originator: [EMAIL PROTECTED]
>Organization:
>MySQL support: none
>Synopsis: stuck threads
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
Release: mysql-3.23.32 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.14 Distrib 3.23.32, 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.32-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /my/mysql.sock
Uptime: 1 day 2 hours 46 min 40 sec
Threads: 3 Questions: 4344271 Slow queries: 0 Opens: 3479 Flush tables: 2 Open
tables: 62 Queries per second avg: 45.065
>Environment:
System: Linux medusa.hitlist.com 2.2.14-5.0smp #1 SMP Tue Mar 7 21:01:40 EST 2000 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='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Mar 19 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 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 --with-unix-socket-path=/my/mysql.sock
--with-berkely-db=/usr/local/BerkeleyDB.3.2
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
