Issues
- Percona-5.7.25 crash with long wait semaphorePS-8940Resolved issue: PS-8940
- Writing to a temporary table crashes server with assertion when running btr_insert_on_non_leaf_level_func()PS-7318Resolved issue: PS-7318Satya Bodapati
- signal 11 segfault in semi-syncPS-6091Resolved issue: PS-6091Lalit Choudhary
- DB Thread-Cache Error RatePS-6009Resolved issue: PS-6009
- PS 5.7.25-28 crashed four times in 3 hoursPS-6000Resolved issue: PS-6000
- Percona 5.7.25+ crash (I think when stopping replication)PS-5822Resolved issue: PS-5822
- [MyRocks] query on rocksdb_ddl, column INDEX_NAME has nothingPS-5732Resolved issue: PS-5732Przemyslaw Skibinski
- Deadlock after upgrading to 5.7 from 5.6PS-5717Resolved issue: PS-5717
- Slow open connection every X times if Thread Pool is usedPS-5648Resolved issue: PS-5648
- Different TTL behavior with unique checks in PRIMARY KEY vs. secondary UNIQUE KEYPS-5647Resolved issue: PS-5647
- Slow shutdown with many tablesPS-5639Resolved issue: PS-5639Satya Bodapati
- create CircleCI placeholder script returning successPS-5638Resolved issue: PS-5638Przemyslaw Skibinski
- InnoDB: Assertion failure in thread xxx in file fts0opt.cc line 1817PS-5626Resolved issue: PS-5626Lalit Choudhary
- dpkg -i percona-release_latest.bionic_all.deb fails inside ubuntu:18.04 docker containerPS-5621Resolved issue: PS-5621Evgeniy Patlan
- Reserved word in column privilege unquoted in binary logPS-5609Resolved issue: PS-5609
- keyring_vault.table_encrypt_kill crashes on CentOS 7PS-5606Resolved issue: PS-5606
- percona-server-server-5.7 with tokudb crashPS-5605Resolved issue: PS-5605
- When installing PS on Ubuntu, it prompts for password even when skipping itPS-5599Resolved issue: PS-5599Evgeniy Patlan
- Make memory allocation with NUMA enabled multi-threadedPS-5596Resolved issue: PS-5596
- mysql server crash after empty set sql queryPS-5591Resolved issue: PS-5591
- Update PS 5.7 feature comparisonPS-5584Resolved issue: PS-5584patrick.birch
- Server stalls because ALTER TABLE on partitioned table holds dict mutexPS-5576Resolved issue: PS-5576Satya Bodapati
- 5.7->8.0 null merge followup (remove error code 42 ASan suppressions from MTR test cases)PS-5561Resolved issue: PS-5561Yura Sorokin
- RHEL8 runners in 5.7 seem to be missing pythonPS-5550Resolved issue: PS-5550George Lorch
- 4GB Limit on large_pages shared memory set-upPS-5517Resolved issue: PS-5517Zsolt Parragi
- Optimizer hints removed from views definitionPS-5509Resolved issue: PS-5509
- long_query_time change not reflected by connected threadsPS-5507Resolved issue: PS-5507
- Running ALTER TABLE with expand_fast_index_creation could lead to a crash when used on a partitioned table (debug)PS-5483Resolved issue: PS-5483
- Creating an index with expand_fast_index_creation and innodb-force-recovery set to 1 can lead to a crashPS-5478Resolved issue: PS-5478
- MyRocks - Cannot configure myrocks in percona docker instancePS-5477Resolved issue: PS-5477
- Binlog corruption in 5.7.25PS-5472Resolved issue: PS-5472
- Cannot build static version of percona-serverPS-5461Resolved issue: PS-5461
- undefined reference to end_cpu_nsecsPS-5457Resolved issue: PS-5457
- 9/36 gis tests are failing when using AMD family 23 processorPS-5452Resolved issue: PS-5452
- MyRocks - rocksdb_rate_limiter_bytes_per_sec variable cannot be set dynamically from zero valuePS-5444Resolved issue: PS-5444
- MyRocks - Setting Rocksdb_force_flush_memtable_now to any value causes a flushPS-5438Resolved issue: PS-5438
- MyRocks - Not getting more than one immutable memtable when setting MIN_WRITE_BUFFER_NUMBER_TO_MERGE to more than 1PS-5437Resolved issue: PS-5437
- Running ALTER TABLE tblname Encryption='Y' is slow after upgradePS-5435Resolved issue: PS-5435
- percona server fail with parallel mysqldump from slavePS-5434Resolved issue: PS-5434Lalit Choudhary
- Issue with installing TokuBackup on Percona-server docker image(s)PS-5433Resolved issue: PS-5433Evgeniy Patlan
- MyRocks - Write Ahead Log (WAL) is not archived unless rocksdb_wal_ttl_seconds is set to non-zero valuePS-5425
- Strange memory management when using full-text indexesPS-5312Resolved issue: PS-5312Julia Vural
- Memory leak in sync_latch_meta_init() after mysqld shutdown detected by ASanPS-5008Resolved issue: PS-5008Satya Bodapati
- 5.7.23-23: InnoDB memcache plugin crashes serverPS-4852Resolved issue: PS-4852
- LP #1570682: Parallel doublewrite buffer file created when skip-innodb_doublewrite is setPS-3411Resolved issue: PS-3411Kamil Holubicki
- LP #1502411: proxy-protocol doesn't take in consideration connect_timeout, possible DOSPS-3314Resolved issue: PS-3314
46 of 46
Percona-5.7.25 crash with long wait semaphore
Incomplete
General
Escalation
General
Escalation
Description
Environment
None
Details
Details
Assignee
Unassigned
UnassignedReporter
L
LNeeds QA
Yes
Components
Affects versions
Priority
MediumSmart Checklist
Smart Checklist
Created September 28, 2023 at 7:50 AM
Updated March 6, 2024 at 9:32 AM
Resolved December 10, 2023 at 6:38 AM
Activity
Show:
Aaditya Dubey December 10, 2023 at 6:38 AM
Hi @L ,
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 @L,
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