My operating system version is Ubuntu 18.04, and the database is running on Percona Server for MySQL 5.7.34. The MySQL service crashed unexpectedly twice, on April 21 and May 6 respectively. Before the service outage, the database logs showed obvious InnoDB latch wait errors: Thread 139909617137408 had waited at row0sel.cc line 3611 for 851 seconds for the semaphore, specifically an S-lock on the RW-latch at 0x7f4400fc8570 (created in file buf0buf.cc line 1438). A writer thread (thread id 139948401846016) had reserved this RW-latch in wait exclusive mode, with the current status showing 1 reader, 1 waiter flag, and the lock_word being ffffffffffffffff.
This appears to be a known bug. Could you help check what causes it? Looking forward to your response.
here is the whole log.
error.log (4.3 MB)