Percona-5.7.25 crash with long wait semaphore
General
Escalation
General
Escalation
Description
Environment
None
Activity
Show:
Aaditya Dubey December 10, 2023 at 6:38 AM
Hi ,
We still haven't heard any news from you. So I assume issue does not persist anymore and will close the ticket. If you disagree just reply and create a follow-up new Jira Ticket.
Aaditya Dubey October 16, 2023 at 9:54 AM
Hi ,
Thank you for the report.
Please share full errorLog and test case to repeat the issue if available.
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 12308450
--Thread 139664483940096 has waited at trx0trx.cc line 1192 for 849.00 seconds the semaphore:
Mutex at 0x7f0cd1b613a0, Mutex REDO_RSEG created trx0rseg.cc:211, lock var 1
--Thread 139754511615744 has waited at trx0undo.ic line 190 for 250.00 seconds the semaphore:
S-lock on RW-latch at 0x7f0ea4d84130 created in file buf0buf.cc line 1425
a writer (thread id 139766813452032) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 190
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0undo.ic line 171
--Thread 139664615204608 has waited at trx0undo.ic line 190 for 250.00 seconds the semaphore:
S-lock on RW-latch at 0x7f0ea4d84130 created in file buf0buf.cc line 1425
a writer (thread id 139766813452032) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 190
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0undo.ic line 171
--Thread 139664618817280 has waited at trx0undo.ic line 190 for 250.00 seconds the semaphore:
S-lock on RW-latch at 0x7f0ea4d84130 created in file buf0buf.cc line 1425
a writer (thread id 139766813452032) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 190
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0undo.ic line 171
--Thread 139766813452032 has waited at trx0rseg.ic line 48 for 850.00 seconds the semaphore:
X-lock on RW-latch at 0x7f19a53cc770 created in file buf0buf.cc line 1425
a writer (thread id 139663931066112) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file not yet reserved line 0
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0rseg.ic line 48
--Thread 139748380047104 has waited at trx0undo.ic line 190 for 250.00 seconds the semaphore:
S-lock on RW-latch at 0x7f0ea4d84130 created in file buf0buf.cc line 1425
a writer (thread id 139766813452032) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 190
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0undo.ic line 171
--Thread 139721569617664 has waited at trx0undo.ic line 190 for 250.00 seconds the semaphore:
S-lock on RW-latch at 0x7f0ea4d84130 created in file buf0buf.cc line 1425
a writer (thread id 139766813452032) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 190
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0undo.ic line 171
--Thread 139663931066112 has waited at trx0undo.ic line 171 for 850.00 seconds the semaphore:
X-lock on RW-latch at 0x7f0ea4d84130 created in file buf0buf.cc line 1425
a writer (thread id 139766813452032) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file trx0undo.ic line 190
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0undo.ic line 171
--Thread 139664660780800 has waited at buf0flu.cc line 1229 for 845.00 seconds the semaphore:
SX-lock on RW-latch at 0x7f19a53cc770 created in file buf0buf.cc line 1425
a writer (thread id 139663931066112) has reserved it in mode exclusive
number of readers 0, waiters flag 1, lock_word: 0
Last time read locked in file not yet reserved line 0
Last time write locked in file /data/percona-server-5.7.25/storage/innobase/include/trx0rseg.ic line 48
OS WAIT ARRAY INFO: signal count 32818118
RW-shared spins 0, rounds 29531859, OS waits 10390740
RW-excl spins 0, rounds 45411161, OS waits 729726
RW-sx spins 1102898, rounds 14950177, OS waits 142560
Spin rounds per wait: 29531859.00 RW-shared, 45411161.00 RW-excl, 13.56 RW-sx
thread 139766813452032 wait 139663931066112
thread 139663931066112 wait 139766813452032