percona-discussion team mailing list archive

[Jeremy Kerr <jk@xxxxxxxxxx>]

LCM: glad to hear you got the backtrace. Here's what I can tell from it:

Most threads are blocked in pthread_cond_wait:

7 are blocked on log_sys->mutex from mtr_commit()
4 threads are each waiting on the elements of os_aio_segment_wait_events[0, 1, 2, 3]->os_mutex
1 thread is waiting on buf_pool_mutex from log_close(), but *also* holds the log_sys mutex which the first 7 threads are waiting on.

I'm not aware of any locking dependencies that mean that the threads in
mtr_commit will hold the os_aio_segment_wait_events->os_mutex, but this
is entirely possible. Vadim: are you able to confirm/reject this?

So, the buf_pool_mutex thread could be the culprit here. I'd suggest
taking a look at the log_sys->mutex and confirming that this thread is
indeed the owner (just dump the pthread_mutex_t in gdb), and then seeing
who owns the buf_pool_mutex.

LCM: also, could you post your config.h generated during the mysql
build? I'd just like to confirm which type of mutexes are in use.

-- 
Innodb locks up under large INSERT load
https://bugs.launchpad.net/bugs/378100
You received this bug notification because you are a member of Percona
developers, which is the registrant for Percona-XtraDB.

Status in Percona XtraDB Storage Engine for MySQL: New

Bug description:
While trying to load a new db on the 5.1.34-xtradb build, the Innodb engine locks up after a few minutes with multiple table loads running.

I can still log into the server, but I don't get any data back from the SHOW ENGINE INNODB STATUS command. I also can't kill any of the existing INSERT commands. I can reproduce the problem with as few as 3 simulateous loads (INSERT) occurring.

I am running this on SuSE version 10 with 8 processors and 126GB of RAM. 

Can I get some help in troubleshooting this? There are no messages being written to the error log.