MySQL Forums
Forum List  »  InnoDB

Re: innodb update locks table...
Posted by: Heikki Tuuri
Date: February 28, 2006 05:57PM


as you see from, 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


(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,

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

Options: ReplyQuote

Written By
February 26, 2006 04:23PM
February 27, 2006 05:45AM
February 27, 2006 01:58PM
February 28, 2006 04:41PM
Re: innodb update locks table...
February 28, 2006 05:57PM
February 28, 2006 06:28PM
March 01, 2006 08:26AM
March 10, 2006 04:41PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.