Comment 6 for bug 1182918

Revision history for this message
Amol (ajkedar) wrote :

Yes i recently faced the issue in percona xtradb cluster 5.5.34

--Thread 140004927993600 has waited at row0sel.c line 3670 for 0.0000 seconds the semaphore:
S-lock on RW-latch at 0x6653a48 '&btr_search_latch_arr[i]'
number of readers 0, waiters flag 0, lock_word: 100000
Last time read locked in file row0sel.c line 3670
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-debs/label_exp/ubuntu-precise-64bit/target/Percona-XtraDB-Cluster-5.5.34/storage/innobase/btr/btr0sea.c line 674
--Thread 140005536966400 has waited at buf0buf.ic line 376 for 0.0000 seconds the semaphore:
Mutex at 0x7f55a3f645f0 '&block->mutex', lock var 0
waiters flag 0
--Thread 140005551875840 has waited at buf0buf.ic line 376 for 0.0000 seconds the semaphore:
Mutex at 0x7f55a3f645f0 '&block->mutex', lock var 0
waiters flag 0
--Thread 140005535368960 has waited at row0sel.c line 3670 for 0.0000 seconds the semaphore:
S-lock on RW-latch at 0x6653a48 '&btr_search_latch_arr[i]'
number of readers 0, waiters flag 0, lock_word: 100000
Last time read locked in file row0sel.c line 3670
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-debs/label_exp/ubuntu-precise-64bit/target/Percona-XtraDB-Cluster-5.5.34/storage/innobase/btr/btr0sea.c line 674
--Thread 140005536700160 has waited at row0sel.c line 3670 for 0.0000 seconds the semaphore:
S-lock on RW-latch at 0x6653a48 '&btr_search_latch_arr[i]'
number of readers 0, waiters flag 0, lock_word: 100000
Last time read locked in file row0sel.c line 3670
Last time write locked in file /mnt/workspace/percona-xtradb-cluster-debs/label_exp/ubuntu-precise-64bit/target/Percona-XtraDB-Cluster-5.5.34/storage/innobase/btr/btr0sea.c line 674
--Thread 140005559064320 has waited at buf0buf.ic line 376 for 0.0000 seconds the semaphore:
Mutex at 0x7f55a3f645f0 '&block->mutex', lock var 0
waiters flag 0
--Thread 140005533771520 has waited at buf0buf.ic line 376 for 0.0000 seconds the semaphore:
Mutex at 0x7f55a3f645f0 '&block->mutex', lock var 1
waiters flag 0