Skip to content

FIX: Percona InnoDB: Warning: a long semaphore wait:…

September 17, 2012

There is a Bug in Percona server that make semaphores to wait

Paste from the error log:

 

InnoDB: Warning: a long semaphore wait:
–Thread 140470371960576 has waited at dict0dict.c line 744 for 253.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140471051273984 has waited at dict0dict.c line 744 for 252.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140468937459456 has waited at dict0dict.c line 744 for 251.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140468817950464 has waited at dict0dict.c line 744 for 251.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140470382466816 has waited at dict0dict.c line 744 for 250.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140466198472448 has waited at dict0dict.c line 744 for 250.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140469373732608 has waited at dict0dict.c line 744 for 250.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140465988605696 has waited at dict0dict.c line 744 for 248.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
–Thread 140470378264320 has waited at dict0dict.c line 744 for 248.00 seconds the semaphore:
Mutex at 0x8137bf8 ‘&dict_sys->mutex’, lock var 1
waiters flag 1

 

The ONLY fix is to upgrade the Percona Server.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: