Re: innodb update locks table...
Anda,
as you see from
http://bugs.mysql.com/bug.php?id=15868, I put it to the 'Can't repeat' status because I was not able to repeat it on a uniprocessor or a 4-way Opteron.
You may be hitting a different bug. Are you sure that Tomcat uses MySQL connections in a legal way? If it mixes MySQL API calls in a wrong sequence, it might cause hangs and crashes. Hmm... the problem might be that Tomcat uses prepared statement calls in a wrong way.
Can you compile mysqld yourself:
mysql-5.0.18> CFLAGS="-O3 -g" CXXFLAGS="-O3 -g" ./configure
mysql-5.0.18> make
Then run inside gdb:
mysql-5.0.18/sql> gdb mysqld
(gdb) run
...
You can use 'top' or ps -A to check the process numbers of mysqld threads.
When mysqld hangs, send a signal to one of the mysqld threads in gdb:
kill -11 <process number of the thread>
That signal should stop gdb. Ctrl-C used to stop gdb years ago, but it does not seem to work nowadays.
Then, do:
(gdb) info threads
Then:
(gdb) thread 1
(gdb) bt full
...
etc. so that we get a stack trace for every thread. Then we could see where the threads are stuck. I suspect some bug in Tomcat pooling, but who knows.
Best regards,
Heikki
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php