>Description:
mysql apparently gets stuck when unlocking tables
i have several applications that do:
LOCK TABLES pv WRITE
LOAD DATA LOCAL INFILE 'pageview.data' INTO TABLE pv (id,count,date)
UNLOCK TABLES
future accesses to databases do not complete due to stuck "UNLOCK
TABLES"
commands.
| 196 | jsd | loathing.gamespot.com | page2 | Query | 48719 |
closing tables | UNLOCK TABLES |
| 197 | jsd | loathing.gamespot.com | page2 | Query | 48607 |
statistics | SELECT url1,url2,url3,id FROM url WHERE site='gs' |
| 198 | jsd | stage.gamespot.com | gamepro | Query | 507 |
closing tables | UNLOCK TABLES |
| 199 | jsd | stage.gamespot.com | gamepro | Field List | 472 |
Opening table | |
| 200 | jsd | stage.gamespot.com | gamepro | Query | 267 |
Opening table | describe gmbyr |
| 203 | jsd | stage.gamespot.com | | Query |
0 | | show processlist
notice that 197 (select) and 199/200 (field list/describe) are
stuck due to the
UNLOCK TABLES command not completing...
there is no way to free anything short of sending kill -9 to
mysqld. normal
mysqladmin shutdown does not work. tables are damaged of course
and need to
be fixed with mysqlcheck.
i tried using the prebuilt solaris binary and also compiling it
myself from
source. same problem. all recommended patches from Sun are
installed.
>How-To-Repeat:
unlock tables;
>Fix:
>Submitter-Id: <submitter ID>
>Originator:
>Organization: gamespot
>MySQL support: none
>Synopsis: mysql hangs doing unlock tables;
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.42 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.42, for
sun-solaris2.7 on sparc
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.42
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 6 days 23 hours 30 min 2 sec
Threads: 6 Questions: 15457 Slow queries: 85 Opens: 15 Flush tables:
1 Open tables: 5 Queries per second avg: 0.026
>Environment:
System: SunOS viagra.gamespot.com 5.7 Generic_106541-17 sun4u sparc
SUNW,Ultra-5_10
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake
/usr/local/bin/gcc /usr/ucb/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/3.0.1/specs
Configured with: ../configure --with-as=/usr/local/bin/as
--with-ld=/usr/local/bin/ld
Thread model: posix
gcc version 3.0.1
Compilation info:
CC='/usr/local/egcs/bin/gcc' CFLAGS='' CXX='/usr/local/egcs/bin/g++'
CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1707532 Sep 13 19:39 /lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 8 1998 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 bin bin 1125056 Sep 13 19:39 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1707532 Sep 13 19:39 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 8 1998 /usr/lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 bin bin 1125056 Sep 13 19:39 /usr/lib/libc.so.1
Configure command: ./configure --without-docs --without-bench
Perl: This is perl, version 5.005_02 built for sun4-solaris
---------------------------------------------------------------------
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