Announcement

Announcement Module
Collapse
No announcement yet.

Innodb Thread/Mutex error

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Innodb Thread/Mutex error

    Hi there,

    We are running Perconas MySQL Build 5.5.23-r253 in production and run into the following error today:


    InnoDB: Warning: a long semaphore wait:--Thread 47316710868736 has waited at buf0flu.c line 1290 for 241.00 seconds the semaphore:Mutex at 0x16d983c8 '&buf_pool->mutex', lock var 1waiters flag 1


    This happened several times, slowing down the server without any heavy load spikes. A Sysadmin tried to restart the mysql-service. It hung without any activity and he (sadly) killed it. I guess this is the reason for the corrupted index:


    InnoDB: Error: trying to load index GEN_CLUST_INDEX for table tmp/#sql7e10_7a9_59InnoDB: but the index tree has been freed!


    We failed over to a slave, but I would like to understand the original problem, and I am happy about every idear/hint pointing me in a direction to prevent such errors in the future.

    Thanks for any help!
    Sebastian Munz.

    The mysqld.err log:


    120727 9:49:48 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:50:48 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:51:48 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:52:48 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)InnoDB: Warning: a long semaphore wait:--Thread 47316983875328 has waited at buf0lru.c line 498 for 241.00 seconds the semaphore:Mutex at 0x2b06aeaaa478 '&block->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316710868736 has waited at buf0flu.c line 1290 for 241.00 seconds the semaphore:Mutex at 0x16d983c8 '&buf_pool->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316984940288 has waited at dict0dict.c line 742 for 241.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316984674048 has waited at buf0buf.c line 3714 for 241.00 seconds the semaphore:X-lock (wait_ex) on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316986005248 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316840453888 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316984407808 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316843648768 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985472768 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316841252608 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316842850048 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316984141568 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985739008 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985206528 has waited at buf0buf.c line 2527 for 241.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:InnoDB: Pending preads 0, pwrites 0=====================================120727 9:53:02 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 67 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 29255 1_second, 29216 sleeps, 2921 10_second, 54 background, 54 flushsrv_master_thread log flush and writes: 29764----------SEMAPHORES----------OS WAIT ARRAY INFO: reservation count 10065, signal count 8871--Thread 47316983875328 has waited at buf0lru.c line 498 for 254.00 seconds the semaphore:Mutex at 0x2b06aeaaa478 '&block->mutex', lock var 1waiters flag 1--Thread 47316710868736 has waited at buf0flu.c line 1290 for 254.00 seconds the semaphore:Mutex at 0x16d983c8 '&buf_pool->mutex', lock var 1waiters flag 1--Thread 47316984940288 has waited at dict0dict.c line 742 for 254.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316984674048 has waited at buf0buf.c line 3714 for 254.00 seconds the semaphore:X-lock (wait_ex) on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316986005248 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316840453888 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316984407808 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316843648768 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316985472768 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316841252608 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316842850048 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316984141568 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316985739008 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316985206528 has waited at buf0buf.c line 2527 for 254.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316721358592 has waited at buf0buf.c line 2527 for 253.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316843382528 has waited at buf0buf.c line 2527 for 253.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316844979968 has waited at buf0buf.c line 2527 for 253.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316722157312 has waited at buf0buf.c line 2527 for 253.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316840187648 has waited at buf0buf.c line 2527 for 251.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316722423552 has waited at buf0buf.c line 2527 for 251.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316839921408 has waited at buf0buf.c line 2527 for 251.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316722689792 has waited at buf0buf.c line 2527 for 250.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316841518848 has waited at dict0dict.c line 5217 for 133.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316843915008 has waited at ha_innodb.cc line 9541 for 133.00 seconds the semaphore:Mutex at 0xf9d9e0 '&srv_dict_tmpfile_mutex', lock var 1waiters flag 1--Thread 47316840986368 has waited at ha_innodb.cc line 9541 for 133.00 seconds the semaphore:Mutex at 0xf9d9e0 '&srv_dict_tmpfile_mutex', lock var 1waiters flag 1--Thread 47316842583808 has waited at ha_innodb.cc line 9541 for 133.00 seconds the semaphore:Mutex at 0xf9d9e0 '&srv_dict_tmpfile_mutex', lock var 1waiters flag 1--Thread 47316843116288 has waited at ha_innodb.cc line 9541 for 133.00 seconds the semaphore:Mutex at 0xf9d9e0 '&srv_dict_tmpfile_mutex', lock var 1waiters flag 1--Thread 47316842317568 has waited at ha_innodb.cc line 9541 for 133.00 seconds the semaphore:Mutex at 0xf9d9e0 '&srv_dict_tmpfile_mutex', lock var 1waiters flag 1--Thread 47316840720128 has waited at dict0dict.c line 742 for 133.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316842051328 has waited at dict0dict.c line 742 for 133.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316721891072 has waited at dict0dict.c line 742 for 133.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316844181248 has waited at dict0dict.c line 742 for 133.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316986271488 has waited at buf0buf.c line 2527 for 133.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316986537728 has waited at buf0buf.c line 2527 for 133.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316987070208 has waited at dict0dict.c line 742 for 132.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316987336448 has waited at dict0dict.c line 742 for 132.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316987602688 has waited at dict0dict.c line 742 for 132.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316986803968 has waited at dict0dict.c line 742 for 132.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316844447488 has waited at ha_innodb.cc line 9541 for 16.000 seconds the semaphore:Mutex at 0xf9d9e0 '&srv_dict_tmpfile_mutex', lock var 1waiters flag 1--Thread 47316987868928 has waited at dict0dict.c line 742 for 12.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316988401408 has waited at dict0dict.c line 742 for 12.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316988667648 has waited at buf0buf.c line 2527 for 12.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316989466368 has waited at dict0dict.c line 742 for 12.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316988933888 has waited at dict0dict.c line 742 for 12.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316989732608 has waited at buf0buf.c line 2527 for 12.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316989200128 has waited at dict0dict.c line 742 for 12.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316989998848 has waited at buf0buf.c line 2527 for 12.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316990265088 has waited at buf0buf.c line 2527 for 11.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316990531328 has waited at buf0buf.c line 2527 for 11.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316990797568 has waited at buf0buf.c line 2527 for 11.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316991596288 has waited at buf0buf.c line 2527 for 11.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316991862528 has waited at buf0buf.c line 2527 for 11.000 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477--Thread 47316991063808 has waited at dict0dict.c line 742 for 11.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316991330048 has waited at dict0dict.c line 742 for 11.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1--Thread 47316992128768 has waited at dict0dict.c line 742 for 11.000 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1Mutex spin waits 42901, rounds 163881, OS waits 4142RW-shared spins 9666, rounds 223600, OS waits 4846RW-excl spins 1015, rounds 35826, OS waits 997Spin rounds per wait: 3.82 mutex, 23.13 RW-shared, 35.30 RW-excl--------FILE I/O--------I/O thread 0 state: waiting for i/o request (insert buffer thread)I/O thread 1 state: waiting for i/o request (log thread)I/O thread 2 state: waiting for i/o request (read thread)I/O thread 3 state: waiting for i/o request (read thread)I/O thread 4 state: waiting for i/o request (read thread)I/O thread 5 state: waiting for i/o request (read thread)I/O thread 6 state: waiting for i/o request (write thread)I/O thread 7 state: waiting for i/o request (write thread)I/O thread 8 state: waiting for i/o request (write thread)I/O thread 9 state: waiting for i/o request (write thread)Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0Pending flushes (fsync) log: 0; buffer pool: 0123754 OS file reads, 333106 OS file writes, 61558 OS fsyncs0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s-------------------------------------INSERT BUFFER AND ADAPTIVE HASH INDEX-------------------------------------Ibuf: size 1, free list len 3, seg size 5, 2020 mergesmerged operations: insert 2035, delete mark 48, delete 9discarded operations: insert 0, delete mark 0, delete 0Hash table size 17700827, node heap has 17119 buffer(s)0.00 hash searches/s, 0.12 non-hash searches/s---LOG---Log sequence number 154716916832Log flushed up to 154716915522Last checkpoint at 154716472088Max checkpoint age 869019772Checkpoint age target 841862905Modified age 415963Checkpoint age 4447440 pending log writes, 0 pending chkp writes147508 log i/o's done, 0.00 log i/o's/second----------------------BUFFER POOL AND MEMORY----------------------Total memory allocated 8824815616; in additional pool allocated 0Internal hash tables (constant factor + variable factor) Adaptive hash index 422088528 (141606616 + 280481912) Page hash 8851208 (buffer pool 0 only) Dictionary cache 36008760 (35403184 + 605576) File system 127992 (82672 + 45320) Lock system 21268344 (21250568 + 17776) Recovery system 0 (0 + 0)Dictionary memory allocated 605576InnoDB: ###### Diagnostic info printed to the standard error streamInnoDB: Warning: a long semaphore wait:--Thread 47316983875328 has waited at buf0lru.c line 498 for 272.00 seconds the semaphore:Mutex at 0x2b06aeaaa478 '&block->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316710868736 has waited at buf0flu.c line 1290 for 272.00 seconds the semaphore:Mutex at 0x16d983c8 '&buf_pool->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316984940288 has waited at dict0dict.c line 742 for 272.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316984674048 has waited at buf0buf.c line 3714 for 272.00 seconds the semaphore:X-lock (wait_ex) on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316986005248 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316840453888 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316984407808 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316843648768 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985472768 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316841252608 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316842850048 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316984141568 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985739008 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985206528 has waited at buf0buf.c line 2527 for 272.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316721358592 has waited at buf0buf.c line 2527 for 271.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316843382528 has waited at buf0buf.c line 2527 for 271.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316844979968 has waited at buf0buf.c line 2527 for 271.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316722157312 has waited at buf0buf.c line 2527 for 271.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316840187648 has waited at buf0buf.c line 2527 for 269.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316722423552 has waited at buf0buf.c line 2527 for 269.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316839921408 has waited at buf0buf.c line 2527 for 269.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316722689792 has waited at buf0buf.c line 2527 for 268.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:InnoDB: Pending preads 0, pwrites 0120727 9:53:48 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)InnoDB: ###### Diagnostic info printed to the standard error streamInnoDB: Warning: a long semaphore wait:--Thread 47316983875328 has waited at buf0lru.c line 498 for 303.00 seconds the semaphore:Mutex at 0x2b06aeaaa478 '&block->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316710868736 has waited at buf0flu.c line 1290 for 303.00 seconds the semaphore:Mutex at 0x16d983c8 '&buf_pool->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316984940288 has waited at dict0dict.c line 742 for 303.00 seconds the semaphore:Mutex at 0x22d9f658 '&dict_sys->mutex', lock var 1waiters flag 1InnoDB: Warning: a long semaphore wait:--Thread 47316984674048 has waited at buf0buf.c line 3714 for 303.00 seconds the semaphore:X-lock (wait_ex) on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316986005248 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316840453888 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316984407808 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316843648768 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985472768 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316841252608 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316842850048 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316984141568 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985739008 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316985206528 has waited at buf0buf.c line 2527 for 303.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316721358592 has waited at buf0buf.c line 2527 for 302.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316843382528 has waited at buf0buf.c line 2527 for 302.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316844979968 has waited at buf0buf.c line 2527 for 302.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316722157312 has waited at buf0buf.c line 2527 for 302.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316840187648 has waited at buf0buf.c line 2527 for 300.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316722423552 has waited at buf0buf.c line 2527 for 300.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316839921408 has waited at buf0buf.c line 2527 for 300.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: Warning: a long semaphore wait:--Thread 47316722689792 has waited at buf0buf.c line 2527 for 299.00 seconds the semaphore:S-lock on RW-latch at 0x16d98488 '&buf_pool->page_hash_latch'a writer (thread id 47316984674048) has reserved it in mode wait exclusivenumber of readers 1, waiters flag 1, lock_word: ffffffffffffffffLast time read locked in file buf0buf.c line 2527Last time write locked in file /var/tmp/portage/dev-db/percona-server-5.5.23-r253/work/Percona-Server-5.5.23-rel25.3/storage/innobase/buf/buf0buf.c line 3477InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:InnoDB: Pending preads 0, pwrites 0InnoDB: ###### Diagnostic info printed to the standard error stream120727 9:54:49 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:55:49 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:56:49 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:57:49 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:58:49 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 9:59:50 [Note] Start binlog_dump to slave_server(2), pos(mysql-bin.000082, 50801376)120727 10:00:13 [Note] /usr/sbin/mysqld: Normal shutdown120727 10:00:13 [Note] Event Scheduler: Purging the queue. 0 events120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2432 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2431 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2426 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2423 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2422 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2421 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2420 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2419 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2418 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2417 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2416 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2415 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2414 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2413 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2412 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2411 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2410 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2409 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2408 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2405 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2399 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2395 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2394 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2393 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2392 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2391 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2390 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2389 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2388 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2387 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2386 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2385 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2384 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2383 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2382 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2381 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2380 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2378 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2372 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2371 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2368 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2367 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2366 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2365 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2364 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2363 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2362 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2361 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2360 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2359 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2358 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2357 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2356 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2355 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2354 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2353 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2350 user: 'nagios'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2347 user: 'slave_checker'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2340 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2339 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2338 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2337 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2336 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2335 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2334 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2333 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2332 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2331 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2330 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2329 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2328 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2327 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2326 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2325 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2323 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2313 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2312 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2311 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2310 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2309 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2308 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2307 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2306 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2305 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2304 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2303 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2302 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2301 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2300 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2299 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2298 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2180 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2082 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2031 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2025 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2021 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2008 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2003 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 2001 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1970 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1966 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1965 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1964 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1963 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1962 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1961 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1960 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 1959 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 8 user: 'betaapp1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 7 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 6 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 5 user: 'app1'120727 10:00:15 [Warning] /usr/sbin/mysqld: Forcing close of thread 4 user: 'app1'120727 10:03:37 InnoDB: The InnoDB memory heap is disabled120727 10:03:37 InnoDB: Mutexes and rw_locks use GCC atomic builtins120727 10:03:37 InnoDB: Compressed tables use zlib 1.2.5120727 10:03:37 InnoDB: Initializing buffer pool, size = 8.0G120727 10:03:37 InnoDB: Completed initialization of buffer pool120727 10:03:37 InnoDB: highest supported file format is Barracuda.InnoDB: Log scan progressed past the checkpoint lsn 154716472088120727 10:03:37 InnoDB: Database was not shut down normally!InnoDB: Starting crash recovery.InnoDB: Reading tablespace information from the .ibd files...InnoDB: Restoring possible half-written data pages from the doublewriteInnoDB: buffer...InnoDB: Doing recovery: scanned up to log sequence number 154716915522120727 10:03:38 InnoDB: Starting an apply batch of log records to the database...InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completedInnoDB: Last MySQL binlog file position 0 50801376, file name ./mysql-bin.000082InnoDB: We removed now the InnoDB internal data dictionary entryInnoDB: of table 120727 10:03:39 [Warning] Invalid (old?) table or database name '#sql7e10_4_0'"tmp"..InnoDB: We removed now the InnoDB internal data dictionary entryInnoDB: of table 120727 10:03:39 [Warning] Invalid (old?) table or database name '#sql7e10_7_2'"tmp"..InnoDB: We removed now the InnoDB internal data dictionary entryInnoDB: of table 120727 10:03:39 [Warning] Invalid (old?) table or database name '#sql7e10_7_4'"tmp".

  • #2
    You are being hit with the bug
    https://bugs.launchpad.net/percona-server/+bug/1026926


    The only workaround to use is to enable innodb_lazy_drop_table in Percona Server >= 5.5.23

    Please use 'bug affects me' in the launchpad issue to raise the heat level of the issue.

    Comment

    Working...
    X