>Description: mysqld still seems to hang when nightly table checks are running. Formerly, this seemed to be due to a race condition that was hopefully fixed in 3.23.46. Server is up, but all queries are stuck in "opening tables". mysqld is taking 100% of one CPU. pstack and other debugging sent under additional cover. Database shutdown hung, and database was ultimately killed with kill -KILL. Tables were all marked as closed, though!
>How-To-Repeat: Run analyze table on all tables while other activity is occuring in database (particularly connect/disconnects). >Fix: Analyze temporarily disabled. However, several large join tables which are updated nightly need to have analyze run as part of batch stream. >Submitter-Id: Support #297 >Originator: David Birnbaum >Organization: >MySQL support: extended >Synopsis: mysql stuck on analyze >Severity: serious >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.23.46 (Source distribution) >Environment: System: SunOS fosters 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-4 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /opt/gcc/3.0.1/lib/gcc-lib/sparc-sun-solaris2.8/3.0.1/specs Configured with: ../3.0.1/configure --prefix=/opt/gcc/3.0.1 Thread model: posix gcc version 3.0.1 Compilation info: CC='/opt/gcc/2.95.2/bin/gcc' CFLAGS='-O3 -mcpu=v8 -Wa,-xarch=v8plusa' CXX='/opt/gcc/2.95.2/bin/g++' CXXFLAGS='-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 11 Mar 31 2001 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 27 18:09 /lib/libc.so.1 lrwxrwxrwx 1 root root 11 Mar 31 2001 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1136748 Nov 27 18:09 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/opt/mysql/3.23.46 --with-berkeley-db --with-innobase --localstatedir=/export/DB/mysqldb --with-unix-socket-path=/var/tmp/mysql.sock --------------------------------------------------------------------- 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