MySQL Forums
Forum List  »  InnoDB

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

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

Options: ReplyQuote


Subject
Views
Written By
Posted
6155
February 26, 2006 04:23PM
3369
February 27, 2006 05:45AM
2754
February 27, 2006 01:58PM
2886
February 28, 2006 04:41PM
Re: innodb update locks table...
2667
February 28, 2006 05:57PM
2587
February 28, 2006 06:28PM
2466
March 01, 2006 08:26AM
5182
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.