InnoDB: Warning: a long semaphore wait:
--Thread 1196837184 has waited at btr/btr0sea.c line 947 for 241.00 seconds the semaphore:
S-lock on RW-latch at 0x2aaab20cb0b8 created in file btr/btr0sea.c line 139
a writer (thread id 1276442944) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file row/row0sel.c line 3499
Last time write locked in file btr/btr0sea.c line 516
InnoDB: Warning: a long semaphore wait:
--Thread 1204291904 has waited at dict/dict0dict.c line 751 for 241.00 seconds the semaphore:
Mutex at 0x2aaab20d42b8 created file dict/dict0dict.c line 713, lock var 1
waiters flag 1
InnoDB: Warning: a long semaphore wait:
--Thread 1276442944 has waited at btr/btr0sea.c line 516 for 241.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaab20cb0b8 created in file btr/btr0sea.c line 139
a writer (thread id 1276442944) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file row/row0sel.c line 3499
Last time write locked in file btr/btr0sea.c line 516
...
=====================================
110224 20:58:09 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 41 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 20546482, signal count 19237377
--Thread 1196837184 has waited at btr/btr0sea.c line 947 for 247.00 seconds the semaphore:
S-lock on RW-latch at 0x2aaab20cb0b8 created in file btr/btr0sea.c line 139
a writer (thread id 1276442944) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file row/row0sel.c line 3499
Last time write locked in file btr/btr0sea.c line 516
--Thread 1204291904 has waited at dict/dict0dict.c line 751 for 247.00 seconds the semaphore:
Mutex at 0x2aaab20d42b8 created file dict/dict0dict.c line 713, lock var 1
waiters flag 1
--Thread 1276442944 has waited at btr/btr0sea.c line 516 for 247.00 seconds the semaphore:
X-lock on RW-latch at 0x2aaab20cb0b8 created in file btr/btr0sea.c line 139
a writer (thread id 1276442944) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file row/row0sel.c line 3499
Last time write locked in file btr/btr0sea.c line 516
--Thread 1298008384 has waited at row/row0sel.c line 3499 for 247.00 seconds the semaphore:
S-lock on RW-latch at 0x2aaab20cb0b8 created in file btr/btr0sea.c line 139
a writer (thread id 1276442944) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file row/row0sel.c line 3499
Last time write locked in file btr/btr0sea.c line 516
--Thread 1287092544 has waited at btr/btr0sea.c line 1170 for 247.00 seconds the semaphore:
S-lock on RW-latch at 0x2aaab20cb0b8 created in file btr/btr0sea.c line 139
a writer (thread id 1276442944) has reserved it in mode  wait exclusive
number of readers 1, waiters flag 1
Last time read locked in file row/row0sel.c line 3499
Last time write locked in file btr/btr0sea.c line 516
...
---TRANSACTION 22 1219868725, ACTIVE 247 sec, process no 32426, OS thread id 1276442944 starting index read, thread declared inside InnoDB 500
mysql tables in use 1, locked 0
, holds adaptive hash latch
MySQL thread id 73880904, query id 2041897441 mag-div16.osl.basefarm.net 10.11.26.86 readonly statistics
SELECT repository_file_id, offset FROM magenta_repository_item WHERE repository_item_id = '2581902325'