>Description:
ADD INDEX for a modest-sized table hangs. The temporary table gets
created, but then the process forever hangs on
lwp_cond_wait(0xFF345548, 0xFF345558, 0xFF33EDB0) Err#62 ETIME
according to truss. There are no other processes active, says SHOW
PROCESSLIST. The table (myISAM) has lots of indices, including a
full-text index.
>How-To-Repeat:
alter table add index (number(4))
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Henning Schulzrinne
>Organization:
Dept. of Computer Science, Columbia University
>MySQL support: none
>Synopsis: ADD INDEX hangs
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.53 (Official MySQL binary)
>Environment:
Sun Netra
System: SunOS signal.cs.columbia.edu 5.8 Generic_108528-17 sun4u sparc SUNW,UltraAX-i2
Architecture: sun4
Some paths: /usr/bin/perl /usr/local/gnu/bin/make /usr/local/gnu/bin/gmake
/usr/local/gnu/bin/gcc /import/pkg/SUNWspro/bin//cc
GCC: Reading specs from
/usr/local/gnu/bin/../lib/gcc-lib/sparc-sun-solaris2.8/3.2.1/specs
Configured with: /src/unpack/gnu/gcc-3.2.1/configure --prefix=/opt/CUCSgnu
--with-gnu-as --with-as=/opt/CUCSgnu/bin/as --with-gnu-ld
--with-ld=/opt/CUCSgnu/bin/ld --enable-languages=c,c++,f77,objc
Thread model: posix
gcc version 3.2.1
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
LIBC:
-rw-r--r-- 1 root bin 1788196 Sep 21 00:52 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jan 27 03:45 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1157872 Sep 21 00:52 /lib/libc.so.1
-rw-r--r-- 1 root bin 1788196 Sep 21 00:52 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Jan 27 03:45 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1157872 Sep 21 00:52 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --with-server-suffix=
--enable-thread-safe-client --enable-local-infile --enable-assembler --disable-shared
--without-innodb CC=gcc 'CFLAGS=-O3 -fno-omit-frame-pointer' 'CXXFLAGS=-O3
-fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc
---------------------------------------------------------------------
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
